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 | N | Area | Area name |
AREA_CODE | VARCHAR2 | 32 | N | 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 | N | 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 | N | Technical identifier of physical seat | |
PHYSEAT_ORDER | NUMBER | 22 | N | 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 | N | Seat category | Seat category name |
SEAT_DESCRIPTION | VARCHAR2 | 1248 | Y | Seat description | |
SEAT_NUMBER | VARCHAR2 | 240 | Y | Seat number | |
SEAT_QUALITY | VARCHAR2 | 4000 | N | 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 | N | 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 | N | Seat coordinate | |
T_COORDINATE_Y | NUMBER | 22 | N | 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 | N | 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 |