Table "Bank Acc. Rec. Match Buffer"
Buffer table for managing many-to-one matching relationships in bank account reconciliation processes. This table temporarily stores matching combinations where multiple bank statement lines correspond to a single bank account ledger entry, enabling complex reconciliation scenarios such as split transactions, fees, and multi-line bank statement entries that relate to one ledger posting. Used during automatic matching to track and process these complex matching relationships.
Remarks
Key features include match ID grouping for related entries, processing status tracking, and integration with bank reconciliation matching algorithms. The table supports scenarios where bank statements contain multiple lines for charges, fees, or split amounts that should be matched against a single ledger entry. Enables sophisticated matching logic while maintaining clear audit trails and processing control.
Properties
| Name | Value |
|---|---|
| Caption | Bank Account Reconciliation Many-to-One Matchings |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Ledger Entry No." | Integer | Bank account ledger entry number being matched in many-to-one relationships. References the target ledger entry that multiple statement lines should match against. |
| "Statement No." | Code[20] | Statement number identifying the bank reconciliation session. Groups related matching entries under a single reconciliation process. |
| "Statement Line No." | Integer | Statement line number participating in the many-to-one match. Identifies specific bank statement lines that contribute to the complex match. |
| "Bank Account No." | Code[20] | Bank account number for the reconciliation process. Ensures matching relationships are contained within the correct bank account context. |
| "Match ID" | Integer | Unique identifier grouping related statement lines in many-to-one matches. Multiple buffer entries with the same Match ID represent lines that collectively match one ledger entry. |
| "Is Processed" | Boolean | Indicates whether this matching relationship has been processed and applied. Used to track completion status and prevent duplicate processing of match groups. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |