FCT_HOG_EFS_ACCOUNT_BALANCE_PIT_LN_INSIGHT

Database

INSNZP01_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID NUMERIC(38,0) 19
2 ACCOUNT_EFS_DIM_ID NUMERIC(38,0) 19
3 SOURCE_SYSTEM_CODE CHARACTER VARYING(30) 30
4 SOURCE_SYSTEM_GROUP CHARACTER VARYING(3) 3
5 ACCOUNT_NUMBER CHARACTER VARYING(20) 20
6 BALANCE_SHEET_INDICATOR CHARACTER VARYING(20) 20
7 CURRENCY_CODE CHARACTER VARYING(3) 3
8 CURRENT_BALANCE NUMERIC(37,2) 19
9 GL_PRINCIPAL_BALANCE NUMERIC(37,2) 19
10 CAPTIAL_BALANCE NUMERIC(37,2) 19
11 BALANCE NUMERIC(37,2) 19
12 TOTAL_GUARANTEE_VALUE NUMERIC(37,2) 19
13 TOTAL_UNRECOVERED_COSTS NUMERIC(37,2) 19
14 PRINCIPLE_LIMIT NUMERIC(37,2) 19
15 UNDRAWN_AMOUNT NUMERIC(37,2) 19
16 INT_INCOME_ACCRUED_CTD NUMERIC(37,2) 19
17 INT_INCOME_MOVEMENT_MTD NUMERIC(37,2) 19
18 INT_INCOME_TOTAL_MTD NUMERIC(37,2) 19
19 INT_EXPENSE_ACCRUED_CTD NUMERIC(37,2) 19
20 INT_EXPENSE_MOVEMENT_MTD NUMERIC(37,2) 19
21 INT_EXPENSE_TOTAL_MTD NUMERIC(37,2) 19
22 INBA_AMOUNT NUMERIC(37,2) 19
23 DEBIT_INT_RATE NUMERIC(15,2) 19
24 CREDIT_INT_RATE NUMERIC(15,2) 19
25 DEBIT_INT_BASE_RATE NUMERIC(15,2) 19
26 DEBIT_INT_MARGIN_RATE NUMERIC(15,2) 19
27 AVAILABLE_REDRAW_BALANCE NUMERIC(37,2) 19
28 OFFSET_FACILITY_BALANCE NUMERIC(37,2) 19
29 OFFSET_BALANCE_AT_INTEREST_CALC NUMERIC(37,2) 19
30 UNEARNED_INT_MTD NUMERIC(37,2) 19
31 DRAWN_AMOUNT_LTD NUMERIC(37,2) 19
32 UNAPPLIED_FUND_AMOUNT NUMERIC(37,2) 19
33 NEXT_DUE_DATE TIMESTAMP 8
34 NEXT_DUE_AMT NUMERIC(37,2) 19
35 REDRAW_FLAG CHARACTER(1) 1
36 IS_REPORTED_ACCOUNT CHARACTER VARYING(1) 1
37 ACCOUNT_ID_NUMBER CHARACTER VARYING(30) 30
38 REPAYMENTS_IN_ADVANCE NUMERIC(37,2) 19
39 CURRENT_LOAN_LIMIT NUMERIC(37,2) 19