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