Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
| 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_SUB_CATEGORY | VARCHAR2 | 240 | Y | Tariff name | |
| CONTACT_ADDR_COUNTRY_CODE | VARCHAR2 | 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 | 240 | Y | State | Postal code |
| CONTACT_AGE_GROUP | VARCHAR2 | 4000 | Y | Contact age group. Possible values are: - Child (<6) - Child (<16) - Student - Adult - Senior |
|
| CONTACT_LANGUAGE | VARCHAR2 | 4000 | Y | Contact preferred language | |
| CONTACT_ZIPCODE | VARCHAR2 | 20 | Y | Postal code of shipment address | |
| ENTRANCE_DATE | TIMESTAMP(3) | 11 | Y | Entrance date | Entrance date (dd.mm.yyyy) |
| ENTRANCE_DATE_CTRL | DATE | 7 | Y | Date time of access control | |
| INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
| IS_RESULT_OK | NUMBER | 22 | Y | Flag indicating whether the access control was successfull | |
| IS_VOUCHER_FLAG | NUMBER | 22 | Y | Flag indicating whether the current record concerns a voucher | |
| 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 |
| MOVEMENT_ID | NUMBER | 22 | N | Technical identifier of movement | |
| NB_OF_ENTRANCES | NUMBER | 22 | Y | Number of controlled tickets For group tickets (only for visit passes), this number takes into account the number of participants of the group. It's equal to the actual number of participants if it has been set. Otherwise, it matches the actual number of participants. |
|
| NB_OF_NO_SHOWS | NUMBER | 22 | Y | Number of no shows | |
| NB_OF_SALES | NUMBER | 22 | Y | Nb of sales | Number of sales |
| ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
| ORIGIN_GENDER | VARCHAR2 | 100 | Y | Origin gender | Origin gender |
| ORIGIN_YEAR_OF_BIRTH | NUMBER | 22 | Y | Origin year of birth | Origin year of birth |
| PARENT_PRODUCT | VARCHAR2 | 240 | Y | Composed product | Name of composed product (containing the current single product) |
| 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 |
| 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. |
| RATE_TYPE | VARCHAR2 | 240 | Y | Rate type | Name of rate type |
| REQUEST_SALE_GAP | NUMBER | 22 | Y | Request sale days | Not available |
| SALES_CHANNEL | VARCHAR2 | 240 | Y | Sales channel | Sales channel name |
| SEASON | VARCHAR2 | 240 | Y | Season | Season name |
| SEAT_CATEGORY | VARCHAR2 | 60 | Y | Seat category | Seat category name |
| SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
| SPACE | VARCHAR2 | 240 | Y | Space | Name of space where event takes place |
| SUB_TOPIC | VARCHAR2 | 240 | Y | Sub topic | Subtopic (level 1) of lowest rank assigned to the product. |
| TICKET_STATE | VARCHAR2 | 25 | Y | Ticket's state | Ticket state. Possible values are: - NOT_PRINTED - EXPORTED (to a printing company) - PRINTED - CANCELLED - INVALIDATED (because a duplicate has been created) - CONTROLED |
| TOPIC | VARCHAR2 | 240 | Y | Topic | Parent of the subtopic related to the product. |
| T_ACTIVITY_ID | NUMBER | 22 | Y | Activity technical identifier | |
| T_AUDIENCE_CAT_ID | NUMBER | 22 | Y | Audience category technical identifier | |
| T_AUDIENCE_SUB_CAT_ID | NUMBER | 22 | Y | Technical identifier of tariff | |
| 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_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
| T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
| 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_PROMOTION_ID | NUMBER | 22 | Y | Technical identifier of promotion | |
| 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_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
| T_SEAT_CAT_ID | NUMBER | 22 | Y | Seat category technical identifier | |
| 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_TICKET_ID | NUMBER | 22 | Y | Technical identifier of ticket | |
| T_TIMESLOT_ID | NUMBER | 22 | Y | Technical identifier of timeslot | |
| T_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of goods topic | |
| 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 |
| 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 |