Version: 1.0
Attribute ID | Datatype | Data length | Nullabe ? | Label | Description |
---|---|---|---|---|---|
BARCODE | VARCHAR2 | 512 | Y | Barcode | Voucher barcode |
FILE_NUMBER | NUMBER | 22 | Y | File number | File number |
INSTIT_CODE | VARCHAR2 | 15 | N | Institution code | |
ITEM | VARCHAR2 | 4000 | Y | Item | Item name |
LAST_UPDATE | TIMESTAMP(6) WITH TIME ZONE | 13 | Y | Date of last update of report data | |
OPERATOR_LOGIN | VARCHAR2 | 20 | Y | Operator login | |
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_YY | VARCHAR2 | 16 | Y | Order year | Order year |
ORDER_DATE_YY_MM | VARCHAR2 | 7 | Y | Order month year | Order month (MM.YYYY) |
ORDER_NUMBER | NUMBER | 22 | N | Order Number | Order number |
ORGANIZATION | VARCHAR2 | 240 | Y | Organization | Organization name |
POINT_OF_SALES | VARCHAR2 | 32 | Y | Point of sales | Point of sales code |
PRODUCT | VARCHAR2 | 240 | Y | Product | Product name |
PRODUCT_TYPE | VARCHAR2 | 240 | Y | Product type | Name of product type |
REMAINING_AMT | NUMBER | 22 | Y | Remaining amount | |
SALES_CHANNEL | VARCHAR2 | 240 | N | Sales channel | Sales channel name |
SALE_FILE_CONCT_STRUCT | VARCHAR2 | 400 | 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 |
SEASON | VARCHAR2 | 240 | Y | Season | Season name |
TAX_NUMBER | VARCHAR2 | 20 | Y | Tax number | Ticket tax number |
T_ITEM_ID | NUMBER | 22 | N | Technical identifier of item | |
T_ORGANIZ_ID | NUMBER | 22 | Y | Technical identifier of organization | |
T_POS_ID | NUMBER | 22 | N | Technical identifier of point of sales | |
T_PRODUCT_ID | NUMBER | 22 | N | Product technical identifier | |
T_PRODUCT_TYPE_ID | NUMBER | 22 | Y | Technical identifier of product type | |
T_SALCHAN_ID | NUMBER | 22 | N | Technical identifier of sales channel | |
T_SEASON_ID | NUMBER | 22 | Y | Season technical identifier | |
U_DELAY_DAYS | NUMBER | 22 | Y | Duration(in number of days) between sales and utilization of voucher | |
U_EXCESS_AMT | NUMBER | 22 | Y | Difference between value of voucher and it's use | |
U_FILE_NUMBER | VARCHAR2 | 4000 | Y | Number of the file in which voucher was used | |
U_OPERATOR_LOGIN | VARCHAR2 | 20 | Y | Login of the operator with which the sales using voucher was made | |
U_ORDER_DATE | VARCHAR2 | 10 | Y | Date of order which uses voucher (DD.MM.YYYY) | |
U_ORDER_DATE_MM_YY | VARCHAR2 | 7 | Y | Month of order date which uses voucher (MM.YYYY) | |
U_ORDER_DATE_YY | VARCHAR2 | 16 | Y | Year of order date which uses voucher (YYYY) | |
U_ORDER_DATE_YY_MM | VARCHAR2 | 7 | Y | Month of order date which uses voucher (YYYY.MM) | |
U_ORDER_NUMBER | NUMBER | 22 | Y | Order number which uses voucher | |
U_POINT_OF_SALES | VARCHAR2 | 32 | Y | Point of sale code | |
U_POS_ID | NUMBER | 22 | Y | Technical identifier of point of sales creating the order which uses voucher | |
U_SALCHAN_ID | NUMBER | 22 | Y | Technical identifier of sales channel creating the order which uses voucher | |
U_SALES_CHANNEL | VARCHAR2 | 240 | Y | Name of sales channel creating the order which uses voucher | |
U_SALE_FILE_CONCT_STRUCT | VARCHAR2 | 400 | Y | Name of the company/organization the contact belongs to | |
U_SALE_FILE_CONTACT_FMT_NAME | VARCHAR2 | 4000 | Y | Contact name in format: "last name, first name (contact number)". No contact number if only beneficiary. | |
U_SALE_FILE_CONTACT_NUMBER | VARCHAR2 | 4000 | Y | Contact number | |
VALIDITY_END_DATE | DATE | 7 | Y | Validity end date | End date of the voucher |
VALIDITY_START_DATE | DATE | 7 | Y | Validity start date | Validity start date |
VOUCHER_IDENTIFIER | VARCHAR2 | 20 | Y | Voucher code | |
VOUCHER_PRICE | NUMBER | 22 | Y | Voucher price | Unit price of voucher |
VOUCHER_STATE | VARCHAR2 | 25 | Y | Voucher state | Voucher status Possible values: - Used - Partially used - Valid - Expired - Exported - Controlled out |
VOUCHER_VALUE | NUMBER | 22 | Y | Voucher value | Valeur unitaire du bon |