SDW_TSDMF_OF_PS_GL_BALANCE

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 ALL_TIME_SID BIGINT 8
2 PRODUCT_SID BIGINT 8
3 CATEGORY_SID BIGINT 8
4 COST_CENTRE_SID BIGINT 8
5 ENTITY_SID BIGINT 8
6 PERIOD_DIM_ID BIGINT 8
7 GL_ACCOUNT_DIM_ID BIGINT 8
8 GL_PRODUCT_DIM_ID BIGINT 8
9 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
10 COST_CENTRE_DIM_ID BIGINT 8
11 ACCOUNT_SID BIGINT 8
12 MEASURE NUMERIC(14,2) 19
13 BUSINESS_LOAD_DATE TIMESTAMP 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