Recon Event Panel Options
- Copy Page Tree (Unlicensed)
- Nancy Cohn (Deactivated)
- Former user (Deleted)
When you use Position Recon panels to submit events to match positions, ledger balances, and lots. You can select various event options based on the business requirements for your reconciliation. See the Match Positions, Ledger Balances and Lots page for details about using these panels.
Recon Positions Event Panel Options
The following are the key options when you match using the Recon Position Event panel.
Option | Tag | Description |
|---|---|---|
Pos Recon Process | ||
Event Type | 55 | Specifies the event used to reconcile positions. Default is RECON_POSITION2. |
Data Set Option | 989 | Specifies the location of the position records for reconciliation. Options include:
|
Left Source | 1102 | Specifies the data source or source list to use for the left match. |
Right Source | 1104 | Specifies the data source or source list to use for the right match. |
Effective Date | 1109 | Specifies the effective date of the records to 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. |
Active Status | 1283 | Specifies the entity status. Options include Active (default) and Both. |
Tolerance Rule ID | 4256 | Specifies the tolerance rule with the filters to apply for position reconciliation. |
Unmatch Only Flag List | 7050 | Indicates whether to store only unmatched and out of balance records to the Exception tables to conserve table space. Default is store all records. |
Match Nulls | 1018 | Indicates whether to reconcile to null values or flag as unmatched. |
Position Units by Percentage | 1019 | Indicates whether to use a percentage tolerance check. |
Position Units Tolerance | 963 | Specifies the tolerance amount allowed for Position Units. Default is 0.25. |
Original Face by Percentage | 1021 | Indicates whether to use a percentage tolerance check. |
Original Face Tolerance | 964 | Specifies the tolerance amount allowed for Original Face. Default is 0.25. |
Market Value by Percentage | 1023 | Indicates whether to use a percentage tolerance check. |
Market Value Tolerance | 965 | Specifies the tolerance amount allowed for Market Value. Default is 0.25. |
Cost by Percentage | 1025 | Indicates whether to use a percentage tolerance check. |
Cost Tolerance | 966 | Specifies the tolerance amount allowed for Cost. Default is 0.25. |
Book Value by Percentage | 1027 | Indicates whether to use a percentage tolerance check. |
Book Value Tolerance | 967 | Specifies the tolerance amount allowed for Book Value. Default is 0.25. |
Accruals by Percentage | 1029 | Â Indicates whether to use a percentage tolerance check. |
Accruals Tolerance | 968 | Specifies the tolerance amount allowed for Accruals. Default is 0.25. |
For warehouse to warehouse position matching, you can specify tolerances for these additional fields on the data warehouse: | ||
Book Value Base by Percentag | 1030 | Indicates whether to use a percentage tolerance check. |
Book Value Base Tolerance | 7661 | Specifies the tolerance amount allowed for Book Value Base. Default is 0.25. |
Market Value Base by Percentage | 1031 | Indicates whether to use a percentage tolerance check. |
Market Value Base Tolerance | 7662 | Specifies the tolerance amount allowed for Market Value Base. Default is 0.25. |
Accrued Income by Percentage | 1032 | Indicates whether to use a percentage tolerance check. |
Accrued Income Tolerance | 7663 | Specifies the tolerance amount allowed for Accrued Income. Default is 0.25. |
Notional Cost Base by Percentage | 1033 | Indicates whether to use a percentage tolerance check. |
Notional Cost Base Tolerance | 7664 | Specifies the tolerance amount allowed for Notional Cost Base. Default is 0.25. |
Unrealized GL Base by Percentage | 1034 | Indicates whether to use a percentage tolerance check. |
Unrealized GL Base Tolerance | 7665 | Specifies the tolerance amount allowed for Unrealized Gain/Loss Base. Default is 0.25. |
Unrealized GL by Percentage | 1035 | Indicates whether to use a percentage tolerance check. |
Unrealized GL Tolerance | 7666 | Specifies the tolerance amount allowed for Unrealized Gain/Loss. Default is 0.25. |
Dividend Receivable by Percentage | 1036 | Indicates whether to use a percentage tolerance check. |
Dividend Receivable Tolerance | 7667 | Specifies the tolerance amount allowed for Dividend Receivable. Default is 0.25. |
Dividend Receivable Base by Percentage | 1037 | Indicates whether to use a percentage tolerance check. |
Dividend Receivable Base Tolerance | 7668 | Specifies the tolerance amount allowed for Dividend Receivable Base. Default is 0.25. |
Reclaim Receivable Tolerance | 1038 | Indicates whether to use a percentage tolerance check. |
Reclaim Receivable Tolerance | 7669 | Specifies the tolerance amount allowed for Reclaim Receivable. Default is 0.25. |
Reclaim Receivable Base by Percentage | 1039 | Indicates whether to use a percentage tolerance check. |
Reclaim Receivable Base Tolerance | 7670 | Specifies the tolerance amount allowed for Reclaim Receivable Base. Default is 0.25. |
Settled Position by Percentage | 1040 | Indicates whether to apply a percentage instead of a difference as the tolerance check. |
Settled Position Tolerance | 7671 | Specifies the tolerance amount allowed for Settled Position. Default is 0.25. |
User Float21 Tolerance | 7676 | Indicates/specifies the tolerance amount allowed for User Float21. |
User Float22 Tolerance | 7677 | Indicates/specifies the tolerance amount allowed for User Float22. |
User Group1 Tolerance Switch | 7051 | Indicates whether to reconcile for matching User Group1 values. |
User Group2 Tolerance Switch | 7052 | Indicates whether to reconcile for matching User Group2 values. |
User Date1 Tolerance Switch | 7053 | Indicates whether to reconcile for matching User Date1 values. |
User Date2 Tolerance Switch | 7054 | Indicates whether to reconcile for matching User Date2 values. NOTE: For Portfolio Valuation to Warehouse position matching, you can only use Positions Units, Cost, and Unrealized Gain/Loss tolerances. |
Recon Ledger Event Panel Options
The following are the options when you match using the Recon Ledger Event panel.
Option | Tag | Description |
|---|---|---|
Event Type | 55 | Displays the event used to reconcile positions as LEDGER_RECON. |
Table Option | 989 | Specifies the location of the ledger balance records as Warehouse/Warehouse. |
Left Source ID | 7002 | Indicates whether a source ID or source list is used to locate the records for the left match. Default is Source ID. |
Left Source | 1102 | Specifies the source ID or source list to use for the left match. |
Left Source List | 373 | Specifies the source list to use for the left match. |
Right Source ID | 7004 | Indicates whether a source ID or source list is used to locate the records for the right match. Default is Source ID. |
Right Source | 1104 | Specifies the source ID or source list to use for the right match. |
Right Source List | 323 | Specifies the source list to use for the right match. |
Effective Date | 1109 | Specifies the effective date of the records to 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. |
Active Status | 1283 | Specifies the entity status. Options include Active (default) and Both. |
Match Nulls | 1018 | Indicates whether to reconcile to null values or flag as unmatched. |
Unmatch Only Flag List | 7050 | Indicates whether to store only unmatched and out of balance records to the Exception tables to conserve table space. Default is store all records. |
Roll Up Indicator List | 7060 | Indicates whether to roll up security level balances to the ledger account for reconciliation. |
Currency Flag List | 7179 | Â Indicates whether to reconcile local currency balances in addition to base currency balances. |
Tolerance Rule ID | 4256 | Specifies the tolerance rule with the filters to apply for ledger balance reconciliation. |
Ledger Balance by Percentage | 930 | Â Indicates whether to apply percentage tolerances. Default is No. |
Ledger Balance Tol | 922 | Specifies the tolerance amount to apply to ledger balance matches to determine in balance, in balance within tolerance, and out of balance match statuses. Default is 0.25. |
Recon Lots Event Panel Options
The following are the options when you match using the Recon Lots Event panel.