Validates if:

– for every [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip] for which [simple_tooltip content='TYP_TRNSCTN; It defines the type of transaction to which the transaction identifier refers.']Type of transaction[/simple_tooltip] is Loan/Deposit (1)
in cube [simple_tooltip content='CRDT_FCLTS_INSTRMNTS; It contains the relationships between credit facilities and instruments.']Credit facilities-Instruments[/simple_tooltip]
– there is a corresponding [simple_tooltip content='INSTRMNT_UNQ_ID; An identifier applied by the reporting agent to uniquely identify each instrument.']Instrument unique identifier[/simple_tooltip]
in cube [simple_tooltip content='LN']Loan[/simple_tooltip]

Scheme dependencies:

[simple_tooltip content='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 identifier
in cube Loan']V_LN_CRDT_FCLTS_INSTRMNT[/simple_tooltip]
[simple_tooltip content='Creates a single dataset comprising all cubes within the "Loans" entity']T_UNN_LN[/simple_tooltip]
[simple_tooltip content='Where, for Other trade receivables:

- Connected factoring operation identifier is by default null
- Project finance loan is by default Non-project finance loan (2)
- Repayment rights is by default Other (2)
- Subordinated debt is by default Non-subordinated debt (2)
- Type of instrument is Other trade receivables (1023)']D_IMPLCT_OTHR_TRD_RCVBLS[/simple_tooltip]
[simple_tooltip content='Get Other trade receivables data']T_GT_OTHR_TRD_RCVBLS[/simple_tooltip]
[simple_tooltip content='Where Indirect factoring cube is merged with associated records from Factoring cube, keeping:

- Accounting classification
- Contract identifier
- Observed agent internal identifier
- Prudential portfolio
- Is retail exposure
- Is serviced by the observed agent
and variables inherited from associated factoring records are added back to Indirect factoring

And for the new Indirect factoring:

- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Fiduciary instrument is by default Not applicable (0)
- Project finance loan is by default Non-project finance loan (2)
- Payment frequency is by default Bullet (4)
- Exposure with recourse is by default Not applicable (0)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Syndicated contract identifier is by default null
- Type of amortisation is by default Bullet (4)
- Type of instrument is Indirect Factoring (1021)']D_IMPLCT_INDRCT_FCTRNG[/simple_tooltip]
[simple_tooltip content='Get Indirect factoring data']T_GT_INDRCT_FCTRNG[/simple_tooltip]
[simple_tooltip content='Get Factoring data']T_GT_FCTRNG[/simple_tooltip]
[simple_tooltip content='Where, for Credit card debt: extended credit:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Syndicated contract identifier is by default null
- Type of instrument is Credit card debt extended credit (50)']D_IMPLCT_CRDT_CRD_DBT_EXTNDD_CRDT[/simple_tooltip]
[simple_tooltip content='Get Credit card debt: extended credit data']T_GT_CRDT_CRD_DBT_EXTNDD_CRDT[/simple_tooltip]
[simple_tooltip content='Where, for Other loans:

- Connected factoring operation identifier is by default null
- Repayment rights is by default Other (2)
- Type of instrument is Other loans (1022)']D_IMPLCT_OTHR_LNS[/simple_tooltip]
[simple_tooltip content='Get Other loans data']T_GT_OTHR_LNS[/simple_tooltip]
[simple_tooltip content='Where, for Other deposits:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Project finance loan is by default Non-project finance loan (2)
- if Is debt financing is TRUE (T), then Purpose is Debt financing (5)
else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)
- Is revolving loan is by default Not applicable (0)
- Syndicated contract identifier is by default null
- Type of instrument is Deposits other than reverse repurchase agreements (1000)
']D_IMPLCT_OTHR_DPSTS[/simple_tooltip]
[simple_tooltip content='Get Other deposits data']T_GT_OTHR_DPSTS[/simple_tooltip]
[simple_tooltip content='Where, for Factoring:

- Connected factoring operation identifier is by default null
- End date of the interest-only period is by default null
- Project finance loan is by default Non-project finance loan (2)
- Repayment rights is by default Other (2)
- Subordinated debt is by default Non-subordinated debt (2)
- Type of amortisation is by default Amortisation types other than French, German, Fixed amortisation schedule or bullet (5)
- Type of instrument is Factoring (1020)
']D_IMPLCT_FCTRNG[/simple_tooltip]
[simple_tooltip content='Where, for Transferable deposits:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Project finance loan is by default Non-project finance loan (2)
- if Is debt financing is TRUE (T), then Purpose is Debt financing (5)
else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)
- Repayment rights is by default On demand or short notice (1)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Syndicated contract identifier is by default null
- Type of amortisation is by default Amortisation types other than French, German, Fixed amortisation schedule or bullet (5)
- Type of instrument isTransferable deposits (1025)']D_IMPLCT_TRNSFRBL_DPSTS[/simple_tooltip]
[simple_tooltip content='Get Transferable deposits data']T_GT_TRNSFRBL_DPSTS[/simple_tooltip]
[simple_tooltip content='Where, for Overdrafts:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Repayment rights is by default On demand or short notice (1)
- Is revolving loan is by default Not applicable (0)
- Type of instrument is Overdrafts (20)']D_IMPLCT_OVRDRFTS[/simple_tooltip]
[simple_tooltip content='Get Overdrafts data']T_GT_OVRDRFTS[/simple_tooltip]
[simple_tooltip content='Where for Credit card debt: convenience credit:

- Interest rate is by default not applicable (0)
- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Next interest rate reset date is by default null
- Interest rate cap is by default null
- Interest rate floor is by default null
- Interest rate reset frequency is by default null
- Interest rate spread / margin is by default null
- if Is debt financing is TRUE (T), then Purpose is Debt financing (5)
else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)
- Payment frequency is by default Bullet (4)
- Reference rate is by default Not applicable (0)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Syndicated contract identifier is by default null
- Type of amortisation is by default Bullet (4)
- Type of interest rate is by default Not applicable (0)
- Type of instrument is Credit card debt convenience credit (40)']D_IMPLCT_CRDT_CRD_DBT_CNVNNC_CRDT[/simple_tooltip]
[simple_tooltip content='Get Credit card debt: convenience credit data']T_GT_CRDT_CRD_DBT_CNVNNC_CRDT[/simple_tooltip]
[simple_tooltip content='Where, for Reverse repurchase loans:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- End date of the interest-only period is by default null
- Project finance loan is by default Non-project finance loan (2)
- if Is debt financing is TRUE (T), then Purpose is Debt financing (5)
else Purposes other than real estate purchase, margin lending, debt financing, imports, exports, construction investment, working capital facility (11)
- Payment frequency is by default Bullet (4)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Type of amortisation is by default Bullet (4)
- Type of instrument is Reverse repurchase agreements (1003)']D_IMPLCT_RVRS_RPRCHS_LNS[/simple_tooltip]
[simple_tooltip content='Get Reverse repurchase loans data']T_GT_RVRS_RPRCHS_LNS[/simple_tooltip]
[simple_tooltip content='Where, for Financial leases:

- Connected factoring operation identifier is by default null
- Is credit line other than revolving credit is by default Not applicable (0)
- Repayment rights is by default Other (2)
- Is revolving loan is by default Not applicable (0)
- Subordinated debt is by default Non-subordinated debt (2)
- Type of instrument is Finance leases (80)']D_IMPLCT_FNNCL_LSS[/simple_tooltip]
[simple_tooltip content='Get Financial leases data']T_GT_FNNCL_LSS[/simple_tooltip]
[simple_tooltip content='Get Credit facilities-Instruments data']T_GT_CRDT_FCLTS_INSTRMNTS[/simple_tooltip]