Version: 1.0
Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
---|---|---|---|---|---|
ACCESSIBLE_TICKETS | CHAR | 4 | Y | Flag indicating whether the request concerns tickets for disabled people. | |
ACCOUNT_HOLDER | VARCHAR2 | 400 | Y | Account holder last name and first name | |
ACTUAL_SEAT_CAT | VARCHAR2 | 32 | Y | Name of actual seat category | |
ADMINISTRATIVE_FEE_AMOUNT | CHAR | 4 | Y | Total amount of administrative fees. This encompasses generally shipment fees. | |
ALTERNATE_REQUEST_RANK | NUMBER | 22 | Y | Rank of the current request in the chain of alternative requests. | |
APPLICATION_STATE | VARCHAR2 | 100 | Y | State of the application | |
APPLICATION_STATE_DETAILS | VARCHAR2 | 4000 | Y | State details of the application | |
BANK | VARCHAR2 | 240 | Y | Bank | Name of bank |
BANK_ADDRESS | VARCHAR2 | 800 | Y | Bank address | |
BANK_COUNTRY_CODE | VARCHAR2 | 8 | Y | Bank country code | |
CARD_ALIAS | VARCHAR2 | 400 | Y | Alias of the payment card | |
CARD_ALIAS_REJECTION | VARCHAR2 | 400 | Y | Reason of refusal of card aliasing | |
CARD_EXPIRY_MONTH | NUMBER | 22 | Y | Payment card expiry month | |
CARD_EXPIRY_YEAR | NUMBER | 22 | Y | Payment card expiry year | |
CARD_HOLDER | VARCHAR2 | 400 | Y | Payment card holder | |
CARD_MASKED_NUMBER | VARCHAR2 | 80 | Y | Payment card masked number | |
CARD_TYPE | VARCHAR2 | 100 | Y | Card type | Card type (Mastercard, Visa,..) |
CONTINGENT | VARCHAR2 | 240 | Y | Contingent | Contingent name |
DISABLED_PROOF_STATUS | VARCHAR2 | 100 | Y | Information about the proof of being disabled | |
FILE_ID | VARCHAR2 | 400 | Y | Technical identifier of file | |
GROUP_REINTEGRATED | CHAR | 4 | Y | Application GroupID reintegration state | |
GROUP_USER_NUMBER | VARCHAR2 | 80 | Y | Identifies the (potential) group to which the requestor belongs | |
GUESTS_ONLY | CHAR | 4 | Y | Flag indicating whether the ticket request contains only beneficiaries | |
INSTIT_CODE | VARCHAR2 | 60 | Y | Institution code | |
IP_ADDRESS_REQUEST | VARCHAR2 | 200 | Y | IP address from which the ticket request has been submitted | |
LAST_LOTTERY_SYNC_DATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date-time of application reintegration within Ticketing | |
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
LOTTERY_ACCESS_CODE | VARCHAR2 | 400 | Y | Access code used to connect to a lottery | |
LOTTERY_CODE | VARCHAR2 | 96 | Y | Lottery where the user has registered | |
NB_PERSONS_CARERS | NUMBER | 22 | Y | Number of tickets for people taking care of disableds | |
NB_PERSONS_DISABLED | NUMBER | 22 | Y | Number of tickets requested for disableds | |
NB_PERSONS_TOT | NUMBER | 22 | Y | Number of tickets requested | |
ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
PAID_AMOUNT | NUMBER | 22 | Y | Paid amount | Paid amount |
PARKING_REQUEST | CHAR | 4 | Y | Parking request | |
PAYMENT_IDENTIFIER | VARCHAR2 | 400 | Y | Payment identification | |
PAYMENT_LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Last update of payment | |
PAYMENT_METHOD | VARCHAR2 | 100 | Y | Payment method | Name of payment method |
PAYMENT_REFERENCE | VARCHAR2 | 80 | Y | Payment reference | |
PAYMENT_REJECTION | VARCHAR2 | 400 | Y | Payment rejection reason | |
RANKING | NUMBER | 22 | Y | Result of the ranking process (among all requests with the same ranking priority) | |
RANKING_PRIORITY | NUMBER | 22 | Y | Priority that may be set manually before the ranking process | |
REFUND_ACCOUNT_BIC | VARCHAR2 | 44 | Y | BIC to be used to refund requestor (if necessary) | |
REFUND_ACCOUNT_IBAN | VARCHAR2 | 136 | Y | IBAN to be used to refund requestor (if necessary) | |
REQUESTED_SEAT_CAT | VARCHAR2 | 32 | Y | Name of requested seat category | |
REQUESTOR_IS_HOST | CHAR | 4 | Y | Flag indicator whether the requestor lives near the city hosting the performance | |
REQUESTOR_MEMBERSHIP | VARCHAR2 | 400 | Y | Requestor membership to a club or association | |
REQUESTOR_MEMBERSHIP_VALIDITY | VARCHAR2 | 100 | Y | Status of validity of the membership | |
REQUEST_CREATION_DATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Insertion date of ticket request | |
REQUEST_DTE_LOG_LU | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Last update of the request | |
REQUEST_STATE | VARCHAR2 | 100 | Y | State of the ticket request | |
RESULT_MAIL_NOTIFICATION | VARCHAR2 | 100 | Y | Email notification status | |
SHIPMENT_MODE | VARCHAR2 | 240 | Y | Shipment mode | Shipment mode name |
T_ACTUAL_SEAT_CAT_ID | NUMBER | 22 | Y | Technical identifier of actual seat category | |
T_ALTERNATE_PARENT_REQUEST_ID | VARCHAR2 | 248 | Y | A request may be defined as an alternative to another request | |
T_APPLICATION_ID | VARCHAR2 | 248 | Y | Technical identifier of lottery application | |
T_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
T_ORGANIZATION_ID | NUMBER | 22 | Y | Technical identifier of organization | |
T_PACKAGE_ID | NUMBER | 22 | Y | Technical identifier of package | |
T_PAYMENT_ID | VARCHAR2 | 248 | Y | Technical identifier of payment | |
T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
T_REQUESTED_SEAT_CAT_ID | NUMBER | 22 | Y | Technical identifier of requested seat category | |
T_SHIPMENT_ID | NUMBER | 22 | Y | Technical identifier of shipment | |
T_TICKET_REQUEST_ID | VARCHAR2 | 248 | N | Technical identifier of ticket request | |
T_USER_ID | VARCHAR2 | 248 | Y | Technical identifier of user | |
UPGRADE_DOWNGRADE | VARCHAR2 | 56 | Y | Flag indicating whether the requestor accepts an upgrade or downgrade of the seat category |