INT_PERIOD_DISBURSEMENT_MEASURE

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_PERIOD_DISBURSEMENT_MEASURE_V

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 SRC_EFFECTIVE_PERIOD_DIM_ID BIGINT 8
6 BDM_DIM_ID BIGINT 8
7 TRANSACTION_DIM_ID BIGINT 8
8 TRANSACTION_TYP2_DIM_ID BIGINT 8
9 SOURCE_PRODUCT_DIM_ID BIGINT 8
10 BRANCH_DIM_ID BIGINT 8
11 ACCOUNT_STATUS_DIM_ID BIGINT 8
12 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
13 BALANCE_SHEET_INDICATOR CHARACTER VARYING(5) 5
14 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
15 SALES_MEASURES_DIM_ID BIGINT 8
16 CPR_MEASURES_DIM_ID BIGINT 8
17 SOURCE_PRODUCT_LVL_DIM_ID BIGINT 8
18 PERS_INV_USG_TP_SUMM_DIM_ID BIGINT 8
19 OF_COST_CENTRE_SID BIGINT 8
20 OF_ENTITY_SID BIGINT 8
21 OF_ACCOUNT_SID BIGINT 8
22 OF_CATEGORY_SID BIGINT 8
23 OF_PRODUCT_SID BIGINT 8
24 OF_INTERCOMPANY_SID BIGINT 8
25 GL_BUSINESS_UNIT_DIM_ID BIGINT 8
26 GL_PRODUCT_DIM_ID BIGINT 8
27 GL_ACCOUNT_DIM_ID BIGINT 8
28 COST_CENTRE_DIM_ID BIGINT 8
29 TRANSACTION_AMOUNT DOUBLE PRECISION 8
30 SALES_MEASURE_COUNT INTEGER 4
31 SALES_MEASURE_CODE CHARACTER VARYING(16) 16
32 SALES_MEASURE_SUB_CODE CHARACTER VARYING(16) 16
33 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
34 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
35 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
36 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8