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 |
| AREA | VARCHAR2 | 240 | Y | Area | Area name |
| 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_SUB_CATEGORY | VARCHAR2 | 240 | Y | Tariff name | |
| BIRTHDATE | DATE | 7 | Y | Birth date | Date of birth of cultural contact or beneficiary |
| BLOCK | VARCHAR2 | 240 | Y | Block | Block name |
| 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 |
| CONTACT_ADDRESS | VARCHAR2 | 4000 | Y | Contact address | Contact address (street, number, address complement) |
| CONTACT_ADDR_COUNTRY_CODE | CHAR | 2 | Y | Country | Address country code for cultural contact or beneficiary |
| CONTACT_ADDR_TOWN | VARCHAR2 | 400 | Y | Town | Town of address |
| CONTACT_ADDR_ZIPCODE | VARCHAR2 | 20 | Y | State | Postal code |
| CONTINGENT | VARCHAR2 | 4000 | Y | Contingent | Contingent name |
| CULTURAL_CONTACT | VARCHAR2 | 1220 | Y | Cultural contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
| CULTURAL_CONTACT_EMAIL | VARCHAR2 | 254 | Y | Cultural contact email | Email address of contact |
| CULTURAL_CONTACT_FIX_PHONE | VARCHAR2 | 31 | Y | Phone number incl. Prefix | |
| CULTURAL_CONTACT_MOBILE_PHONE | VARCHAR2 | 31 | Y | Cultural contact mobile phone | Phone number incl. Prefix |
| CULTURAL_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Cultural contact N° | Contact number |
| EXPIRATION_DATE | DATE | 7 | Y | Deadline for the the payment of an option or booking (dd.mm.yyyy) | |
| FILE_CONTACT | VARCHAR2 | 1220 | Y | File contact | 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 contact number |
| FILE_NUMBER | NUMBER | 22 | Y | File number | File number |
| INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
| INVOICE_NUMBER | VARCHAR2 | 4000 | Y | Invoice number | Invoice number |
| 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 | |
| LOGICAL_SEAT_CATEGORY | VARCHAR2 | 240 | Y | Logical seat category | Name of logical seat category |
| 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_STATE | VARCHAR2 | 4000 | Y | Option state | Option state (ex: requested, confirmed) |
| ORDER_DATE | VARCHAR2 | 10 | Y | Purchase order date | Order date |
| ORDER_NUMBER | NUMBER | 22 | Y | Order Number | Order number |
| ORDER_REMARK | VARCHAR2 | 4000 | Y | Order remark | |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| 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_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) |
| PAYMENT_STATE | VARCHAR2 | 4000 | Y | Payments state | Payment state. Possible values are: - Deposit - Paid/not paid - Suspense account (paid/not paid) |
| PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
| PRODUCT_DATE_TIME | TIMESTAMP(3) | 11 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
| PRODUCT_FAMILY | VARCHAR2 | 4000 | Y | Prod. Family | Product family name. Possible values are: - Membership - Season ticket - Voucher - Goods - Hospitality bundle - Competition - Event - Package - Dated pass - Timeslot pass - Non-dated pass - Visit pass - Service - Hospitality - Open product - Visit |
| PRODUCT_TYPE | VARCHAR2 | 240 | Y | Product type | Name of product type |
| QUANTITY | NUMBER | 22 | Y | Quantity | Number of tickets |
| REFERENCE_DATE | DATE | 7 | Y | Reference date | Order reference date |
| SALES_CHANNEL | VARCHAR2 | 240 | Y | Sales channel | Sales channel name |
| SAL_ENT_COUNTRY_CODE | CHAR | 2 | Y | Sales entity country code | Country code of the selling entity |
| SAL_ENT_ID | NUMBER | 22 | Y | Identifier of the sales entity | |
| SAL_ENT_NAME | VARCHAR2 | 240 | Y | Sales entity name | Name of the sales entity |
| SAL_ENT_STRUCT_ADDRESS | VARCHAR2 | 400 | Y | Mailing address of the contact structure | |
| SAL_ENT_STRUCT_COUNTRY_CODE | CHAR | 2 | Y | Contact structure country code | |
| SAL_ENT_STRUCT_ID | NUMBER | 22 | Y | Identifier of the contact structure | |
| SAL_ENT_STRUCT_NAME | VARCHAR2 | 400 | Y | Sales entity structure | Contact structure name |
| SAL_ENT_STRUCT_ZIP_CODE | VARCHAR2 | 20 | Y | Contact structure zip code | |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SEAT_CATEGORY | VARCHAR2 | 60 | Y | Seat category | Seat category name |
| SEAT_NUMBER | VARCHAR2 | 240 | Y | Seat number | |
| SEAT_ROW | VARCHAR2 | 240 | Y | Seat row number | |
| SUB_TOPIC | VARCHAR2 | 240 | Y | Sub topic | Subtopic (level 1) of lowest rank assigned to the product. |
| TOPIC | VARCHAR2 | 240 | Y | Topic | Parent of the subtopic related to the product. |
| T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
| T_AUDIENCE_SUB_CAT_ID | NUMBER | 22 | Y | Technical identifier of tariff | |
| T_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of cultural contact | |
| T_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| T_ITEM_ID | NUMBER | 22 | Y | Technical identifier of item | |
| T_LOGSEAT_ID | NUMBER | 22 | Y | Technical identifier of logical seat | |
| T_MOVEMENT_ID | NUMBER | 22 | N | Technical identifier of movement | |
| T_OPERATION_ID | NUMBER | 22 | Y | Technical identifier of operation | |
| 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_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
| T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
| T_PHY_AREA_ID | NUMBER | 22 | Y | Technical identifier of area | |
| 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_PRODFAMILY_ID | NUMBER | 22 | Y | Technical identifier of product family of composed product (containing the current single product) | |
| 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_SUB_TOPIC_ID | NUMBER | 22 | Y | Identifier of subtopic | |
| T_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of goods topic | |
| 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 |
| VISIT_LANGUAGE | VARCHAR2 | 4000 | Y | Visit language | Visit language |