--- title: "Table 270 Bank Account" author: "Jonas Paprotka" url: https://jonas-paprotka.de/ref/table/270-bank-account/ type: table id: 270 name: "Bank Account" app: "Base Application" namespace: Microsoft.Bank.BankAccount versions: "17-28" build: 28.5.54151.54365 source: "https://jonas-paprotka.de/ref/table/270-bank-account/source/29/" checked: 2026-09-20 subject: "Microsoft Dynamics 365 Business Central" license: "Content © 2026 Jonas Paprotka. Quote freely with attribution and a link." --- # Table 270 Bank Account Jonas Paprotka, https://jonas-paprotka.de/ref/table/270-bank-account/ | | | | --- | --- | | App | Base Application | | Namespace | Microsoft.Bank.BankAccount | | Versions | 17-28 | | Source file | Bank/BankAccount/BankAccount.Table.al | ## Fields | Id | Name | Type | Versions | Obsolete | Reason | | --- | --- | --- | --- | --- | --- | | 1 | No. | Code[20] | 17-28 | - | - | | 2 | Name | Text[100] | 17-28 | - | - | | 3 | Search Name | Code[100] | 17-28 | - | - | | 4 | Name 2 | Text[50] | 17-28 | - | - | | 5 | Address | Text[100] | 17-28 | - | - | | 6 | Address 2 | Text[50] | 17-28 | - | - | | 7 | City | Text[30] | 17-28 | - | - | | 8 | Contact | Text[100] | 17-28 | - | - | | 9 | Phone No. | Text[30] | 17-28 | - | - | | 10 | Telex No. | Text[20] | 17-28 | - | - | | 13 | Bank Account No. | Text[30] | 17-28 | - | - | | 14 | Transit No. | Text[20] | 17-28 | - | - | | 15 | Territory Code | Code[10] | 17-28 | - | - | | 16 | Global Dimension 1 Code | Code[20] | 17-28 | - | - | | 17 | Global Dimension 2 Code | Code[20] | 17-28 | - | - | | 18 | Chain Name | Code[10] | 17-28 | - | - | | 20 | Min. Balance | Decimal | 17-28 | - | - | | 21 | Bank Acc. Posting Group | Code[20] | 17-28 | - | - | | 22 | Currency Code | Code[10] | 17-28 | - | - | | 24 | Language Code | Code[10] | 17-28 | - | - | | 25 | Format Region | Text[80] | 23-28 | - | - | | 26 | Statistics Group | Integer | 17-28 | - | - | | 29 | Our Contact Code | Code[20] | 17-28 | - | - | | 35 | Country/Region Code | Code[10] | 17-28 | - | - | | 37 | Amount | Decimal | 17-28 | - | - | | 38 | Comment | Boolean | 17-28 | - | - | | 39 | Blocked | Boolean | 17-28 | - | - | | 41 | Last Statement No. | Code[20] | 17-28 | - | - | | 42 | Last Payment Statement No. | Code[20] | 17-28 | - | - | | 43 | Pmt. Rec. No. Series | Code[20] | 21-28 | - | - | | 54 | Last Date Modified | Date | 17-28 | - | - | | 55 | Date Filter | Date | 17-28 | - | - | | 56 | Global Dimension 1 Filter | Code[20] | 17-28 | - | - | | 57 | Global Dimension 2 Filter | Code[20] | 17-28 | - | - | | 58 | Balance | Decimal | 17-28 | - | - | | 59 | Balance (LCY) | Decimal | 17-28 | - | - | | 60 | Net Change | Decimal | 17-28 | - | - | | 61 | Net Change (LCY) | Decimal | 17-28 | - | - | | 62 | Total on Checks | Decimal | 17-28 | - | - | | 70 | Use as Default for Currency | Boolean | 20-28 | - | - | | 84 | Fax No. | Text[30] | 17-28 | - | - | | 85 | Telex Answer Back | Text[20] | 17-28 | - | - | | 89 | Picture | Blob | 17-25 | Removed 18.0 | Replaced by Image field | | 91 | Post Code | Code[20] | 17-28 | - | - | | 92 | County | Text[30] | 17-28 | - | - | | 93 | Last Check No. | Code[20] | 17-28 | - | - | | 94 | Balance Last Statement | Decimal | 17-28 | - | - | | 95 | Balance at Date | Decimal | 17-28 | - | - | | 96 | Balance at Date (LCY) | Decimal | 17-28 | - | - | | 97 | Debit Amount | Decimal | 17-28 | - | - | | 98 | Credit Amount | Decimal | 17-28 | - | - | | 99 | Debit Amount (LCY) | Decimal | 17-28 | - | - | | 100 | Credit Amount (LCY) | Decimal | 17-28 | - | - | | 101 | Bank Branch No. | Text[20] | 17-28 | - | - | | 102 | E-Mail | Text[80] | 17-28 | - | - | | 103 | Home Page | Text[255] | 17-28 | - | - | | 107 | No. Series | Code[20] | 17-28 | - | - | | 108 | Check Report ID | Integer | 17-28 | - | - | | 109 | Check Report Name | Text[250] | 17-28 | - | - | | 110 | IBAN | Code[50] | 17-28 | - | - | | 111 | SWIFT Code | Code[20] | 17-28 | - | - | | 113 | Bank Statement Import Format | Code[20] | 17-28 | - | - | | 115 | Credit Transfer Msg. Nos. | Code[20] | 17-28 | - | - | | 116 | Direct Debit Msg. Nos. | Code[20] | 17-28 | - | - | | 117 | SEPA Direct Debit Exp. Format | Code[20] | 17-28 | - | - | | 121 | Bank Stmt. Service Record ID | RecordId | 17-28 | - | - | | 123 | Transaction Import Timespan | Integer | 17-28 | - | - | | 124 | Automatic Stmt. Import Enabled | Boolean | 17-28 | - | - | | 130 | IntercompanyEnable | Boolean | 22-28 | - | - | | 140 | Image | Media | 17-28 | - | - | | 170 | Creditor No. | Code[35] | 17-28 | - | - | | 1210 | Payment Export Format | Code[20] | 17-28 | - | - | | 1211 | Bank Clearing Code | Text[50] | 17-28 | - | - | | 1212 | Bank Clearing Standard | Text[50] | 17-28 | - | - | | 1213 | Bank Name - Data Conversion | Text[50] | 17-25 | Removed 15.0 | Changed to AMC Banking 365 Fundamentals Extension | | 1250 | Match Tolerance Type | Option | 17-28 | - | - | | 1251 | Match Tolerance Value | Decimal | 17-28 | - | - | | 1252 | Disable Automatic Pmt Matching | Boolean | 18-28 | - | - | | 1253 | Disable Bank Rec. Optimization | Boolean | 23-28 | - | - | | 1260 | Positive Pay Export Code | Code[20] | 17-28 | - | - | | 1280 | Check Transmitted | Boolean | 24-28 | - | - | | 5061 | Mobile Phone No. | Text[30] | 17-28 | - | - | ## Keys | Name | Fields | Versions | | --- | --- | --- | | Key1, clustered | No. | 17-28 | | Key2 | Search Name | 17-28 | | Key3 | Bank Acc. Posting Group | 17-28 | | Key4 | Currency Code | 17-28 | | Key5 | Country/Region Code | 17-28 | ## Procedures | Name | Parameters | Returns | Access | Versions | Obsolete | Reason | | --- | --- | --- | --- | --- | --- | --- | | AssistEdit | (Record Bank Account) | Boolean | public | 17-28 | - | - | | ValidateShortcutDimCode | (Integer, var Code[20]) | - | public | 17-28 | - | - | | ShowContact | () | - | public | 17-28 | - | - | | SetInsertFromContact | (Boolean) | - | public | 17-28 | - | - | | GetPaymentExportCodeunitID | () | Integer | public | 17-28 | - | - | | GetPaymentExportXMLPortID | () | Integer | public | 17-28 | - | - | | GetDDExportCodeunitID | () | Integer | public | 17-28 | - | - | | GetDDExportXMLPortID | () | Integer | public | 17-28 | - | - | | GetBankExportImportSetup | (var Record Bank Export/Import Setup) | - | public | 17-28 | - | - | | GetDDExportImportSetup | (var Record Bank Export/Import Setup) | - | public | 17-28 | - | - | | GetCreditTransferMessageNo | () | Code[20] | public | 17-28 | - | - | | GetDirectDebitMessageNo | () | Code[20] | public | 17-28 | - | - | | DisplayMap | () | - | public | 17-28 | - | - | | GetDataExchDef | (var Record Data Exch. Def) | - | public | 17-28 | - | - | | GetDataExchDefPaymentExport | (var Record Data Exch. Def) | - | public | 17-28 | - | - | | GetBankAccountNoWithCheck | () | Text | public | 17-28 | - | - | | GetBankAccountNo | () | Text | public | 17-28 | - | - | | IsInLocalCurrency | () | Boolean | public | 17-28 | - | - | | GetPosPayExportCodeunitID | () | Integer | public | 17-28 | - | - | | IsLinkedToBankStatementServiceProvider | () | Boolean | public | 17-28 | - | - | | StatementProvidersExist | () | Boolean | public | 17-28 | - | - | | LinkStatementProvider | (var Record Bank Account) | - | public | 17-28 | - | - | | SimpleLinkStatementProvider | (var Record Online Bank Acc. Link) | - | public | 17-28 | - | - | | UnlinkStatementProvider | () | - | public | 17-28 | - | - | | RefreshStatementProvider | (var Record Bank Account) | - | public | 17-28 | - | - | | RenewAccessConsentStatementProvider | (var Record Bank Account) | - | public | 17-28 | - | - | | EditAccountStatementProvider | (var Record Bank Account) | - | public | 17-28 | - | - | | UpdateBankAccountLinking | () | - | public | 17-28 | - | - | | GetUnlinkedBankAccounts | (var Record Bank Account) | - | public | 17-28 | - | - | | GetLinkedBankAccounts | (var Record Bank Account) | - | public | 17-28 | - | - | | IsAutoLogonPossible | () | Boolean | public | 17-28 | - | - | | CreateNewAccount | (Record Online Bank Acc. Link) | - | public | 17-28 | - | - | | GetOnlineFeedStatementStatus | (var Option, var Boolean) | - | public | 17-28 | - | - | | DisableStatementProviders | () | - | public | 17-28 | - | - | | CopyBankFieldsFromCompanyInfo | (Record Company Information) | - | public | 20-28 | - | - | | GetDefaultBankAccountNoForCurrency | (Code[20]) | Code[20] | public | 20-28 | - | - | ## Events | Kind | Name | Parameters | Versions | Obsolete | Reason | | --- | --- | --- | --- | --- | --- | | Integration event | OnAfterIsUpdateNeeded | (Record Bank Account, Record Bank Account, var Boolean) | 17-28 | - | - | | Integration event | OnAfterValidateShortcutDimCode | (var Record Bank Account, var Record Bank Account, Integer, var Code[20]) | 17-28 | - | - | | Integration event | OnBeforeValidateShortcutDimCode | (var Record Bank Account, var Record Bank Account, Integer, var Code[20]) | 17-28 | - | - | | Integration event | OnCheckLinkedToStatementProviderEvent | (var Record Bank Account, var Boolean) | 17-28 | - | - | | Integration event | OnCheckAutoLogonPossibleEvent | (var Record Bank Account, var Boolean) | 17-28 | - | - | | Integration event | OnUnlinkStatementProviderEvent | (var Record Bank Account, var Boolean) | 17-28 | - | - | | Integration event | OnMarkAccountLinkedEvent | (var Record Online Bank Acc. Link, var Record Bank Account) | 17-28 | - | - | | Integration event | OnSimpleLinkStatementProviderEvent | (var Record Online Bank Acc. Link, var Text) | 17-28 | - | - | | Integration event | OnLinkStatementProviderEvent | (var Record Bank Account, var Text) | 17-28 | - | - | | Integration event | OnRefreshStatementProviderEvent | (var Record Bank Account, var Text) | 17-28 | - | - | | Integration event | OnGetDataExchangeDefinitionEvent | (var Code[20], var Boolean) | 17-28 | - | - | | Integration event | OnUpdateBankAccountLinkingEvent | (var Record Bank Account, var Text) | 17-28 | - | - | | Integration event | OnGetStatementProvidersEvent | (var Record Name/Value Buffer) | 17-28 | - | - | | Integration event | OnDisableStatementProviderEvent | (Text) | 17-28 | - | - | | Integration event | OnRenewAccessConsentStatementProviderEvent | (var Record Bank Account, var Text) | 17-28 | - | - | | Integration event | OnEditAccountStatementProviderEvent | (var Record Bank Account, var Text) | 17-28 | - | - | | Integration event | OnBeforeRunContactListPage | (var Record Contact, var Boolean) | 17-28 | - | - | | Integration event | OnValidateBankAccount | (var Record Bank Account, Text) | 19-28 | - | - | | Integration event | OnGetBankAccount | (var Boolean, Record Bank Account, var Text) | 19-28 | - | - | | Integration event | OnBeforeValidateIBAN | (var Record Bank Account, var Record Bank Account, var Boolean) | 20-28 | - | - | | Integration event | OnAfterCopyBankFieldsFromCompanyInfo | (var Record Bank Account, Record Company Information) | 21-28 | - | - | | Integration event | OnBeforeValidateCity | (var Record Bank Account, var Record Post Code, Integer, var Boolean) | 21-28 | - | - | | Integration event | OnBeforeValidatePostCode | (var Record Bank Account, var Record Post Code, Integer, var Boolean) | 21-28 | - | - | | Integration event | OnBeforeGetCreditTransferMessageNo | (var Code[20], var Boolean) | 23-28 | - | - | | Integration event | OnBeforeGetDirectDebitMessageNo | (var Code[20], var Boolean) | 23-28 | - | - | | Integration event | OnValidateCurrencyCodeOnBeforeTestBalanceFields | (var Record Bank Account) | 25-28 | - | - | | Integration event | OnBeforeGetBankExportImportSetup | (var Record Bank Export/Import Setup, var Boolean) | 26-28 | - | - | | Integration event | OnBeforeIsInLocalCurrency | (var Record Bank Account, var Boolean, var Boolean) | 26-28 | - | - | ## Source Symbols: Microsoft.BaseApplication.symbols.437dbf0e-84ff-417a-965d-ed2bb9650972, https://dynamicssmb2.pkgs.visualstudio.com/DynamicsBCPublicFeeds/_packaging/MSSymbols/nuget/v3/index.json, highest build per major on 2026-09-20. AL source 29: https://github.com/microsoft/BCApps, MIT, releases/29.x at a66254c3b8b5bb1cea290dc8f9d097aec4381153. Jonas Paprotka, 2026-09-20.