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 |
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_KIND_TYPE | VARCHAR2 | 25 | Y | Reduction level | |
AUDIENCE_SUB_CATEGORY | VARCHAR2 | 240 | Y | Tariff name | |
CATALOG_CURRENCY_CODE | CHAR | 3 | Y | Currency code of catalog | |
CONTINGENT | VARCHAR2 | 4000 | Y | Contingent | Contingent name |
CURRENT_QUANTITY | NUMBER | 22 | Y | Current quantity | Number of non cancelled tickets |
EXPIRATION_DATE | DATE | 7 | Y | Deadline for the the payment of an option or booking (dd.mm.yyyy) | |
EXP_DATE_YY_MM_DD | VARCHAR2 | 10 | Y | Expiration date | Deadline for the the payment of an option or booking (yyyy.mm.dd) |
FILE_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | 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 | Contact number |
FILE_NUMBER | NUMBER | 22 | Y | File number | File number |
FINDER_FILE_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | Finder contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
FINDER_FILE_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Finder contact number | Contact number |
GOODS_COLLECTION | VARCHAR2 | 240 | Y | Collection | Name of goods collection |
GOODS_FAMILY | VARCHAR2 | 240 | Y | Goods family | Name of goods family |
GOODS_SUBFAMILY | VARCHAR2 | 240 | Y | Goods sub-family | Name of subfamily of goods product (only level 1) |
GOODS_SUBTOPIC | VARCHAR2 | 240 | Y | Goods sub-topic | Name of subtopic of goods product (only level 1) |
GOODS_TOPIC | VARCHAR2 | 240 | Y | Goods topic | Name of topic of goods product |
INSTIT_CODE | VARCHAR2 | 15 | Y | Institution code | |
INSURED | CHAR | 1 | Y | Insured | Flag indicating whether the sale is covered by the cancellation insurance (True, False) |
INVOICE_CONTACT_FMT_NAME | VARCHAR2 | 2000 | Y | Local invoice contact | Local invoice contact |
INVOICE_DATE | TIMESTAMP(3) WITH TIME ZONE | 13 | Y | Invoice date | Invoice date |
INVOICE_NUMBER | VARCHAR2 | 4000 | Y | Invoice number | Invoice number |
IS_ACCOUNTING_BALANCE | VARCHAR2 | 1 | Y | Boolean (T/F) indicating if it′s accouting balanced. | |
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 | |
LICENCE_NUMBER | VARCHAR2 | 4000 | Y | Performance license number | Performance licence number |
LOGICAL_SEAT_CATEGORY | VARCHAR2 | 240 | Y | Logical seat category | Name of logical seat category |
NET_SOLD_AMT_ITX | NUMBER | 22 | Y | Net Sales amt incl.Tax | Total amount of sales including tax (cancellations are subtracted) |
NET_SOLD_CHARGE_AMT_ITX | NUMBER | 22 | Y | Net Sales Charges amt incl.Tax | Total amount of charges including tax (cancellations are subtracted) |
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_CONTACT_ADDRESS | VARCHAR2 | 4000 | Y | Contact address (street, number, address complement) | |
ORDER_CONTACT_COUNTRY | VARCHAR2 | 4000 | Y | Address country name | |
ORDER_CONTACT_EMAIL | VARCHAR2 | 254 | Y | Order contact email | Email address of contact |
ORDER_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. | |
ORDER_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Order contact N° | Contact number |
ORDER_CONTACT_PRIMARY_PHONE | VARCHAR2 | 31 | Y | Phone number incl. Prefix | |
ORDER_CONTACT_STRUCT_NAME | VARCHAR2 | 400 | Y | Order contact structure | Name of company/institution the contact belongs to |
ORDER_CONTACT_STRUCT_NUMBER | VARCHAR2 | 20 | Y | Order contact structure N° | Number of company/institution the contact belongs to |
ORDER_CONTACT_TOWN | VARCHAR2 | 400 | Y | Town of address | |
ORDER_CONTACT_ZIPCODE | VARCHAR2 | 20 | Y | Postal code | |
ORDER_DATE | VARCHAR2 | 10 | Y | Purchase order date | Order date |
ORDER_DATE_MM_YY | VARCHAR2 | 7 | Y | Order month | Order month (MM.YYYY) |
ORDER_DATE_TIME | VARCHAR2 | 19 | Y | Order date time | Order date time |
ORDER_DATE_YY_MM | VARCHAR2 | 7 | Y | Order month year | Order month (MM.YYYY) |
ORDER_DATE_YY_MM_DD | VARCHAR2 | 10 | Y | Order date | |
ORDER_NUMBER | NUMBER | 22 | Y | Order Number | Order number |
ORDER_POS | VARCHAR2 | 32 | Y | Code of point of sale | |
ORDER_QUANTITY | NUMBER | 22 | Y | Order quantity | Number of tickets |
ORDER_REMARK | VARCHAR2 | 4000 | Y | Order remark | |
ORDER_TYPE | VARCHAR2 | 25 | Y | Order type (sale, exchange) | |
ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
ORG_CURRENCY_CODE | CHAR | 3 | Y | Organization currency | Currency code of organization |
ORIGINATING_SALES_CHANNEL | VARCHAR2 | 240 | Y | Originating Sales channel | Neme of the sales channel that performed the original booking/sale |
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_TYPE | VARCHAR2 | 240 | Y | Composed product type | Name of product type of composed product (containing the current single product) |
PARENT_P_FAMILY_TYPE | VARCHAR2 | 25 | Y | Name of product family type 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) |
PAYMENT_METHOD | VARCHAR2 | 240 | Y | Payment method | Name of payment method |
PAYMENT_STATE | VARCHAR2 | 4000 | Y | Payments state | Payment state. Possible values are: - Deposit - Paid/not paid - Suspense account (paid/not paid) |
PAYMETH_ACC_EXTERNAL_ID | VARCHAR2 | 4000 | Y | Payment method accounting code. This code can be freely defined in SecuTix and establishes a link with the accounting performed outside SecuTix. Our Confluence web site describes how to define accounting codes. | |
PERFORMANCE_DESCRIPTION | VARCHAR2 | 1000 | Y | Performance description | Performance description |
PERF_TIMESLOT_STATE | VARCHAR2 | 4000 | Y | Translated value of T_PERF_TIMESLOT_STATE | |
PRICE_DYNAMIC | CHAR | 1 | Y | Flag indicating whether the price is defined dynamically | |
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_TIME | TIMESTAMP(3) | 11 | Y | Product date time | Performance or timeslot date and time (dd.mm.yyyy hh:mm:ss) |
PRODUCT_EXTERNAL_NAME | VARCHAR2 | 240 | Y | External name of product | |
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 |
PROD_ACC_EXTERNAL_ID | VARCHAR2 | 4000 | Y | Product accounting code. This code can be freely defined in SecuTix and establishes a link to the accounting performed outside SecuTix. Our Confluence web site describes how to define accounting codes. | |
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 |
REFERENCE_DATE | DATE | 7 | Y | Reference date | Order reference date |
REQUEST_SALE_GAP | NUMBER | 22 | Y | Request sale days | Not available |
SALES_CHANNEL | VARCHAR2 | 240 | Y | Sales channel | Sales channel name |
SALES_CHANNEL_TYPE | VARCHAR2 | 4000 | Y | Sale channel type | Name of sales channel type. Possible values are: - Ticket vending machine - Goods shop - Secutix file - Box office - Internet agency - Internet resale platform - Internet B2B - Internet B2C - Phone platform |
SALE_FILE_CONCT_STRUCT | VARCHAR2 | 1220 | Y | Name of the company/organization the contact belongs to | |
SALE_FILE_CONTACT_FMT_NAME | VARCHAR2 | 831 | Y | Sales file contact | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. |
SALE_FILE_CONTACT_NUMBER | VARCHAR2 | 20 | Y | Sales file contact number | Contact number |
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 |
SELLER_ORGANIZATION | VARCHAR2 | 240 | Y | Seller organization | Organization 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. |
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. |
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_CASHDESK_ID | NUMBER | 22 | Y | Technical identifier of cash desk | |
T_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
T_CO_PRODUCER_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact who is the co-producer | |
T_FAMILY_SUB_TYPE | VARCHAR2 | 38 | 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 | 38 | 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_GOODSCOLLECTION_ID | NUMBER | 22 | Y | Technical identifier of goods collection | |
T_GOODS_FAMILY_ID | NUMBER | 22 | Y | Technical identifier of goods family | |
T_GOODS_SUBFAMILY_ID | NUMBER | 22 | Y | Technical identifier of subfamily of goods product (only level 1) | |
T_GOODS_SUBTOPIC_ID | NUMBER | 22 | Y | Technical identifier of subtopic of goods product (only level 1) | |
T_GOODS_TOPIC_ID | NUMBER | 22 | Y | Technical identifier of topic of goods product | |
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_OPERATION_DATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Timestamp of operation creation | |
T_OPERATION_ID | NUMBER | 22 | Y | Technical identifier of operation | |
T_OPERATION_KIND | VARCHAR2 | 25 | Y | Operation type. Possible values are: - CHARGES - COMMISSION - COMPOSED_PRODUCT - DELIVERY_OVERHEADS - ORDER_OVERHEADS - PAYMENT_OVERHEADS - PRODUCT_COMPOSITION (part of a composed product) - SIMPLE_PRODUCT: any product except season ticket, package and single entry - SINGLE_ENTRY: single entry |
|
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_ORDER_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
T_ORDER_ST_CT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
T_ORGANIZ_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_PAYMENT_ID | NUMBER | 22 | Y | Technical identifier of payment | |
T_PAYMENT_STATE | VARCHAR2 | 25 | Y | Ticket/operation payment state: - DEPOSIT (not for sold tickets) - NOT_PAID - WAITING_ACCOUNT - PAID |
|
T_PAYMETH_ID | NUMBER | 22 | Y | Technical identifier of payment method | |
T_PERFORMANCE_ID | NUMBER | 22 | Y | Technical identifier of performance | |
T_PERF_TIMESLOT_STATE | VARCHAR2 | 25 | Y | State of performance or timeslot: - Running - Suspended |
|
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_PROMOTION_ID | NUMBER | 22 | Y | Technical identifier of promotion | |
T_P_CONTINGENT_ID | NUMBER | 22 | Y | Technical identifier of contingent | |
T_P_PRODFAMILY_ID | NUMBER | 22 | Y | Technical identifier of product family of composed product (containing the current single product) | |
T_P_PRODTYPE_ID | NUMBER | 22 | Y | Technical identifier of product type | |
T_P_PRODUCT_ID | NUMBER | 22 | Y | Technical identifier of product | |
T_RATE_TYPE_ID | NUMBER | 22 | Y | Technical identifier of rate type | |
T_SALCHAN_ID | NUMBER | 22 | Y | Technical identifier of sales channel | |
T_SALE_FILE_CONTACT_ID | NUMBER | 22 | Y | Technical identifier of contact | |
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_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_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 | |
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 |
VALUE_DATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Value date | Payment value date (dd.mm.yyyy) |
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 |