FCT_OBP_ACCOUNT_CS_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_ACCOUNT_CS

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 PRODUCT_GROUP_CODE CHARACTER VARYING(20) 20
9 SOURCE_PRODUCT_CODE CHARACTER VARYING(71) 71
10 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
11 ACCOUNT_STATUS_DIM_ID BIGINT 8
12 BRANCH_DIM_ID BIGINT 8
13 SOURCE_CURRENCY_DIMENSION_ID BIGINT 8
14 BILL_TYPE_DIM_ID BIGINT 8
15 LOAN_PURPOSE_DIM_ID BIGINT 8
16 CUSTOMER_DIM_ID BIGINT 8
17 INTEREST_RATE_TERM_DIM_ID BIGINT 8
18 ORIG_TERM_MATURITY_DIM_ID BIGINT 8
19 ACCT_CREDIT_RISK_DIM_ID BIGINT 8
20 DAYS_PAST_DUE_DIM_ID BIGINT 8
21 CUST_CLASSIFIER_DIM_ID BIGINT 8
22 GCIS_CUSTOMER_DIM_ID BIGINT 8
23 CUSTOMER_ADDRESS_DIM_ID BIGINT 8
24 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
25 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
28 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
29 SECURITISATION_DIM_ID INTEGER 4
30 CHANNEL_DIM_ID INTEGER 4
31 OF_GL_PRINCIPAL_BALANCE_DIM_ID BIGINT 8
32 OF_GL_INT_INCOME_ACR_DIM_ID BIGINT 8
33 OF_GL_INBA_DIM_ID INTEGER 4
34 ANZSIC_DIM_ID BIGINT 8
35 OF_GL_INT_INCOME_MVMT_DIM_ID BIGINT 8
36 OF_GL_UNAPPLIED_FUNDS_DIM_ID INTEGER 4
37 OF_GL_UNEARNED_INT_DIM_ID INTEGER 4
38 OF_GL_INT_EXPENSE_ACR_DIM_ID BIGINT 8
39 OF_GL_INT_EXPENSE_MVMT_DIM_ID BIGINT 8
40 RSDL_TERM_MATURITY_DIM_ID BIGINT 8
41 INTEREST_RATE_DIM_ID BIGINT 8
42 MATERIALITY_DIM_ID BIGINT 8
43 INTEREST_RATE_TYPE CHARACTER VARYING(8) 8
44 PRODUCT_CODE CHARACTER VARYING(30) 30