| 1 |
PROCESS_DATE |
DATE |
4 |
| 2 |
ACCOUNT_NUMBER |
CHARACTER VARYING(40) |
40 |
| 3 |
COLLECTION_ACCOUNT_NUMBER |
CHARACTER(10) |
10 |
| 4 |
LAST_COLLECTIONS_ACTIVITY |
TIMESTAMP |
8 |
| 5 |
COLLECTION_CASE_ID |
CHARACTER(10) |
10 |
| 6 |
FROM_DATE |
TIMESTAMP |
8 |
| 7 |
TILL_DATE |
TIMESTAMP |
8 |
| 8 |
ARREARS |
NUMERIC(38,16) |
19 |
| 9 |
ACCOUNT_BALANCE |
NUMERIC(38,16) |
19 |
| 10 |
DPD |
SMALLINT |
2 |
| 11 |
PRODUCT_GROUP |
CHARACTER VARYING(20) |
20 |
| 12 |
COLLECTIONS_CASE_TYPE |
CHARACTER(12) |
12 |
| 13 |
COLLECTIONS_STATUS |
CHARACTER VARYING(60) |
60 |
| 14 |
COLLECTION_CASE_TYPE_DESCRIPTION |
CHARACTER VARYING(60) |
60 |
| 15 |
PRIMARY_ACCOUNT_NAME |
CHARACTER VARYING(250) |
250 |
| 16 |
QUEUE_TEAM_USER |
CHARACTER VARYING(164) |
164 |