FCT_BNK_QRM_COLLATERAL_FACILITY_LKP_INSIGHT

Database

INSNZP05_BANK

Schema

BANKPADM

Type

VIEW

Description

Collateral Extract consumed by QRM, showing Collateral ID, facility ID & Charge ID

Columns
# Name Data Type Length
1 FACILITY_ID CHARACTER VARYING(40) 40
2 COLLATERAL_ID CHARACTER VARYING(18) 18
3 CHARGE_ID CHARACTER VARYING(18) 18
4 EXTERNAL_ACCOUNT_NUMBER CHARACTER VARYING(40) 40
5 EXTERNAL_ACCOUNT_SYSTEM CHARACTER VARYING(20) 20
6 EXTERNAL_ACCOUNT_STATUS CHARACTER VARYING(50) 50