D_TICKET_DISTRIB_HISTORY

Version: 1.0

Attribute details

Attribute ID Datatype Data length Nullabe ? Label Description
ACTION_TYPE VARCHAR2 25 Y Action type Transaction type
DATE_TIME TIMESTAMP(3) 11 N Date time
INSTIT_CODE VARCHAR2 15 N Institution code Institution code
LAST_UPDATE TIMESTAMP(6) WITH TIME ZONE 13 Y Date of last update of report data
NEW_CT_CONTACT_EMAIL VARCHAR2 254 Y New contact email Email address of the new cultural contact
NEW_CT_CONTACT_FIRSTNAME VARCHAR2 400 Y New contact first name First name of the new cultural contact
NEW_CT_CONTACT_LASTNAME VARCHAR2 400 Y New contact last name Last name of the new cultural contact
NEW_CT_CONTACT_NUMBER VARCHAR2 20 Y New contact number New cultural contact number
OLD_CT_CONTACT_EMAIL VARCHAR2 254 Y Old contact email Email address of the old cultural contact
OLD_CT_CONTACT_FIRSTNAME VARCHAR2 400 Y Old contact first name First name of the old cultural contact
OLD_CT_CONTACT_LASTNAME VARCHAR2 400 Y Old contact last name Last name of the old cultural contact
OLD_CT_CONTACT_NUMBER VARCHAR2 20 Y Old contact number Old cultural contact number
OPERATOR_LOGIN VARCHAR2 20 N Operator login
REQUESTED_BY NUMBER 22 Y Requested by Identifier of the contact requesting ticket distribution
STATUS VARCHAR2 25 N Status Transaction status
TICKET_STATE VARCHAR2 25 N 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
TICKET_TAX_NUMBER VARCHAR2 20 Y Ticket number Ticket tax number
T_DISTRIBUTION_ID NUMBER 22 N Technical identifier of ticket distribution record
T_MOVEMENT_ID NUMBER 22 N Technical identifier of movement
T_NEW_CC_STR_ID NUMBER 22 Y Technical identifier of structure that the new cultural contact belongs to
T_NEW_CT_CONTACT_ID NUMBER 22 N Technical identifier of new cultural contact
T_OLD_CC_STR_ID NUMBER 22 Y Technical identifier of structure that the old cultural contact belongs to
T_OLD_CT_CONTACT_ID NUMBER 22 N Technical identifier of old cultural contact
T_TICKET_ID NUMBER 22 N Technical identifier of ticket