INT_PERIOD_DISBURSEMENT_RPT_H

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

TABLE

Description

 

Source Object (CTAS)

SDSNZP05_BANK..INT_PERIOD_DISBURSEMENT_RPT_H_V

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 FINANCIAL_END_ID NUMERIC(38,0) 19
3 ACCOUNT_DIM_ID BIGINT 8
4 SOURCE_PRODUCT_DIM_ID BIGINT 8
5 SOURCE_PRODUCT_CODE CHARACTER VARYING(65) 65
6 BALANCE_SHEET_INDICATOR CHARACTER VARYING(5) 5
7 COST_CENTRE_DIM_ID BIGINT 8
8 COST_CENTRE_DIM_ID_8WK BIGINT 8
9 BDM_DIM_ID BIGINT 8
10 BDM_DIM_ID_8WK BIGINT 8
11 TRANSACTION_DIM_ID BIGINT 8
12 TRANSACTION_TYP2_DIM_ID BIGINT 8
13 PERS_INV_USAGE_TYPE_DIM_ID BIGINT 8
14 LOW_DOC_DIM_ID BIGINT 8
15 MARGIN_PERCENT_BAND_DIM_ID BIGINT 8
16 STAFF_ACCOUNT_FLAG CHARACTER(1) 1
17 MARGIN_CODE_MATRIX_DIM_ID BIGINT 8
18 DISBURSEMENT_STATUS_DIM_ID BIGINT 8
19 EFFECTIVE_PERIOD_DIM_ID BIGINT 8
20 HOGAN_SALES_OFFICER_DIM_ID BIGINT 8
21 HOGAN_SALES_OFFICER_DIM_ID_8WK BIGINT 8
22 HOGAN_SALES_OFFICER_ID CHARACTER VARYING(254) 254
23 HOGAN_SALES_OFFICER_UID CHARACTER VARYING(254) 254
24 SALES_OFFICER_ROLE_DIM_ID BIGINT 8
25 SALES_OFFICER_CODE CHARACTER VARYING(24) 24
26 SALES_OFFICER_COST_CENTRE_CODE CHARACTER VARYING(24) 24
27 SOURCE_START_DATE TIMESTAMP 8
28 SOURCE_END_DATE TIMESTAMP 8
29 COST_CENTRE_CHANGE_FLAG CHARACTER VARYING(1) 1
30 SALES_OFFICER_CHANGE_FLAG CHARACTER VARYING(1) 1
31 ORIGINAL_INDICATOR BIGINT 8
32 UPDATE_INDICATOR BIGINT 8
33 DISBURSEMENT_AMOUNT DOUBLE PRECISION 8
34 CUSTOMER_RATE NUMERIC(8,5) 19
35 MARGIN_RATE NUMERIC(8,5) 19
36 CARDED_RATE NUMERIC(8,5) 19
37 CUSTOMER_RATE_VALUE DOUBLE PRECISION 8
38 MARGIN_RATE_VALUE DOUBLE PRECISION 8
39 CARDED_RATE_VALUE DOUBLE PRECISION 8
40 LINE_OF_CREDIT_LIMIT_RULE_FLAG CHARACTER VARYING(3) 3
41 CURRENT_RECORD_FLAG CHARACTER VARYING(1) 1
42 OF_COST_CENTRE_SID BIGINT 8
43 OF_COST_CENTRE_SID_8WK BIGINT 8
44 OF_ENTITY_SID BIGINT 8
45 OF_ACCOUNT_SID BIGINT 8
46 OF_CATEGORY_SID BIGINT 8
47 OF_PRODUCT_SID BIGINT 8
48 OF_INTERCOMPANY_SID BIGINT 8
49 CDC_SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
50 CDC_RECORD_TYPE CHARACTER VARYING(16) 16
51 CDC_COMMIT_TIMESTAMP TIMESTAMP 8
52 CDC_EXTRACT_TIMESTAMP TIMESTAMP 8