SDW_TSDMF_SALES_SUMM

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 PERIOD_TYPE_DIM_ID BIGINT 8
3 COST_CENTRE_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
5 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
6 SOURCE_PRODUCT_DIM_ID BIGINT 8
7 SOURCE_PRODUCT_LVL_DIM_ID BIGINT 8
8 SALES_MEASURES_DIM_ID BIGINT 8
9 COST_CENTRE_LVLS_DIM_ID BIGINT 8
10 CPR_MEASURES_DIM_ID BIGINT 8
11 BDM_DIM_ID BIGINT 8
12 ACT_CNT_POINT_IN_TIME BIGINT 8
13 ACT_AMT_POINT_IN_TIME NUMERIC(15,2) 19
14 ACT_CNT_WK BIGINT 8
15 ACT_AMT_WK NUMERIC(15,2) 19
16 ACT_CNT_MTD BIGINT 8
17 ACT_AMT_MTD NUMERIC(15,2) 19
18 ACT_CNT_QTD BIGINT 8
19 ACT_AMT_QTD NUMERIC(15,2) 19
20 ACT_CNT_FIN_YTD BIGINT 8
21 ACT_AMT_FIN_YTD NUMERIC(15,2) 19
22 PERS_INV_USG_TP_SUMM_DIM_ID BIGINT 8
23 SALES_OFFICER_DIM_ID BIGINT 8
24 SALES_OFFICER_ROLE_DIM_ID BIGINT 8
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