OBP24_FLX_PM_LN_PRODUCTS_B
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_PM_LN_PRODUCTS_B
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | PRODUCT_CODE | CHARACTER VARYING(30) | 30 |
| 2 | NSF_BEHAVIOR_TYPE | CHARACTER VARYING(1) | 1 |
| 3 | INCLUDE_UNBILL_PENALTY_FLAG | CHARACTER(1) | 1 |
| 4 | HOLIDAY_PROCESSING_TYPE | CHARACTER VARYING(15) | 15 |
| 5 | RPA_AUTO_DEBIT_FLAG | CHARACTER(1) | 1 |
| 6 | AUTO_DEBIT_MAX_RETRY_NUM | DOUBLE PRECISION | 8 |
| 7 | AUTO_DEBIT_AMT | CHARACTER VARYING(1) | 1 |
| 8 | CHARGE_PENALTY_RETRY_FLAG | CHARACTER(1) | 1 |
| 9 | REDRAW_ALLOWED_TYPE | CHARACTER VARYING(1) | 1 |
| 10 | SUBSEQUENT_DISBURSEMENT_TYPE | CHARACTER VARYING(1) | 1 |
| 11 | DECREASE_LOAN_TERM_TYPE | CHARACTER VARYING(1) | 1 |
| 12 | LOAN_TERM_INCREASE_TYPE | CHARACTER VARYING(1) | 1 |
| 13 | LOAN_AMT_INCREASE_TYPE | CHARACTER VARYING(1) | 1 |
| 14 | ALLOW_REPAY_HOLIDAY_PRD_TYPE | CHARACTER VARYING(1) | 1 |
| 15 | PRINCIPAL_OFFSET_ALLOWED_TYPE | CHARACTER VARYING(1) | 1 |
| 16 | ALLOW_DOWNWARDS_FLAG | CHARACTER(1) | 1 |
| 17 | ALLOW_UPWARDS_FLAG | CHARACTER(1) | 1 |
| 18 | DEBT_CONSOLIDATION_MIN_AMT | DOUBLE PRECISION | 8 |
| 19 | APPROPRAITION_SEQ | CHARACTER VARYING(20) | 20 |
| 20 | FEE_AMOTISATION_METHOD_TYPE | CHARACTER VARYING(1) | 1 |
| 21 | COLLECTED_BALANCE_FLAG | CHARACTER(1) | 1 |
| 22 | INCOMING_PAYMENTS_FLAG | CHARACTER(1) | 1 |
| 23 | ADVANCE_INTEREST_MIN_PERIOD | DOUBLE PRECISION | 8 |
| 24 | LONG_OVERDUE_FIRST_FLAG | CHARACTER(1) | 1 |
| 25 | PAYOFF_BENEFIT_TYPE | CHARACTER VARYING(1) | 1 |
| 26 | FEE_AMORTIZATION_FRQ_TYPE | CHARACTER VARYING(1) | 1 |
| 27 | UPDATE_UTILIZATION_FLAG | CHARACTER(1) | 1 |
| 28 | WRITTEN_OFF_ACCT_APP_SEQ | CHARACTER VARYING(6) | 6 |
| 29 | EPS_SIMULATION_PER_DAYS | CHARACTER VARYING(20) | 20 |
| 30 | LOCKIN_PERIOD_UNIT_TYPE | CHARACTER VARYING(20) | 20 |
| 31 | LOCKIN_PERIOD_MAX_NUM | DOUBLE PRECISION | 8 |
| 32 | RECESSION_PERIOD_DAYS | DOUBLE PRECISION | 8 |
| 33 | ACCOUNT_AUTO_CLOSSURE_FLAG | CHARACTER(1) | 1 |
| 34 | REFRESH_FIXED_RATE_FLAG | CHARACTER(1) | 1 |
| 35 | NOTICE_PERIOD_UNIT_TYPE | CHARACTER VARYING(20) | 20 |
| 36 | NOTICE_PERIOD_MAX_NUM | DOUBLE PRECISION | 8 |
| 37 | REDRAW_RESERVE_MIN_NUM | DOUBLE PRECISION | 8 |
| 38 | DEFAULT_RESCHEDULE_MODE_TYPE | CHARACTER VARYING(20) | 20 |
| 39 | MIN_REPAY_HOLIDAY_PERIOD | DOUBLE PRECISION | 8 |
| 40 | MAX_REPAY_HOLIDAY_PERIOD | DOUBLE PRECISION | 8 |
| 41 | MIN_AMT_PPF | DOUBLE PRECISION | 8 |
| 42 | MATURITY_DATE_INTACT_FLAG | CHARACTER(1) | 1 |
| 43 | CAP_ECONOMIC_COST_FOR_PPF_FLAG | CHARACTER(1) | 1 |
| 44 | DEFAULT_RESCHEDULE_DATE | CHARACTER VARYING(30) | 30 |
| 45 | DECREASE_INSTALLMENT_ALWD_FLAG | CHARACTER(1) | 1 |
| 46 | PRD_TO_DSPLY_WAIVED_ORIG_FEES | DOUBLE PRECISION | 8 |
| 47 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 48 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 49 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 50 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |