FCT_BNK_COLLECTION_PTP_MANAGEMENT_REPORT
Description
Target Objects (CTAS)
INSNZP05_BANK..FCT_BNK_COLLECTION_PTP_MANAGEMENT_REPORT_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PRODUCT | CHARACTER VARYING(20) | 20 |
| 2 | PROMISED_PAYMENT_CREATE_DATE | DATE | 4 |
| 3 | NUMBER_OF_PTP | NUMERIC(38,0) | 19 |
| 4 | TOTAL_PTP_AMOUNT | NUMERIC(18,2) | 19 |
| 5 | AVG_PTP_AMOUNT | NUMERIC(18,2) | 19 |
| 6 | MULTIPLE_PTP_WITH_INSTALMENT | NUMERIC(18,2) | 19 |
| 7 | MULTIPLE_TOTAL_NUMBER_OF_INSTALMENT | NUMERIC(18,2) | 19 |
| 8 | MULTIPLE_TOTAL_AMOUNT_OF_INSTALMENT | NUMERIC(18,2) | 19 |
| 9 | BROKEN_TOTAL_PTP | NUMERIC(18,2) | 19 |
| 10 | BROKEN_TOTAL_AMOUNT | NUMERIC(18,2) | 19 |
| 11 | KEPT_NUMBER_OF_PTP | NUMERIC(18,2) | 19 |
| 12 | KEPT_PTP_TOTAL_AMOUNT | NUMERIC(18,2) | 19 |