Bank Statement Reconciliation Matching Rules

The Bank Statement Reconciliation Matching Rules view object contains reconciliation matching rules that are used during automatic reconciliation. Each rule determines how the bank statement lines and system transactions are automatically matched.

Data store key : FscmTopModelAM.FinExtractAM.CeBiccExtractAM.ReconMatchingRuleExtractPVO

Primary Keys : ReconMatchingRuleReconMatchingRuleId

Initial Extract Date : ReconMatchingRuleCreationDate

Incremental Extract Date : ReconMatchingRuleLastUpdateDate

Attributes

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

Name	Description
ReconMatchingRuleActiveFlag	Indicates whether the reconciliation matching rule is active. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleAmountMatchFlag	Indicates whether the reconciliation matching rule should match on amount. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleApSourceFlag	Indicates whether the reconciliation matching rule is used to reconcile payables transactions. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleArSourceFlag	Indicates whether the reconciliation matching rule is used to reconcile receivables transactions. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleCreatedBy	The user who created the reconciliation matching rule.
ReconMatchingRuleCreationDate	The date and time when the reconciliation matching rule was created.
ReconMatchingRuleDateMatchFlag	Indicates whether the reconciliation matching rule should match on date. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleDescription	The description of the reconciliation matching rule.
ReconMatchingRuleExtSourceFlag	Indicates whether the reconciliation matching rule is used to reconcile cash management external cash transactions. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleGlSourceFlag	Indicates whether the reconciliation matching rule is used to reconcile journal entry lines. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleJoinCondition	The join condition formed from the match criteria.
ReconMatchingRuleLastUpdateDate	The date and time when the reconciliation matching rule was last updated.
ReconMatchingRuleLastUpdateLogin	The session login associated with the user who last updated the reconciliation matching rule.
ReconMatchingRuleLastUpdatedBy	The user who last updated the reconciliation matching rule.
ReconMatchingRuleMatchType	The matching type of the reconciliation matching rule. A list of accepted values is defined in the lookup type CE_RECON_MATCH_TYPE.
ReconMatchingRuleMatchingRuleName	The name of the reconciliation matching rule.
ReconMatchingRuleObjectVersionNumber	The number of times the reconciliation matching rule row has been updated.
ReconMatchingRulePaySourceFlag	Indicates whether the reconciliation matching rule is used to reconcile payroll transactions. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleReconMatchingRuleId	The unique identifier of the reconciliation matching rule. This is the primary key of the Bank Statement Reconciliation Matching Rules view object.
ReconMatchingRuleReferenceIdMatchFlag	Indicates whether the reconciliation matching rule should match on reconciliation reference. A list of accepted values is defined in the lookup type YES_NO.
ReconMatchingRuleSeedDataSource	The source or the name of the predefined data file.
ReconMatchingRuleStmtGroupby	The group by clause on the bank statement line side. It is used in automatic reconciliation.
ReconMatchingRuleTrxGroupby	The group by clause on the system transaction side. It is used in automatic reconciliation.
ReconMatchingRuleTypeMatchFlag	Indicates whether the reconciliation matching rule should match on transaction type. A list of accepted values is defined in the lookup type YES_NO.