Bank Statement Reconciliation Tolerance Rules

The Bank Statement Reconciliation Tolerance Rules view object contains amount and date tolerances that prevent or warn users when reconciliation would be a breach of a defined tolerance. The reconciliation tolerance rules are used during automatic and manual reconciliation.

Data store key : FscmTopModelAM.FinExtractAM.CeBiccExtractAM.ReconToleranceRuleExtractPVO

Primary Keys : ReconToleranceRuleReconToleranceRuleId

Initial Extract Date : ReconToleranceRuleCreationDate

Incremental Extract Date : ReconToleranceRuleLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
ReconToleranceRuleActiveFlag	Indicates whether the reconciliation tolerance rule is active. A list of accepted values is defined in the lookup type YES_NO.
ReconToleranceRuleAmountAbove	The amount tolerance above the statement line amount.
ReconToleranceRuleAmountBelow	The amount tolerance below the statement line amount.
ReconToleranceRuleAmountEnabledFlag	Indicates whether the reconciliation tolerance rule is enabled for amount tolerance. A list of accepted values is defined in the lookup type YES_NO.
ReconToleranceRuleCreatedBy	The user who created the reconciliation tolerance rule.
ReconToleranceRuleCreationDate	The date and time when the reconciliation tolerance rule was created.
ReconToleranceRuleDateEnabledFlag	Indicates whether the reconciliation tolerance rule is enabled for date tolerance. A list of accepted values is defined in the lookup type YES_NO.
ReconToleranceRuleDaysAfter	The number of days after the statement booking date that is used for the date tolerance.
ReconToleranceRuleDaysBefore	The number of days before the statement booking date that is used for the date tolerance.
ReconToleranceRuleDescription	The description of the reconciliation tolerance rule.
ReconToleranceRuleLastUpdateDate	The date and time when the reconciliation tolerance rule was last updated.
ReconToleranceRuleLastUpdateLogin	The session login associated with the user who last updated the reconciliation tolerance rule.
ReconToleranceRuleLastUpdatedBy	The user who last updated the reconciliation tolerance rule.
ReconToleranceRuleObjectVersionNumber	The number of times the reconciliation tolerance rule row has been updated.
ReconToleranceRulePercentAbove	The tolerance percentage above the statement line amount.
ReconToleranceRulePercentBelow	The tolerance percentage below the statement line amount.
ReconToleranceRuleReconToleranceRuleId	The unique identifier of the reconciliation tolerance rule. This is the primary key of the Bank Statement Reconciliation Tolerance Rules view object.
ReconToleranceRuleToleranceRuleName	The name of the reconciliation tolerance rule.
ReconToleranceRulesPercentEnabledFlag	Indicates whether the reconciliation tolerance rule is enabled for percent tolerance. A list of accepted values is defined in the lookup type YES_NO.