FCT_OBP_ACCOUNT_TD_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_ACCOUNT_TD

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