FCT_BNK_COLLECTION_HARDSHIP_APPLN_CUST_LEVEL_REPORT2_V
Description
Target Objects (CTAS)
SDSNZP05_BANK..FCT_BNK_COLLECTION_HARDSHIP_APPLN_CUST_LEVEL_REPORT2
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | HARDSHIP_APPLN_CASE_ID | CHARACTER(10) | 10 |
| 2 | PARTY_ID | CHARACTER VARYING(40) | 40 |
| 3 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 4 | COLLECTION_ACCOUNT_ID | CHARACTER VARYING(10) | 10 |
| 5 | PRODUCT_GROUP | CHARACTER VARYING(30) | 30 |
| 6 | DAYS_PAST_DUE | SMALLINT | 2 |
| 7 | PERIOD_DT | DATE | 4 |
| 8 | DAYS_IN_ARREARS | INTEGER | 4 |
| 9 | DPD_BUCKET | CHARACTER VARYING(8) | 8 |
| 10 | NO_OF_ASSOCIATED_ACCOUNTS | BIGINT | 8 |
| 11 | HOST_SYSTEM | CHARACTER VARYING(5) | 5 |
| 12 | NOTICE_DATE | DATE | 4 |
| 13 | ARRERS_BALANCE | NUMERIC(38,16) | 19 |
| 14 | BALANCE | NUMERIC(38,16) | 19 |
| 15 | NOTICE_DATE_BALANCE | NUMERIC(38,16) | 19 |
| 16 | NOTICE_DATE_ARRERS_BALANCE | NUMERIC(38,16) | 19 |