FCT_OBP_TRANSACTIONS_CS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_TRANSACTIONS_CS_V

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 TRANSACTION_DIM_ID BIGINT 8
3 POSTING_PERIOD_DIM_ID BIGINT 8
4 SRC_EFFECTIVE_PERIOD_DIM_ID BIGINT 8
5 BUSINESS_PERIOD_DIM_ID BIGINT 8
6 CLASSIFICATION_PERIOD_DIM_ID BIGINT 8
7 BRANCH_DIM_ID BIGINT 8
8 SOURCE_PRODUCT_DIM_ID BIGINT 8
9 ACCOUNT_STATUS_DIM_ID BIGINT 8
10 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
11 TRANSACTION_TYP2_DIM_ID BIGINT 8
12 TXN_CLASSIFICATION_DIM_ID BIGINT 8
13 SOURCE_PRODUCT_CODE CHARACTER VARYING(71) 71
14 PRODUCT_CODE CHARACTER VARYING(30) 30
15 PRODUCT_GROUP_CODE CHARACTER VARYING(20) 20
16 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
17 OF_ACCOUNT_SID BIGINT 8
18 OF_COST_CENTRE_SID BIGINT 8
19 OF_ENTITY_SID BIGINT 8
20 OF_CATEGORY_SID BIGINT 8
21 OF_PRODUCT_SID BIGINT 8
22 OF_INTERCOMPANY_SID BIGINT 8
23 CLASSIFICATION_DATE DATE 4
24 POSTING_DATE TIMESTAMP 8
25 TXN_BRANCH CHARACTER VARYING(10) 10
26 TXN_REF_NO CHARACTER VARYING(50) 50
27 SUB_SEQ_NO DOUBLE PRECISION 8
28 TXN_CHANNEL CHARACTER VARYING(50) 50
29 TRANSACTION_DATE DATE 4
30 TRANSACTION_TIMESTAMP TIMESTAMP 8
31 VALUE_DATE TIMESTAMP 8
32 TRANSACTION_USER_ID CHARACTER VARYING(50) 50
33 EVENT_ID CHARACTER VARYING(50) 50
34 AUTHORIZER_CODE CHARACTER VARYING(50) 50
35 TXN_AMOUNT_TCY DOUBLE PRECISION 8
36 TCY_CODE CHARACTER VARYING(3) 3
37 TXN_AMOUNT_ACY DOUBLE PRECISION 8
38 ACY_CODE CHARACTER VARYING(3) 3
39 CLEAR_BAL_AMT DOUBLE PRECISION 8
40 UNCLEARED_AMT DOUBLE PRECISION 8
41 USER_HOLD_AMT DOUBLE PRECISION 8
42 SYSTEM_HOLD_AMT DOUBLE PRECISION 8
43 CHEQUE_NO CHARACTER VARYING(50) 50
44 CHEQUE_DEPOSIT_DATE TIMESTAMP 8
45 CHEQUE_VALUE_DATE TIMESTAMP 8
46 IS_TXN_REVERSED CHARACTER VARYING(1) 1
47 IS_USER_INIT_TXN CHARACTER VARYING(1) 1
48 TXN_TYPE CHARACTER VARYING(50) 50
49 TXN_DESC CHARACTER VARYING(500) 500
50 CARD_REF_NO CHARACTER VARYING(50) 50
51 USER_REFERENCE_NUMBER CHARACTER VARYING(50) 50
52 USER_REF_NO CHARACTER VARYING(50) 50
53 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
54 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
55 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
56 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8