8.5 Instrument Transactions Summary
This category consists of connectors that aggregate or summarize transactions across various financial instruments. These are typically used to generate reports or provide analytics for tracking volumes, flows, or positions.
There are four entities mapped under this category:
- Stage Liability Transactions Summary
- Stage Off Balance Sheet Transaction Summary
- Stage Fee-Based Transaction Summary
- Stage Asset Transaction Summary
For all these entities, the key attributes marked as primary keys (PKs) are:
- As of Date
- Account or Contract Number
- Common Chart of Account Code
- General Ledger Account Code
- ISO Currency Code
- Legal Entity Code
- Organization Unit Code
- Product Code
The execution parameters to be passed include:
- Input File Name
- Load Identifier
- Data File Specifications ID
Table 8-6 List of connectors in this category is listed below:
| # | Connector Name | Primary Source | Target | # of fields | # of key fields | # of Direct Mapping | # of variable mapping |
|---|---|---|---|---|---|---|---|
| 1 | Instruments Transactions Summary | Stage Liability Transactions Summary | Stage Account Cost Summary | 15 | 8 | 4 | 3 |
| 2 | Instruments Transactions Summary | Stage Off Balance sheet Transaction Summary | Stage Account Cost Summary | 15 | 8 | 4 | 3 |
| 3 | Instruments Transactions Summary | Stage Fee Based Transaction Summary | Stage Account Cost Summary | 15 | 8 | 4 | 3 |
| 4 | Instruments Transactions Summary | Stage Asset Transaction Summary | Stage Account Cost Summary | 15 | 8 | 4 | 3 |