Version: 1.0
| Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
|---|---|---|---|---|---|
| ACTIVITY | VARCHAR2 | 240 | Y | Activity | Activity name of event |
| ALLEY | VARCHAR2 | 240 | Y | Alley | Row number of seat |
| AREA | VARCHAR2 | 240 | Y | Area | Area name |
| AREA_CODE | VARCHAR2 | 32 | Y | Area code | Area code |
| 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 | |
| BENEFICIARY | VARCHAR2 | 831 | Y | Beneficiary | If a beneficiary (ticket owner) has been entered, this displays his last name and first name. Otherwise, it displays the last name and first name of the contact. |
| BLOCK | VARCHAR2 | 240 | Y | Block | Block name |
| BLOCK_CODE | VARCHAR2 | 32 | Y | Block code | Block code |
| CATALOG_CURRENCY_CODE | CHAR | 3 | Y | Currency code of catalog | |
| CLASSIFICATION1 | VARCHAR2 | 4000 | Y | Seat classification 1 | |
| CLASSIFICATION2 | VARCHAR2 | 4000 | Y | Seat classification 2 | |
| CONTINGENT | VARCHAR2 | 4000 | Y | Contingent | Contingent name |
| CULTURAL_CONTACT | VARCHAR2 | 831 | 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_NB | VARCHAR2 | 20 | Y | Contact number | |
| CULTURAL_CONTACT_STRUCTURE | VARCHAR2 | 400 | Y | Cultural contact structure | Name of company/institution the contact belongs to |
| CULTURAL_CONTACT_TELEPHONE | VARCHAR2 | 31 | Y | Cultural contact telephone | Phone number incl. Prefix |
| DUMMY_SEAT | CHAR | 1 | Y | Dummy seat | Dummy seat - Seat is not actually physically existing |
| ENTRANCE | VARCHAR2 | 240 | Y | Entrance | Entrance name |
| ENTRANCE_EXTERNAL_ACCESS | VARCHAR2 | 60 | Y | External entrance to be used to reach an area or a set of seats | |
| EVENT | VARCHAR2 | 240 | Y | Event | Event name |
| FILE_NUMBER | NUMBER | 22 | Y | File number | File number |
| FLOOR | VARCHAR2 | 240 | Y | Floor | Floor |
| FREEZE_REASON | VARCHAR2 | 4000 | Y | Reason why the seat is currently frozen | |
| FROZEN | CHAR | 1 | Y | Frozen | Flag indicating whether the current seat is frozen (T) or not (F) |
| HOSP_BUNDLE_CODE | VARCHAR2 | 32 | Y | Hospitality bundle code | |
| HOSP_BUNDLE_NAME | VARCHAR2 | 240 | Y | Hospitality bundle name | |
| HOSP_PRODUCT_CODE | VARCHAR2 | 32 | Y | Hospitality product code | |
| HOSP_PRODUCT_NAME | VARCHAR2 | 240 | Y | Hospitality product name | |
| HOSP_ROOM_CODE | VARCHAR2 | 32 | Y | Hospitality room code | |
| HOSP_ROOM_NAME | VARCHAR2 | 240 | Y | Hospitality room name | |
| INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
| INVALIDATION_REASON | VARCHAR2 | 4000 | Y | Reason why a given seat has been invalidated. Possible values are: - Other - Decor - Emergency exit - Restricted view - Disassembled seat - Security |
|
| 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 |
| LOG_CONFIG | VARCHAR2 | 240 | Y | Name of logical configuration | |
| LOG_ENTRANCE | VARCHAR2 | 240 | Y | Logical entrance name | |
| LOG_ENTRANCE_EXTERNAL_ACCESS | VARCHAR2 | 60 | Y | External logical entrance to be used to reach an area or a set of seats | |
| LOG_ENTRANCE_EXT_NAME | VARCHAR2 | 240 | Y | Logical entrance external name | |
| LOG_SEAT_CATEGORY_EXT_NAME | VARCHAR2 | 240 | Y | Logical seat category | Logical seat category external name |
| 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 | |
| ORDER_CONTACT | VARCHAR2 | 831 | Y | Order contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
| ORDER_CONTACT_EMAIL | VARCHAR2 | 254 | Y | Order contact email | Email address of contact |
| ORDER_CONTACT_NB | VARCHAR2 | 20 | Y | Contact number | |
| ORDER_CONTACT_TELEPHONE | VARCHAR2 | 31 | Y | Order contact telephone | Phone number incl. Prefix |
| ORDER_DATE | VARCHAR2 | 10 | Y | Purchase order date | Order date |
| ORDER_NUMBER | NUMBER | 22 | Y | Order Number | Order number |
| OUTER_LOG_ENTRANCE | VARCHAR2 | 240 | Y | Outer log entrance | Outer logical entrance name |
| OUTER_LOG_ENTRANCE_EXT_NAME | VARCHAR2 | 240 | Y | Logical external entrance external name | |
| PHYSEAT_ID | NUMBER | 22 | Y | Technical identifier of physical seat | |
| PHYSEAT_ORDER | NUMBER | 22 | Y | Sequence number (impacting the best seat allocation) of physical seat | |
| PHYSICAL_AREA_EXT_NAME | VARCHAR2 | 240 | Y | Physical block external name | |
| PHYSICAL_BLOCK_EXT_NAME | VARCHAR2 | 240 | Y | Physical block external name | |
| PHY_CONFIG | VARCHAR2 | 240 | Y | Name of physical configuration | |
| PRODUCT_DATE_TIME | TIMESTAMP(3) | 11 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
| REMARK | VARCHAR2 | 240 | Y | Remark | Comment concerning the seat |
| 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 | 32 | Y | Seat category | Seat category name |
| SEAT_DESCRIPTION | VARCHAR2 | 1248 | Y | Seat description | |
| SEAT_NUMBER | VARCHAR2 | 240 | Y | Seat number | |
| SEAT_QUALITY | VARCHAR2 | 4000 | Y | Seat quality | Seat quality describing the level of comfort provided. Possible values are: - Bench - Seat - Armchair - Wheelchair - Seat - Folding chair |
| SEAT_ROW | VARCHAR2 | 240 | Y | Seat row number | |
| SECTOR | VARCHAR2 | 240 | Y | Sector | Name of sector in which an area is located |
| SITE | VARCHAR2 | 240 | Y | Site | Name of site where event takes place |
| SPACE | VARCHAR2 | 240 | Y | Space | Name of space where event takes place |
| STAGE_VISIBILITY | VARCHAR2 | 4000 | Y | Stage visibility | Stage visibility |
| STATE | VARCHAR2 | 25 | Y | State | Seat state. Possible values are: - Invalidated - Free - Reserved - Sold |
| TITLING_VISIBILITY | VARCHAR2 | 4000 | Y | Titling visibility | Titling visibilité |
| 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_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of cultural contact | |
| T_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
| T_COORDINATE_X | NUMBER | 22 | Y | Seat coordinate | |
| T_COORDINATE_Y | NUMBER | 22 | Y | Seat coordinate | |
| T_CULTURAL_CONTACT_STRUCT_ID | NUMBER | 22 | Y | Technical identifier of company/institution the contact belongs to | |
| T_ENTRANCE_ID | NUMBER | 22 | N | Technical identifier of entrance to be used to reach an area or a set of seats | |
| T_EVENT_ID | NUMBER | 22 | N | Technical identifier of product | |
| T_FREEZE_REASON_CODE | VARCHAR2 | 120 | Y | Technical code - Reason why the seat is currently frozen | |
| T_LOGCONFIG_ID | NUMBER | 22 | N | Technical identifier of performance logical configuration | |
| T_LOGSEAT_ID | NUMBER | 22 | N | Technical identifier of logical seat | |
| T_LOG_ENTRANCE_ID | NUMBER | 22 | Y | Technical identifier of logical entrance | |
| T_LOG_SEAT_CAT_ID | NUMBER | 22 | N | Technical identifier of logical seat category | |
| T_OUTER_LOG_ENTRANCE_ID | NUMBER | 22 | Y | Technical identifier of logical outer entrance | |
| T_PERFORMANCEID | NUMBER | 22 | N | Technical identifier of performance | |
| T_PHYCONFIG_ID | NUMBER | 22 | N | Technical identifier of physical configuration | |
| T_PHY_AREA_ID | NUMBER | 22 | N | Technical identifier of area | |
| T_PHY_BLOCK_ID | NUMBER | 22 | Y | Technical identifier of block | |
| T_SALECONFIG_ID | NUMBER | 22 | Y | Technical identifier of sales configuration | |
| T_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
| T_SEAT_CAT_ID | NUMBER | 22 | N | Seat category technical identifier | |
| T_SEAT_QUALITY_ID | NUMBER | 22 | N | Seat quality technical identifier | |
| T_SITE_ID | NUMBER | 22 | N | Technical identifier of site | |
| T_SPACE_ID | NUMBER | 22 | N | Technical identifier of space | |
| T_STRUCT_CT_ID | NUMBER | 22 | Y | Technical identifier of company/institution the contact belongs to | |
| UNIT_AMT_ITX | NUMBER | 22 | Y | Gross Unit price | Product unit price including tax |