Transformation Scheme ID
V_LN_CRDT_FCLTS_INSTRMNT
Description
Validates referential integrity of credit facilities-instruments to loans
Classification
Phase | Type | Subtype | Related entity |
---|---|---|---|
Preparation | Validation | Integrity | LN |
Natural language
Validates if:– for every Instrument unique identifier for which Type of transaction is Loan/Deposit (1)in cube Credit facilities-Instruments– there is a corresponding Instrument unique identifierin cube Loan
Scheme dependencies:
VTL Syntax
0 | CRDT_FCLTS_INSTRMNTS_FLTRD := CRDT_FCLTS_INSTRMNTS [filter (TYP_TRNSCTN = "1"), keep (INSTRMNT_UNQ_ID)]; |
1 | call PRCDR_RFRNTL_INTGRTY (CRDT_FCLTS_INSTRMNTS_FLTRD, INSTRMNT_UNQ_ID, LN, INSTRMNT_UNQ_ID, V_LN_CRDT_FCLTS_INSTRMNT); |