# | Column Name | Max Size | Data Type |
---|---|---|---|
1 | RCPT_NUMBER | 12 | CHAR |
2 | REGNUM | 3 | VARCHAR |
3 | SEQUENCE_NUMBER | SMALLINT | |
4 | ACCOUNTING_DATE | DATETIME | |
5 | RCPT_DATE_TIME | DATETIME | |
6 | USER_ID | 10 | CHAR |
7 | PAYER_NAME | 40 | VARCHAR |
8 | TRAN_SOURCE | 20 | VARCHAR |
9 | TRAN_CODE | 30 | VARCHAR |
10 | CR_ACCOUNT | 100 | VARCHAR |
11 | DR_ACCOUNT | 100 | VARCHAR |
12 | DESCRIPTION | 50 | VARCHAR |
13 | COMMENT | 50 | VARCHAR |
14 | REFERENCE_NUMBER | 50 | VARCHAR |
15 | EXTENDED_FEE_AMOUNT | MONEY | |
16 | BANKCODE | SMALLINT | |
17 | QUANTITY | REAL | |
18 | USER_ENTERED_QTY | FLOAT | |
19 | RCPT_STATUS | SMALLINT | |
20 | LOCATION_CODE | 3 | CHAR |
21 | TRAN_DESCRIPTION | 40 | VARCHAR |
22 | SHORT_DESCRIPTION | 50 | VARCHAR |
23 | USER_DATA_1 | 30 | VARCHAR |
24 | USER_DATA_2 | 30 | VARCHAR |
25 | USER_DATA_3 | 30 | VARCHAR |
26 | USER_DATA_4 | 30 | VARCHAR |
27 | USER_DATA_5 | 30 | VARCHAR |
28 | USER_DATA_6 | 30 | VARCHAR |
29 | USER_DATA_7 | 30 | VARCHAR |
30 | USER_DATA_8 | 30 | VARCHAR |
31 | USER_DATA_9 | 30 | VARCHAR |
32 | SYSTEM_CODE | 5 | VARCHAR |
Created:09/22/2020 12:20:37