# | Column Name | Max Size | Data Type |
---|---|---|---|
1 | RCPT_NUMBER | 12 | CHAR |
2 | REGNUM | 3 | VARCHAR |
3 | USER_ID | 10 | CHAR |
4 | ACCOUNTING_DATE | DATETIME | |
5 | RCPT_DATE_TIME | DATETIME | |
6 | CHANGE_DUE | MONEY | |
7 | RCPT_STATUS | SMALLINT | |
8 | PAYER_NAME | 40 | VARCHAR |
9 | TRAN_SOURCE | 20 | VARCHAR |
10 | SEQUENCE_NUMBER | SMALLINT | |
11 | TRAN_CODE | 30 | VARCHAR |
12 | DR_ACCOUNT | 100 | VARCHAR |
13 | CR_ACCOUNT | 100 | VARCHAR |
14 | DISCOUNT | MONEY | |
15 | UNIT_FEE | MONEY | |
16 | DISCOUNT_RATE | REAL | |
17 | DESCRIPTION | 50 | VARCHAR |
18 | COMMENT | 50 | VARCHAR |
19 | REFERENCE_NUMBER | 50 | VARCHAR |
20 | EXTENDED_FEE_AMOUNT | MONEY | |
21 | BANKCODE | SMALLINT | |
22 | QUANTITY | REAL | |
23 | USER_ENTERED_QTY | FLOAT | |
24 | TRAN_DESCRIPTION | 40 | VARCHAR |
25 | SHORT_DESCRIPTION | 50 | VARCHAR |
26 | SYSTEM_CODE | 5 | VARCHAR |
27 | SUMMARY_FLAG | 1 | VARCHAR |
28 | USER_DATA_1 | 30 | VARCHAR |
29 | USER_DATA_2 | 30 | VARCHAR |
30 | USER_DATA_3 | 30 | VARCHAR |
31 | USER_DATA_4 | 30 | VARCHAR |
32 | USER_DATA_5 | 30 | VARCHAR |
33 | USER_DATA_6 | 30 | VARCHAR |
34 | USER_DATA_7 | 30 | VARCHAR |
35 | USER_DATA_8 | 30 | VARCHAR |
36 | USER_DATA_9 | 30 | VARCHAR |
37 | DEPT_CODE | 15 | VARCHAR |
38 | LOCATION_CODE | 3 | CHAR |
39 | F01 | 50 | VARCHAR |
40 | F02 | 50 | VARCHAR |
41 | F03 | 50 | VARCHAR |
42 | F04 | 50 | VARCHAR |
43 | F05 | 50 | VARCHAR |
44 | F06 | 50 | VARCHAR |
45 | F07 | 50 | VARCHAR |
46 | F08 | 50 | VARCHAR |
47 | F09 | 50 | VARCHAR |
48 | F10 | 50 | VARCHAR |
49 | F11 | 50 | VARCHAR |
50 | F12 | 50 | VARCHAR |
51 | F13 | 50 | VARCHAR |
52 | F14 | 50 | VARCHAR |
53 | F15 | 50 | VARCHAR |
54 | F16 | 50 | VARCHAR |
55 | F17 | 50 | VARCHAR |
56 | F18 | 50 | VARCHAR |
57 | F19 | 50 | VARCHAR |
58 | F20 | 50 | VARCHAR |
59 | F21 | 50 | VARCHAR |
60 | F22 | 50 | VARCHAR |
61 | F23 | 50 | VARCHAR |
62 | F24 | 50 | VARCHAR |
63 | F25 | 50 | VARCHAR |
64 | F26 | 50 | VARCHAR |
65 | F27 | 50 | VARCHAR |
66 | F28 | 50 | VARCHAR |
67 | F29 | 50 | VARCHAR |
68 | F30 | 50 | VARCHAR |
69 | CUST_NAME | 50 | VARCHAR |
Created:09/22/2020 12:20:24