SDW_TSDMF_GROWTH_TXFRS_SUMM

Database

SDSNZS01_BDW

Schema

CDCPADM_BDW

Type

TABLE

Description

 

Synonyms

SDSNZP05_BANK..CBP_SDW_TSDMF_GROWTH_TXFRS_SUMM

Columns
# Name Data Type Length
1 BUSINESS_PERIOD_DIM_ID BIGINT 8
2 START_PERIOD_DIM_ID BIGINT 8
3 END_PERIOD_DIM_ID BIGINT 8
4 PERIOD_TYPE_DIM_ID BIGINT 8
5 REPORTING_PERIOD_DIM_ID BIGINT 8
6 ACCOUNT_DIM_ID BIGINT 8
7 SOURCE_PRODUCT_DIM_ID BIGINT 8
8 SOURCE_PRODUCT_CODE CHARACTER VARYING(24) 24
9 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
10 COST_CENTRE_DIM_ID BIGINT 8
11 GL_PRODUCT_DIM_ID BIGINT 8
12 BDM_DIM_ID BIGINT 8
13 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
14 SEGMENT_START_PERIOD_DIM_ID BIGINT 8
15 SEGMENT_END_PERIOD_DIM_ID BIGINT 8
16 SEGMENT_OPENING_BALANCE NUMERIC(14,2) 19
17 SEGMENT_CLOSING_BALANCE NUMERIC(14,2) 19
18 SEGMENT_GROWTH NUMERIC(14,2) 19
19 SEGMENT_TRANSFER NUMERIC(14,2) 19
20 SEGMENT_ACTIVE INTEGER 4
21 OPENED_CLOSED_IMPACT INTEGER 4
22 SEGMENT_IMPACT_OA INTEGER 4
23 SEGMENT_IMPACT_PERS_INV INTEGER 4
24 SEGMENT_IMPACT_SP INTEGER 4
25 SEGMENT_IMPACT_BAL_SHT_IND INTEGER 4
26 SEGMENT_IMPACT_GL_PROD INTEGER 4
27 SEGMENT_IMPACT_COST_CENTRE INTEGER 4
28 SEGMENT_IMPACT_BDM INTEGER 4
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