FCT_OBP_NROD_LN_ACCOUNT_INSIGHT
Description
Synonyms
SDSNZP02_BANK..NROD_FCT_OBP_NROD_LN_ACCOUNT_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | ACCOUNT_SOURCE_UNIQUE_ID | CHARACTER VARYING(32) | 32 |
| 2 | ACCOUNT_SOURCE_REF_ID | CHARACTER VARYING(32) | 32 |
| 3 | ACCOUNT_NAME | CHARACTER VARYING(100) | 100 |
| 4 | CUSTOMER_SOURCE_UNIQUE_ID | CHARACTER VARYING(32) | 32 |
| 5 | ACCOUNT_STATUS_CODE | CHARACTER VARYING(10) | 10 |
| 6 | CREDIT_DEBIT_CODE | CHARACTER VARYING(10) | 10 |
| 7 | CURRENCY_CODE | CHARACTER VARYING(3) | 3 |
| 8 | DATE_OPENED | CHARACTER VARYING(200) | 200 |
| 9 | DATE_CLOSED | CHARACTER VARYING(200) | 200 |
| 10 | ACCOUNT_BALANCE | NUMERIC(16,2) | 19 |
| 11 | OVERDRAFT_LIMIT | CHARACTER VARYING(1) | 1 |
| 12 | PERIODIC_LOAN_AMOUNT | CHARACTER VARYING(1) | 1 |
| 13 | LIFE_INS_CONTRACT_DURATION | CHARACTER VARYING(1) | 1 |
| 14 | BRANCH_ID | CHARACTER VARYING(32) | 32 |
| 15 | RELATIONSHIP_MGR_ID | CHARACTER VARYING(32) | 32 |
| 16 | IBAN | CHARACTER VARYING(34) | 34 |
| 17 | BIC | CHARACTER VARYING(11) | 11 |
| 18 | FROZEN_OVERRIDE_DATE | CHARACTER VARYING(1) | 1 |
| 19 | PRODUCT_SOURCE_TYPE_CODE | CHARACTER VARYING(20) | 20 |
| 20 | CREDIT_LIMIT | NUMERIC(16,2) | 19 |
| 21 | RISK_SCORE | CHARACTER VARYING(1) | 1 |
| 22 | ACCOUNT_SEGMENT | NATIONAL CHARACTER VARYING(250) | 250 |
| 23 | DORMANT_STATUS_FLAG | CHARACTER VARYING(1) | 1 |
| 24 | FROZEN_STATUS_FLAG | CHARACTER VARYING(1) | 1 |
| 25 | CREDIT_GRADE | CHARACTER VARYING(10) | 10 |
| 26 | REF_DEBT_COL_FLAG | CHARACTER VARYING(1) | 1 |
| 27 | BALANCE_DATE | CHARACTER VARYING(200) | 200 |
| 28 | COMMENTS | CHARACTER VARYING(4000) | 4000 |
| 29 | ORG_UNIT_CODE | CHARACTER VARYING(10) | 10 |
| 30 | ISSUE_DATE | CHARACTER VARYING(1) | 1 |
| 31 | PAYMENT_FREQ | CHARACTER VARYING(1) | 1 |
| 32 | INST_PREMIUM_AMT | CHARACTER VARYING(1) | 1 |
| 33 | ANN_PREMIUM_AMT | CHARACTER VARYING(1) | 1 |
| 34 | SINGLE_PREMIUM_TOTAL | CHARACTER VARYING(1) | 1 |
| 35 | SUM_INSURED | CHARACTER VARYING(1) | 1 |
| 36 | PAYMENT_METHOD | CHARACTER VARYING(1) | 1 |
| 37 | BENEFICIARY_FLAG | CHARACTER VARYING(1) | 1 |
| 38 | GROSS_PREM_TTD | CHARACTER VARYING(1) | 1 |
| 39 | CASH_SURR_VALUE | CHARACTER VARYING(1) | 1 |
| 40 | DEATH_BENEFIT_AMT | CHARACTER VARYING(1) | 1 |
| 41 | CUSTOMER_INITIATED_CLOSURE | CHARACTER VARYING(1) | 1 |
| 42 | DELAYED_ACCOUNT_FLAG | CHARACTER VARYING(1) | 1 |
| 43 | LANGUAGE_PREF_CODE | CHARACTER VARYING(1) | 1 |
| 44 | SETTLEMENT_BANK_NAME | CHARACTER VARYING(1) | 1 |
| 45 | DELIVERY_INSTRUCTIONS | CHARACTER VARYING(1) | 1 |
| 46 | SETTLEMENT_TYPE | CHARACTER VARYING(1) | 1 |
| 47 | RISK_CATEGORY | CHARACTER VARYING(1) | 1 |
| 48 | BLOCKED_TYPE | CHARACTER VARYING(1) | 1 |
| 49 | BLOCKED_REASON | CHARACTER VARYING(1) | 1 |
| 50 | PRIMARY_CARD_ID | CHARACTER VARYING(1) | 1 |
| 51 | ADDRESS | CHARACTER VARYING(1) | 1 |
| 52 | ZONE | CHARACTER VARYING(1) | 1 |
| 53 | CITY | CHARACTER VARYING(1) | 1 |
| 54 | POSTAL_CODE | CHARACTER VARYING(1) | 1 |
| 55 | COUNTRY_CODE | CHARACTER VARYING(1) | 1 |
| 56 | ADDRESS_VALID_FROM | CHARACTER VARYING(1) | 1 |
| 57 | ADDRESS_VALID_TO | CHARACTER VARYING(1) | 1 |
| 58 | CREDIT_TURNOVER | CHARACTER VARYING(1) | 1 |
| 59 | DEBIT_TURNOVER | CHARACTER VARYING(1) | 1 |
| 60 | TURNOVER_FROM_DATE | CHARACTER VARYING(1) | 1 |
| 61 | TURNOVER_TO_DATE | CHARACTER VARYING(1) | 1 |
| 62 | HOLDING_BANK_NAME | CHARACTER VARYING(1) | 1 |
| 63 | SALARY_LODGED_FLAG | CHARACTER VARYING(1) | 1 |
| 64 | ACCOUNT_ON_HOLD_FLAG | CHARACTER VARYING(1) | 1 |
| 65 | SENT_CORRESPONDENCE_FLAG | CHARACTER VARYING(1) | 1 |
| 66 | ACCOUNT_PURPOSE | CHARACTER VARYING(1) | 1 |
| 67 | PRIMARY_CUSTOMER_CATEGORY_CODE | CHARACTER VARYING(6) | 6 |
| 68 | COLLECTED_BALANCE | CHARACTER VARYING(1) | 1 |
| 69 | OTHER_HOLD_AMOUNT | CHARACTER VARYING(1) | 1 |
| 70 | REPORTING_REGION | CHARACTER VARYING(1) | 1 |