FCT_BNK_TRANSACTIONS_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

Merged Lending transactional dataset at account and txn grain

Synonyms

SDSNZP02_BANK..UBAR_FCT_BNK_TRANSACTIONS_INSIGHT

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 BIGINT 8
9 BDM_DIM_ID BIGINT 8
10 BRANCH_DIM_ID BIGINT 8
11 CLMS_DIVISION_DIM_ID BIGINT 8
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 NUMERIC(14,2) 19
21 CLMS_CLC_FEE_AMT NUMERIC(14,2) 19
22 CLMS_EFF_CPTL_BAL NUMERIC(14,2) 19
23 CLMS_EFF_CRN_BAL NUMERIC(14,2) 19
24 CLMS_EFF_DBT_WRTOF_BAL NUMERIC(14,2) 19
25 CLMS_EFF_INBA_BAL NUMERIC(14,2) 19
26 CLMS_EFF_IIA_ACR_INT_BAL NUMERIC(14,2) 19
27 CLMS_EFF_ON_UREC_COST_BAL NUMERIC(14,2) 19
28 CLMS_EFF_DCN_PREM_BAL NUMERIC(14,2) 19
29 CLMS_EFF_PNP_LMT NUMERIC(14,2) 19
30 CLMS_EFF_APRV_GNT_LMT NUMERIC(14,2) 19
31 CLMS_EFF_DRN_LTD NUMERIC(14,2) 19
32 CLMS_EFF_MX_INT_TO_BE_CPZ NUMERIC(14,2) 19
33 CLMS_EFF_AMT_OF_INT_CPZ NUMERIC(14,2) 19
34 CLMS_EFF_VAL_GNT NUMERIC(14,2) 19
35 CLMS_EFF_UREC_COST_CGY_1_BAL NUMERIC(14,2) 19
36 CLMS_EFF_UREC_COST_CGY_2_BAL NUMERIC(14,2) 19
37 CLMS_EFF_UREC_COST_CGY_3_BAL NUMERIC(14,2) 19
38 CLMS_EFF_UREC_COST_CGY_4_BAL NUMERIC(14,2) 19
39 CLMS_EFF_UREC_COST_CGY_5_BAL NUMERIC(14,2) 19
40 CLMS_EFF_UREC_COST_CGY_6_BAL NUMERIC(14,2) 19
41 CLMS_EFF_UREC_COST_CGY_7_BAL NUMERIC(14,2) 19
42 CLMS_EFF_UREC_COST_CGY_8_BAL NUMERIC(14,2) 19
43 CLMS_EFF_UREC_COST_CGY_9_BAL NUMERIC(14,2) 19
44 CLMS_EFF_AST_WDV_INL_EXPN NUMERIC(14,2) 19
45 CLMS_EFF_AST_ORIG_COST NUMERIC(14,2) 19
46 CLMS_EFF_DPRCN_LMT NUMERIC(14,2) 19
47 CLMS_EFF_GST_AC_BAL NUMERIC(14,2) 19
48 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
49 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
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 BIGINT 8
54 TXN_CLASSIFICATION_DIM_ID BIGINT 8
55 CLASSIFICATION_DATE TIMESTAMP 8
56 OF_ACCOUNT_SID BIGINT 8
57 OF_COST_CENTRE_SID BIGINT 8
58 OF_ENTITY_SID BIGINT 8
59 OF_CATEGORY_SID BIGINT 8
60 OF_PRODUCT_SID BIGINT 8
61 OF_INTERCOMPANY_SID BIGINT 8
62 LN_DISB_TXN_AMT DOUBLE PRECISION 8
63 SDW_IGNITE_SOURCE CHARACTER VARYING(1) 1
64 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
65 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
66 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
67 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8