Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
| ADVANTAGE | VARCHAR2 | 240 | Y | Advantage | Advantage name |
| 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. | |
| AUDIENCECATEGORY | VARCHAR2 | 4000 | Y | Audience category | 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 |
| AUDIENCESUBCATEGORY | VARCHAR2 | 240 | Y | Tariff | Tariff name |
| 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 | |
| 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_QUANTITY | NUMBER | 22 | Y | Current quantity | Number of non cancelled tickets |
| DN_QUOTA | NUMBER | 22 | Y | Quota of an item, performance and given seat category, or timeslot and given pass | |
| 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 | |
| INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
| INVOICE_CONTACT_FMT_NAME | VARCHAR2 | 2000 | Y | Local invoice contact | Local invoice contact |
| IS_ACCOUNTING_BALANCE | VARCHAR2 | 1 | Y | Boolean (T/F) indicating if it′s accouting balanced. | |
| IS_GOODS | NUMBER | 22 | Y | Flag indicating if the current product is a goods product | |
| 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 |
| 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_AUTH | NUMBER | 22 | Y | VAT amt of fixed price season ticket | Tax amount on authorised tickets within fixed price season tickets |
| 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 |
| 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_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_DATE | VARCHAR2 | 10 | Y | Purchase order date | Order date |
| ORDER_DATE_MM_YY | VARCHAR2 | 7 | Y | Order month | Order month (MM.YYYY) |
| 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_POS | VARCHAR2 | 32 | Y | Code of point of sale | |
| 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 |
| 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 |
| PARENT_CONTINGENT | VARCHAR2 | 240 | Y | Parent contingent | Contingent name |
| PARENT_PRODUCT | VARCHAR2 | 240 | Y | Composed product | Name of composed product (containing the current single product) |
| PARENT_PRODUCT_TYPE | VARCHAR2 | 240 | Y | Composed product type | Name of product 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) |
| PERFORMANCE_DESCRIPTION | VARCHAR2 | 1000 | Y | Performance description | Performance description |
| PERFORMANCE_QUOTA | NUMBER | 22 | Y | Performance quota | |
| PERFORMANCE_STATE | VARCHAR2 | 4000 | Y | Performance state | Performance state. Possible values are: - Cancelled - Running - Suspended |
| PERF_FISCAL_NUMBER | NUMBER | 22 | Y | Performance fiscal number | |
| 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_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. | |
| 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 |
| 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_TAX_AMT | NUMBER | 22 | Y | Sale tax amt | Sales tax amount |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SEASON_CODE | VARCHAR2 | 32 | Y | Season code | |
| SEAT_CAT | VARCHAR2 | 60 | Y | Seat category name | |
| 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 |
| 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 | |
| TOPIC | VARCHAR2 | 240 | Y | Topic | Parent of the subtopic related to the product. |
| 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) |
| 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 |
| TO_DELETE | NUMBER | 22 | Y | This field will be removed soon | |
| 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_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_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_IC_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| T_INVOICE_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact who is the local invoice contact | |
| 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_ORDER_POS_ID | NUMBER | 22 | Y | Technical identifier of point of sale | |
| 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_PARTNER_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
| T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
| T_PERFORMANCE_STATE | VARCHAR2 | 25 | Y | Performance/timeslot state. Possible values are: - Running - Suspended - Cancelled |
|
| 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_P_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| 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_SALES_CHANNEL_ID | NUMBER | 22 | Y | Technical identifier of sales channel | |
| T_SALES_CHANNEL_TYPE | VARCHAR2 | 25 | Y | Type of sales channel | |
| 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_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 |
| VISITTHEME | VARCHAR2 | 240 | Y | Visit theme | Visit theme |