Version: 1.0
Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
---|---|---|---|---|---|
ACCESS_CODE | VARCHAR2 | 80 | Y | Access code | Partner code or single usage code of advantage |
ADVANTAGE | VARCHAR2 | 240 | Y | Advantage | Advantage name |
ADVANTAGE_CODE | VARCHAR2 | 60 | Y | Advantage code | Advantage code |
AMT_ITX | NUMBER | 22 | Y | Product unit price including tax | |
ANSWER | VARCHAR2 | 4000 | Y | Answer to a question | |
ANSWER_STATUS | VARCHAR2 | 0 | Y | Answer status | Answer status (answered, not answered) |
AUDIENCE_CATEGORY | VARCHAR2 | 4000 | Y | Audience category name. Possible values are: - Invited in error - Complimentary guest - Member community - Member contact - Member group - Occasional community - Occasional contact - Promotional guest - Season-ticket community - Season-ticket contact - Royalty cost guest |
|
AUDIENCE_SUB_CATEGORY | VARCHAR2 | 240 | Y | Tariff name | |
BARCODE | VARCHAR2 | 128 | Y | Barcode | Voucher barcode |
CARD_TYPE | VARCHAR2 | 240 | Y | Card type | Card type (Mastercard, Visa,..) |
CATALOG_CURRENCY_CODE | CHAR | 3 | Y | Currency code of catalog | |
CODE | VARCHAR2 | 32 | Y | Code of question | |
CONTACT_CT_FIRSTNAME | VARCHAR2 | 400 | Y | First name of contact | |
CONTACT_CT_LASTNAME | VARCHAR2 | 400 | Y | Last name of contact | |
CONTROL_STATUS | VARCHAR2 | 4000 | Y | Control state | Ticket control status . NOT_CHECKED - SYNCED (synchronised with access control) - CHECKED |
C_CONTACT | VARCHAR2 | 831 | Y | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. | |
C_CT_ADDR_SALTN | VARCHAR2 | 152 | Y | Salutation used for the contact address. The value of the field is defined based on the "Title" field. | |
C_CT_BIRTHDAY | VARCHAR2 | 10 | Y | Date of birth | |
C_CT_COUNTRY_CODE | VARCHAR2 | 4000 | Y | Address country code | |
C_CT_EMAIL | VARCHAR2 | 254 | Y | Email address of contact | |
C_CT_FIX_PHONE | VARCHAR2 | 31 | Y | Phone number incl. Prefix | |
C_CT_FORMATTED_ADDR | VARCHAR2 | 4000 | Y | Contact address (street, number, address complement) | |
C_CT_FUNCTION | VARCHAR2 | 400 | Y | Contact function | |
C_CT_GENDER | VARCHAR2 | 25 | Y | Contact gender | |
C_CT_IDENTITY | VARCHAR2 | 100 | Y | Number of identity card | |
C_CT_LETTER_SALTN | VARCHAR2 | 400 | Y | Letter salutation | |
C_CT_NATIONALITY | VARCHAR2 | 2 | Y | Contact nationality | |
C_CT_NB | VARCHAR2 | 20 | Y | Contact number | |
C_CT_PREF_LANG | VARCHAR2 | 4000 | Y | Contact preferred language | |
C_CT_ROLE | VARCHAR2 | 25 | Y | Contact role. Possible values are: - Relay - Public |
|
C_CT_STAFF | NUMBER | 22 | Y | Staff of company the contact belongs to | |
C_CT_STRUCT | VARCHAR2 | 400 | Y | Name of company/institution the contact belongs to | |
C_CT_STRUCT_NB | VARCHAR2 | 20 | Y | Number of company/institution the contact belongs to | |
C_CT_TOWN | VARCHAR2 | 400 | Y | Town of address | |
C_CT_ZIPCODE | VARCHAR2 | 8 | Y | Postal code | |
DUPLICATE_FROM_FISCAL_NB | VARCHAR2 | 20 | Y | Fiscal number of ticket duplicated by current ticket) | |
FILE_NUMBER | NUMBER | 22 | Y | File number | File number |
FISCAL_NUMBER | VARCHAR2 | 20 | Y | Fiscal number | Ticket fiscal number |
GUIDES | VARCHAR2 | 4000 | Y | Guides | |
INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
INTERNAL_NAME_L1 | VARCHAR2 | 4000 | Y | Question internal name | |
INVALIDATED_BY_FISCAL_NB | VARCHAR2 | 20 | Y | Fiscal number of ticket duplicating current ticket) | |
ITEM | VARCHAR2 | 4000 | Y | Item | Item name |
LAST_MODIFICATION | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Last modification | Timestamp of ticket last modification |
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
MOVEMENT_ID | NUMBER | 22 | N | Technical identifier of movement | |
OPERATION_TYPE | VARCHAR2 | 25 | N | Operation type | Operation type. Possible values are: - booking - booking cancellation - sale - refund - option - option cancellation |
ORDER_DATE | VARCHAR2 | 10 | Y | Purchase order date | Order date |
ORDER_OPERATOR | VARCHAR2 | 20 | Y | Operator name + login | |
ORDER_OP_LOGIN | VARCHAR2 | 20 | Y | Order operator login | Operator login |
ORDER_POS | VARCHAR2 | 32 | Y | Code of point of sale | |
ORDER_SALES_CHANNEL | VARCHAR2 | 240 | Y | Name of sales channel | |
ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
ORG_CURRENCY_CODE | CHAR | 3 | Y | Organization currency | Currency code of organization |
PRINT_DATE_TIME | TIMESTAMP(3) WITH TIME ZONE | 13 | Y | Print date time | Printing date time |
PRINT_OPERATOR | VARCHAR2 | 20 | Y | Printing operator | Operator name + login |
PRINT_POS | VARCHAR2 | 32 | Y | Printing point of sales | Point of sales code |
PRINT_SALES_CHANNEL | VARCHAR2 | 240 | Y | Printing sales channel | Name of sales channel |
PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
PRODUCT_DATE_TIME | TIMESTAMP(3) | 11 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
PRODUCT_FAMILY | VARCHAR2 | 4000 | Y | Prod. Family | Product family name. Possible values are: - Membership - Season ticket - Voucher - Goods - Hospitality bundle - Competition - Event - Package - Dated pass - Timeslot pass - Non-dated pass - Visit pass - Service - Hospitality - Open product - Visit |
PROVIDER | VARCHAR2 | 1000 | Y | Name of company distributing the ticket | |
PROVIDER_CT_NB | VARCHAR2 | 20 | Y | Number of company distributing the ticket | |
QUESTION | VARCHAR2 | 4000 | Y | Question | |
RANK | NUMBER | 22 | Y | Rank of question within the questionnaire | |
REFERENCE_DATE | DATE | 7 | Y | Reference date | Order reference date |
REPRINT_FROM_FISCAL_NB | VARCHAR2 | 20 | Y | Fiscal number of ticket reprinted by current ticket) | |
SAL_ENT_COUNTRY_CODE | CHAR | 2 | Y | Sales entity country code | Country code of the selling entity |
SAL_ENT_ID | NUMBER | 22 | Y | Identifier of the sales entity | |
SAL_ENT_NAME | VARCHAR2 | 240 | Y | Sales entity name | Name of the sales entity |
SAL_ENT_STRUCT_ADDRESS | VARCHAR2 | 400 | Y | Mailing address of the contact structure | |
SAL_ENT_STRUCT_COUNTRY_CODE | CHAR | 2 | Y | Contact structure country code | |
SAL_ENT_STRUCT_ID | NUMBER | 22 | Y | Identifier of the contact structure | |
SAL_ENT_STRUCT_NAME | VARCHAR2 | 400 | Y | Sales entity structure | Contact structure name |
SAL_ENT_STRUCT_ZIP_CODE | VARCHAR2 | 20 | Y | Contact structure zip code | |
SEASON | VARCHAR2 | 240 | Y | Season | Season name |
SEAT_CATEGORY | VARCHAR2 | 60 | Y | Seat category | Seat category name |
SHIPMENT_MODE | VARCHAR2 | 240 | Y | Shipment mode | Shipment mode name |
SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
SPACE | VARCHAR2 | 240 | Y | Space | Name of space where event takes place |
TICKET_PRINT_STATE | VARCHAR2 | 4000 | Y | Ticket printing status: - PRINTED - NOT_PRINTED |
|
TICKET_SUPPORT | VARCHAR2 | 4000 | Y | Ticket's support | Ticket medium: last one used if ticket has been printed on multiple media. Possible values are: - Simple card - Thermal ticket - E-ticket - RFID - Mobile ticket - Passbook |
TICKET_VALIDITY_STATE | VARCHAR2 | 4000 | Y | Ticket validity status: - VALID - INVALID (duplicated or reprinted) - CANCELLED - EXPIRED (end of validity is in the past) |
|
T_ADVANTAGE_ID | NUMBER | 22 | Y | Technical identifier of advantage | |
T_ANSWER_STATUS | VARCHAR2 | 0 | Y | Question answer status: - ANSWERED - NOT ANSWERED |
|
T_CONTROL_STATUS | VARCHAR2 | 11 | Y | Ticket control status . NOT_CHECKED - SYNCED (synchronised with access control) - CHECKED |
|
T_FAMILY_TYPE | VARCHAR2 | 38 | Y | Name of product family type of product related to current charges. Possible values are: - GOODS - HOSPITALITY - MEMBERSHIP - PACKAGE - PASS - SEASONTICKET - SERVICE - SIMPLE_TICKET |
|
T_ITEM_ID | NUMBER | 22 | Y | Technical identifier of item | |
T_ORDER_POS_ID | NUMBER | 22 | Y | Technical identifier of point of sale | |
T_ORDER_SALCHAN_ID | NUMBER | 22 | Y | Technical identifier of sales channel | |
T_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
T_PRODUCT_FAMILY_ID | NUMBER | 22 | Y | Technical identifier of product family | |
T_PRODUCT_ID | NUMBER | 22 | Y | Product technical identifier | |
T_PROVIDER_CT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
T_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
T_SEAT_CAT_ID | NUMBER | 22 | Y | Seat category technical identifier | |
T_SHIPMENT_MODE_ID | NUMBER | 22 | Y | Technical identifier of shipment mode | |
T_SITE_ID | NUMBER | 22 | Y | Technical identifier of site | |
T_SPACE_ID | NUMBER | 22 | Y | Technical identifier of space | |
T_TICKET_ID | NUMBER | 22 | Y | Technical identifier of ticket | |
T_TICKET_PRINT_STATE | VARCHAR2 | 25 | Y | Ticket printing status: - PRINTED - NOT_PRINTED |
|
T_TICKET_VALIDITY_STATE | VARCHAR2 | 9 | Y | Ticket validity status: - VALID - INVALID (duplicated or reprinted) - CANCELLED - EXPIRED (end of validity is in the past) |
|
T_TICK_SUPPORT_ID | NUMBER | 22 | Y | Technical identifier of support on which ticket is printed or loaded | |
T_TIMESLOT_ID | NUMBER | 22 | Y | Technical identifier of timeslot | |
VALIDITY_END_DATE | DATE | 7 | Y | Validity end date | End date of the voucher |
VALIDITY_START_DATE | DATE | 7 | Y | Validity start date | Start date of the voucher |