INT_PERIOD_TRANSACTION_MEASURE_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_PERIOD_TRANSACTION_MEASURE

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 BUSINESS_PERIOD_DIM_ID BIGINT 8
3 PERIOD_TYPE_DIM_ID BIGINT 8
4 ACCOUNT_DIM_ID BIGINT 8
5 SOURCE_PRODUCT_DIM_ID BIGINT 8
6 BRANCH_DIM_ID BIGINT 8
7 ACCOUNT_STATUS_DIM_ID BIGINT 8
8 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
9 BALANCE_SHEET_INDICATOR CHARACTER VARYING(5) 5
10 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
11 SALES_MEASURES_DIM_ID BIGINT 8
12 CPR_MEASURES_DIM_ID BIGINT 8
13 SOURCE_PRODUCT_LVLS_DIM_ID BIGINT 8
14 PERS_INV_USG_TP_SUMM_DIM_ID BIGINT 8
15 OF_COST_CENTRE_SID BIGINT 8
16 OF_ENTITY_SID BIGINT 8
17 OF_ACCOUNT_SID BIGINT 8
18 OF_CATEGORY_SID BIGINT 8
19 OF_PRODUCT_SID BIGINT 8
20 OF_INTERCOMPANY_SID BIGINT 8
21 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
22 GL_PRODUCT_DIM_ID BIGINT 8
23 GL_ACCOUNT_DIM_ID BIGINT 8
24 COST_CENTRE_DIM_ID BIGINT 8
25 TRANSACTION_TOTAL_AMOUNTS DOUBLE PRECISION 8
26 SALES_MEASURE_COUNT BIGINT 8
27 SALES_MEASURE_CODE CHARACTER VARYING(24) 24
28 SALES_MEASURE_SUB_CODE CHARACTER VARYING(120) 120
29 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
30 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
31 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
32 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8