Groups
VOUCHER_LOG
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | CHANGE_DATE | DATE | 7 | Y | ||
| 3 | OPERATOR | VARCHAR2 | 50 | Y | ||
| 4 | VOUCHER_ID | NUMBER | 22 | Y | ||
| 5 | CODE | VARCHAR2 | 80 | Y | ||
| 6 | KEYWORD | VARCHAR2 | 100 | Y | ||
| 7 | STATUS_ID | NUMBER | 22 | Y | ||
| 8 | AMOUNT | NUMBER | 22 | Y | ||
| 9 | CREATE_DATE | DATE | 7 | Y | ||
| 10 | ASSIGN_DATE | DATE | 7 | Y | ||
| 11 | CREDITED_DATE | DATE | 7 | Y | ||
| 12 | SUBSCRIPTION_ID | NUMBER | 22 | Y | ||
| 13 | START_DATE | DATE | 7 | Y | ||
| 14 | END_DATE | DATE | 7 | Y | ||
| 15 | ASSIGNED_BY | VARCHAR2 | 80 | Y | ||
| 16 | RETAILER | VARCHAR2 | 80 | Y | ||
| 17 | PARTNER | VARCHAR2 | 80 | Y | ||
| 18 | BATCH | VARCHAR2 | 80 | Y | ||
| 19 | PRICE_CODE | VARCHAR2 | 80 | Y | ||
| 20 | VOUCHER_FILE_ID | NUMBER | 22 | Y | ||
| 21 | ACTION | VARCHAR2 | 20 | Y | ||
| 22 | EXPORTED | NUMBER | 22 | Y | ||
| 23 | CREATED_BY | VARCHAR2 | 50 | Y |