SDW_TSDMF_REPAYMENT_EVENTS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_SDW_TSDMF_REPAYMENT_EVENTS

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 ACCOUNT_STATUS_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 SOURCE_PRODUCT_DIM_ID BIGINT 8
7 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
8 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
9 OF_INTERCOMPANY_SID BIGINT 8
10 OF_PRODUCT_SID BIGINT 8
11 OF_CATEGORY_SID BIGINT 8
12 OF_ACCOUNT_SID BIGINT 8
13 OF_COST_CENTRE_SID BIGINT 8
14 OF_ENTITY_SID BIGINT 8
15 BRANCH_DIM_ID BIGINT 8
16 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
17 TRANSACTION_DIM_ID BIGINT 8
18 TRANSACTION_TYP2_DIM_ID BIGINT 8
19 TXN_CLASSIFICATION_DIM_ID BIGINT 8
20 PAYOUT_REASON_DIM_ID BIGINT 8
21 BILL_TYPE_DIM_ID BIGINT 8
22 REPYMT_EVENT_TYPE_DIM_ID BIGINT 8
23 BILL_FREQUENCY_DIM_ID BIGINT 8
24 REPAYMENT_AMOUNT NUMERIC(14,2) 19
25 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
26 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
27 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
28 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8