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 |