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