...
- Cash Event Type
- Cash Category
- Transaction Type
- Settlement Currency
...
| Note |
|---|
The arithmetic sign of the Data Set Option parameter indicates whether the system reconciles at the security level or the transaction level. |
The type of transaction date used in the match depends on the mode of comparison you choose for reconciling cash activity. The system selects cash activity records by:
...
You must decide on the mode of comparison for reconciling cash activity. There are several possible modes for matching records, depending on the combination of source and data location assumed for cash activity reconciliation. You must choose one combination for your overall reconciliation strategy and configure the MSGSERVICE.INI parameters for DataSetOption option. See the Configure the MSGSERVICE.INI Parameters section for additional information. The system uses positive values (such as 2, 3, and 4) to indicate that cash reconciliation occurs at the transaction level. And the system uses negative values (such as -2, -3, and -4) to indicate that cash reconciliation occurs at the security level.
| Note |
|---|
...
Eagle best practice is matching cash activity directly to warehouse tables or the ESTAR database, eliminating the prerequisite load of cash activity records to work tables. |
DataSetOptions include:
- DataSetOption = 1. Specifies the local to local custodian mode of comparison for reconciling the CUST_CASH_TXNS and CASH_TXNS tables in the MSGCENTER database.
- DataSetOption = 2 or -2. Specifies the data warehouse to data warehouse mode of comparison for reconciling different sources on the CASH_ACTIVITY table in the CASH database.
- DataSetOption = 3 or -3. Specifies the traded cash activity to data warehouse mode of comparison for reconciling the ESTAR_TRADED_CASH_ACTIVITY table in the ESTAR database to the CASH_ACTIVITY table in the CASH database.
- DataSetOption = 4 or -4. Specifies the settled cash activity to data warehouse mode of comparison for reconciling the ESTAR_SETTLED_CASH_ACTIVITY table in the ESTAR database to the CASH_ACTIVITY table in the CASH database.