INT_OBP_RETAIL_LENDING_MONTHLY_V

Database

SDSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Target Objects (CTAS)

SDSNZP05_BANK..INT_OBP_RETAIL_LENDING_MONTHLY

Columns
# Name Data Type Length
1 ACCOUNT_DIM_ID BIGINT 8
2 ACCOUNT_NUMBER CHARACTER VARYING(40) 40
3 MONTH_END_ID NUMERIC(38,0) 19
4 MONTH_OPENING_PERIOD_DIM_ID INTEGER 4
5 MONTHLY_OPENING_PIT_PERIOD_ID BIGINT 8
6 MONTHLY_CLOSING_PIT_PERIOD_ID BIGINT 8
7 FINANCIAL_YEAR_END_ID NUMERIC(38,0) 19
8 FINANCIAL_YEAR CHARACTER VARYING(401) 401
9 SECONDARY_OFFICER CHARACTER VARYING(40) 40
10 MANAGER_ID CHARACTER VARYING(50) 50
11 BASE_RATE DOUBLE PRECISION 8
12 MARGIN_RATE DOUBLE PRECISION 8
13 CUSTOMER_RATE DOUBLE PRECISION 8
14 STAGE_CODE CHARACTER VARYING(128) 128
15 DISBURSEMENT DOUBLE PRECISION 8
16 CASHBACK DOUBLE PRECISION 8
17 FEE DOUBLE PRECISION 8
18 INTEREST DOUBLE PRECISION 8
19 REPAYMENT DOUBLE PRECISION 8
20 PAYOUT DOUBLE PRECISION 8
21 INSURANCE DOUBLE PRECISION 8
22 30DAYS_REPAYMENT DOUBLE PRECISION 8
23 30DAYS_PAYOUT DOUBLE PRECISION 8