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 |
| 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 |
| DISCOUNT | CHAR | 1 | Y | Discount | Discount (percentage) granted by the product supplier |
| FEES | VARCHAR2 | 240 | Y | Fees | Price component name (other than ticket price) / charge name / overheads name |
| FEES_TYPE | VARCHAR2 | 4000 | Y | Fee type | Price component or fee. Possible values are: - INTERNAL PRICE COMPONENTS - EXTERNAL PRICE COMPONENTS - CHARGES - OVERHEADS - SHIPMENT_FEES |
| INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
| INVOICE_CONTACT_FMT_NAME | VARCHAR2 | 1034 | Y | Local invoice contact | Local invoice contact |
| IS_TICKET_PRICE_COMPONENT | VARCHAR2 | 4 | Y | Is ticket price component | Boolean (T/F) indicating if it′s the price component |
| ITEM | VARCHAR2 | 4000 | Y | Item | Item name |
| LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
| LOGICAL_SEAT_CATEGORY | VARCHAR2 | 240 | Y | Logical seat category | Name of logical seat category |
| 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_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) |
| ORDER_DATE | DATE | 7 | Y | Purchase order date | Order date |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| ORIGINATING_SALES_CHANNEL | VARCHAR2 | 240 | Y | Originating Sales channel | Neme of the sales channel that performed the original booking/sale |
| PARENT_PRODUCT | VARCHAR2 | 240 | Y | Composed product | Name 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 | 956 | Y | Performance description | Performance description |
| 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_DATE | VARCHAR2 | 8 | Y | Product date | Performance or timeslot date (dd.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_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_TYPE | VARCHAR2 | 240 | Y | Product type | Name of product type |
| QUANTITY | NUMBER | 22 | Y | Quantity | Number of tickets |
| REFUND_AMT_ETX | NUMBER | 22 | Y | Refund amt excl. Tax | Refund amount excluding tax |
| REFUND_AMT_ETX_NOT_ROUNDED | NUMBER | 22 | Y | Refund amt excl.Tax (unrounded) | Refund amt excl.Tax (unrounded) |
| REFUND_AMT_ITX | NUMBER | 22 | Y | Refund amt incl. Tax | Refund 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 |
| SALES_CHANNEL | VARCHAR2 | 240 | Y | Sales channel | Sales channel name |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SEAT_CAT | VARCHAR2 | 32 | Y | Seat category name | |
| SELLER_ORGANIZATION | VARCHAR2 | 240 | Y | Seller organization | Organization name |
| SOLD_AMT_ETX | NUMBER | 22 | Y | Sale amount excluding tax | |
| SOLD_AMT_ETX_NOT_ROUNDED | NUMBER | 22 | Y | Sales amt excl.Tax (unrounded) | Sales amt excl.Tax (unrounded) |
| SOLD_AMT_ITX | NUMBER | 22 | Y | Sale amount including tax | |
| 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 |
| 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 |
| TOPIC | VARCHAR2 | 240 | Y | Topic | Parent of the subtopic related to the product. |
| TOTAL_AMT_ETX | NUMBER | 22 | Y | Total amount of charges sold excluding tax (cancellations are subtracted) | |
| TOTAL_AMT_ITX | NUMBER | 22 | Y | Total amount of charges sold including tax (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 | |
| 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_CO_PRODUCER_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact who is the co-producer | |
| T_FAMILY_SUB_TYPE | VARCHAR2 | 25 | 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 | 25 | 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_FEES_TYPE | VARCHAR2 | 19 | Y | Price component or fee. Possible values are: - INTERNAL PRICE COMPONENTS - EXTERNAL PRICE COMPONENTS - CHARGES - OVERHEADS - SHIPMENT_FEES |
|
| T_FEE_ID | NUMBER | 22 | Y | Technical identifier of charge/fee | |
| 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_ORGANIZATION_ID | NUMBER | 22 | Y | Technical identifier of organization | |
| 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_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_TYPE_ID | NUMBER | 22 | Y | Technical identifier of product type | |
| T_P_PRODUCT_ID | NUMBER | 22 | Y | Technical identifier of product | |
| T_SALCHAN_ID | NUMBER | 22 | Y | Technical identifier 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_SUB_TOPIC_ID | NUMBER | 22 | Y | Identifier of subtopic | |
| 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 | |
| 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 |