SDW_TSDMF_PORTFOLIO_PERIOD

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP02_BANK..UBAR_SDW_TSDMF_PORTFOLIO_PERIOD

Columns
# Name Data Type Length
1 OPENING_PERIOD_ID BIGINT 8
2 CLOSING_PERIOD_ID BIGINT 8
3 ACCOUNT_DIM_ID BIGINT 8
4 CLOSING_BORROWER_DIM_ID BIGINT 8
5 OPENING_BDM_DIM_ID BIGINT 8
6 CLOSING_BDM_DIM_ID BIGINT 8
7 OPENING_BRANCH_DIM_ID BIGINT 8
8 CLOSING_BRANCH_DIM_ID BIGINT 8
9 OPENING_CLMS_DIVISION_DIM_ID BIGINT 8
10 CLOSING_CLMS_DIVISION_DIM_ID BIGINT 8
11 OPENING_SOURCE_PRODUCT_DIM_ID BIGINT 8
12 CLOSING_SOURCE_PRODUCT_DIM_ID BIGINT 8
13 OPENING_DEPARTMENT_DIM_ID BIGINT 8
14 CLOSING_DEPARTMENT_DIM_ID BIGINT 8
15 OPENING_GL_ACCOUNT_DIM_ID BIGINT 8
16 CLOSING_GL_ACCOUNT_DIM_ID BIGINT 8
17 OPENING_GL_PRODUCT_DIM_ID BIGINT 8
18 CLOSING_GL_PRODUCT_DIM_ID BIGINT 8
19 OPENING_GL_BSN_UNIT_DIM_ID BIGINT 8
20 CLOSING_GL_BSN_UNIT_DIM_ID BIGINT 8
21 MOVEMENT_DIM_ID BIGINT 8
22 LEDGER_MOVEMENT_DIM_ID BIGINT 8
23 ACCOUNT_STATUS_MOVEMENT_DIM_ID BIGINT 8
24 INSERT_RUN_AUDIT_ID BIGINT 8
25 UPDATE_RUN_AUDIT_ID BIGINT 8
26 OPENING_BALANCE NUMERIC(14,2) 19
27 CLOSING_BALANCE NUMERIC(14,2) 19
28 OPENING_SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
29 CLOSING_SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
30 OPENING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
31 CLOSING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
32 PERIOD_TYPE_DIM_ID BIGINT 8
33 OPENING_PERS_INV_USG_TP_DIM_ID BIGINT 8
34 CLOSING_PERS_INV_USG_TP_DIM_ID BIGINT 8
35 REPORTING_PERIOD_DIM_ID BIGINT 8
36 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
37 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
39 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8