FCT_OPC_EFS_OPTION_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 BALANCE_SHEET_INDICATOR CHARACTER VARYING(9) 9
7 CURRENT_BALANCE NUMERIC(38,13) 19
8 ORIGINAL_TABLE CHARACTER VARYING(7) 7
9 CURRENCY_CODE CHARACTER VARYING(3) 3
10 ORIGINAL_CURRENCY_CODE CHARACTER VARYING(3) 3
11 ORIGINAL_BALANCE NUMERIC(21,4) 19
12 CONVERSION_RATE NUMERIC(18,8) 19