FCT_OPC_EFS_SWAP_BALANCE_PIT_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID BIGINT 8
2 ACCOUNT_EFS_DIM_ID CHARACTER VARYING(8) 8
3 BRANCH CHARACTER VARYING(2) 2
4 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
5 ACCOUNT_NUMBER CHARACTER VARYING(8) 8
6 ORIGINAL_TABLE CHARACTER VARYING(7) 7
7 CURRENCY_CODE CHARACTER VARYING(3) 3
8 ORIGINAL_CURRENCY_CODE CHARACTER VARYING(3) 3
9 CONVERSION_RATE NUMERIC(18,8) 19
10 INTEREST_INCOME_DAILY_AUD NUMERIC(38,6) 19
11 INTEREST_INCOME_MTD_AUD NUMERIC(38,6) 19
12 INTEREST_INCOME_ACCRUED_AUD NUMERIC(38,6) 19
13 INTEREST_EXPENSE_DAILY_AUD NUMERIC(38,6) 19
14 INTEREST_EXPENSE_MTD_AUD NUMERIC(38,6) 19
15 INTEREST_EXPENSE_ACCRUED_AUD NUMERIC(38,6) 19
16 ORIGINAL_INTEREST_INCOME_DAILY NUMERIC(38,14) 19
17 ORIGINAL_INTEREST_EXPENSE_DAILY NUMERIC(38,14) 19
18 CURRENT_BALANCE NUMERIC(38,4) 19
19 ORIGINAL_BALANCE NUMERIC(38,4) 19
20 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9