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 |