FCT_OBP_GROWTH_TXFRS_SUMM_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_GROWTH_TXFRS_SUMM

Columns
# Name Data Type Length
1 BUSINESS_PERIOD_DIM_ID BIGINT 8
2 START_PERIOD_DIM_ID NUMERIC(38,0) 19
3 END_PERIOD_DIM_ID NUMERIC(38,0) 19
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(104) 104
9 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
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 NUMERIC(38,0) 19
15 SEGMENT_END_PERIOD_DIM_ID NUMERIC(38,0) 19
16 GL_ACCOUNT_DIM_ID BIGINT 8
17 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
18 OF_ACCOUNT_SID BIGINT 8
19 OF_CATEGORY_SID BIGINT 8
20 OF_COST_CENTRE_SID BIGINT 8
21 OF_ENTITY_SID BIGINT 8
22 OF_INTERCOMPANY_SID BIGINT 8
23 OF_PRODUCT_SID BIGINT 8
24 SEGMENT_OPENING_BALANCE DOUBLE PRECISION 8
25 SEGMENT_CLOSING_BALANCE DOUBLE PRECISION 8
26 SEGMENT_GROWTH DOUBLE PRECISION 8
27 SEGMENT_TRANSFER DOUBLE PRECISION 8
28 SALES_SEGMENT_TRANSFER_CC DOUBLE PRECISION 8
29 SALES_SEGMENT_TRANSFER_NON_CC DOUBLE PRECISION 8
30 SALES_GROWTH DOUBLE PRECISION 8
31 SEGMENT_ACTIVE INTEGER 4
32 OPENED_CLOSED_IMPACT INTEGER 4
33 SEGMENT_IMPACT_OA INTEGER 4
34 SEGMENT_IMPACT_PERS_INV INTEGER 4
35 SEGMENT_IMPACT_SP INTEGER 4
36 SEGMENT_IMPACT_BAL_SHT_IND INTEGER 4
37 SEGMENT_IMPACT_GL_PROD INTEGER 4
38 SEGMENT_IMPACT_COST_CENTRE INTEGER 4
39 SEGMENT_IMPACT_BDM BIGINT 8
40 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
41 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
42 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
43 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8