FCT_OBP_ACCOUNT

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 ACCOUNT_SECURITY_DIM_ID BIGINT 8
2 ACCT_CLASSIFER_DIM_ID BIGINT 8
3 ACCOUNT_DIM_ID BIGINT 8
4 COUNTERPARTY_TYPE_DIM_ID BIGINT 8
5 PORTFOLIO_FACILITY_DIM_ID BIGINT 8
6 PERIOD_DIM_ID BIGINT 8
7 SOURCE_PRODUCT_DIM_ID BIGINT 8
8 SOURCE_PRODUCT_CODE CHARACTER VARYING(104) 104
9 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
10 ACCOUNT_STATUS_DIM_ID BIGINT 8
11 BRANCH_DIM_ID BIGINT 8
12 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
13 BILL_TYPE_DIM_ID BIGINT 8
14 LOAN_PURPOSE_DIM_ID BIGINT 8
15 CUSTOMER_DIM_ID BIGINT 8
16 INTEREST_RATE_TERM_DIM_ID BIGINT 8
17 ORIG_TERM_MATURITY_DIM_ID BIGINT 8
18 ACCT_CREDIT_RISK_DIM_ID BIGINT 8
19 DAYS_PAST_DUE_DIM_ID BIGINT 8
20 CUST_CLASSIFIER_DIM_ID BIGINT 8
21 GCIS_CUSTOMER_DIM_ID BIGINT 8
22 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
23 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
24 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
25 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
26 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
27 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
28 SECURITISATION_DIM_ID BIGINT 8
29 CHANNEL_DIM_ID BIGINT 8
30 OF_GL_PRINCIPAL_BALANCE_DIM_ID BIGINT 8
31 OF_GL_INT_INCOME_ACR_DIM_ID BIGINT 8
32 OF_GL_INBA_DIM_ID BIGINT 8
33 ANZSIC_DIM_ID BIGINT 8
34 OF_GL_INT_INCOME_MVMT_DIM_ID BIGINT 8
35 OF_GL_UNAPPLIED_FUNDS_DIM_ID BIGINT 8
36 OF_GL_UNEARNED_INT_DIM_ID BIGINT 8
37 OF_GL_INT_EXPENSE_ACR_DIM_ID BIGINT 8
38 OF_GL_INT_EXPENSE_MVMT_DIM_ID BIGINT 8
39 RSDL_TERM_MATURITY_DIM_ID BIGINT 8
40 INTEREST_RATE_DIM_ID BIGINT 8
41 MATERIALITY_DIM_ID BIGINT 8
42 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
43 PRODUCT_CODE CHARACTER VARYING(30) 30