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

Version 1 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.

Run Cash Matching Process

  • Tables Option (tag 989). 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 Source (tag 1102). Specifies the data source or source list to use for the left match.
  • Right Source (tag 1114). Specifies the data source or source list to use for the right match.
  • Entity Name (tag 1164). Specifies the name of the entity to match on ledger balances.
  • Entity ID / Composite ID (tag 1163). Specifies the entity ID or composite entity ID to match on ledger balances.
  • Post Date (tag 30). Specifies the post date, trade date, or settlement date to filter cash activity for the Tables Option you selected.
  • Tolerance Rule ID (tag 4256). Specifies the tolerance rule with the filters to apply for cash activity reconciliation.
  • Unmatch Only List (tag 7090). Indicates whether to store only unmatched or out of balance records to the Exception tables to conserve table space.
  • Transaction Status (tag 54). Specifies whether to use only traded or settled records.
  • STAR Direct Flag List (tag 7050). Indicates whether to consider only the cash activity records flagged by S2P.
  • Date Tolerance (tag 7250). Specifies the number of days allowed for otherwise matching records to be considered matched.
  • Txn Amount Tolerance (tag 7660). Specifies the amount allowed for base transaction amounts to differ and still constitute a cash match. Default is 0.25.
  • Txn Amount Local Tolerance (tag 7661). Specifies the amount allowed for local transaction amounts to differ and still constitute a cash match. Default is 0.25.
  • Txn Units Tolerance (tag 7662). Specifies the amount allowed for transaction units to differ and still constitute a cash match. Default is 0.25.
  • User Float1 Tolerance (tag 1323). Specifies the tolerance amount allowed for User Float1.
  • User Float2 Tolerance (tag 1324). Specifies the tolerance amount allowed for User Float2.
  • User Float3 Tolerance (tag 1325). Specifies the tolerance amount allowed for User Float3.
  • User Float4 Tolerance (tag 1326). Specifies the tolerance amount allowed for User Float4.
  • User Float5 Tolerance (tag 1327). Specifies the tolerance amount allowed for User Float5.
  • User Float6 Tolerance (tag 1328). Specifies the tolerance amount allowed for User Float6.
  • User Char1 Tolerance Switch (tag 7051). Indicates whether to reconcile for matching User Char1 values.
  • User Char2 Tolerance Switch (tag 7052). Indicates whether to reconcile for matching User Char2 values.
  • User Char3 Tolerance Switch (tag 7053). Indicates whether to reconcile for matching User Char3 values.
  • User Char4 Tolerance Switch (tag 7054). Indicates whether to reconcile for matching User Char4 values.
  • User Char5 Tolerance Switch (tag 7055). Indicates whether to reconcile for matching User Char5 values.
  • User Char6 Tolerance Switch (tag 7056). Indicates whether to reconcile for matching User Char6 values.
  • No labels