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 |
| ADVANTAGE | VARCHAR2 | 240 | Y | Advantage | Advantage name |
| ADVANTAGE_CODE | VARCHAR2 | 60 | Y | Advantage code | Advantage code |
| AGENCY | VARCHAR2 | 400 | Y | Agency | Name of the company the agent belongs to. Format: "last name, first name (contact number)" |
| AGENT | VARCHAR2 | 831 | Y | Agent | Name of the relay who made the order on a B2B2C sales channel. Format: "last name, first name (contact number)" |
| AGENT_NUMBER | VARCHAR2 | 20 | Y | Number of the relay (Contact) who made the order on a B2B2C sales channel. | |
| 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_KIND | VARCHAR2 | 25 | Y | Audience kind | Reduction level |
| AUDIENCE_KIND_TYPE | VARCHAR2 | 25 | Y | Reduction level | |
| AUDIENCE_SUB_CATEGORY | VARCHAR2 | 240 | Y | Tariff name | |
| BASE_UNIT_AMT_ETX | NUMBER | 22 | Y | Base unit amount excluding tax. Base amount = amount before applying promotions like advantages | |
| BASE_UNIT_AMT_ITX | NUMBER | 22 | Y | Base unit amount including tax. Base amount = amount before applying promotions like advantages | |
| BOOKING_AMT_ETX | NUMBER | 22 | Y | Net booking amt | Booking amount excluding tax |
| BOOKING_AMT_ITX | NUMBER | 22 | Y | Gross booking amt | Booking amount including tax |
| BOOKING_CANCEL_AMT_ETX | NUMBER | 22 | Y | Net booking cancellation amt | Amount of cancelled bookings excluding tax |
| BOOKING_CANCEL_AMT_ITX | NUMBER | 22 | Y | Gross booking cancellation amt | Amount of cancelled bookings including tax |
| BOOKING_CANCEL_CHARGE_AMT_ETX | NUMBER | 22 | Y | Net booking cancellation charges amt | Amount of charges on cancelled bookings excluding tax |
| BOOKING_CANCEL_CHARGE_AMT_ITX | NUMBER | 22 | Y | Gross booking cancellation charges amt | Amount of charges on cancelled bookings including tax |
| BOOKING_CANCEL_C_QTY | NUMBER | 22 | Y | Booking cancel C | Number of cancelled free bookings |
| BOOKING_CANCEL_P_QTY | NUMBER | 22 | Y | Booking cancel P | Number of cancelled paid bookings |
| BOOKING_CANCEL_T_QTY | NUMBER | 22 | Y | Booking cancel T | Total number of cancelled bookings |
| BOOKING_CANCEL_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Booking canceled qty inside composed product | Total nomber of cancelled bookings of tickets inside a composed product |
| BOOKING_CHARGE_AMT_ETX | NUMBER | 22 | Y | Net booking charges | Amount of charges on bookings excluding tax |
| BOOKING_CHARGE_AMT_ITX | NUMBER | 22 | Y | Gross booking charges | Amount of charges on bookings including tax |
| BOOKING_CHARGE_TAX_AMT | NUMBER | 22 | Y | Booking charge tax amt | Tax amount on charges on bookings |
| BOOKING_COMMISSION_AMT_ITX | NUMBER | 22 | Y | Gross booking commission amt | Commission amount on bookings including tax |
| BOOKING_C_QTY | NUMBER | 22 | Y | Booking C | Number of bookings of free tickets |
| BOOKING_P_QTY | NUMBER | 22 | Y | Booking P | Number of bookings of paid tickets |
| BOOKING_TAX_AMT | NUMBER | 22 | Y | Booking tax amt | Booking tax amount |
| BOOKING_T_QTY | NUMBER | 22 | Y | Booking T | Total number of bookings |
| BOOKING_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Booking qty inside composed product | Total number of bookings inside a composed product |
| CAN_BOOKING_COMMISSION_AMT_ITX | NUMBER | 22 | Y | Commission amount on cancelled bookings including tax | |
| CATALOG_CURRENCY_CODE | CHAR | 3 | Y | Currency code of catalog | |
| CHARGE_AMT_ETX | NUMBER | 22 | Y | Net charges amt | Total amount of charges excluding tax |
| CHARGE_AMT_ITX | NUMBER | 22 | Y | Gross charges amt | Charge amount including tax |
| COMM_FILE_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | Commission contact | |
| COMM_FILE_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Commission contact number | |
| COMM_FILE_CONTACT_STRUCT | VARCHAR2 | 400 | Y | Commission contact structure name | |
| CONTACT_ADDR_COUNTRY_CODE | VARCHAR2 | 2 | Y | Country | Address country code |
| CONTINGENT | VARCHAR2 | 4000 | Y | Contingent | Contingent name |
| CONTINGENT_TYPE | VARCHAR2 | 4000 | Y | Contingent type | Type of audience for which the contingent is foreseen. Possible values are: - Target group - Invited - Company - Services - Press - Diplomatic - Disabled - Other - Goods stock |
| CURRENT_CHARGE_AMT_ETX | NUMBER | 22 | Y | Net charges current amt | Total amount of non refunded charges excluding tax |
| CURRENT_CHARGE_AMT_ITX | NUMBER | 22 | Y | Gross charges current amt | Total amount of non refunded charges including tax |
| CURRENT_QUANTITY | NUMBER | 22 | Y | Current quantity | Number of non cancelled tickets |
| DN_CT_ADDR_ZIPCODE | VARCHAR2 | 240 | Y | Postal code of purchaser address | |
| DN_QUOTA | NUMBER | 22 | Y | Quota of an item, performance and given seat category, or timeslot and given pass | |
| EXPIRATION_DATE | DATE | 7 | Y | Deadline for the the payment of an option or booking (dd.mm.yyyy) | |
| EXP_DATE_YY_MM_DD | VARCHAR2 | 10 | Y | Expiration date | Deadline for the the payment of an option or booking (yyyy.mm.dd) |
| EXTERNAL_REFERENCE | VARCHAR2 | 400 | Y | External reference | External reference tracks the 3rd-party website/partner that leads to the sales conversion |
| FEE | VARCHAR2 | 240 | Y | Name of fee | |
| FILE_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. | |
| FILE_CONTACT_NUMBER | VARCHAR2 | 20 | Y | File contact number | |
| FILE_EXT_STATUS | VARCHAR2 | 4000 | Y | External file status. Possible values editable by institution | |
| FILE_NUMBER | NUMBER | 22 | Y | File number | File number |
| FILE_STATE | VARCHAR2 | 4000 | Y | File state. Possible values are: - In progress - Suspended - Option - Reservation - Option/reservation - Confirmed - Not settled - Part. settled - Settled - Canceled - Discarded - Technical error |
|
| FINDER_FILE_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | Finder contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
| FINDER_FILE_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Finder contact number | Contact number |
| GOODS_BARCODE | VARCHAR2 | 128 | Y | Goods barcode | Barcode of item product |
| GOODS_COLLECTION | VARCHAR2 | 240 | Y | Collection | Name of goods collection |
| GOODS_DIMENSION | VARCHAR2 | 4000 | Y | Goods item characteristics | Conctenated value of good dimensions (example: Size:M, Colour: Red) |
| GOODS_FAMILY | VARCHAR2 | 240 | Y | Goods family | Name of goods family |
| GOODS_SUBFAMILY | VARCHAR2 | 240 | Y | Goods sub-family | Name of subfamily of goods product (only level 1) |
| GOODS_SUBTOPIC | VARCHAR2 | 240 | Y | Goods sub-topic | Name of subtopic of goods product (only level 1) |
| GOODS_TOPIC | VARCHAR2 | 240 | Y | Goods topic | Name of topic of goods product |
| GOODS_UNIT_AMNT_WITHOUT_VAT | NUMBER | 22 | Y | Average unit amount of item purchase | |
| HOSP_ROOM | VARCHAR2 | 240 | Y | Name of the hospitality room | |
| HOSP_ROOM_CODE | VARCHAR2 | 60 | Y | Hospitality room code | |
| HOSP_SESSION | VARCHAR2 | 240 | Y | Hospitality session | |
| INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
| INSURED | CHAR | 1 | Y | Insured | Flag indicating whether the sale is covered by the cancellation insurance (True, False) |
| INSURED_AMT_ETX | NUMBER | 22 | Y | Amount of insurance premium excluding tax | |
| INSURED_AMT_ITX | NUMBER | 22 | Y | Amount of insurance premium including tax | |
| INVOICE_CONTACT_FMT_NAME | VARCHAR2 | 2000 | Y | Local invoice contact | Local invoice contact |
| INVOICE_DATE | TIMESTAMP(3) WITH TIME ZONE | 13 | Y | Invoice date | Invoice date |
| INVOICE_NUMBER | VARCHAR2 | 4000 | Y | Invoice number | Invoice number |
| IP_ADDRESS | VARCHAR2 | 50 | Y | Contact IP Address | Contact IP Address |
| IS_ACCOUNTING_BALANCE | VARCHAR2 | 1 | Y | Boolean (T/F) indicating if it′s accouting balanced. | |
| ITEM | VARCHAR2 | 4000 | Y | Item | Item name |
| ITEM_REFERENCE | VARCHAR2 | 80 | Y | Item Reference | Goods item reference |
| LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
| LICENCE_NUMBER | VARCHAR2 | 4000 | Y | Performance license number | Performance licence number |
| LOGICAL_SEAT_CATEGORY | VARCHAR2 | 240 | Y | Logical seat category | Name of logical seat category |
| LOG_SEAT_CATEGORY_EXT_NAME | VARCHAR2 | 240 | Y | Logical seat category | Logical seat category external name |
| MANAGER | VARCHAR2 | 833 | Y | Manager | Name of ticketing system managing the product (if current institution acts as a reseller) |
| 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 | |
| NET_BOOKING_AMT_ETX | NUMBER | 22 | Y | Net res. amt excl. VAT | Booking amount excluding tax (cancellations are subtracted) |
| NET_BOOKING_AMT_ITX | NUMBER | 22 | Y | Net res. amt incl. VAT | Booking amount including tax (cancellations are subtracted) |
| NET_BOOKING_CHARGE_AMT_ETX | NUMBER | 22 | Y | Net res. charges amt excl. VAT | Amount of charges on bookings excluding tax (cancellations are subtracted) |
| NET_BOOKING_CHARGE_AMT_ITX | NUMBER | 22 | Y | Net res. charges amt incl. VAT | Amount of charges on bookings including tax (cancellations are subtracted) |
| NET_BOOKING_CHARGE_TAX_AMT | NUMBER | 22 | Y | Booking charge tax net amt | Tax amount on charges on bookings (cancellations are subtracted) |
| NET_BOOKING_COMMISSION_AMT_ITX | NUMBER | 22 | Y | Net booking commission amt | Commission amount on bookings including tax (cancellations are subtracted) |
| NET_BOOKING_C_QTY | NUMBER | 22 | Y | Net res. C | Number of bookings of free tickets (cancellations are subtracted) |
| NET_BOOKING_P_QTY | NUMBER | 22 | Y | Net res. P | Number of bookings of paid tickets (cancellations are subtracted) |
| NET_BOOKING_TAX_AMT | NUMBER | 22 | Y | Booking tax net amt | Booking tax amount (cancellations are subtracted) |
| NET_BOOKING_TKT_AMT_ITX | NUMBER | 22 | Y | Booking amount (only ticket price) including tax (cancellations are subtracted) | |
| NET_BOOKING_T_QTY | NUMBER | 22 | Y | Net res. T | Total number of bookings (cancellations are subtracted) |
| NET_BOOKING_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Net booking qty inside composed product | Total number of bookings inside a composed product (cancellations are subtracted) |
| NET_COMMISSION_AMT_ITX | NUMBER | 22 | Y | Commission amount on sales including tax (cancellations are subtracted) | |
| NET_OPTION_AMT_ETX | NUMBER | 22 | Y | Net option amt excl. VAT | Option amount excluding tax (cancellations are subtracted) |
| NET_OPTION_AMT_ITX | NUMBER | 22 | Y | Net option amt incl. VAT | Option amount including tax (cancellations are subtracted) |
| NET_OPTION_CHARGE_AMT_ETX | NUMBER | 22 | Y | Net option charges amt excl. VAT | Amount of charges on options excluding tax (cancellations are subtracted) |
| NET_OPTION_CHARGE_AMT_ITX | NUMBER | 22 | Y | Net option charges amt incl. VAT | Amount of charges on options including tax (cancellations are subtracted) |
| NET_OPTION_CHARGE_TAX_AMT | NUMBER | 22 | Y | Option charge tax net amt | Tax amount on charges on options (cancellations are subtracted) |
| NET_OPTION_C_QTY | NUMBER | 22 | Y | Net option C | Number of options of free tickets (cancellations are subtracted) |
| NET_OPTION_P_QTY | NUMBER | 22 | Y | Net option P | Number of options of paid tickets (cancellations are subtracted) |
| NET_OPTION_TAX_AMT | NUMBER | 22 | Y | Net requested tax amt | Option tax amount (cancellations are subtracted) |
| NET_OPTION_T_QTY | NUMBER | 22 | Y | Net option T | Total number of options (cancellations are subtracted) |
| NET_OPTION_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Net option qty inside composed product | Total number of options inside a composed product (cancellations are subtracted) |
| NET_SOLD_AMT_ETX | NUMBER | 22 | Y | Net sales amt excl.Tax | Total amount of sales excluding tax (cancellations are subtracted) |
| NET_SOLD_AMT_ETX_NOT_ROUNDED | NUMBER | 22 | Y | Net sales amt excl.Tax (unrounded) | Total amount of sales excluding tax (cancellations are subtracted). This amount isn't rounded. |
| NET_SOLD_AMT_ITX | NUMBER | 22 | Y | Net Sales amt incl.Tax | Total amount of sales including tax (cancellations are subtracted) |
| NET_SOLD_AUTH_AMT_ETX | NUMBER | 22 | Y | Net amt of fixed price season ticket (excl. VAT) | Amount excluding tax of authorised tickets within fixed price season tickets |
| NET_SOLD_AUTH_AMT_ITX | NUMBER | 22 | Y | Net amt of fixed price season ticket (incl. VAT) | Amount including tax of authorised tickets within fixed price season tickets |
| NET_SOLD_AVAILABLE_AMT_ITX | NUMBER | 22 | Y | Net amt of available tickets | Amount including tax of tickets not yet selected within fixed price season tickets |
| NET_SOLD_CHARGE_AMT_ETX | NUMBER | 22 | Y | Net sale charges | Amount of charges on sales excluding tax (cancellations are subtracted) |
| NET_SOLD_CHARGE_AMT_ITX | NUMBER | 22 | Y | Net Sales Charges amt incl.Tax | Amount of charges on sales including tax (cancellations are subtracted) |
| NET_SOLD_CHARGE_TAX_AMT | NUMBER | 22 | Y | Sold charge tax net amt | Tax amount on charges on sales (cancellations are subtracted) |
| NET_SOLD_C_QTY | NUMBER | 22 | Y | Net sold C | Number of sales of free tickets (cancellations are subtracted) |
| NET_SOLD_P_QTY | NUMBER | 22 | Y | Net sold P | Number of sales of paid tickets (cancellations are subtracted) |
| NET_SOLD_TAX_AMT | NUMBER | 22 | Y | Net sales tax amt | Sales tax amount (cancellations are subtracted) |
| NET_SOLD_TAX_AMT_NOT_ROUNDED | NUMBER | 22 | Y | Net tax amt (unrounded) | Total amount of VAT (cancellations are subtracted). This amount isn't rounded. |
| NET_SOLD_TKT_AMT_ITX | NUMBER | 22 | Y | Total amount of sales (only ticket price) including tax (cancellations are subtracted) | |
| NET_SOLD_T_QTY | NUMBER | 22 | Y | Net sold T | Total number of sales (cancellations are subtracted) |
| NET_SOLD_T_QTY_AUTH | NUMBER | 22 | Y | Number of authorised tickets | Number of authorised tickets within fixed price season tickets |
| NET_SOLD_T_QTY_AVAILABLE | NUMBER | 22 | Y | Number of available tickets | Number of not yet selected tickets within fixed price season tickets |
| NET_SOLD_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Net sold qty inside composed product | Total number of sales inside a composed product (cancellations are subtracted) |
| NET_SOLD_USED_AMT_ITX | NUMBER | 22 | Y | Net amt of package/season ticket content (incl. VAT) | Number of already selected tickets within fixed price season tickets |
| ONETIMECODE_STRUCT | VARCHAR2 | 1000 | Y | Structure having received the code | |
| ONETIMECODE_STRUCT_NUMBER | VARCHAR2 | 20 | Y | Structure having received the code | |
| OPERATION_TYPE | VARCHAR2 | 4000 | Y | Operation type | Operation type. Possible values are: - booking - booking cancellation - sale - refund - option - option cancellation |
| OPERATOR_LOGIN | VARCHAR2 | 20 | Y | Operator login | |
| OPTION_AMT_ETX | NUMBER | 22 | Y | Net requested amt | Option amount excluding tax |
| OPTION_AMT_ITX | NUMBER | 22 | Y | Gross requested amt | Option amount including tax |
| OPTION_CANCEL_AMT_ETX | NUMBER | 22 | Y | Option cancellation amount excl. VAT | Amount of cancelled options excluding tax |
| OPTION_CANCEL_AMT_ITX | NUMBER | 22 | Y | Option cancellation amount incl. VAT | Amount of cancelled options including tax |
| OPTION_CANCEL_CHARGE_AMT_ETX | NUMBER | 22 | Y | Net request charge cancellation amt | Amount of charges on cancelled options excluding tax |
| OPTION_CANCEL_CHARGE_AMT_ITX | NUMBER | 22 | Y | Gross request charge cancellation amt | Amount of charges on cancelled options including tax |
| OPTION_CANCEL_C_QTY | NUMBER | 22 | Y | Request cancellation C | Number of cancelled free options |
| OPTION_CANCEL_P_QTY | NUMBER | 22 | Y | Request cancellation P | Number of cancelled paid options |
| OPTION_CANCEL_T_QTY | NUMBER | 22 | Y | Request cancellation T | Total number of cancelled options |
| OPTION_CANCEL_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Option canceled qty inside composed product | Total nomber of cancelled options of tickets inside a composed product |
| OPTION_CHARGE_AMT_ETX | NUMBER | 22 | Y | Net requested charges | Amount of charges on options excluding tax |
| OPTION_CHARGE_AMT_ITX | NUMBER | 22 | Y | Gross requested charges | Amount of charges on options including tax |
| OPTION_C_QTY | NUMBER | 22 | Y | Requested C | Number of options of free tickets |
| OPTION_P_QTY | NUMBER | 22 | Y | Requested P | Number of options of paid tickets |
| OPTION_STATE | VARCHAR2 | 4000 | Y | Option state | Option state (ex: requested, confirmed) |
| OPTION_TAX_AMT | NUMBER | 22 | Y | Requested tax amt | Option tax amount |
| OPTION_T_QTY | NUMBER | 22 | Y | Requested T | Total number of options |
| OPTION_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Option qty inside composed product | Total number of options inside a composed product |
| ORDER_CLOSING_DATE_TIME | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Order closing date time | Order closing date time |
| ORDER_CONTACT_ADDRESS | VARCHAR2 | 4000 | Y | Contact address (street, number, address complement) | |
| ORDER_CONTACT_COUNTRY | VARCHAR2 | 4000 | Y | Address country name | |
| ORDER_CONTACT_EMAIL | VARCHAR2 | 254 | Y | Order contact email | Email address of contact |
| ORDER_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. | |
| ORDER_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Order contact N° | Contact number |
| ORDER_CONTACT_PRIMARY_PHONE | VARCHAR2 | 31 | Y | Phone number incl. Prefix | |
| ORDER_CONTACT_STRUCT_NAME | VARCHAR2 | 400 | Y | Order contact structure | Name of company/institution the contact belongs to |
| ORDER_CONTACT_STRUCT_NUMBER | VARCHAR2 | 20 | Y | Order contact structure N° | Number of company/institution the contact belongs to |
| ORDER_CONTACT_TOWN | VARCHAR2 | 400 | Y | Town of address | |
| ORDER_CONTACT_ZIPCODE | VARCHAR2 | 20 | Y | Postal code | |
| ORDER_CREATION_DATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Order creation date | |
| ORDER_DATE | VARCHAR2 | 10 | Y | Purchase order date | Order date |
| ORDER_DATE_MM_YY | VARCHAR2 | 7 | Y | Order month | Order month (MM.YYYY) |
| ORDER_DATE_TIME | VARCHAR2 | 19 | Y | Order date time | Order date time |
| ORDER_DATE_YY | VARCHAR2 | 4 | Y | Order year | Order year |
| ORDER_DATE_YY_MM | VARCHAR2 | 7 | Y | Order month year | Order month (MM.YYYY) |
| ORDER_DATE_YY_MM_DD | VARCHAR2 | 10 | Y | Order date | |
| ORDER_NUMBER | NUMBER | 22 | Y | Order Number | Order number |
| ORDER_POS | VARCHAR2 | 32 | Y | Code of point of sale | |
| ORDER_QUANTITY | NUMBER | 22 | Y | Order quantity | Number of tickets |
| ORDER_REMARK | VARCHAR2 | 4000 | Y | Order remark | |
| ORDER_TYPE | VARCHAR2 | 25 | Y | Order type (sale, exchange) | |
| ORDER_UNIT_FEE | NUMBER | 22 | Y | Obsolete. Avoid using. | |
| ORDER_WEEK | VARCHAR2 | 2 | Y | Order week | Order date: number of week |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| ORG_CURRENCY_CODE | CHAR | 3 | Y | Organization currency | Currency code of organization |
| ORIGINAL_POS | VARCHAR2 | 32 | Y | Original point of sales, i.e. the point of sales having performed the sale. | |
| ORIGINATING_SALES_CHANNEL | VARCHAR2 | 240 | Y | Originating Sales channel | Neme of the sales channel that performed the original booking/sale |
| ORIGIN_COUNTRY | VARCHAR2 | 4000 | Y | Name of the country of origin | |
| ORIGIN_COUNTRY_CODE | CHAR | 2 | Y | Origin country code | |
| ORIGIN_GENDER | VARCHAR2 | 100 | Y | Origin gender | Origin gender |
| ORIGIN_REGION | VARCHAR2 | 4000 | Y | Name of the region of origin | |
| ORIGIN_REGION_CODE | VARCHAR2 | 40 | Y | Identifier of the region of origin | |
| ORIGIN_YEAR_OF_BIRTH | NUMBER | 22 | Y | Origin year of birth | Origin year of birth |
| OTC_STRUCT_CT_ID | NUMBER | 22 | Y | Structure having received the code | |
| PARENT_CONTINGENT | VARCHAR2 | 240 | Y | Parent contingent | Contingent name |
| PARENT_HOSP_BUNDLE | VARCHAR2 | 240 | Y | Hospitality bundle name | |
| PARENT_HOSP_BUNDLE_CODE | VARCHAR2 | 32 | Y | Hospitality bundle code | |
| PARENT_HOSP_PRODUCT | VARCHAR2 | 240 | Y | Hospitality product name | |
| PARENT_HOSP_PRODUCT_CODE | VARCHAR2 | 32 | Y | Hospitality product code | |
| PARENT_HOSP_ROOM | VARCHAR2 | 240 | Y | Hospitality room name | |
| PARENT_HOSP_ROOM_CODE | VARCHAR2 | 32 | Y | Hospitality room code | |
| PARENT_PRODUCT | VARCHAR2 | 240 | Y | Composed product | Name of composed product (containing the current single product) |
| PARENT_PRODUCT_FAMILY | VARCHAR2 | 4000 | Y | Name of product family of composed product (containing the current single product). Possible values are: - Season ticket - Hospitality bundle - Package |
|
| PARENT_PRODUCT_TYPE | VARCHAR2 | 240 | Y | Composed product type | Name of product type of composed product (containing the current single product) |
| PARENT_P_FAMILY_TYPE | VARCHAR2 | 25 | Y | Name of product family type of composed product (containing the current single product) | |
| PARTNER_CONTACT_FMT_NAME | VARCHAR2 | 1034 | Y | Partner contact | Name of the institution (Contact) organizing the event (current organization acts as as a reseller) in format: "last name, first name (contact number)". No contact number if only beneficiary. |
| PARTNER_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Partner contact number | Name of the institution (Contact) organizing the event (current organization acts as as a reseller) |
| PAYMENT_STATE | VARCHAR2 | 4000 | Y | Payments state | Payment state. Possible values are: - Deposit - Paid/not paid - Suspense account (paid/not paid) |
| PERFORMANCE_DESCRIPTION | VARCHAR2 | 1000 | Y | Performance description | Performance description |
| PERFORMANCE_QUOTA | NUMBER | 22 | Y | Performance quota | |
| PERF_FISCAL_NUMBER | NUMBER | 22 | Y | Performance fiscal number | |
| PERF_TIMESLOT_STATE | VARCHAR2 | 4000 | Y | Translated value of T_PERF_TIMESLOT_STATE | |
| PRICE_DYNAMIC | CHAR | 1 | Y | Flag indicating whether the price is defined dynamically | |
| PRICE_LEVEL_CODE | VARCHAR2 | 32 | Y | Price level | Price level code |
| PRODUCER_CONTACT_FMT_NAME | VARCHAR2 | 1034 | Y | Producer contact | Name of the company (Contact) producing the event in format: "last name, first name (contact number)". No contact number if only beneficiary. |
| PRODUCER_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Producer contact N° | Number of the company (Contact) producing the event |
| PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
| PRODUCT_CODE | VARCHAR2 | 32 | Y | Product code | |
| PRODUCT_DATE | VARCHAR2 | 8 | Y | Product date | Performance or timeslot date (dd.mm.yyyy) |
| PRODUCT_DATE_DAY | VARCHAR2 | 1 | Y | Product weekday | Performance or timeslot day of week |
| PRODUCT_DATE_MM_YY | VARCHAR2 | 7 | Y | Performance or timeslot month (mm.yyyy) | |
| PRODUCT_DATE_TIME | TIMESTAMP(3) | 11 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
| PRODUCT_DATE_YY_MM | VARCHAR2 | 7 | Y | Product month year | Performance or timeslot month (yyyy.mm) |
| PRODUCT_DATE_YY_MM_DD | VARCHAR2 | 10 | Y | Performance or timeslot date (yyyy.mm.dd) | |
| PRODUCT_DESIGNATION | VARCHAR2 | 4000 | Y | Product designation | |
| PRODUCT_EXTERNAL_NAME | VARCHAR2 | 240 | Y | External name of product | |
| 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 |
| PRODUCT_STATE | VARCHAR2 | 4000 | Y | Product state | Product state. Possible values are: - Cancelled - Running - Suspended |
| PRODUCT_TIME | VARCHAR2 | 5 | Y | Product time | Performance or timeslot time (hh:mm:ss) |
| PRODUCT_TYPE | VARCHAR2 | 240 | Y | Product type | Name of product type |
| PROD_ACC_EXTERNAL_ID | VARCHAR2 | 4000 | Y | Product accounting code. This code can be freely defined in SecuTix and establishes a link to the accounting performed outside SecuTix. Our Confluence web site describes how to define accounting codes. | |
| PROMOTION | VARCHAR2 | 240 | Y | Promotion | Promotion name (name of package, season ticket, membership or advantage) |
| PROMOTION_TYPE | VARCHAR2 | 4000 | Y | Promotion type | promotion can be of 4 types: PACKAGE - when a product is part of package SEASON_TICKET - when a product is part of season ticket MEMBERSHIP - when a product is sold @ membership rates ADVANTAGE - when a product is sold with advantage. |
| P_PRICE_DYNAMIC | CHAR | 1 | Y | Boolean (T/F) indicating if it′s dynamic price composed product | |
| RATE_TYPE | VARCHAR2 | 240 | Y | Rate type | Name of rate type |
| REFERENCE_DATE | DATE | 7 | Y | Reference date | Order reference date |
| REFUND_AMT_ETX | NUMBER | 22 | Y | Refund amt excl. Tax | Refund amount excluding tax |
| REFUND_AMT_ITX | NUMBER | 22 | Y | Refund amt incl. Tax | Refund amount including tax |
| REFUND_CHARGE_AMT_ETX | NUMBER | 22 | Y | Refund charges excl. Tax | Refund charge amount excluding tax |
| REFUND_CHARGE_AMT_ITX | NUMBER | 22 | Y | Refund charges incl. Tax | Refund charge amount including tax |
| REFUND_COMMISSION_AMT_ITX | NUMBER | 22 | Y | Refund commission amt incl. Tax | Refund commission amount including tax |
| REFUND_C_QTY | NUMBER | 22 | Y | Refund C | Number of cancelled free tickets |
| REFUND_P_QTY | NUMBER | 22 | Y | Refund P | Number of cancelled paid tickets |
| REFUND_T_QTY | NUMBER | 22 | Y | Refund T | Total number of cancelled tickets |
| REFUND_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Refunded qty inside composed product | Number of cancelled tickets within composed product |
| REQUEST_SALE_GAP | NUMBER | 22 | Y | Request sale days | Not available |
| SALES_CHANNEL | VARCHAR2 | 240 | Y | Sales channel | Sales channel name |
| SALES_CHANNEL_TYPE | VARCHAR2 | 4000 | Y | Sale channel type | Name of sales channel type. Possible values are: - Ticket vending machine - Goods shop - Secutix file - Box office - Internet agency - Internet resale platform - Internet B2B - Internet B2C - Phone platform |
| SALES_TYPE | VARCHAR2 | 10 | Y | Sales type | Sales type (anonymous, registered) |
| SALE_AMT_ETX | NUMBER | 22 | Y | Sale amt excl. Tax | Sale amount excluding tax |
| SALE_AMT_ITX | NUMBER | 22 | Y | Sale amt incl. Tax | Sale amount including tax |
| SALE_CHARGE_AMT_ETX | NUMBER | 22 | Y | Sale charges excl. Tax | Amount of charges on sales excluding tax |
| SALE_CHARGE_AMT_ITX | NUMBER | 22 | Y | Sale charges incl. Tax | Amount of charges on sales including tax |
| SALE_CHARGE_TAX_AMT | NUMBER | 22 | Y | Sale charge tax amt | Tax amount on charges on sales |
| SALE_COMMISSION_AMT_ITX | NUMBER | 22 | Y | Gross sale commission amt | Commission on sales including tax |
| SALE_FILE_CONCT_STRUCT | VARCHAR2 | 1220 | Y | Name of the company/organization the contact belongs to | |
| SALE_FILE_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | Sales file contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
| SALE_FILE_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Sales file contact number | Contact number |
| SALE_TAX_AMT | NUMBER | 22 | Y | Sale tax amt | Sales tax amount |
| 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 |
| SEASON_CODE | VARCHAR2 | 32 | Y | Season code | |
| SEAT_CATEGORY | VARCHAR2 | 60 | Y | Seat category | Seat category name |
| SELFPAID_VAT | CHAR | 1 | Y | VAT self-payment | Flag indicating whether the VAT amount has to be paid by the purchaser in his country of residence |
| SELLER_ORGANIZATION | VARCHAR2 | 240 | Y | Seller organization | Organization name |
| SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
| SOLD_C_QTY | NUMBER | 22 | Y | Sold C | Number of sales of free tickets |
| SOLD_P_QTY | NUMBER | 22 | Y | Sold P | Number of sales of paid tickets |
| SOLD_T_QTY | NUMBER | 22 | Y | Sold T | Total number of sales of paid tickets |
| SOLD_T_QTY_CHILD_INSIDE_CP | NUMBER | 22 | Y | Number of sales inside composed product | |
| SOLD_T_QTY_INSIDE_CP | NUMBER | 22 | Y | Sold qty inside composed product | Number of sales inside composed product |
| 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 | |
| START_TIME | TIMESTAMP(3) | 11 | Y | Hour of start date of the period (ex: 10:00 am) | |
| SUB_TOPIC | VARCHAR2 | 240 | Y | Sub topic | Subtopic (level 1) of lowest rank assigned to the product. |
| TAX_CODE | VARCHAR2 | 32 | Y | VAT code | VAT code. VAT codes are defined for each country. For instance, for France: - TN: Normal rate - TR: Reduced rate - TSR: Highly reduced rate - T0: Zero rate A VAT rate that may depend on a period of time is defined for each VAT code. |
| TAX_RATE | NUMBER | 22 | Y | VAT rate | VAT rate |
| 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) |
| TIMESLOT_CONT_AVL | NUMBER | 22 | Y | Availability of timeslot contingent | |
| TIMESLOT_CONT_QUOTA | NUMBER | 22 | Y | Quota of timeslot contingent | |
| TIME_ZONE | VARCHAR2 | 40 | Y | Time zone of the organization | |
| TOPIC | VARCHAR2 | 240 | Y | Topic | Parent of the subtopic related to the product. |
| TOTAL_CURRENT_AMT_ETX | NUMBER | 22 | Y | Net current amount | Total amount of non cancelled operations excluding tax |
| TOTAL_CURRENT_AMT_ITX | NUMBER | 22 | Y | Gross current amount | Total amount of non cancelled operations including tax |
| TOTAL_NET_BOOKING_C_CNT | NUMBER | 22 | Y | Nb of part. – Net res C | Number of non-paying participants - bookings (cancellations are subtracted) |
| TOTAL_NET_BOOKING_P_CNT | NUMBER | 22 | Y | Nb of part. – Net res P | Number of paying participants - bookings (cancellations are subtracted) |
| TOTAL_NET_BOOKING_T_CNT | NUMBER | 22 | Y | Nb of part. – Net res T | Total number of participants - bookings (cancellations are subtracted) |
| TOTAL_NET_SOLD_C_CNT | NUMBER | 22 | Y | Nb of part. – Net sold C | Number of non-paying participants - sales (cancellations are subtracted) |
| TOTAL_NET_SOLD_P_CNT | NUMBER | 22 | Y | Nb of part. – Net sold P | Number of paying participants - sales (cancellations are subtracted) |
| TOTAL_NET_SOLD_T_CNT | NUMBER | 22 | Y | Nb of part. – Net sold T | Total number of participants - sales (cancellations are subtracted) |
| TOTAL_UNIT_AMT_ETX | NUMBER | 22 | Y | Net total amount | Total amount of operations excluding tax |
| TOTAL_UNIT_AMT_ITX | NUMBER | 22 | Y | Gross total amount | Total amount of operations including tax |
| TOUR | VARCHAR2 | 240 | Y | Tour | Tour |
| TOUR_PROMOTER | VARCHAR2 | 1661 | Y | Tour promoter | Tour promoter |
| TOUR_PROMOTER_ID | NUMBER | 22 | Y | Technical identifier of contact who is the tour promoter | |
| TOWN | VARCHAR2 | 400 | Y | Town | Town |
| T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
| T_ADVANTAGE_ID | NUMBER | 22 | Y | Technical identifier of advantage | |
| T_AUDIENCE_CAT_ID | NUMBER | 22 | Y | Audience category technical identifier | |
| T_AUDIENCE_SUB_CAT_ID | NUMBER | 22 | Y | Technical identifier of tariff | |
| T_CASHDESK_ID | NUMBER | 22 | Y | Technical identifier of cash desk | |
| T_CHARGES_ID | NUMBER | 22 | Y | Technical identifier of simple charge | |
| T_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| T_CONTINGENT_TYPE | VARCHAR2 | 25 | Y | Type of audience for which the contingent is foreseen. Possible values are: - Target group - Invited - Company - Services - Press - Diplomatic - Disabled - Other - Goods stock |
|
| T_CO_PRODUCER_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact who is the co-producer | |
| T_FAMILY_SUB_TYPE | VARCHAR2 | 38 | Y | Name of product family subtype. Possible values are: - DATE_SPECIFIC_PASS: dated pass - DONATION: donation - GOODS: goods product - HOSPITALITY: hospitality for a single match - HOSPITALITY_PACKAGE: hospitality for several matches - MEMBERSHIP: membership - OPEN: open product - OPEN_PASS: non-dated pass - PACKAGE: package - SEASONTICKET: season ticket - SERVICE: service - SIMPLE_TICKET: event - SPORTING_EVENT: competition - TIMESLOT_PASS: timeslot pass - VISIT: visit (old visits based on events) - VISIT_PASS: visit pass - VOUCHER: voucher |
|
| 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_FILE_EXT_STATUS | VARCHAR2 | 120 | Y | External file status code. Possible values editable by institution | |
| T_FILE_STATE | VARCHAR2 | 25 | Y | File state. Possible values are: - RUNNING - SUSPENDED - IN_OPTION - IN_RESERVATION - OPTION_RESERV - CONFIRMED - NOT_SOLDED - PART_SOLDED - SOLDED - CANCELED - ABANDONNED - TECH_ERROR |
|
| T_GOODSCOLLECTION_ID | NUMBER | 22 | Y | Technical identifier of goods collection | |
| T_GOODS_FAMILY_ID | NUMBER | 22 | Y | Technical identifier of goods family | |
| T_GOODS_SUBFAMILY_ID | NUMBER | 22 | Y | Technical identifier of subfamily of goods product (only level 1) | |
| T_GOODS_SUBTOPIC_ID | NUMBER | 22 | Y | Technical identifier of subtopic of goods product (only level 1) | |
| T_GOODS_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of topic of goods product | |
| T_HOSPROOM_ID | NUMBER | 22 | Y | Technical identifier of the hospitality room | |
| T_HOSPSESSION_ID | NUMBER | 22 | Y | Technical identifier of the hospitality session | |
| T_INVOICE_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact who is the local invoice contact | |
| T_ITEMCONT_ID | NUMBER | 22 | Y | Technical identifier of item-contingent | |
| T_ITEM_ID | NUMBER | 22 | Y | Technical identifier of item | |
| T_LOG_SEAT_CAT_ID | NUMBER | 22 | Y | Technical identifier of logical seat category | |
| T_MANAGER_ID | NUMBER | 22 | Y | Technical identifier of external manager | |
| T_OPERATION_DATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Timestamp of operation creation | |
| T_OPERATION_ID | NUMBER | 22 | Y | Technical identifier of operation | |
| T_OPERATION_KIND | VARCHAR2 | 25 | Y | Operation type. Possible values are: - CHARGES - COMMISSION - COMPOSED_PRODUCT - DELIVERY_OVERHEADS - ORDER_OVERHEADS - PAYMENT_OVERHEADS - PRODUCT_COMPOSITION (part of a composed product) - SIMPLE_PRODUCT: any product except season ticket, package and single entry - SINGLE_ENTRY: single entry |
|
| T_OPERATION_TYPE | VARCHAR2 | 25 | Y | Operation type. Possible values are: - OPTION - OPTION_CANCEL - REFUND - SALE - RESERVATION - RESERVATION_CANCEL |
|
| T_OPTION_STATE | VARCHAR2 | 25 | Y | Option state. Possible values are: - Pre-requested - Requested - Confirmed - Rejected |
|
| 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_ST_CT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
| T_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
| T_ORIGINAL_POS_ID | NUMBER | 22 | Y | Technical identifier of original point of sales, i.e. the point of sales having performed the sale. | |
| T_ORIGINATING_SALES_CHANNEL | NUMBER | 22 | Y | Technical identifier of sales channel | |
| T_OVERHEADS_ID | NUMBER | 22 | Y | Technical identifier of overheads | |
| T_PARTNER_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
| T_PAYMENT_STATE | 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_PERF_TIMESLOT_STATE | VARCHAR2 | 25 | Y | State of performance or timeslot: - Running - Suspended |
|
| T_PLACEADDR_ID | NUMBER | 22 | Y | Place address | |
| T_PRODUCER_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
| T_PRODUCT_FAMILY_ID | NUMBER | 22 | Y | Technical identifier of product family | |
| T_PRODUCT_ID | NUMBER | 22 | Y | Product technical identifier | |
| T_PRODUCT_STATE | VARCHAR2 | 25 | Y | Product state. Possible values are: - Cancelled - Running - Suspended |
|
| T_PRODUCT_TYPE_ID | NUMBER | 22 | Y | Technical identifier of product type | |
| T_PROMOTION_ID | NUMBER | 22 | Y | Technical identifier of promotion | |
| T_PROMOTION_TYPE | VARCHAR2 | 80 | Y | Promotion type. Possible values are : PACKAGE, SEASON_TICKET,MEMBERSHIP,ADVANTAGE | |
| T_P_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| T_P_OPERATION_ID | NUMBER | 22 | Y | Technical identifier of operation | |
| T_P_PRODFAMILY_ID | NUMBER | 22 | Y | Technical identifier of product family of composed product (containing the current single product) | |
| T_P_PRODTYPE_ID | NUMBER | 22 | Y | Technical identifier of product type | |
| T_P_PRODUCT_ID | NUMBER | 22 | Y | Technical identifier of product | |
| T_RATE_TYPE_ID | NUMBER | 22 | Y | Technical identifier of rate type | |
| T_RESUMED_OP_ID | NUMBER | 22 | Y | Technical identifier of resumed operation (if the current operation resumes another one) | |
| T_SALCHAN_ID | NUMBER | 22 | Y | Technical identifier of sales channel | |
| T_SALES_CHANNEL_TYPE | VARCHAR2 | 25 | Y | Type of sales channel | |
| T_SALE_FILE_CONTACT_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_SELLER_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
| T_SHIPMENTFEE_ID | NUMBER | 22 | Y | Technical identifier of shipment fee | |
| 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_TIMESLOT_ID | NUMBER | 22 | Y | Technical identifier of timeslot | |
| T_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of goods topic | |
| T_TOUR_ID | NUMBER | 22 | Y | Technical identifier of tour | |
| T_VISITTHEME_ID | NUMBER | 22 | Y | Technical identifier of visit theme | |
| UNIT_AMT_ETX | NUMBER | 22 | Y | Net Unit price | Product unit price excluding tax |
| UNIT_AMT_ITX | NUMBER | 22 | Y | Gross Unit price | Product unit price including tax |
| UNIT_CHARGE_AMT_ETX | NUMBER | 22 | Y | Unit amount of charges excluding tax | |
| UNIT_CHARGE_AMT_ITX | NUMBER | 22 | Y | Unit amount of charges including tax | |
| VISITGROUP_ID | NUMBER | 22 | Y | Technical identifier of visit group | |
| VISITTHEME | VARCHAR2 | 240 | Y | Visit theme | Visit theme |
| VISIT_LANGUAGE | VARCHAR2 | 4000 | Y | Visit language | Visit language |