| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
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. |
| Anchor | ||||
|---|---|---|---|---|
|
| Anchor | ||||
|---|---|---|---|---|
|
The following are the options when you match using the Recon Lots Event panel.
Option | Tag | Description | ||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Event Type | 55 | Displays the event used to reconcile positions as LOTS_RECON. | ||||||
Dataset Option | 989 | Specifies the location of the ledger balance records as Warehouse/Warehouse. | ||||||
Left Source ID / Source List | 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 Name | 1102 | Specifies the source ID to use for the left match. | ||||||
Left Source List | 373 | Specifies the source list to use for the left match. | ||||||
Right Source ID / Source List | 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 Name | 1104 | Specifies the source ID 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. | ||||||
Tolerance Rule ID | 4256 | Specifies the tolerance rule with the filter to apply for lot 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. | ||||||
Match Nulls | 1018 | Indicates whether to reconcile to null values or flag as unmatched. | ||||||
Matching by Orig Event ID | 7043 | Indicates whether to match lots by Original Event ID as an additional match key. Default is No. | ||||||
| ||||||||
Original Face by Percentage | 4064 | Indicates whether to use a percentage tolerance check. | ||||||
Original Face Tolerance | 8608 | Specifies the tolerance amount allowed for Original Face. Default is 0.25. | ||||||
Par of Shares by Percentage | 4065 | Indicates whether to use a percentage tolerance check. | ||||||
Par of Shares Tolerance | 8609 | Specifies the tolerance amount allowed for Par of Shares. Default is 0.25. | ||||||
Book Value by Percentage | 4066 | Indicates whether to use a percentage tolerance check. | ||||||
Book Value Tolerance | 8610 | Specifies the tolerance amount allowed for Book Value. Default is 0.25. | ||||||
Accrued Income by Percentage | 4067 | Indicates whether to use a percentage tolerance check. | ||||||
Accrued Income Tolerance | 8611 | Specifies the tolerance amount allowed for Accrued Income. Default is 0.25. | ||||||
Amort LTD Base by Percentage | 4068 | Indicates whether to use a percentage tolerance check. | ||||||
Amort LTD Base Tolerance | 8612 | Specifies the tolerance amount allowed for Amort LTD Base. Default is 0.25. | ||||||
Interest Sold Base by Percentage | 4069 | Indicates whether to use a percentage tolerance check. | ||||||
Interest Sold Base Tolerance | 8613 | Specifies the tolerance amount allowed for Interest Sold Base. Default is 0.25. | ||||||
Int Received by Percentage | 4070 | Indicates whether to use a percentage tolerance check. | ||||||
Int Received Tolerance | 8614 | Specifies the tolerance amount allowed for int_received. Default is 0.25. | ||||||
OID LTD Income by Percentage | 4071 | Indicates whether to use a percentage tolerance check. | ||||||
OID LTD Income Tolerance | 8615 | Specifies the tolerance amount allowed for oid_ltd_income. Default is 0.25. | ||||||
Market Value Income by Percentage | 4072 | Indicates whether to use a percentage tolerance check. | ||||||
Market Value Income Tolerance | 8616 | Specifies the tolerance amount allowed for market_value_income. Default is 0.25. | ||||||
Notional Cost by Percentage | 4073 | Indicates whether to use a percentage tolerance check. | ||||||
Notional Cost Tolerance | 8617 | Specifies the tolerance amount allowed for notional_cost. Default is 0.25. | ||||||
Mkt Value Base by Percentage | 4074 | Indicates whether to use a percentage tolerance check. | ||||||
Mkt Value Base Tolerance | 8618 | Specifies the tolerance amount allowed for mkt_value_base. Default is 0.25. | ||||||
Notional Market Value by Percentage | 4075 | Indicates whether to use a percentage tolerance check. | ||||||
Notional Market Value Tolerance | 8619 | Specifies the tolerance amount allowed for notional_market_value. Default is 0.25. | ||||||
TIP LTD Income by Percentage | 4076 | Indicates whether to use a percentage tolerance check. | ||||||
TIP LTD Income Tolerance | 8620 | Specifies the tolerance amount allowed for tip_ltd_income. Default is 0.25. | ||||||
Cls Amort Base by Percentage | 4077 | Indicates whether to use a percentage tolerance check. | ||||||
Cls Amort Base Tolerance | 8621 | Specifies the tolerance amount allowed for cls_amort_base. Default is 0.25. | ||||||
Cls OID Income by Percentage | 4078 | Indicates whether to use a percentage tolerance check. | ||||||
Cls OID Income Tolerance | 8622 | Specifies the tolerance amount allowed for cls_oid_income. Default is 0.25. | ||||||
Cls TIPs Income by Percentage | 4079 | Indicates whether to use a percentage tolerance check. | ||||||
Cls TIPs Income Tolerance | 8623 | Specifies the tolerance amount allowed for cls_tips_income. Default is 0.25. | ||||||
Accr LTD Base by Percentage | 4080 | Indicates whether to use a percentage tolerance check. | ||||||
Accr LTD Base Tolerance | 8624 | Specifies the tolerance amount allowed for accr_ltd_base. Default is 0.25. | ||||||
Amort PTD Base by Percentage | 4081 | Indicates whether to use a percentage tolerance check. | ||||||
Amort PTD Base Tolerance | 8625 | Specifies the tolerance amount allowed for amort_ptd_base. Default is 0.25. | ||||||
Credit Loss Base by Percentage | 4082 | Indicates whether to use a percentage tolerance check. | ||||||
Credit Loss Base Tolerance | 8626 | Specifies the tolerance amount allowed for credit_loss_base. Default is 0.25. | ||||||
Def Income Total PTD Base by Percentage | 4083 | Indicates whether to use a percentage tolerance check. | ||||||
Def Income Total PTD Base Tolerance | 8627 | Specifies the tolerance amount allowed for def_income_total_ptd_base. Default is 0.25. | ||||||
Impairment LTD Base by Percentage | 4084 | Indicates whether to use a percentage tolerance check. | ||||||
Impairment LTD Base Tolerance | 8628 | Specifies the tolerance amount allowed for impairment_ltd_base. Default is 0.25. | ||||||
Non Credit Loss Base by Percentage | 4085 | Indicates whether to use a percentage tolerance check. | ||||||
Non Credit Loss Base Tolerance | 8629 | Specifies the tolerance amount allowed for non_credit_loss_base. Default is 0.25. | ||||||
OID PTD Base by Percentage | 4086 | Indicates whether to use a percentage tolerance check. | ||||||
OID PTD Base Tolerance | 8630 | Specifies the tolerance amount allowed for oid_ptd_base. Default is 0.25. | ||||||
Orig Accr PTD by Percentage | 4087 | Indicates whether to use a percentage tolerance check. | ||||||
Orig Accr PTD Tolerance | 8631 | Specifies the tolerance amount allowed for orig_accr_ptd. Default is 0.25. | ||||||
Orig Sold Interest Base by Percentage | 4088 | Indicates whether to use a percentage tolerance check. | ||||||
Orig Sold Interest Base Tolerance | 8632 | Specifies the tolerance amount allowed for orig_sold_interest_base. Default is 0.25. | ||||||
Orig Traded Interest Base by Percentage | 4089 | Indicates whether to use a percentage tolerance check. | ||||||
Orig Traded Interest Base Tolerance | 8633 | Specifies the tolerance amount allowed for orig_traded_interest_base. Default is 0.25. | ||||||
Orig Acq Cost Base by Percentage | 4090 | Indicates whether to use a percentage tolerance check. | ||||||
Orig Acq Cost Base Tolerance | 8634 | Specifies the tolerance amount allowed for orig_acq_cost_base. Default is 0.25. | ||||||
TIPs PTD Base by Percentage | 4091 | Indicates whether to use a percentage tolerance check. | ||||||
TIPs PTD Base Tolerance | 8635 | Specifies the tolerance amount allowed for tips_ptd_base. Default is 0.25. | ||||||
Curr Ws Dis Loss Base by Percentage | 4092 | Indicates whether to use a percentage tolerance check. | ||||||
Curr Ws Dis Loss Base Tolerance | 8636 | Specifies the tolerance amount allowed for curr_ws_dis_loss_base. Default is 0.25. |
| Anchor | ||||
|---|---|---|---|---|
|