FCT_BNK_CRHDS_REPO_ACCOUNT_DETAIL
Description
Target Objects (CTAS)
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | CASE_STATUS | CHARACTER(12) | 12 |
| 2 | CASE_ID | CHARACTER(10) | 10 |
| 3 | ACCOUNT_NUMBER | CHARACTER VARYING(40) | 40 |
| 4 | REPO_DATE | CHARACTER VARYING(50) | 50 |
| 5 | REPO_ACCT_BAL | CHARACTER VARYING(50) | 50 |
| 6 | WRITEOFF_VALUE | NUMERIC(36,18) | 19 |
| 7 | WRITEOFF_DATE | TIMESTAMP | 8 |
| 8 | BANKRUPT | CHARACTER VARYING(5) | 5 |
| 9 | OUTSOURCE_DEBT | CHARACTER VARYING(3) | 3 |
| 10 | OUTSOURCE_AGENCY | CHARACTER VARYING(3) | 3 |
| 11 | OUTSOURCE_AMOUNT | CHARACTER VARYING(50) | 50 |
| 12 | RECOVERED_DEBT | CHARACTER VARYING(50) | 50 |
| 13 | RECOVERED_STILL_DUE | NUMERIC(38,6) | 19 |
| 14 | RECOVERED_NOTES | CHARACTER VARYING(1) | 1 |
| 15 | RECOVERED_CLOSE_DATE | CHARACTER VARYING(50) | 50 |