FCT_BNK_AML_ACCOUNTS_INSIGHT
Description
OBP Loan Term Deposit and CASA extract of accounts and balances with status for AML
Synonyms
SDSNZP02_BANK..SYN_FCT_BNK_AML_ACCOUNTS_INSIGHT
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | INSERT_OR_UPDATE | CHARACTER VARYING(1) | 1 |
| 2 | ACCOUNT_SOURCE_UNIQUE_ID | BIGINT | 8 |
| 3 | ACCOUNT_SOURCE_REF_ID | CHARACTER VARYING(40) | 40 |
| 4 | SOURCE_SYS_CODE | CHARACTER VARYING(4) | 4 |
| 5 | ACCOUNT_NAME | CHARACTER VARYING(500) | 500 |
| 6 | CUSTOMER_SOURCE_UNIQUE_ID | BIGINT | 8 |
| 7 | ACCOUNT_STATUS_UNIQUE_ID | BIGINT | 8 |
| 8 | CREDIT_DEBIT_CODE | CHARACTER VARYING(1) | 1 |
| 9 | CURRENCY_CODE | CHARACTER VARYING(10) | 10 |
| 10 | DATE_OPENED | CHARACTER VARYING(200) | 200 |
| 11 | DATE_CLOSED | CHARACTER VARYING(200) | 200 |
| 12 | LAST_UPDATED_TIMESTAMP | CHARACTER VARYING(200) | 200 |
| 13 | ACCOUNT_BALANCE | NUMERIC(18,2) | 19 |
| 14 | OVERDRAFT_LIMIT | CHARACTER VARYING(1) | 1 |
| 15 | PERIODIC_LOAN_AMOUNT | CHARACTER VARYING(1) | 1 |
| 16 | LIFE_INS_CONTRACT_DURATION | CHARACTER VARYING(1) | 1 |
| 17 | ACCOUNT_TYPE_CODE | CHARACTER VARYING(4) | 4 |
| 18 | BRANCH_ID | CHARACTER VARYING(10) | 10 |
| 19 | RELATIONSHIP_MGR_ID | CHARACTER VARYING(1) | 1 |
| 20 | IBAN | CHARACTER VARYING(1) | 1 |
| 21 | BIC | CHARACTER VARYING(1) | 1 |
| 22 | FROZEN_OVERRIDE_DATE | CHARACTER VARYING(1) | 1 |
| 23 | PRODUCT_SOURCE_TYPE_CODE | BIGINT | 8 |
| 24 | CREDIT_LIMIT | CHARACTER VARYING(1) | 1 |
| 25 | RISK_SCORE | CHARACTER VARYING(1) | 1 |
| 26 | ACCOUNT_SEGMENT | CHARACTER VARYING(1) | 1 |
| 27 | DORMANT_STATUS_FLAG | CHARACTER VARYING(1) | 1 |
| 28 | FROZEN_STATUS_FLAG | CHARACTER VARYING(1) | 1 |
| 29 | CREDIT_GRADE | CHARACTER VARYING(1) | 1 |
| 30 | CURRENT_RECORD_FLAG | CHARACTER VARYING(1) | 1 |
| 31 | REF_DEBT_COL_FLAG | CHARACTER VARYING(1) | 1 |
| 32 | BALANCE_DATE | CHARACTER VARYING(1) | 1 |
| 33 | ORG_UNIT_CODE | CHARACTER VARYING(10) | 10 |
| 34 | ISSUE_DATE | CHARACTER VARYING(1) | 1 |
| 35 | PAYMENT_FREQ | CHARACTER VARYING(1) | 1 |
| 36 | INST_PREMIUM_AMT | CHARACTER VARYING(1) | 1 |
| 37 | ANN_PREMIUM_AMT | CHARACTER VARYING(1) | 1 |
| 38 | SINGLE_PREMIUM_TOTAL | CHARACTER VARYING(1) | 1 |
| 39 | SUM_INSURED | CHARACTER VARYING(1) | 1 |
| 40 | PAYMENT_METHOD | CHARACTER VARYING(1) | 1 |
| 41 | BENEFICIARY_FLAG | CHARACTER VARYING(1) | 1 |
| 42 | GROSS_PREM_TTD | CHARACTER VARYING(1) | 1 |
| 43 | CASH_SURR_VALUE | CHARACTER VARYING(1) | 1 |
| 44 | DEATH_BENEFIT_AMT | CHARACTER VARYING(1) | 1 |
| 45 | CUSTOMER_INITIATED_CLOSURE | CHARACTER VARYING(1) | 1 |
| 46 | DELAYED_ACCOUNT_FLAG | CHARACTER VARYING(1) | 1 |
| 47 | LANGUAGE_PREF_CODE | CHARACTER VARYING(1) | 1 |
| 48 | SETTLEMENT_BANK_NAME | CHARACTER VARYING(1) | 1 |
| 49 | DELIVERY_INSTRUCTIONS | CHARACTER VARYING(1) | 1 |
| 50 | SETTLEMENT_TYPE | CHARACTER VARYING(1) | 1 |
| 51 | RISK_CATEGORY | CHARACTER VARYING(1) | 1 |
| 52 | BLOCKED_TYPE | CHARACTER VARYING(1) | 1 |
| 53 | BLOCKED_REASON | CHARACTER VARYING(1) | 1 |
| 54 | DATE_OPENED_PLUS10 | CHARACTER VARYING(1) | 1 |
| 55 | DATE_OPENED_PLUS120 | CHARACTER VARYING(1) | 1 |
| 56 | CARD_ID | CHARACTER VARYING(1) | 1 |
| 57 | ADDRESS | CHARACTER VARYING(1) | 1 |
| 58 | ZONE | CHARACTER VARYING(1) | 1 |
| 59 | POSTAL_CODE | CHARACTER VARYING(1) | 1 |
| 60 | COUNTRY_CODE | CHARACTER VARYING(1) | 1 |
| 61 | CREDIT_TURNOVER | CHARACTER VARYING(1) | 1 |
| 62 | DEBIT_TRUNOVER | CHARACTER VARYING(1) | 1 |
| 63 | CREDIT_TURNOVER_FROM_DATE | CHARACTER VARYING(1) | 1 |
| 64 | CREDIT_TURNOVER_TO_DATE | CHARACTER VARYING(1) | 1 |
| 65 | DEBIT_TURNOVER_FROM_DATE | CHARACTER VARYING(1) | 1 |
| 66 | DEBIT_TURNOVER_TO_DATE | CHARACTER VARYING(1) | 1 |
| 67 | HOLDING_BANK_NAME | CHARACTER VARYING(1) | 1 |
| 68 | SALARY_LODGED_FLAG | CHARACTER VARYING(1) | 1 |
| 69 | ACCOUNT_ON_HOLD_FLAG | CHARACTER VARYING(1) | 1 |
| 70 | SENT_CORRESPONDENCE_FLAG | CHARACTER VARYING(1) | 1 |
| 71 | BROKER_CODE | CHARACTER VARYING(20) | 20 |
| 72 | LAST_CUST_DEP_DATE | CHARACTER VARYING(1) | 1 |
| 73 | LAST_CUST_WDL_DATE | CHARACTER VARYING(1) | 1 |