Table 274 "Bank Acc. Reconciliation Line"
Base Application · Microsoft.Bank.Reconciliation
Across versions
- BC23present
- BC242 events removed, 1 fields changed
- BC253 events added
- BC261 fields removed
- BC272 events added
- BC2821 fields changed
- BC29-30unchanged
Neighbourhood 42 connected objects and pages
Base Application · Microsoft.Bank.Reconciliation · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 1290 “Payment Reconciliation Journal” (9 Learn pages), Page 1287 “Payment Application Review” (6), Page 1291 “Pmt. Recon. Journal Overview” (1).
Properties
| Property | Value |
|---|---|
| Caption | Bank Acc. Reconciliation Line |
| DataClassification | CustomerContent |
| Permissions | TableData “Data Exch. Field” = rimd |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Bank Account No. | Code[20] | — | TableRelation Table 270 “Bank Account” (Bank Account) |
| 2 | Statement No. | Code[20] | — | TableRelation Table 273 “Bank Acc. Reconciliation” (“Bank Acc. Reconciliation”.“Statement No.” where(“Bank Account No.” = field(“Bank Account No.”))) |
| 3 | Statement Line No. | Integer | — | |
| 4 | Document No. Δ BC28 | Code[20] | Specifies a number of your choice that will appear on the reconciliation line. | |
| 5 | Transaction Date Δ BC28 | Date | Specifies the posting date of the bank account or check ledger entry on the reconciliation line when the Suggest Lines function is used. | |
| 6 | Description Δ BC28 | Text[100] | Specifies a description for the transaction on the reconciliation line. | |
| 7 | Statement Amount Δ BC28 | Decimal | Specifies the amount that was paid into the bank account and then imported as a bank statement line represented by the journal line. | |
| 8 | Difference Δ BC28 | Decimal | Specifies the difference between the amount in the Statement Amount field and the amount in the Applied Amount field. | |
| 9 | Applied Amount Δ BC28 | Decimal | Specifies the amount of the transaction on the reconciliation line that has been applied to a bank account or check ledger entry. | not editable |
| 11 | Applied Entries Δ BC28 | Integer | Specifies whether the transaction on the bank’s statement has been applied to one or more bank account or check ledger entries. | not editable |
| 12 | Value Date Δ BC28 | Date | Specifies the value date of the transaction on the bank reconciliation line. | |
| 13 | Ready for Application | Boolean | — | |
| 14 | Check No. Δ BC28 | Code[20] | Specifies the check number for the transaction on the reconciliation line. | |
| 15 | Related-Party Name Δ BC28 | Text[250] | Specifies the name of the customer or vendor who made the payment that is represented by the journal line. | |
| 16 | Additional Transaction Info Δ BC28 | Text[100] | Specifies additional information on the bank statement line for the payment. | |
| 17 | Data Exch. Entry No. | Integer | — | TableRelation Table 1220 “Data Exch.” (Data Exch.); not editable |
| 18 | Data Exch. Line No. | Integer | — | not editable |
| 20 | Statement Type | Enum “Bank Acc. Rec. Stmt. Type” | — | enum Enum 1254 “Bank Acc. Rec. Stmt. Type” |
| 21 | Account Type Δ BC28 | Enum “Gen. Journal Account Type” | Specifies the type of account that the payment application will be posted to when you post the payment reconciliation journal. | enum Enum 81 “Gen. Journal Account Type” |
| 22 | Account No. Δ BC28 | Code[20] | Specifies the account number that the payment application will be posted to when you post the payment reconciliation journal. | TableRelation Table 15 “G/L Account”, Table 18 “Customer”, Table 23 “Vendor” (if (“Account Type” = const(“G/L Account”)) “G/L Account” where(“Account Type” = const(Posting), Blocked = const(false)) else if (“Account Type” = const(Customer)) Customer else if (“Account Type” = const(Vendor)) Vendor else if (“Account Type” = const(“Bank Account”)) “Bank Account” else if (“Accoun…) |
| 23 | Transaction Text Δ BC28 | Text[140] | Specifies the text that the customer or vendor entered on that payment transaction that is represented by the journal line. | |
| 24 | Related-Party Bank Acc. No. Δ BC28 | Text[100] | Specifies the bank account number of the customer or vendor who made the payment. | |
| 25 | Related-Party Address Δ BC28 | Text[100] | Specifies the address of the customer or vendor who made the payment that is represented by the journal line. | |
| 26 | Related-Party City Δ BC28 | Text[50] | Specifies the city name of the customer or vendor. | |
| 27 | Payment Reference No. | Code[50] | Payment Reference caption | |
| 31 | Shortcut Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up on the General Ledger Setup page. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 32 | Shortcut Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up om the General Ledger Setup page. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 50 | Match Confidence Δ BC28 | Enum “Bank Rec. Match Confidence” | Specifies the quality of the automatic payment application on the journal line. | FlowField: max(“Applied Payment Entry”.“Match Confidence” where(“Statement Type” = field(“Statement Type”), “Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Statement Line No.” = field(“Statement Line No.”))); enum Enum 1252 “Bank Rec. Match Confidence”; not editable |
| 51 | Match Quality | Integer | — | FlowField: max(“Applied Payment Entry”.Quality where(“Bank Account No.” = field(“Bank Account No.”), “Statement No.” = field(“Statement No.”), “Statement Line No.” = field(“Statement Line No.”), “Statement Type” = field(“Statement Type”))); not editable |
| 60 | Sorting Order | Integer | — | |
| 61 | Parent Line No. | Integer | — | not editable |
| 70 | Transaction ID Δ BC28 | Text[50] | Specifies the ID of the imported bank transaction. | |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
Keys
- Key1: Statement Type, Bank Account No., Statement No., Statement Line No. (clustered)
- Key2: Account Type, Statement Amount
Events published
OnAfterInitDefaultDimensionSources(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)OnAfterSetUpNewLine(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; xBankAccReconciliationLine: Record "Bank Acc. Reconciliation Line")(integration)OnAfterShowDimensions(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line")(integration)OnAfterCreateDim(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)OnAfterFilterBankRecLines(var Rec: Record "Bank Acc. Reconciliation Line"; BankAccRecon: Record "Bank Acc. Reconciliation")(integration)OnAfterGetAccountName(AccountType: Option; AccountNo: Code[20]; var Name: Text)(integration)OnAfterGetAppliedEntryAccountNo(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; AppliedToEntryNo: Integer; var AccountNo: Code[20])(integration)OnAfterOpenAccountPage(AccountType: Option; AccountNo: Code[20])(integration)OnAfterRemoveAppliedPaymentEntries(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line")(integration)OnAfterDrillDownOnNoOfLedgerEntriesBasedOnAmount(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; AmountFilter: Text)(integration)OnAfterValidateShortcutDimCode(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var xBankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnBeforeOnModify(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var IsHandled: Boolean)(integration)OnBeforeValidateShortcutDimCode(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var xBankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnDisplayApplicationOnAfterBankAccLedgEntrySetFilters(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var BankAccLedgEntry: Record "Bank Account Ledger Entry")(integration)OnBeforeIsTransactionPostedAndReconciled(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var ReturnValue: Boolean; var IsHandled: Boolean)+ BC24 (integration)OnDisplayApplicationOnAfterSetBankAccReconcLine(var PaymentApplication: Page "Payment Application")(integration)OnRemoveApplicationOnAfterBankAccLedgEntrySetFilters(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var BankAccLedgEntry: Record "Bank Account Ledger Entry")(integration)OnBeforeGetStyle(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var Result: text; var IsHandled: Boolean)(integration)OnBeforeGetCustomerLedgerEntriesInAmountRange(BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var CustLedgerEntry: Record "Cust. Ledger Entry"; AccountNo: Code[20]; AmountFilter: Text; MinAmount: Decimal; MaxAmount: Decimal; var Result: Integer; var IsHandled: Boolean)+ BC25 (integration)OnBeforeGetVendorLedgerEntriesInAmountRange(BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var VendorLedgerEntry: Record "Vendor Ledger Entry"; AccountNo: Code[20]; AmountFilter: Text; MinAmount: Decimal; MaxAmount: Decimal; var Result: Integer; var IsHandled: Boolean)+ BC25 (integration)OnBeforeShowDimensions(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; var IsHandled: Boolean)+ BC25 (integration)OnGetAppliedPmtDataOnAfterLoopIteration(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; AppliedPmtEntry: Record "Applied Payment Entry")+ BC27 (integration)OnAfterTransferFromPostedPaymentReconLine(var BankAccReconciliationLine: Record "Bank Acc. Reconciliation Line"; PostedPaymentReconLine: Record "Posted Payment Recon. Line")+ BC27 (integration)
Procedures
GetPaymentRecJournalTelemetryFeatureName(): Text(internal)DisplayApplication(): Opens the payment application interface to display and manage applications for this reconciliation line. For bank reconciliation, shows bank account ledger entries; for payment application, shows detailed payment applications. Provides interactive interface for reviewing, modifying, or removing paym…TransferFromPostedPaymentReconLine(PostedPaymentReconLine: Record "Posted Payment Recon. Line")GetPaymentFile(var DataExchField: Record "Data Exch. Field"): BooleanGetCurrencyCode(): Code[10]: Retrieves the currency code associated with the bank account for this reconciliation line. Optimizes performance by caching the bank account record when possible.GetStyle(): TextClearDataExchEntries(): Clears data exchange entries and related import data for this reconciliation line. Removes data exchange field records and updates related reconciliation lines that share the same data exchange entry. Used during cleanup operations when removing or modifying imported statement data.ShowDimensions()CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])SetUpNewLine()ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])AcceptAppliedPaymentEntriesSelectedLines()RejectAppliedPaymentEntriesSelectedLines()RejectAppliedPayment()AcceptApplication()FilterManyToOneMatches(var BankAccRecMatchBuffer: Record "Bank Acc. Rec. Match Buffer")RemoveApplication()Δ BC24 (protected)SetManualApplication()GetAppliedEntryAccountName(AppliedToEntryNo: Integer): TextGetAppliedToName(): TextGetAppliedEntryAccountType(AppliedToEntryNo: Integer): IntegerGetAppliedToAccountType(): IntegerGetAppliedEntryAccountNo(AppliedToEntryNo: Integer): Code[20]GetAppliedToAccountNo(): Code[20]AppliedEntryAccountDrillDown(AppliedEntryNo: Integer)AppliedToDrillDown()OpenAccountPage(AccountType: Option; AccountNo: Code[20])DrillDownOnNoOfLedgerEntriesWithinAmountTolerance()DrillDownOnNoOfLedgerEntriesOutsideOfAmountTolerance()FilterBankRecLinesByDate(BankAccReconciliation: Record "Bank Acc. Reconciliation"; Overwrite: Boolean)FilterBankRecLines(BankAccReconciliation: Record "Bank Acc. Reconciliation"; Overwrite: Boolean)FilterBankRecLines(BankAccReconciliation: Record "Bank Acc. Reconciliation")LinesExist(BankAccRecon: Record "Bank Acc. Reconciliation"): BooleanGetAppliedToDocumentNo(SeparatorTxt: Text): TextGetAppliedToDocumentNo(): TextGetAppliedToEntryNo(): TextGetAppliedToEntryFilter(): TextShowAppliedToEntries()TransferRemainingAmountToAccount()GetStatusText(): TextGetAmountRangeForTolerance(var MinAmount: Decimal; var MaxAmount: Decimal)GetAppliedPmtData(var AppliedPmtEntry: Record "Applied Payment Entry"; var RemainingAmountAfterPosting: Decimal; var DifferenceStatementAmtToApplEntryAmount: Decimal; PmtAppliedToTxt: Text)GetAppliedPmtData(var AppliedPmtEntry: Record "Applied Payment Entry"; PmtAppliedToTxt: Text)IsTransactionPostedAndReconciled(): BooleanCanImport(): BooleanBankStatementLinesListIsEmpty(StatementNo: Code[20]; StatementType: Option; BankAccountNo: Code[20]): BooleanGetAppliesToIDForBankStatement(): Code[50](internal)GetAppliesToID(): Code[50]GetDescription(): Text[100]GetMatchedAutomaticallyFilter(): TextCreateDimFromDefaultDim()
Plus 20 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- Data Exch. Entry No.: TableRelation Table 1220 “Data Exch.”
- Match Confidence: CalcFormula Table 1294 “Applied Payment Entry”
- Match Quality: CalcFormula Table 1294 “Applied Payment Entry”
- Account No.: TableRelation Table 15 “G/L Account” (conditional)
- Account No.: TableRelation Table 18 “Customer” (conditional)
- Account No.: TableRelation Table 23 “Vendor” (conditional)
- Account No.: TableRelation Table 270 “Bank Account” (conditional)
- Bank Account No.: TableRelation Table 270 “Bank Account”
- Statement No.: TableRelation Table 273 “Bank Acc. Reconciliation”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
Referenced by
12 fields in 3 objects relate to this table (TableRelation or CalcFormula).
- Table 273 “Bank Acc. Reconciliation”: Total Applied Amount, Total Difference, Total Negative Adjustments, Total Paid Amount, Total Positive Adjustments, Total Received Amount, Total Transaction Amount, Total Unposted Applied Amount
- Table 271 “Bank Account Ledger Entry”: Statement Line No., Statement No.
- Table 272 “Check Ledger Entry”: Statement Line No., Statement No.
Pages and codeunits on this table
- Page 1286 “Payment Rec Match Details” (source table)
- Page 1287 “Payment Application Review” (source table)
- Page 1290 “Payment Reconciliation Journal” (source table)
- Page 1291 “Pmt. Recon. Journal Overview” (source table)
- Page 380 “Bank Acc. Reconciliation Lines” (source table)
- Page 412 “Bank Rec. Line Match Details” (source table)
- Codeunit 1248 “Process Bank Acc. Rec Lines” (codeunit runs on it)
- Codeunit 1255 “Match Bank Payments” (codeunit runs on it)
- Codeunit 1261 “Imp. SEPA CAMT Bank Rec. Lines” (codeunit runs on it)
- Codeunit 20126 “AMC Bank Process Statement” (codeunit runs on it)
- Codeunit 20127 “AMC Bank Imp.-Pre-Process” (codeunit runs on it)
- Codeunit 20128 “AMC Bank Imp.-Post-Process” (codeunit runs on it)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 408 “DimensionManagement” (8 calls:
CreateDim → GetRecDefaultDimID,CreateDim → UpdateGlobalDimFromDimSetID,InitDefaultDimensionSources → AddDimSource, …) - Codeunit 375 “Bank Acc. Entry Set Recon.-No.” (1 call:
RemoveApplication → RemoveReconNo) - Page 17 “G/L Account Card” (1 call:
OpenAccountPage → (object)) - Page 21 “Customer Card” (1 call:
OpenAccountPage → (object)) - Page 25 “Customer Ledger Entries” (1 call:
DrillDownOnNoOfLedgerEntriesBasedOnAmount → (object)) - Page 26 “Vendor Card” (1 call:
OpenAccountPage → (object)) - Page 29 “Vendor Ledger Entries” (1 call:
DrillDownOnNoOfLedgerEntriesBasedOnAmount → (object)) - Page 370 “Bank Account Card” (1 call:
OpenAccountPage → (object)) - Page 372 “Bank Account Ledger Entries” (1 call:
DrillDownOnNoOfLedgerEntriesBasedOnAmount → (object))
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Bank Acc. Reconciliation Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.