Table 270 "Bank Account"

Base Application · Microsoft.Bank.BankAccount · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30051 “APIV2 - Bank Accounts” (5 Learn pages), Page 370 “Bank Account Card” (3), Page 371 “Bank Account List” (2), Page 375 “Bank Account Statistics” (1), Page 377 “Bank Account Balance” (1), Page 1233 “Positive Pay Export” (1).

Properties

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.

Keys

• Key1: No. (clustered)
• Key2: Search Name
• Key3: Bank Acc. Posting Group
• Key4: Currency Code
• Key5: Country/Region Code

Events published

• OnAfterIsUpdateNeeded(BankAccount: Record "Bank Account"; xBankAccount: Record "Bank Account"; var UpdateNeeded: Boolean) (integration): Integration event raised after determining if bank account update is needed. Enables custom logic for evaluating when bank account updates are required.
• OnAfterCopyBankFieldsFromCompanyInfo(var BankAccount: Record "Bank Account"; CompanyInformation: Record "Company Information") (integration): Integration event raised after copying bank-related fields from company information. Enables custom field mapping or additional processing during bank account initialization.
• OnAfterValidateShortcutDimCode(var BankAccount: Record "Bank Account"; var xBankAccount: Record "Bank Account"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration): Integration event raised after validating a shortcut dimension code for bank account. Enables custom processing or additional validation after dimension code validation.
• OnBeforeValidateIBAN(var BankAccount: Record "Bank Account"; var xBankAccount: Record "Bank Account"; var IsHandled: Boolean) (integration): Integration event raised before validating IBAN format and check digits. Enables custom IBAN validation logic or handling of special IBAN formats.
• OnBeforeValidateShortcutDimCode(var BankAccount: Record "Bank Account"; var xBankAccount: Record "Bank Account"; FieldNumber: Integer; var ShortcutDimCode: Code[20]) (integration): Integration event raised before validating a shortcut dimension code for bank account. Enables custom dimension validation logic or preprocessing before standard validation.
• OnCheckLinkedToStatementProviderEvent(var BankAccount: Record "Bank Account"; var IsLinked: Boolean) (integration): Integration event for checking if bank account is linked to a statement provider service. Enables bank statement provider integrations to indicate connection status.
• OnCheckAutoLogonPossibleEvent(var BankAccount: Record "Bank Account"; var AutoLogonPossible: Boolean) (integration): Integration event for checking if automatic logon is possible for the bank account. Enables bank statement provider integrations to indicate authentication capabilities.
• OnUnlinkStatementProviderEvent(var BankAccount: Record "Bank Account"; var Handled: Boolean) (integration): Integration event for unlinking bank account from statement provider service. Enables bank statement provider integrations to handle connection removal.
• OnMarkAccountLinkedEvent(var OnlineBankAccLink: Record "Online Bank Acc. Link"; var BankAccount: Record "Bank Account") (integration): Integration event for marking bank account as linked to statement provider service. Enables bank statement provider integrations to update linkage status.
• OnSimpleLinkStatementProviderEvent(var OnlineBankAccLink: Record "Online Bank Acc. Link"; var StatementProvider: Text) (integration): Integration event for simple linking of bank account to statement provider. Enables streamlined connection setup with basic provider information.
• OnLinkStatementProviderEvent(var BankAccount: Record "Bank Account"; var StatementProvider: Text) (integration): Integration event for linking bank account to statement provider service. Enables bank statement provider integrations to establish account connections.
• OnRefreshStatementProviderEvent(var BankAccount: Record "Bank Account"; var StatementProvider: Text) (integration): Integration event for refreshing bank account connection to statement provider. Enables renewal of authentication or data synchronization with provider services.
• OnGetDataExchangeDefinitionEvent(var DataExchDefCodeResponse: Code[20]; var Handled: Boolean) Δ BC24 (integration): Integration event for retrieving data exchange definition for online bank feeds. Enables dynamic configuration of data format for processing bank statement imports.
• OnUpdateBankAccountLinkingEvent(var BankAccount: Record "Bank Account"; var StatementProvider: Text) (integration): Integration event for updating bank account linking information. Enables maintenance of connection details between bank accounts and statement providers.
• OnGetStatementProvidersEvent(var TempNameValueBuffer: Record "Name/Value Buffer" temporary) (integration): Integration event for retrieving available statement provider services. Enables discovery of available bank statement provider integrations.
• OnDisableStatementProviderEvent(ProviderName: Text) (integration): Integration event for disabling a statement provider service. Enables deactivation or removal of statement provider integrations.
• OnRenewAccessConsentStatementProviderEvent(var BankAccount: Record "Bank Account"; var StatementProvider: Text) (integration): Integration event for renewing access consent for statement provider. Enables re-authorization workflow for open banking and similar integrations.
• OnEditAccountStatementProviderEvent(var BankAccount: Record "Bank Account"; var StatementProvider: Text) (integration): Integration event for editing online bank account information. Enables customization of bank account details editing interface.
• OnBeforeRunContactListPage(var Contact: Record Contact; var IsHandled: Boolean) (integration): Integration event raised before opening the contact list page. Enables custom contact list handling or alternative contact selection interface.
• OnValidateBankAccount(var BankAccount: Record "Bank Account"; FieldToValidate: Text) (integration): Integration event for validating bank account information. Enables custom validation logic for specific bank account fields or data.
• OnGetBankAccount(var Handled: Boolean; BankAccount: Record "Bank Account"; var ResultBankAccountNo: Text) (integration): Integration event for retrieving bank account information. Enables custom bank account lookup or data retrieval logic.
• OnBeforeValidateCity(var BankAccount: Record "Bank Account"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration): Integration event raised before validating city field on bank account. Enables custom city validation logic with postal code integration.
• OnBeforeValidatePostCode(var BankAccount: Record "Bank Account"; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration): Integration event raised before validating postal code field on bank account. Enables custom postal code validation logic with city integration.
• OnBeforeGetCreditTransferMessageNo(var CreditTransferMsgNo: Code[20]; var IsHandled: Boolean) (integration): Integration event raised before retrieving credit transfer message number. Enables custom logic for generating or determining credit transfer message identifiers.
• OnBeforeGetDirectDebitMessageNo(var DirectDebitMsgNo: Code[20]; var IsHandled: Boolean) (integration): Integration event raised before retrieving direct debit message number. Enables custom logic for generating or determining direct debit message identifiers.
• OnValidateCurrencyCodeOnBeforeTestBalanceFields(var BankAccount: Record "Bank Account") + BC25 (integration): Integration event raised during currency code validation before testing balance fields. Enables custom validation logic before standard balance field testing.
• OnBeforeGetBankExportImportSetup(var BankExportImportSetup: Record "Bank Export/Import Setup"; var IsHandled: Boolean) + BC26 (integration): Integration event raised before retrieving bank export/import setup configuration. Enables custom logic to override or supplement standard setup retrieval.
• OnBeforeIsInLocalCurrency(var Rec: Record "Bank Account"; var Result: Boolean; var IsHandled: Boolean) + BC26 (integration): Integration event raised before determining if bank account is in local currency. Enables custom logic for determining local currency status.

