FCT_OBP_GROWTH_TXFRS_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..FCT_OBP_GROWTH_TXFRS

Columns
# Name Data Type Length
1 BUSINESS_PERIOD_DIM_ID BIGINT 8
2 PERIOD_TYPE_DIM_ID BIGINT 8
3 ACCOUNT_DIM_ID BIGINT 8
4 RANK_WITHIN_ACCOUNT BIGINT 8
5 MAX_WITHIN_ACCOUNT BIGINT 8
6 SOURCE_PRODUCT_DIM_ID BIGINT 8
7 SOURCE_PRODUCT_CODE CHARACTER VARYING(104) 104
8 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
9 COST_CENTRE_DIM_ID BIGINT 8
10 GL_PRODUCT_DIM_ID BIGINT 8
11 BDM_DIM_ID BIGINT 8
12 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
13 ACCOUNT_OPENING_BALANCE DOUBLE PRECISION 8
14 ACCOUNT_CLOSING_BALANCE DOUBLE PRECISION 8
15 ACCOUNT_GROWTH DOUBLE PRECISION 8
16 OPENED_CLOSED_IMPACT BIGINT 8
17 SEGMENT_OPENING_BALANCE DOUBLE PRECISION 8
18 SEGMENT_CLOSING_BALANCE DOUBLE PRECISION 8
19 SEGMENT_GROWTH DOUBLE PRECISION 8
20 SEGMENT_TRANSFER DOUBLE PRECISION 8
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 DOUBLE PRECISION 8
30 SALES_SEGMENT_TRANSFER_NON_CC DOUBLE PRECISION 8
31 SALES_GROWTH DOUBLE PRECISION 8
32 GL_ACCOUNT_DIM_ID BIGINT 8
33 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
34 OF_ACCOUNT_SID BIGINT 8
35 OF_CATEGORY_SID BIGINT 8
36 OF_COST_CENTRE_SID BIGINT 8
37 OF_ENTITY_SID BIGINT 8
38 OF_INTERCOMPANY_SID BIGINT 8
39 OF_PRODUCT_SID 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