FCT_HOG_EFS_BKAISA_DETAILED_MANUADJ_EOM_INSIGHT

Database

INSNZP02_BANK

Schema

BANKPADM

Type

VIEW

Description

 

Columns
# Name Data Type Length
1 PERIOD_DIM_ID CHARACTER VARYING(10) 10
2 OF_PRINCIPAL_PRODUCT_CODE CHARACTER VARYING(10) 10
3 OF_PRINCIPAL_ACCOUNT_CODE INTEGER 4
4 ACCOUNT_NUMBER CHARACTER VARYING(30) 30
5 SOURCE_SYSTEM CHARACTER VARYING(5) 5
6 SESCA_EFS_PARTY_DIM_ID CHARACTER VARYING(60) 60
7 ORGANISATION_NAME CHARACTER VARYING(1014) 1014
8 ONESUMX_CPTY_TYPE NATIONAL CHARACTER VARYING(250) 250
9 BALANCE NUMERIC(38,2) 19
10 DEPOSIT_OR_OVERDRAFT_IND CHARACTER VARYING(9) 9
11 PIT_INTERESTRATE DOUBLE PRECISION 8
12 INTEREST_RATE_TYPE CHARACTER VARYING(20) 20
13 COUNTERPARTY_SUMMARISED CHARACTER VARYING(10) 10
14 COST_OF_FUNDS NUMERIC(38,6) 19