Procedures

• AssistEdit(OldBankAcc: Record "Bank Account"): Boolean: Provides interactive number series selection for bank account creation.
• ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20]): Validates and updates shortcut dimension codes with proper dimension validation.
• ShowContact(): Displays or creates contact information linked to this bank account. Creates new contact if none exists and user confirms creation.
• SetInsertFromContact(FromContact: Boolean): Sets flag indicating if bank account was created from contact information.
• CopyBankFieldsFromCompanyInfo(CompanyInformation: Record "Company Information"): Copies bank-related fields from company information to bank account.
• GetPaymentExportCodeunitID(): Integer: Retrieves the codeunit ID for payment export processing.
• GetPaymentExportXMLPortID(): Integer: Retrieves the XMLPort ID for payment export file generation.
• GetDDExportCodeunitID(): Integer: Retrieves the codeunit ID for direct debit export processing.
• GetDDExportXMLPortID(): Integer: Retrieves the XMLPort ID for direct debit export file generation.
• GetBankExportImportSetup(var BankExportImportSetup: Record "Bank Export/Import Setup"): Retrieves bank export/import setup configuration for payment processing.
• GetDDExportImportSetup(var BankExportImportSetup: Record "Bank Export/Import Setup"): Retrieves bank export/import setup configuration for direct debit processing.
• GetCreditTransferMessageNo(): Code[20]: Generates and returns the next credit transfer message number from the number series.
• GetDirectDebitMessageNo(): Code[20]: Generates and returns the next direct debit message number from the number series.
• GetDefaultBankAccountNoForCurrency(CurrencyCode: Code[20]): Code[20]: Finds the default bank account for a specific currency.
• DisplayMap(): Opens external map service to display bank account location.
• GetDataExchDef(var DataExchDef: Record "Data Exch. Def"): Retrieves data exchange definition for bank statement import processing.
• GetDataExchDefPaymentExport(var DataExchDef: Record "Data Exch. Def"): Retrieves data exchange definition for payment export processing.
• GetBankAccountNoWithCheck(): Text: Retrieves bank account number with validation, raising error if empty.
• GetBankAccountNo(): Text: Retrieves the primary bank account identifier (IBAN if available, otherwise bank account number).
• IsInLocalCurrency(): Boolean: Determines if the bank account uses the local currency.
• GetPosPayExportCodeunitID(): Integer: Retrieves the codeunit ID for positive pay export processing.
• IsLinkedToBankStatementServiceProvider(): Boolean: Checks if bank account is linked to an external bank statement service provider.
• StatementProvidersExist(): Boolean: Checks if any bank statement service providers are available in the system.
• LinkStatementProvider(var BankAccount: Record "Bank Account"): Links bank account to an external bank statement service provider.
• SimpleLinkStatementProvider(var OnlineBankAccLink: Record "Online Bank Acc. Link"): Links online bank account to statement service provider with minimal setup.
• UnlinkStatementProvider(): Removes the link between bank account and external statement service provider.
• RefreshStatementProvider(var BankAccount: Record "Bank Account"): Refreshes the connection to external bank statement service provider.
• RenewAccessConsentStatementProvider(var BankAccount: Record "Bank Account"): Renews access consent for external bank statement service provider.
• EditAccountStatementProvider(var BankAccount: Record "Bank Account"): Opens edit interface for external bank statement service provider account settings.
• UpdateBankAccountLinking(): Updates bank account linking configuration with statement service provider.
• GetUnlinkedBankAccounts(var TempUnlinkedBankAccount: Record "Bank Account" temporary): Retrieves all bank accounts that are not linked to external statement service providers.
• GetLinkedBankAccounts(var TempUnlinkedBankAccount: Record "Bank Account" temporary): Retrieves all bank accounts that are linked to external statement service providers.
• IsAutoLogonPossible(): Boolean: Checks if automatic logon is possible for external bank statement service provider.
• CreateNewAccount(OnlineBankAccLink: Record "Online Bank Acc. Link"): Creates new bank account from online bank account link information.
• GetOnlineFeedStatementStatus(var OnlineFeedStatus: Option; var Linked: Boolean): Retrieves online feed statement status and linking information for bank account.
• DisableStatementProviders(): Disables all available bank statement service providers.

