Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

You can use a Cash Recon panel to submit events to match cash activity. You can select various options based on the business requirements for your cash activity reconciliation. See the Match Cash Activity page for details about using these panels.

The following are the key options when using the Cash Recon Event panel.

OptionTagDescription

Run Cash Matching Process



Tables Option989

Displays the location of the cash activity records for reconciliation.
Options include:

  • Warehouse. Specifies the reconciliation of warehouse records to warehouse records. This is the default option.
  • Traded. Specifies the reconciliation of ESTAR traded cash activity to warehouse records.
  • Settled. Specifies the reconciliation of ESTAR settled cash activity to warehouse records.
  • Warehouse Security Level. Specifies the reconciliation of warehouse records to warehouse records at the security level.
  • Traded Security Level. Specifies the reconciliation of ESTAR traded cash activity to the warehouse records at the security level.
  • Settled Security Level. Specifies the reconciliation of ESTAR settled cash activity to the warehouse records at the security level.
Left Source1102Specifies the data source or source list to use for the left match.
Right Source1114Specifies the data source or source list to use for the right match.
Entity Name1164Specifies the name of the entity to match on ledger balances.
Entity ID / Composite ID1163Specifies the entity ID or composite entity ID to match on ledger balances.
Post Date30Specifies the post date, trade date, or settlement date to filter cash activity for the Tables Option you selected.
Tolerance Rule ID4256Specifies the tolerance rule with the filters to apply for cash activity reconciliation.
Unmatch Only List7090Indicates whether to store only unmatched or out of balance records to the Exception tables to conserve table space.
Transaction Status54Specifies whether to use only traded or settled records.
STAR Direct Flag List7050Indicates whether to consider only the cash activity records flagged by S2P.
Date Tolerance7250Specifies the number of days allowed for otherwise matching records to be considered matched.
Txn Amount Tolerance7660Specifies the amount allowed for base transaction amounts to differ and still constitute a cash match. Default is 0.25.
Txn Amount Local Tolerance7661Specifies the amount allowed for local transaction amounts to differ and still constitute a cash match. Default is 0.25.
Txn Units Tolerance 7662Specifies the amount allowed for transaction units to differ and still constitute a cash match. Default is 0.25.
User Float1 Tolerance1323Specifies the tolerance amount allowed for User Float1.
User Float2 Tolerance1324Specifies the tolerance amount allowed for User Float2.
User Float3 Tolerance1325Specifies the tolerance amount allowed for User Float3.
User Float4 Tolerance1326Specifies the tolerance amount allowed for User Float4.
User Float5 Tolerance1327Specifies the tolerance amount allowed for User Float5.
User Float6 Tolerance1328Specifies the tolerance amount allowed for User Float6.
User Char1 Tolerance Switch7051Indicates whether to reconcile for matching User Char1 values.
User Char2 Tolerance Switch7052Indicates whether to reconcile for matching User Char2 values.
User Char3 Tolerance Switch7053Indicates whether to reconcile for matching User Char3 values.
User Char4 Tolerance Switch7054Indicates whether to reconcile for matching User Char4 values.
User Char5 Tolerance Switch7055Indicates whether to reconcile for matching User Char5 values.
User Char6 Tolerance Switch7056Indicates whether to reconcile for matching User Char6 values.
  • No labels