SDW_TSDMF_FLOW_OF_FUNDS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 OPENING_PERIOD_ID BIGINT 8
2 CLOSING_PERIOD_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 FLOW_OF_FUNDS_MEASURES_DIM_ID BIGINT 8
8 PORTFOLIO_OPENING_MOVEMENT_DIM BIGINT 8
9 MEASURE NUMERIC(14,2) 19
10 PERIOD_TYPE_DIM_ID BIGINT 8
11 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
12 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
13 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
14 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8