Table 288 "Vendor Bank Account"
Base Application · Microsoft.Purchases.Vendor
- 26fields
- 10procedures
- 8events
- 1Learn pages
- 14countries replace it
- 4fields reference it
- 9event subscribers
- 1objects it calls
Across versions
- BC23present
- BC241 fields changed, 1 events added
- BC25-26unchanged
- BC271 fields changed
- BC2822 fields changed
- BC292 fields changed, 1 events added
- BC30unchanged
Neighbourhood 18 connected objects and pages
Base Application · Microsoft.Purchases.Vendor · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 425 “Vendor Bank Account Card” (1 Learn page), Page 426 “Vendor Bank Account List” (1).
Properties
| Property | Value |
|---|---|
| Caption | Vendor Bank Account |
| DataClassification | CustomerContent |
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 | Vendor No. | Code[20] | — | TableRelation Table 23 “Vendor”; NotBlank |
| 2 | Code Δ BC28 | Code[20] | Specifies a code to identify this vendor bank account. | NotBlank |
| 3 | Name Δ BC28 | Text[100] | Specifies the name of the bank where the vendor has this bank account. | |
| 5 | Name 2 | Text[50] | — | |
| 6 | Address Δ BC28 | Text[100] | Specifies the address of the bank where the vendor has the bank account. | |
| 7 | Address 2 Δ BC28 | Text[50] | Specifies additional address information. | |
| 8 | City Δ BC28 | Text[30] | Specifies the city of the bank where the vendor has the bank account. | TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code”.City else if (“Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Country/Region Code”))) |
| 9 | Post Code Δ BC28 | Code[20] | Specifies the postal code. | TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code” else if (“Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Country/Region Code”))) |
| 10 | Contact Δ BC28 | Text[100] | Specifies the name of the bank employee regularly contacted in connection with this bank account. | |
| 11 | Phone No. Δ BC28 | Text[30] | Specifies the telephone number of the bank where the vendor has the bank account. | |
| 12 | Telex No. | Text[20] | — | |
| 13 | Bank Branch No. Δ BC28 | Text[20] | Specifies the number of the bank branch. | |
| 14 | Bank Account No. Δ BC28 Δ BC29 | Text[30] | Specifies the number used by the bank for the bank account. | |
| 15 | Transit No. Δ BC28 | Text[20] | Specifies a bank identification number of your own choice. | |
| 16 | Currency Code Δ BC28 | Code[10] | Specifies the relevant currency code for the bank account. | TableRelation Table 4 “Currency” |
| 17 | Country/Region Code Δ BC28 | Code[10] | Specifies the country/region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 18 | County Δ BC28 | Text[30] | Specifies the state, province or county as a part of the address. | |
| 19 | Fax No. Δ BC28 | Text[30] | Specifies the fax number associated with the address. | |
| 20 | Telex Answer Back | Text[20] | — | |
| 21 | Language Code Δ BC28 | Code[10] | Specifies the language that is used when translating specified text on documents to foreign business partner, such as an item description on an order confirmation. | TableRelation Table 8 “Language” |
| 22 | E-Mail Δ BC28 | Text[80] | Specifies the email address associated with the bank account. | |
| 23 | Home Page Δ BC24 Δ BC27 Δ BC28 | Text[255] | Specifies the bank web site. | |
| 24 | IBAN Δ BC28 Δ BC29 | Code[50] | Specifies the bank account’s international bank account number. | |
| 25 | SWIFT Code Δ BC28 | Code[20] | Specifies the SWIFT code (international bank identifier code) of the bank where the vendor has the account. | TableRelation Table 1210 “SWIFT Code” (SWIFT Code) |
| 1211 | Bank Clearing Code Δ BC28 | Text[50] | Specifies the code for bank clearing that is required according to the format standard you selected in the Bank Clearing Standard field. | |
| 1212 | Bank Clearing Standard Δ BC28 | Text[50] | Specifies the format standard to be used in bank transfers if you use the Bank Clearing Code field to identify you as the sender. | TableRelation Table 1280 “Bank Clearing Standard” (Bank Clearing Standard) |
Keys
- Key1: Vendor No., Code (clustered)
Events published
OnBeforeOnRename(var VendorBankAccount: Record "Vendor Bank Account"; xVendorBankAccount: Record "Vendor Bank Account"; var IsHandled: Boolean)+ BC29 (integration)OnBeforeLookupName(xVendorBankAccount: Record "Vendor Bank Account")(integration)OnValidateBankAccount(var VendorBankAccount: Record "Vendor Bank Account"; FieldToValidate: Text)(integration)OnBeforeValidateIBAN(var VendorBankAccount: Record "Vendor Bank Account"; var xVendorBankAccount: Record "Vendor Bank Account"; var IsHandled: Boolean)(integration)OnGetBankAccount(var Handled: Boolean; VendorBankAccount: Record "Vendor Bank Account"; var ResultBankAccountNo: Text)(integration)OnBeforeValidateCity(var VendorBankAccount: Record "Vendor Bank Account"; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration)OnBeforeValidatePostCode(var VendorBankAccount: Record "Vendor Bank Account"; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)(integration)OnDeleteOnAfterSetFilters(var VendorBankAccount: Record "Vendor Bank Account"; var VendorLedgerEntry: Record "Vendor Ledger Entry")+ BC24 (integration)
Trigger event subscribers
- OnAfterDeleteEvent: Codeunit 1535 “Approvals Mgmt.” DeleteApprovalEntriesAfterDeleteVendorBankAccount, Codeunit 882 “OCR - Sync Master Data” OnAfterDeleteVendorBankAccount
- OnAfterInsertEvent: Codeunit 1550 “Record Restriction Mgt.” RestrictVendorBankAccountAfterInsert, Codeunit 882 “OCR - Sync Master Data” OnAfterInsertVendorBankAccount
- OnAfterModifyEvent: Codeunit 1550 “Record Restriction Mgt.” RestrictVendorBankAccountAfterModify, Codeunit 882 “OCR - Sync Master Data” OnAfterModifyVendorBankAccount
- OnAfterRenameEvent: Codeunit 1550 “Record Restriction Mgt.” UpdateVendorBankAccountRestrictionsAfterRename, Codeunit 882 “OCR - Sync Master Data” OnAfterRenameVendorBankAccount
- OnBeforeDeleteEvent: Codeunit 1550 “Record Restriction Mgt.” RemoveVendorBankAccountRestrictionsBeforeDelete
Procedures
GetBankAccountNoWithCheck(): TextGetBankAccountNo(): Text
Triggers
OnDelete, OnRename
Relations
- drill-down page Page 426 “Vendor Bank Account List”
- lookup page Page 426 “Vendor Bank Account List”
- SWIFT Code: TableRelation Table 1210 “SWIFT Code”
- Bank Clearing Standard: TableRelation Table 1280 “Bank Clearing Standard”
- City: TableRelation Table 225 “Post Code” (conditional)
- Post Code: TableRelation Table 225 “Post Code” (conditional)
- Vendor No.: TableRelation Table 23 “Vendor”
- Currency Code: TableRelation Table 4 “Currency”
- Language Code: TableRelation Table 8 “Language”
- Country/Region Code: TableRelation Table 9 “Country/Region”
Referenced by
4 fields in 4 objects relate to this table (TableRelation or CalcFormula).
- Table 181 “Posted Gen. Journal Line”: Recipient Bank Account
- Table 23 “Vendor”: Preferred Bank Account Code
- Table 25 “Vendor Ledger Entry”: Recipient Bank Account
- Table 81 “Gen. Journal Line”: Recipient Bank Account
Pages and codeunits on this table
- Page 425 “Vendor Bank Account Card” (source table)
- Page 426 “Vendor Bank Account List” (source table)
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 1535 “Approvals Mgmt.” (2 calls:
OnDelete → OnCancelVendorBankAccountApprovalRequest,OnRename → OnRenameRecordInApprovalRequest)
Recent changes
- 2026-08-17 #10136 [CH][SEPA CT] Export requires both IBAN and Clearing No. for domestic payments and refunds (main, BC30, fix)
Countries that replace it
AU, BE, CA, CH, ES, FI, FR, GB, 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: "Vendor Bank Account"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.