SDW_TSDMF_ACCOUNT

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..UBAR_SDW_TSDMF_ACCOUNT

SDSNZP05_BANK..CBP_SDW_TSDMF_ACCOUNT

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