FCT_OBP_TRANSACTIONS

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..FCT_OBP_TRANSACTIONS_V

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 ACCOUNT_STATUS_DIM_ID BIGINT 8
7 BORROWER_DIM_ID BIGINT 8
8 CLMS_GROUP_DIM_ID INTEGER 4
9 BDM_DIM_ID BIGINT 8
10 BRANCH_DIM_ID BIGINT 8
11 CLMS_DIVISION_DIM_ID INTEGER 4
12 SOURCE_PRODUCT_DIM_ID BIGINT 8
13 GL_ACCOUNT_DIM_ID BIGINT 8
14 COST_CENTRE_DIM_ID BIGINT 8
15 GL_PRODUCT_DIM_ID BIGINT 8
16 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
17 ILP_AF_PST_BAL DOUBLE PRECISION 8
18 ILP_AF_PST_ADV_ARS_BAL DOUBLE PRECISION 8
19 ILP_AMT DOUBLE PRECISION 8
20 CLMS_AMT INTEGER 4
21 CLMS_CLC_FEE_AMT INTEGER 4
22 CLMS_EFF_CPTL_BAL INTEGER 4
23 CLMS_EFF_CRN_BAL INTEGER 4
24 CLMS_EFF_DBT_WRTOF_BAL INTEGER 4
25 CLMS_EFF_INBA_BAL INTEGER 4
26 CLMS_EFF_IIA_ACR_INT_BAL INTEGER 4
27 CLMS_EFF_ON_UREC_COST_BAL INTEGER 4
28 CLMS_EFF_DCN_PREM_BAL INTEGER 4
29 CLMS_EFF_PNP_LMT INTEGER 4
30 CLMS_EFF_APRV_GNT_LMT INTEGER 4
31 CLMS_EFF_DRN_LTD INTEGER 4
32 CLMS_EFF_MX_INT_TO_BE_CPZ INTEGER 4
33 CLMS_EFF_AMT_OF_INT_CPZ INTEGER 4
34 CLMS_EFF_VAL_GNT INTEGER 4
35 CLMS_EFF_UREC_COST_CGY_1_BAL INTEGER 4
36 CLMS_EFF_UREC_COST_CGY_2_BAL INTEGER 4
37 CLMS_EFF_UREC_COST_CGY_3_BAL INTEGER 4
38 CLMS_EFF_UREC_COST_CGY_4_BAL INTEGER 4
39 CLMS_EFF_UREC_COST_CGY_5_BAL INTEGER 4
40 CLMS_EFF_UREC_COST_CGY_6_BAL INTEGER 4
41 CLMS_EFF_UREC_COST_CGY_7_BAL INTEGER 4
42 CLMS_EFF_UREC_COST_CGY_8_BAL INTEGER 4
43 CLMS_EFF_UREC_COST_CGY_9_BAL INTEGER 4
44 CLMS_EFF_AST_WDV_INL_EXPN INTEGER 4
45 CLMS_EFF_AST_ORIG_COST INTEGER 4
46 CLMS_EFF_DPRCN_LMT INTEGER 4
47 CLMS_EFF_GST_AC_BAL INTEGER 4
48 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
49 BALANCE_SHEET_INDICATOR CHARACTER VARYING(5) 5
50 TRANSACTION_TYP2_DIM_ID BIGINT 8
51 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
52 PAYOUT_REASON_DIM_ID BIGINT 8
53 CLASSIFICATION_PERIOD_DIM_ID INTEGER 4
54 TXN_CLASSIFICATION_DIM_ID BIGINT 8
55 30DAYS_TXN_CLASSIFICATION_DIM_ID BIGINT 8
56 CLASSIFICATION_DATE TIMESTAMP 8
57 OF_ACCOUNT_SID BIGINT 8
58 OF_COST_CENTRE_SID BIGINT 8
59 OF_ENTITY_SID BIGINT 8
60 OF_CATEGORY_SID BIGINT 8
61 OF_PRODUCT_SID BIGINT 8
62 OF_INTERCOMPANY_SID BIGINT 8
63 LN_DISB_TXN_AMT DOUBLE PRECISION 8
64 TXN_REF_NO CHARACTER VARYING(50) 50
65 SUB_SEQ_NO DOUBLE PRECISION 8
66 TXN_CHANNEL CHARACTER VARYING(50) 50
67 TXN_BRANCH CHARACTER VARYING(10) 10
68 USER_NO CHARACTER VARYING(50) 50
69 AUTHORIZER_CODE CHARACTER VARYING(50) 50
70 NARRATION CHARACTER VARYING(500) 500
71 CARD_REF_NO CHARACTER VARYING(50) 50
72 CHEQUE_NO CHARACTER VARYING(50) 50
73 USER_REF_NO CHARACTER VARYING(50) 50
74 POSTING_DATE TIMESTAMP 8
75 TXN_TYPE CHARACTER VARYING(50) 50
76 TRANSACTION_DATE TIMESTAMP 8
77 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
78 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
79 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
80 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
81 INTEREST_RATE_TYPE CHARACTER VARYING(30) 30
82 PRODUCT_CODE CHARACTER VARYING(30) 30
83 PAYOUT_TXN CHARACTER VARYING(1) 1
84 30DAYS_PAYOUT_TXN CHARACTER VARYING(1) 1