SDW_TSDMF_GROWTH_TXFRS

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Columns
# Name Data Type Length
1 BUSINESS_PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_DIM_ID BIGINT 8
3 ACCOUNT_STATUS_MOVEMENT_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_DIM_ID BIGINT 8
5 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
6 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
7 COST_CENTRE_DIM_ID BIGINT 8
8 GL_PRODUCT_DIM_ID BIGINT 8
9 BDM_DIM_ID BIGINT 8
10 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
11 IMPACT_TYPE_DIM_ID BIGINT 8
12 ACCOUNT_OPENING_BALANCE NUMERIC(14,2) 19
13 ACCOUNT_CLOSING_BALANCE NUMERIC(14,2) 19
14 ACCOUNT_GROWTH NUMERIC(14,2) 19
15 OPENED_CLOSED_IMPACT BIGINT 8
16 ROW_EXPLANATION CHARACTER VARYING(4) 4
17 SEGMENT_OPENING_BALANCE NUMERIC(14,2) 19
18 SEGMENT_CLOSING_BALANCE NUMERIC(14,2) 19
19 SEGMENT_GROWTH NUMERIC(14,2) 19
20 SEGMENT_TRANSFER NUMERIC(14,2) 19
21 SEGMENT_ACTIVE BIGINT 8
22 SEGMENT_IMPACT_OA BIGINT 8
23 SEGMENT_IMPACT_PERS_INV BIGINT 8
24 SEGMENT_IMPACT_SP BIGINT 8
25 SEGMENT_IMPACT_BAL_SHT_IND BIGINT 8
26 SEGMENT_IMPACT_GL_PROD BIGINT 8
27 SEGMENT_IMPACT_COST_CENTRE BIGINT 8
28 SEGMENT_IMPACT_BDM BIGINT 8
29 SALES_SEGMENT_TRANSFER_CC NUMERIC(14,2) 19
30 SALES_SEGMENT_TRANSFER_NON_CC NUMERIC(14,2) 19
31 SALES_GROWTH NUMERIC(14,2) 19
32 GL_ACCOUNT_DIM_ID BIGINT 8
33 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
35 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
36 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
37 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8