FCT_OPC_EFS_NOSTRO_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(35) 35
3 SOURCE_SYSTEM_CODE CHARACTER VARYING(3) 3
4 ACCOUNT_NUMBER CHARACTER VARYING(35) 35
5 BALANCE_SHEET_INDICATOR CHARACTER VARYING(5) 5
6 CURRENT_BALANCE NUMERIC(38,6) 19
7 ACCRUED_INTEREST NUMERIC(15,6) 19
8 CURRENCY_CODE CHARACTER VARYING(3) 3
9 ORIGINAL_CURRENCY_CODE CHARACTER VARYING(3) 3
10 ORIGINAL_BALANCE NUMERIC(38,4) 19
11 CONVERSION_RATE NUMERIC(18,8) 19