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 |
ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
AC_CONTROL_DATE_TIME | TIMESTAMP(3) | 11 | Y | Control date time | Access control date time (rounded to the minute) |
AC_SYNC_DATE_TIME | TIMESTAMP(6) | 11 | Y | Sync date time | Date time of synchronisation with access control system |
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 | |
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 | 512 | Y | Barcode | Voucher barcode |
CARD_NUMBER | VARCHAR2 | 128 | Y | Card number | Number of card on which ticket is loaded |
CARD_TYPE | VARCHAR2 | 240 | Y | Card type | Card type (Mastercard, Visa,..) |
CATALOG_CURRENCY_CODE | CHAR | 3 | Y | Currency code of catalog | |
CHARGE_AMT_ITX | NUMBER | 22 | Y | Gross charges amt | Charge amount including tax |
CONTACT | VARCHAR2 | 831 | Y | Contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
CONTACT_ADDR_COUNTRY_CODE | VARCHAR2 | 2 | Y | Country | Address country code for cultural contact or beneficiary |
CONTACT_ADDR_TOWN | VARCHAR2 | 400 | Y | Town | Town of address |
CONTACT_ADDR_ZIPCODE | VARCHAR2 | 20 | Y | State | Postal code |
CONTACT_BIRTHDATE | VARCHAR2 | 10 | Y | Contact birthdate | Date of birth |
CONTACT_CITY_OF_BIRTH | VARCHAR2 | 400 | Y | Ticket holder city of birth | |
CONTACT_CT_FIRSTNAME | VARCHAR2 | 400 | Y | First name of contact | |
CONTACT_CT_LASTNAME | VARCHAR2 | 400 | Y | Last name of contact | |
CONTACT_DOB | DATE | 7 | Y | Year of birth | Cultural contact date of birthday |
CONTACT_EMAIL | VARCHAR2 | 254 | Y | Email address of contact | |
CONTACT_GENDER | VARCHAR2 | 25 | Y | Contact gender | Cultural contact gender |
CONTACT_IDENTITY | VARCHAR2 | 100 | Y | Number of identity card | |
CONTACT_NATIONALITY | VARCHAR2 | 2 | Y | Contact nationality | |
CONTACT_PROVINCE_OF_BIRTH | VARCHAR2 | 400 | Y | Ticket holder province of birth | |
CONTACT_STRUCTURE | VARCHAR2 | 400 | Y | Structure | Name of compayne/institution the contact belongs to |
CONTINGENT | VARCHAR2 | 4000 | Y | Contingent | Contingent name |
CONTROL_STATUS | VARCHAR2 | 4000 | Y | Control state | Ticket control status . NOT_CHECKED - SYNCED (synchronised with access control) - CHECKED |
DISPLAYED_NUMBER | VARCHAR2 | 128 | Y | Printed number | Number printed on the card |
DUPLICATE_FROM_FISCAL_NB | VARCHAR2 | 20 | Y | Fiscal number of ticket duplicated by current ticket) | |
ENTRANCE | VARCHAR2 | 240 | Y | Entrance | Entrance name |
EXTERNAL_VALIDITIONNUM_TARIFF | VARCHAR2 | 100 | Y | External validation number | External validation number |
FILE_CONTACT | VARCHAR2 | 831 | Y | File contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
FILE_NUMBER | NUMBER | 22 | Y | File number | File number |
FISCAL_NUMBER | VARCHAR2 | 20 | Y | Fiscal number | Ticket fiscal number |
FLOOR | VARCHAR2 | 240 | Y | Floor | Floor |
HOSP_BUNDLE_CODE | VARCHAR2 | 32 | Y | Hospitality bundle code | |
HOSP_BUNDLE_NAME | VARCHAR2 | 240 | Y | Hospitality bundle name | |
HOSP_PRODUCT_CODE | VARCHAR2 | 32 | Y | Hospitality product code | |
HOSP_PRODUCT_NAME | VARCHAR2 | 240 | Y | Hospitality product name | |
HOSP_ROOM_CODE | VARCHAR2 | 32 | Y | Hospitality room code | |
HOSP_ROOM_NAME | VARCHAR2 | 240 | Y | Hospitality room name | |
INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
INVALIDATED_BY_FISCAL_NB | VARCHAR2 | 20 | Y | Fiscal number of ticket duplicating current ticket) | |
INVOICE_NUMBER | VARCHAR2 | 4000 | Y | Invoice number | Invoice number |
INVOICING_DATE | TIMESTAMP(3) WITH TIME ZONE | 13 | Y | Invoice date | |
ITEM | VARCHAR2 | 4000 | Y | Item | Item name |
KIND | VARCHAR2 | 25 | Y | Ticket kind. Possible values are: - SECUTIX - SECUTIX_EXT - THIRD_PARTY |
|
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
LOG_ENTRANCE_EXT_NAME | VARCHAR2 | 240 | Y | Logical entrance external name | |
LOG_SEAT_CATEGORY_EXT_NAME | VARCHAR2 | 240 | Y | Logical seat category | Logical seat category external name |
MATCH_DAY | VARCHAR2 | 4000 | Y | Match day | Day or round of a match |
MATCH_DAY_CODE | VARCHAR2 | 120 | Y | Day or round code of a match | |
ONETIMECODE_STRUCT | VARCHAR2 | 1000 | Y | Structure having received the code | |
ONETIMECODE_STRUCT_NUMBER | VARCHAR2 | 20 | Y | Structure having received the code | |
ORDER_CONTACT | VARCHAR2 | 831 | Y | Order contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
ORDER_CONTACT_EMAIL | VARCHAR2 | 254 | Y | Order contact email | Email address of contact |
ORDER_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Order contact N° | Contact number |
ORDER_CONTACT_PRIMARY_PHONE | VARCHAR2 | 31 | Y | Phone number incl. Prefix | |
ORDER_CONTACT_STRUCTURE | VARCHAR2 | 400 | Y | Name of company/institution the contact belongs to | |
ORDER_CONTACT_STRUCT_NB | VARCHAR2 | 20 | Y | Number of company/institution the contact belongs to | |
ORDER_CREATION_DATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Order creation date | |
ORDER_DATE | VARCHAR2 | 10 | Y | Purchase order date | Order date |
ORDER_NUMBER | NUMBER | 22 | Y | Order Number | Order number |
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 |
OTC_STRUCT_CT_ID | NUMBER | 22 | Y | Structure having received the code | |
OUTER_LOG_ENTRANCE | VARCHAR2 | 240 | Y | Outer log entrance | Outer logical entrance name |
OUTER_LOG_ENTRANCE_EXT_NAME | VARCHAR2 | 240 | Y | Logical external entrance external name | |
PARENT_PRODUCT | VARCHAR2 | 240 | Y | Composed product | Name of composed product (containing the current single product) |
PAYMENT_STATUS | VARCHAR2 | 4000 | Y | Ticket/operation payment status: - Deposit (not for sold tickets) - Not paid - Paid by suspense account - Paid |
|
PHYSICAL_AREA | VARCHAR2 | 240 | Y | Area name | |
PHYSICAL_AREA_CODE | VARCHAR2 | 32 | Y | Area code | |
PHYSICAL_AREA_EXT_NAME | VARCHAR2 | 240 | Y | Physical block external name | |
PHYSICAL_BLOCK | VARCHAR2 | 240 | Y | Block name | |
PHYSICAL_BLOCK_CODE | VARCHAR2 | 32 | Y | Block code | |
PHYSICAL_BLOCK_EXT_NAME | VARCHAR2 | 240 | Y | Physical block external name | |
PHYSICAL_SECTOR | VARCHAR2 | 240 | Y | Sector in which the physical area is located | |
PRINT_DATE_TIME | TIMESTAMP(3) WITH TIME ZONE | 13 | Y | Print date time | Printing date time |
PRINT_OPERATOR | VARCHAR2 | 825 | 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 |
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) | |
RESALE_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Resale contact | Contact number of reseller |
RESALE_SALES_CHANNEL | VARCHAR2 | 240 | Y | Resale sales channel | Resale sales channel name |
RESALE_STATE | VARCHAR2 | 4000 | Y | Resale state | Ticket resale state: - Open - Invalidated - Canceled - In progress - Resold |
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 |
SEAT_DESCRIPTION | VARCHAR2 | 1248 | Y | Seat description | |
SEAT_NUMBER | VARCHAR2 | 240 | Y | Seat number | |
SEAT_QUALITY | VARCHAR2 | 4000 | Y | Seat quality | Seat quality describing the level of comfort provided. Possible values are: - Bench - Seat - Armchair - Wheelchair - Seat - Folding chair |
SEAT_ROW | VARCHAR2 | 240 | Y | Seat row number | |
SELLER_ORGANIZATION | VARCHAR2 | 240 | Y | Seller organization | Organization name |
SHIPMENT_ADDRESS | VARCHAR2 | 4000 | Y | Shipment address | Contact address (street, number, address complement) |
SHIPMENT_MODE | VARCHAR2 | 240 | Y | Shipment mode | Shipment mode name |
SHIPMENT_MODE_EXTERNAL | VARCHAR2 | 240 | Y | External name of shipment mode | |
SHIPMENT_STATE | VARCHAR2 | 4000 | Y | Shipment state | Shipment state. Possible values are: - Sent - Not sent - Cancelled - Reference - Reprocess |
SHIP_ADDR_COUNTRY_CODE | VARCHAR2 | 2 | Y | Address country code | |
SHIP_ADDR_TOWN | VARCHAR2 | 400 | Y | Town of address | |
SHIP_ADDR_ZIPCODE | VARCHAR2 | 20 | Y | Postal code | |
SHIP_CONTACT | VARCHAR2 | 831 | Y | Shipment contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
SHIP_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Shipment contact number | Contact number |
SHIP_CONTACT_STRUCTURE | VARCHAR2 | 400 | Y | Shipment contact structure | Company the shipment contact belongs to |
SHIP_REFERENCE_NUMBER | VARCHAR2 | 200 | Y | Shipment reference number | Shipment reference number |
SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
SPACE | VARCHAR2 | 240 | Y | Space | Name of space where event takes place |
SSO_ID | VARCHAR2 | 255 | Y | SSO ID | |
SSO_PROVIDER | VARCHAR2 | 25 | Y | SSO provider | |
SUB_TOPIC | VARCHAR2 | 240 | Y | Sub topic | Subtopic (level 1) of lowest rank assigned to the product. |
TEAM_1 | VARCHAR2 | 240 | Y | Host team | First team (in case of a match) |
TEAM_2 | VARCHAR2 | 240 | Y | Opposing team | Second team (in case of a match) |
TICKET_CANCELLATION_DATE_TIME | TIMESTAMP(6) | 11 | Y | Cancellation / Invalidation date and time | |
TICKET_CANCELLATION_OPERATOR | VARCHAR2 | 20 | Y | Cancellation operator | |
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) |
|
TOPIC | VARCHAR2 | 240 | Y | Topic | Parent of the subtopic related to the product. |
T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
T_ADVANTAGE_ID | NUMBER | 22 | Y | Technical identifier of advantage | |
T_ANS_QUESTNR_ID | NUMBER | 22 | Y | Technical identifier of answered questionnaire | |
T_AUD_SUB_CAT_ID | NUMBER | 22 | Y | Technical identifier of tariff | |
T_CASHDESK_ID | NUMBER | 22 | Y | Technical identifier of cash desk | |
T_CONTACT_ID | NUMBER | 22 | Y | Contact technical identifier | |
T_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
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_LOGSEAT_ID | NUMBER | 22 | Y | Technical identifier of logical seat | |
T_MOVEMENT_ID | NUMBER | 22 | N | Technical identifier of movement | |
T_OPERATION_ID | NUMBER | 22 | N | Technical identifier of operation | |
T_OPERATION_TYPE | VARCHAR2 | 25 | Y | Operation type. Possible values are: - OPTION - OPTION_CANCEL - REFUND - SALE - RESERVATION - RESERVATION_CANCEL |
|
T_ORDER_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
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_ORDER_ST_CT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
T_ORGANIZATION_ID | NUMBER | 22 | Y | Technical identifier of organization | |
T_OUTER_LOG_ENTRANCE_ID | NUMBER | 22 | Y | Technical identifier of logical outer entrance | |
T_PAYMENT_STATUS | VARCHAR2 | 25 | Y | Ticket/operation payment state: - DEPOSIT (not for sold tickets) - NOT_PAID - WAITING_ACCOUNT - PAID |
|
T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
T_PHY_AREA_ID | NUMBER | 22 | Y | Technical identifier of area | |
T_PHY_BLOCK_ID | NUMBER | 22 | Y | Technical identifier of block | |
T_PRINT_OP_LOGIN | VARCHAR2 | 20 | Y | Operator login | |
T_PRINT_POS_ID | NUMBER | 22 | Y | Technical identifier of point of sales | |
T_PRINT_SALCHAN_ID | NUMBER | 22 | Y | Technical identifier of sales channel | |
T_PRODUCT_FAMILY_ID | NUMBER | 22 | Y | Technical identifier of product family | |
T_PRODUCT_ID | NUMBER | 22 | Y | Product technical identifier | |
T_PRODUCT_ORGANIZATION_ID | NUMBER | 22 | Y | Technical identifier of organization | |
T_P_PRODUCT_ID | NUMBER | 22 | Y | Technical identifier of product | |
T_QUESTNR_ID | NUMBER | 22 | Y | Technical identifier of answered questionnaire | |
T_RESALE_BUCKET | VARCHAR2 | 60 | Y | Resale bucket identifier | |
T_RESALE_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of reseller | |
T_RESALE_ID | NUMBER | 22 | Y | Technical identifier of resale | |
T_RESALE_PURCHASE_MOV_ID | NUMBER | 22 | Y | Technical identifier of resale purchased movement | |
T_RESALE_PURCHASE_TICKET_ID | NUMBER | 22 | Y | Technical identifier of resale purchased ticket | |
T_RESALE_REFUND_MOV_ID | NUMBER | 22 | Y | Technical identifier of resale refunded movement | |
T_RESALE_SALCHAN_ID | NUMBER | 22 | Y | Technical identifier of resale sales channel | |
T_RESALE_SALCHAN_TYPE | VARCHAR2 | 25 | Y | Type of the resale sales channel | |
T_RESALE_STATE | VARCHAR2 | 25 | Y | Ticket resale state: - OPEN - INVALIDATED - CANCELED - IN_PROGRESS - RESOLD |
|
T_RESALE_UNIT_AMT_CURR_CODE | CHAR | 3 | Y | Currency code of the resale amount | |
T_RESALE_UNIT_AMT_ITX | NUMBER | 22 | Y | Unit amount of resale ticket including tax | |
T_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
T_SEAT_CAT_ID | NUMBER | 22 | Y | Seat category technical identifier | |
T_SELLER_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
T_SHIPMENT_ID | NUMBER | 22 | Y | Technical identifier of shipment | |
T_SHIPMENT_MODE_ID | NUMBER | 22 | Y | Technical identifier of shipment mode | |
T_SHIPMENT_STATE | VARCHAR2 | 25 | Y | Shipment state. Possible values are: - UNSENT - SENT - CANCELLED - REFERENCE - REPROCESS |
|
T_SITE_ID | NUMBER | 22 | Y | Technical identifier of site | |
T_SPACE_ID | NUMBER | 22 | Y | Technical identifier of space | |
T_SUB_TOPIC_ID | NUMBER | 22 | Y | Identifier of subtopic | |
T_TEAM_1_ID | NUMBER | 22 | Y | Technical identifier of first team (in case of a match) | |
T_TEAM_2_ID | NUMBER | 22 | Y | Technical identifier of second team (in case of a match) | |
T_TICKET_CANCELLATION_CAUSE | VARCHAR2 | 25 | Y | Cancellation reason (internal name) of ticket. Possible values are: - REFUNDED - LOSS - THEFT - OTHER - EBO_CANCELLED - FORBIDDEN - REPRINT - PRINT_KO - CHANGE_RFID - RESOLD - RESEAT - OTHER_SECURITY_REQUEST_BL - OTHER_PNA_REQUEST_BL - LOSS_COURIER_FAILURE - LOSS_RETURN_DISTRIBUTION - REPRINT_RESEAT - REPRINT_CONTACT_PAPER - REPRINT_CONTACT_MOBILE - REPRINT_DAMAGED - REPRINT_PNA_ON_SITE - REPRINT_ORG_PAPER - REPRINT_ORG_MOBILE - REPRINT_APP_PAPER |
|
T_TICKET_CREATION_DATE | TIMESTAMP(3) WITH TIME ZONE | 13 | Y | Ticket creation date and time | |
T_TICKET_ID | NUMBER | 22 | N | Technical identifier of ticket | |
T_TICKET_PRINT_STATE | VARCHAR2 | 25 | Y | Ticket printing status: - PRINTED - NOT_PRINTED |
|
T_TICKET_STATE | VARCHAR2 | 25 | Y | Ticket state. Possible values are: - NOT_PRINTED - EXPORTED (to a printing company) - PRINTED - CANCELLED - INVALIDATED (because a duplicate has been created) - CONTROLED |
|
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 | |
T_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of goods topic | |
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 |
VISITGROUP_ID | NUMBER | 22 | Y | Technical identifier of visit group | |
VISIT_LANGUAGE | VARCHAR2 | 4000 | Y | Visit language | Visit language |