SDW_TSDMF_FLOW_OF_FUNDS_SP

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 OPENING_PERIOD_DIM_ID BIGINT 8
2 CLOSING_PERIOD_DIM_ID BIGINT 8
3 CLOSING_DEPARTMENT_DIM_ID BIGINT 8
4 CLOSING_GL_ACCOUNT_DIM_ID BIGINT 8
5 CLOSING_GL_PRODUCT_DIM_ID BIGINT 8
6 CLOSING_GL_BSN_UNIT_DIM_ID BIGINT 8
7 CLOSING_SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
8 CLOSING_BAL_SHEET_INDICATOR CHARACTER VARYING(20) 20
9 CLOSING_SOURCE_PRODUCT_DIM_ID BIGINT 8
10 FLOW_OF_FUNDS_MEASURES_DIM_ID BIGINT 8
11 PORTFOLIO_OPENING_MOVEMENT_DIM NUMERIC(38,0) 19
12 MEASURE NUMERIC(14,2) 19
13 PERIOD_TYPE_DIM_ID BIGINT 8
14 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
15 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
16 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
17 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8