INT_WAS_DISBURSEMENT_INT_VW_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_WAS_DISBURSEMENT_INT_VW

Columns
# Name Data Type Length
1 BUSINESS_PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_DIM_ID BIGINT 8
3 COST_CENTRE_DIM_ID BIGINT 8
4 PERIOD_DT TIMESTAMP 8
5 FINANCIAL_END_ID NUMERIC(38,0) 19
6 PERIOD_DIM_ID BIGINT 8
7 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
8 ACCOUNT_ID CHARACTER VARYING(40) 40
9 COST_CENTRE_DIM_ID_8WK BIGINT 8
10 SOURCE_PRODUCT_DIM_ID BIGINT 8
11 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
12 BALANCE_SHEET_INDICATOR CHARACTER VARYING(5) 5
13 PREVIOUS_COST_CENTRE_DIM_ID BIGINT 8
14 BDM_DIM_ID BIGINT 8
15 BDM_DIM_ID_8WK BIGINT 8
16 LOW_DOC_DIM_ID BIGINT 8
17 TRANSACTION_DIM_ID BIGINT 8
18 TRANSACTION_TYP2_DIM_ID BIGINT 8
19 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
20 DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
21 CREATED_BY CHARACTER VARYING(254) 254
22 HOGAN_SALES_OFFICER_DIM_ID BIGINT 8
23 HOGAN_SALES_OFFICER_DIM_ID_8WK BIGINT 8
24 PREVIOUS_HOGAN_SALES_OFFICER_DIM_ID BIGINT 8
25 HOGAN_SALES_OFFICER_ID CHARACTER VARYING(254) 254
26 PREVIOUS_HOGAN_SALES_OFFICER_ID CHARACTER VARYING(254) 254
27 HOGAN_SALES_OFFICER_UID CHARACTER VARYING(254) 254
28 PREVIOUS_HOGAN_SALES_OFFICER_UID CHARACTER VARYING(254) 254
29 SALES_OFFICER_ROLE_DIM_ID BIGINT 8
30 PREVIOUS_SALES_OFFICER_ROLE_DIM_ID BIGINT 8
31 SALES_OFFICER_CODE CHARACTER VARYING(24) 24
32 PREVIOUS_SALES_OFFICER_CODE CHARACTER VARYING(24) 24
33 SALES_OFFICER_COST_CENTRE_CODE CHARACTER VARYING(24) 24
34 PREVIOUS_SALES_OFFICER_COST_CENTRE_CODE CHARACTER VARYING(24) 24
35 SOURCE_START_DATE TIMESTAMP 8
36 PREVIOUS_SOURCE_START_DATE TIMESTAMP 8
37 SOURCE_END_DATE TIMESTAMP 8
38 PREVIOUS_SOURCE_END_DATE TIMESTAMP 8
39 OF_COST_CENTRE_SID BIGINT 8
40 PIT_OF_COST_CENTRE_SID BIGINT 8
41 OF_ENTITY_SID BIGINT 8
42 OF_ACCOUNT_SID BIGINT 8
43 OF_CATEGORY_SID BIGINT 8
44 OF_PRODUCT_SID BIGINT 8
45 OF_INTERCOMPANY_SID BIGINT 8
46 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
47 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
48 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
49 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8
50 SOURCE_TRANSACTION_CODE CHARACTER VARYING(50) 50