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