Transformation Scheme ID
V_CRDT_FCLTS_INSTRMNTS_ID1
Description
Validates that credit facilities are referred in the credit facilities instrument cube.
Classification
Phase | Type | Subtype | Related entity |
---|---|---|---|
Preparation | Validation | Integrity | CRDT_FCLTS |
Natural language
Validates if:– every Instrument unique identifierin cube Positive current accounts– is referred to by a Instrument unique identifier for which Type of transaction is Positive current account (5)in cube Credit facilities-Instruments
Scheme dependencies:
VTL Syntax
0 | CRDT_FCLTS_INSTRMNTS_FLTRD := CRDT_FCLTS_INSTRMNTS [filter (TYP_TRNSCTN = "5"), keep (INSTRMNT_UNQ_ID)]; |
1 | call PRCDR_RFRNTL_INTGRTY (PSTV_CRRNT_ACCNT, INSTRMNT_UNQ_ID, CRDT_FCLTS_INSTRMNTS_FLTRD, INSTRMNT_UNQ_ID, V_PSTV_CRRNT_ACCNT_CRDT_FCLTS_INSTRMNT_ID1); |