FCT_OBP_TRANSACTIONS_SDW_MIGRATED_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_TRANSACTIONS_SDW_MIGRATED

Columns
# Name Data Type Length
1 BUSINESS_PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_DIM_ID BIGINT 8
3 SOURCE_PRODUCT_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_CODE CHARACTER VARYING(104) 104
5 TXN_CLASSIFICATION_DIM_ID BIGINT 8
6 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
7 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
8 ILP_AMT NUMERIC(14,2) 19
9 TRANSACTION_TYP2_DIM_ID BIGINT 8
10 INFORM_CLASSIFICATION CHARACTER VARYING(24) 24
11 TRANSACTION_DIM_ID BIGINT 8
12 BRANCH_DIM_ID BIGINT 8
13 ACCOUNT_STATUS_DIM_ID BIGINT 8
14 SRC_EFFECTIVE_PERIOD_DIM_ID BIGINT 8
15 BDM_DIM_ID BIGINT 8
16 PAYOUT_REASON_DIM_ID BIGINT 8
17 CLASSIFICATION_PERIOD_DIM_ID BIGINT 8
18 OF_COST_CENTRE_SID BIGINT 8
19 OF_ENTITY_SID BIGINT 8
20 OF_ACCOUNT_SID BIGINT 8
21 OF_CATEGORY_SID BIGINT 8
22 OF_PRODUCT_SID BIGINT 8
23 OF_INTERCOMPANY_SID BIGINT 8
24 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
25 GL_PRODUCT_DIM_ID BIGINT 8
26 GL_ACCOUNT_DIM_ID BIGINT 8
27 COST_CENTRE_DIM_ID BIGINT 8
28 COST_CENTRE_CODE CHARACTER VARYING(24) 24
29 SDW_SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
30 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
31 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
32 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
33 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8