FCT_OBP_TRANSACTIONS_TD_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_TRANSACTIONS_TD

Columns
# Name Data Type Length
1 POSTING_PERIOD_DIM_ID BIGINT 8
2 SRC_EFFECTIVE_PERIOD_DIM_ID BIGINT 8
3 BUSINESS_PERIOD_DIM_ID BIGINT 8
4 TRANSACTION_DIM_ID BIGINT 8
5 ACCOUNT_DIM_ID BIGINT 8
6 CLASSIFICATION_PERIOD_DIM_ID BIGINT 8
7 SERVICE_BRANCH_CODE CHARACTER VARYING(10) 10
8 ACCOUNT_STATUS_CODE CHARACTER VARYING(40) 40
9 TRANSACTION_TYP2_DIM_ID BIGINT 8
10 TXN_CLASSIFICATION_DIM_ID BIGINT 8
11 SOURCE_PRODUCT_CODE CHARACTER VARYING(61) 61
12 PRODUCT_CODE CHARACTER VARYING(30) 30
13 PRODUCT_GROUP_CODE CHARACTER VARYING(30) 30
14 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
15 CLASSIFICATION_DATE DATE 4
16 DEPOSIT_NUMBER DOUBLE PRECISION 8
17 TXN_BRANCH CHARACTER VARYING(10) 10
18 TXN_REF_NO CHARACTER VARYING(50) 50
19 SUB_SEQ_NO DOUBLE PRECISION 8
20 TXN_CHANNEL CHARACTER VARYING(50) 50
21 TRANSACTION_DATE DATE 4
22 TRANSACTION_TIMESTAMP TIMESTAMP 8
23 POSTING_DATE DATE 4
24 TRANSACTION_USER_ID CHARACTER VARYING(50) 50
25 EVENT_ID CHARACTER VARYING(50) 50
26 AUTHORIZER_CODE CHARACTER VARYING(50) 50
27 TXN_AMOUNT_TCY DOUBLE PRECISION 8
28 TCY_CODE CHARACTER VARYING(3) 3
29 TXN_AMOUNT_ACY DOUBLE PRECISION 8
30 ACY_CODE CHARACTER VARYING(3) 3
31 ACCOUNT_RUNNING_AMT DOUBLE PRECISION 8
32 DEPOSIT_RUNNING_AMT DOUBLE PRECISION 8
33 SETTLEMENT_REF_ID CHARACTER VARYING(100) 100
34 CHEQUE_NO CHARACTER VARYING(50) 50
35 CHEQUE_DEPOSIT_DATE CHARACTER VARYING(50) 50
36 CHEQUE_VALUE_DATE CHARACTER VARYING(50) 50
37 FX_RATE CHARACTER VARYING(1) 1
38 TXN_TYPE CHARACTER VARYING(50) 50
39 NARRATION CHARACTER VARYING(500) 500
40 TXN_DESC CHARACTER VARYING(100) 100
41 CARD_REF_NO CHARACTER VARYING(50) 50
42 USER_REF_NO CHARACTER VARYING(50) 50
43 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
44 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
45 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
46 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8