| # |
Name |
Data Type |
Length |
| 1 |
COMPANYID |
INTEGER |
4 |
| 2 |
ACTION_CODE |
CHARACTER VARYING(1) |
1 |
| 3 |
PRODUCT_CODE |
CHARACTER VARYING(30) |
30 |
| 4 |
ACCOUNT_NO |
CHARACTER VARYING(40) |
40 |
| 5 |
DEPOSIT_NO |
DOUBLE PRECISION |
8 |
| 6 |
ACCTSTATUS |
CHARACTER VARYING(40) |
40 |
| 7 |
BRANCHNO |
CHARACTER VARYING(10) |
10 |
| 8 |
COSTCENTER |
CHARACTER VARYING(150) |
150 |
| 9 |
DTCLOSED |
CHARACTER VARYING(200) |
200 |
| 10 |
DTOPENED |
CHARACTER VARYING(200) |
200 |
| 11 |
TERM |
INTEGER |
4 |
| 12 |
TERM_CODE |
CHARACTER VARYING(1) |
1 |
| 13 |
CURRENTMATURITYDATE |
CHARACTER VARYING(200) |
200 |
| 14 |
FINALMATURITYDATE |
CHARACTER VARYING(200) |
200 |
| 15 |
OFFICER |
CHARACTER VARYING(254) |
254 |
| 16 |
ORIGINALBRANCH |
CHARACTER VARYING(10) |
10 |
| 17 |
SALEOFFCD |
CHARACTER VARYING(254) |
254 |
| 18 |
SECONDARY_OFFICER |
CHARACTER VARYING(1) |
1 |
| 19 |
SHORTNAME |
CHARACTER VARYING(300) |
300 |
| 20 |
SICOCCUPATIONCD |
CHARACTER VARYING(5) |
5 |
| 21 |
SUBPRDCTCD |
CHARACTER VARYING(30) |
30 |
| 22 |
CURRBALSTATUS |
DOUBLE PRECISION |
8 |
| 23 |
DATEOD |
CHARACTER VARYING(10) |
10 |
| 24 |
INTERESTRATEANNUAL |
DOUBLE PRECISION |
8 |
| 25 |
ARREARSDAYS |
INTEGER |
4 |
| 26 |
OVERDRAWNAMT |
INTEGER |
4 |
| 27 |
FILE_DATE |
CHARACTER VARYING(200) |
200 |
| 28 |
UNCOLLECTED_BALANCE |
DOUBLE PRECISION |
8 |