INT_PERIOD_NET_TRANSFERS_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_PERIOD_NET_TRANSFERS

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 PERIOD_DIM_ID BIGINT 8
3 PERIOD_TYPE_DIM_ID BIGINT 8
4 COST_CENTRE_DIM_ID BIGINT 8
5 SALES_MEASURES_DIM_ID BIGINT 8
6 SALES_MEASURE_CODE CHARACTER VARYING(16) 16
7 SALES_MEASURE_SUB_CODE CHARACTER VARYING(16) 16
8 CPR_MEASURES_DIM_ID BIGINT 8
9 SOURCE_PRODUCT_LVL_DIM_ID BIGINT 8
10 PERS_INV_USG_TP_SUMM_DIM_ID BIGINT 8
11 OF_COST_CENTRE_SID BIGINT 8
12 OF_ENTITY_SID BIGINT 8
13 OF_ACCOUNT_SID BIGINT 8
14 OF_CATEGORY_SID BIGINT 8
15 OF_PRODUCT_SID BIGINT 8
16 OF_INTERCOMPANY_SID BIGINT 8
17 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
18 GL_PRODUCT_DIM_ID BIGINT 8
19 GL_ACCOUNT_DIM_ID BIGINT 8
20 SOURCE_PRODUCT_DIM_ID BIGINT 8
21 BRANCH_DIM_ID BIGINT 8
22 ACCOUNT_STATUS_DIM_ID BIGINT 8
23 SOURCE_PRODUCT_CODE CHARACTER VARYING(104) 104
24 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
25 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
26 PORTFOLIO_COUNT INTEGER 4
27 PORTFOLIO_BALANCE NUMERIC(15,2) 19
28 TRANSFER_WEEK_COUNT INTEGER 4
29 TRANSFER_WEEK_AMOUNT DOUBLE PRECISION 8
30 TRANSFER_MONTH_COUNT INTEGER 4
31 TRANSFER_MONTH_AMOUNT DOUBLE PRECISION 8
32 TRANSFER_QUARTER_COUNT INTEGER 4
33 TRANSFER_QUARTER_AMOUNT DOUBLE PRECISION 8
34 TRANSFER_FINYR_COUNT INTEGER 4
35 TRANSFER_FINYR_AMOUNT DOUBLE PRECISION 8
36 PIT_SRC CHARACTER VARYING(10) 10
37 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
38 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(4) 4
39 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
40 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8