Plus 10 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

• drill-down page Page 371 “Bank Account List”
• lookup page Page 371 “Bank Account List”
• Bank Statement Import Format: TableRelation Table 1200 “Bank Export/Import Setup”
• Payment Export Format: TableRelation Table 1200 “Bank Export/Import Setup”
• Positive Pay Export Code: TableRelation Table 1200 “Bank Export/Import Setup”
• SEPA Direct Debit Exp. Format: TableRelation Table 1200 “Bank Export/Import Setup”
• SWIFT Code: TableRelation Table 1210 “SWIFT Code”
• Bank Clearing Standard: TableRelation Table 1280 “Bank Clearing Standard”
• Our Contact Code: TableRelation Table 13 “Salesperson/Purchaser”
• City: TableRelation Table 225 “Post Code” (conditional)
• Post Code: TableRelation Table 225 “Post Code” (conditional)
• Balance: CalcFormula Table 271 “Bank Account Ledger Entry”
• Balance (LCY): CalcFormula Table 271 “Bank Account Ledger Entry”
• Balance at Date: CalcFormula Table 271 “Bank Account Ledger Entry”
• Balance at Date (LCY): CalcFormula Table 271 “Bank Account Ledger Entry”
• Credit Amount: CalcFormula Table 271 “Bank Account Ledger Entry”
• Credit Amount (LCY): CalcFormula Table 271 “Bank Account Ledger Entry”
• Debit Amount: CalcFormula Table 271 “Bank Account Ledger Entry”
• Debit Amount (LCY): CalcFormula Table 271 “Bank Account Ledger Entry”
• Net Change: CalcFormula Table 271 “Bank Account Ledger Entry”
• Net Change (LCY): CalcFormula Table 271 “Bank Account Ledger Entry”
• Total on Checks: CalcFormula Table 272 “Check Ledger Entry”
• Bank Acc. Posting Group: TableRelation Table 277 “Bank Account Posting Group”
• Territory Code: TableRelation Table 286 “Territory”
• Credit Transfer Msg. Nos.: TableRelation Table 308 “No. Series”
• Direct Debit Msg. Nos.: TableRelation Table 308 “No. Series”
• No. Series: TableRelation Table 308 “No. Series”
• Pmt. Rec. No. Series: TableRelation Table 308 “No. Series”
• Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
• Currency Code: TableRelation Table 4 “Currency”
• Language Code: TableRelation Table 8 “Language”
• Country/Region Code: TableRelation Table 9 “Country/Region”
• Comment: CalcFormula Table 97 “Comment Line”

