Good day,
I am working on a Limit Risk Reporting solution where I have transactions which contributes to limit values.
The limit links to a PARENT_CLIENT_ID and the clients are in a (child and or parent) hierarchy, i.e. All transactions from CLIENTS under a certain parent client will contribute to the limit.
My problem is that the CLIENT_ID is not always contained in the transaction table.
Based on the transaction type the CLIENT_ID is sometimes derived from the value in a PAYMENT INSTRUCTION table which links to a CASHFLOW, which in turn link to a TRANSACTION.
So how can one in essence compose this dynamic model ?
When loading data I also can not refer to the transaction type since it's not part of the payment instruction table, however even if linking the tables based on transaction type it will still lead to a circular model reference.
Kind regards
Edwin