Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Anchor
_Toc439930528
_Toc439930528
Run Cash Matching Process

...

OptionTagDescription
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 Source

...

1102

...

Specifies the data source or source list to use for the left match.
Right Source

...

1114

...

Specifies the data source or source list to use for the right match.
Entity Name

...

1164

...

Specifies the name of the entity to match on ledger balances.
Entity ID / Composite ID

...

1163

...

Specifies the entity ID or composite entity ID to match on ledger balances.
Post Date

...

30

...

Specifies 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 List

...

7090

...

Indicates whether to store only unmatched or out of balance records to the Exception tables to conserve table space.
Transaction Status

...

54

...

Specifies whether to use only traded or settled records.
STAR Direct Flag List

...

7050

...

Indicates whether to consider only the cash activity records flagged by S2P.
Date Tolerance

...

7250

...

Specifies the number of days allowed for otherwise matching records to be considered matched.
Txn Amount Tolerance

...

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

...

7661

...

Specifies the amount allowed for local transaction amounts to differ and still constitute a cash match. Default is 0.25.
Txn Units Tolerance

...

7662

...

Specifies the amount allowed for transaction units to differ and still constitute a cash match. Default is 0.25.
User Float1 Tolerance

...

1323

...

Specifies the tolerance amount allowed for User Float1.
User Float2 Tolerance

...

1324Specifies the tolerance amount allowed for User Float2.
User Float3 Tolerance

...

1325

...

Specifies the tolerance amount allowed for User Float3.
User Float4 Tolerance

...

1326Specifies the tolerance amount allowed for User Float4.
User Float5 Tolerance

...

1327

...

Specifies the tolerance amount allowed for User Float5.
User Float6 Tolerance

...

1328Specifies the tolerance amount allowed for User Float6.
User Char1 Tolerance Switch

...

7051

...

Indicates whether to reconcile for matching User Char1 values.
User Char2 Tolerance Switch

...

7052

...

Indicates whether to reconcile for matching User Char2 values.
User Char3 Tolerance Switch

...

7053

...

Indicates whether to reconcile for matching User Char3 values.
User Char4 Tolerance Switch

...

7054

...

Indicates whether to reconcile for matching User Char4 values.
User Char5 Tolerance Switch

...

7055

...

Indicates whether to reconcile for matching User Char5 values.
User Char6 Tolerance Switch

...

7056

...

Indicates whether to reconcile for matching User Char6 values.