Referenced by

101 fields in 73 objects relate to this table (TableRelation or CalcFormula).

• Table 751 “Standard General Journal Line”: Account No., Bal. Account No., Source No.
• Table 110 “Sales Shipment Header”: Bal. Account No., Company Bank Account Code
• Table 112 “Sales Invoice Header”: Bal. Account No., Company Bank Account Code
• Table 114 “Sales Cr.Memo Header”: Bal. Account No., Company Bank Account Code
• Table 1205 “Credit Transfer Register”: From Bank Account Name, From Bank Account No.
• Table 1207 “Direct Debit Collection”: To Bank Account Name, To Bank Account No.
• Table 1293 “Payment Application Proposal”: Account No., Bank Account No.
• Table 1294 “Applied Payment Entry”: Account No., Bank Account No.
• Table 1296 “Posted Payment Recon. Line”: Account No., Bank Account No.
• Table 1570 “G/L Entry Posting Preview”: Bal. Account No., Source No.
• Table 17 “G/L Entry”: Bal. Account No., Source No.
• Table 179 “Reversal Entry”: Bal. Account No., Source No.
• Table 181 “Posted Gen. Journal Line”: Account No., Source No.
• Table 271 “Bank Account Ledger Entry”: Bal. Account No., Bank Account No.
• Table 272 “Check Ledger Entry”: Bal. Account No., Bank Account No.
• Table 273 “Bank Acc. Reconciliation”: Bank Account Name, Bank Account No.
• Table 274 “Bank Acc. Reconciliation Line”: Account No., Bank Account No.
• Table 275 “Bank Account Statement”: Bank Account Name, Bank Account No.
• Table 36 “Sales Header”: Bal. Account No., Company Bank Account Code
• Table 5107 “Sales Header Archive”: Bal. Account No., Company Bank Account Code
• Table 5900 “Service Header”: Bal. Account No., Company Bank Account Code
• Table 5990 “Service Shipment Header”: Bal. Account No., Company Bank Account Code
• Table 5992 “Service Invoice Header”: Bal. Account No., Company Bank Account Code
• Table 5994 “Service Cr.Memo Header”: Bal. Account No., Company Bank Account Code
• Table 6010 “Service Header Archive”: Bal. Account No., Company Bank Account Code
• Table 6786 “Withholding Tax Posting Setup”: Bal. Payable Account No., Bal. Prepaid Account No.
• Table 81 “Gen. Journal Line”: Account No., Source No.
• Table 120 “Purch. Rcpt. Header”: Bal. Account No.
• Table 122 “Purch. Inv. Header”: Bal. Account No.
• Table 1226 “Payment Export Data”: Sender Bank Account Code
• Table 1231 “Positive Pay Entry”: Bank Account No.
• Table 1232 “Positive Pay Entry Detail”: Bank Account No.
• Table 124 “Purch. Cr. Memo Hdr.”: Bal. Account No.
• Table 1251 “Text-to-Account Mapping”: Bal. Source No.
• Table 1295 “Posted Payment Recon. Hdr”: Bank Account No.
• Table 1299 “Payment Matching Details”: Bank Account No.
• Table 1626 “Office Contact Details”: No.
• Table 1690 “Bank Deposit Header”: Bank Account No.
• Table 1691 “Posted Bank Deposit Header”: Bank Account No.
• Table 1692 “Posted Bank Deposit Line”: Account No.
• Table 1693 “Bank Acc. Comment Line”: Bank Account No.
• Table 182 “Posted Gen. Journal Batch”: Bal. Account No.
• Table 186 “Exch. Rate Adjmt. Ledg. Entry”: Account No.
• Table 21 “Cust. Ledger Entry”: Bal. Account No.
• Table 232 “Gen. Journal Batch”: Bal. Account No.
• Table 25 “Vendor Ledger Entry”: Bal. Account No.
• Table 2671 “Alloc. Account Distribution”: Destination Account Number
• Table 2672 “Allocation Line”: Destination Account Number
• Table 276 “Bank Account Statement Line”: Bank Account No.
• Table 289 “Payment Method”: Bal. Account No.
• and 23 more objects (23 fields): data/code/relations/29.json

