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 | 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 | Y | 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 |