OBP24_FLX_PM_CS_OFFERS_B
Description
Synonyms
SDSNZP05_BANK..CBP_OBP_FLX_PM_CS_OFFERS_B
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | OFFER_CODE | CHARACTER VARYING(30) | 30 |
| 2 | ALLOWED_RATE_TYPE | CHARACTER VARYING(1) | 1 |
| 3 | BACKDATED_ACCOUNT_OPEN_DAYS | DOUBLE PRECISION | 8 |
| 4 | MIN_BAL_TYPE | CHARACTER VARYING(2) | 2 |
| 5 | MIN_BAL_CHARGE_BREACH_BASIS | CHARACTER VARYING(1) | 1 |
| 6 | SWEEP_IN_FLAG | CHARACTER VARYING(1) | 1 |
| 7 | SWEEP_OUT_FLAG | CHARACTER VARYING(1) | 1 |
| 8 | PASSBOOK_FLAG | CHARACTER VARYING(1) | 1 |
| 9 | CHEQUE_BOOK_FLAG | CHARACTER VARYING(1) | 1 |
| 10 | FUND_TRANSFER_FLAG | CHARACTER VARYING(1) | 1 |
| 11 | INWARD_DIRECT_FLAG | CHARACTER VARYING(1) | 1 |
| 12 | PRINCIPAL_OFFSET_FLAG | CHARACTER VARYING(1) | 1 |
| 13 | BUSINESS_PAYMENTS_FLAG | CHARACTER VARYING(1) | 1 |
| 14 | BUSINESS_COLLECTIONS_FLAG | CHARACTER VARYING(1) | 1 |
| 15 | DEBIT_BALANCE_ALLOWED_FLAG | CHARACTER VARYING(1) | 1 |
| 16 | OVERDRAFT_FLAG | CHARACTER VARYING(1) | 1 |
| 17 | OVERLINE_FLAG | CHARACTER VARYING(1) | 1 |
| 18 | AUF_FLAG | CHARACTER VARYING(1) | 1 |
| 19 | TOD_FLAG | CHARACTER VARYING(1) | 1 |
| 20 | PERIODIC_DEBIT_FLAG | CHARACTER VARYING(1) | 1 |
| 21 | PERIODIC_CREDIT_FLAG | CHARACTER VARYING(1) | 1 |
| 22 | OFFICE_OFFER_FLAG | CHARACTER VARYING(1) | 1 |
| 23 | MULTI_FUND_SINGLE_FEE_FLAG | CHARACTER VARYING(1) | 1 |
| 24 | MULTI_FUND_SINGLE_TXN_FLAG | CHARACTER VARYING(1) | 1 |
| 25 | PSEUDO_FEES_FLAG | CHARACTER VARYING(1) | 1 |
| 26 | PSEUDO_INTEREST_FLAG | CHARACTER VARYING(1) | 1 |
| 27 | CHQ_LOCAL_AUTO_REORDER_NUM | DOUBLE PRECISION | 8 |
| 28 | CHQ_MULTICITY_AUTO_REORDER_NUM | DOUBLE PRECISION | 8 |
| 29 | PERSONALIZED_FLAG | CHARACTER VARYING(1) | 1 |
| 30 | CHEQUE_BACK_GROUND | CHARACTER VARYING(1) | 1 |
| 31 | CHANNEL_MOBILE_BANK_FLAG | CHARACTER VARYING(1) | 1 |
| 32 | CHANNEL_BRANCH_FLAG | CHARACTER VARYING(1) | 1 |
| 33 | CHANNEL_INTERNET_BANK_FLAG | CHARACTER VARYING(1) | 1 |
| 34 | CHANNEL_PHONE_BANK_FLAG | CHARACTER VARYING(1) | 1 |
| 35 | MAX_NO_ACC_PER_CUSTOMER | DOUBLE PRECISION | 8 |
| 36 | CHANNEL_ATM_FLAG | CHARACTER VARYING(1) | 1 |
| 37 | RECONCILIATION_REQUIRED_FLAG | CHARACTER VARYING(1) | 1 |
| 38 | ACCOUNT_TYPE | CHARACTER VARYING(30) | 30 |
| 39 | RECONCILIATON_TYPE | CHARACTER VARYING(30) | 30 |
| 40 | MULTI_RECORD_OFFSET_ALLOWED | CHARACTER VARYING(1) | 1 |
| 41 | UDM_ALLOWED_FLAG | CHARACTER VARYING(1) | 1 |
| 42 | RATE_LOCK_REQUIRED_FLAG | CHARACTER VARYING(1) | 1 |
| 43 | LOCKED_RATE_TO_BE_APPLIED_FLAG | CHARACTER VARYING(1) | 1 |
| 44 | ALTERNATE_ACCOUNT_ALLOWED | CHARACTER VARYING(1) | 1 |
| 45 | INTEREST_PAY_OFFSET_ALWD_FLAG | CHARACTER VARYING(1) | 1 |
| 46 | MAX_NO_ACC_PRINCIPAL_OFFSET | DOUBLE PRECISION | 8 |
| 47 | FCF_ENABLED_FLAG | CHARACTER VARYING(1) | 1 |
| 48 | INTEREST_REPAYMENT_TYPE | CHARACTER VARYING(30) | 30 |
| 49 | DEBIT_ALWD_DAYS_IN_FIXED_PRD | DOUBLE PRECISION | 8 |
| 50 | OFFSET_BENEFIT_APPLICABLE_FLAG | CHARACTER VARYING(1) | 1 |
| 51 | OFFSET_BENEFIT_TYPE | CHARACTER VARYING(30) | 30 |
| 52 | FCF_INT_PAY_OFFSET_ALWD_FLAG | CHARACTER VARYING(1) | 1 |
| 53 | CDC_SOURCE_SYSTEM_CODE | CHARACTER VARYING(4) | 4 |
| 54 | CDC_RECORD_TYPE | CHARACTER VARYING(16) | 16 |
| 55 | CDC_COMMIT_TIMESTAMP | TIMESTAMP | 8 |
| 56 | CDC_EXTRACT_TIMESTAMP | TIMESTAMP | 8 |