Pages and codeunits on this table

• Page 1233 “Positive Pay Export” (source table)
• Page 1269 “Auto. Bank Stmt. Import Setup” (source table)
• Page 1282 “Payment Bank Account List” (source table)
• Page 1283 “Payment Bank Account Card” (source table)
• Page 20051 “APIV1 - Bank Accounts” (source table)
• Page 30051 “APIV2 - Bank Accounts” (source table)
• Page 370 “Bank Account Card” (source table)
• Page 371 “Bank Account List” (source table)
• Page 375 “Bank Account Statistics” (source table)
• Page 377 “Bank Account Balance” (source table)

Extended by

• Table extension 20103 “AMC Bank Bank Account ext.”

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” (5 calls: OnDelete → DeleteDefaultDim, OnInsert → UpdateDefaultDim, OnRename → RenameDefaultDim, …)
• Codeunit 5058 “BankCont-Update” (5 calls: IsContactUpdateNeeded → ContactNameIsBlank, OnDelete → OnDelete, OnInsert → OnInsert, …)
• Page 456 “No. Series” (4 calls: AssistEdit → (object), GetCreditTransferMessageNo → (object), GetDirectDebitMessageNo → (object), …)
• Codeunit 361 “MoveEntries” (1 call: OnDelete → MoveBankAccEntries)
• Codeunit 802 “Online Map Management” (1 call: DisplayMap → MakeSelectionIfMapEnabled)
• Page 5052 “Contact List” (1 call: RunContactListPage → (object))
• Page 673 “Job Queue Entry Card” (1 call: ShowBankStatementDownloadJobQueueEntry → (object))

Countries that replace it

AU, BE, CA, ES, FR, IT, MX, NL, NZ, RU, US

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 Account"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.