| Name | Description | Type | Additional information |
|---|---|---|---|
| REFMID | decimal number |
Required |
|
| BRANCH_CODE | string |
Required Max length: 6 |
|
| VOCTYPE | string |
Required Max length: 3 |
|
| VOCNO | decimal number |
Required |
|
| YEARMONTH | string |
Required Max length: 6 |
|
| LOYALTY_CODE | string |
Required Max length: 6 |
|
| SALE_WT | decimal number |
None. |
|
| LOYALTY_WT | decimal number |
None. |
|
| REDEEM_WT | decimal number |
None. |
|
| CUSTOMER_CODE | string |
Max length: 12 |
|
| MID | integer |
Required |
|
| REDEEM_MID | decimal number |
None. |
|
| SALE_AMT | decimal number |
None. |
|
| LOYALTY_POINTS | decimal number |
None. |
|
| REDEEM_POINTS | decimal number |
None. |
|
| REDEEM_AMT | decimal number |
None. |
|
| LOYALTY_AMT | decimal number |
None. |
|
| LTVOCDATE | date |
None. |