---
id: object/table/287
type: object
title: Table 287 "Customer Bank Account"
summary: Table 287 "Customer Bank Account" in Base Application (Microsoft.Sales.Customer). 26 fields, 2 public procedures, 6 events. Present since at least BC23, still in BC30, changed in BC24, BC26-27, BC29.
tier: official
language: en
tags:
  - table
  - base application
versions:
  introduced: null
  last_changed: "29"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 02f7850a626023f599ed077a92f1cbdd3463ac777eab3300c83d25e8f75c1629
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Sales/Customer/CustomerBankAccount.Table.al
    title: src/Layers/W1/BaseApp/Sales/Customer/CustomerBankAccount.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/bank-how-setup-bank-accounts
    - https://learn.microsoft.com/dynamics365/business-central/finance-collect-payments-with-sepa-direct-debit
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/finance/manage-payables
    - topic/business-central/business-functionality/finance/manage-receivables
    - topic/business-central/business-functionality/general-business-functionality/exchange-data-electronically/collect-payments-with-sepa-direct-debit
    - topic/business-central/business-functionality/general-business-functionality/exchange-data-electronically/exchange-data
    - topic/business-central/business-functionality/set-up-business-central/set-up-banking
  localizations:
    - localization/be
    - localization/ca
    - localization/ch
    - localization/es
    - localization/fi
    - localization/fr
    - localization/it
    - localization/mx
    - localization/nl
    - localization/ru
    - localization/us
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 287
name: Customer Bank Account
namespace: Microsoft.Sales.Customer
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in:
  - "24"
  - "26"
  - "27"
  - "29"
source_major: "29"
obsolete: null
countries:
  - be
  - ca
  - ch
  - es
  - fi
  - fr
  - it
  - mx
  - nl
  - ru
  - us
ms_search_form_ids: []
counts:
  fields: 26
  procedures: 9
  events: 6
  subscribers: 0
relations:
  out: 10
  referenced_by: 5
  pages: 2
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 287 "Customer Bank Account"

> Table 287 "Customer Bank Account" in Base Application (Microsoft.Sales.Customer). 26 fields, 2 public procedures, 6 events. Present since at least BC23, still in BC30, changed in BC24, BC26-27, BC29.

Base Application · Microsoft.Sales.Customer · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/Sales/Customer/CustomerBankAccount.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 423 "Customer Bank Account Card"](../page/423.md) (2 Learn pages), [Page 424 "Customer Bank Account List"](../page/424.md) (2).

## Properties

| Property | Value |
|---|---|
| Caption | Customer 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 | Customer No. | Code[20] | — | TableRelation [Table 18 "Customer"](../table/18.md); NotBlank |
| 2 | Code | Code[20] | Specifies a code to identify this customer bank account. | NotBlank |
| 3 | Name | Text[100] | Specifies the name of the bank where the customer has the bank account. |  |
| 5 | Name 2 | Text[50] | — |  |
| 6 | Address | Text[100] | Specifies the address of the bank where the customer has the bank account. |  |
| 7 | Address 2 | Text[50] | Specifies additional address information. |  |
| 8 | City | Text[30] | Specifies the city of the bank where the customer has the bank account. | TableRelation [Table 225 "Post Code"](../table/225.md) (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 | Code[20] | Specifies the postal code. | TableRelation [Table 225 "Post Code"](../table/225.md) (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 | Text[100] | Specifies the name of the bank employee regularly contacted in connection with this bank account. |  |
| 11 | Phone No. | Text[30] | Specifies the telephone number of the bank where the customer has the bank account. |  |
| 12 | Telex No. | Text[20] | — |  |
| 13 | Bank Branch No. | Text[20] | Specifies the number of the bank branch. |  |
| 14 | Bank Account No. | Text[30] | Specifies the number used by the bank for the bank account. |  |
| 15 | Transit No. | Text[20] | Specifies a bank identification number of your own choice. |  |
| 16 | Currency Code | Code[10] | Specifies the relevant currency code for the bank account. | TableRelation [Table 4 "Currency"](../table/4.md) |
| 17 | Country/Region Code | Code[10] | Specifies the country/region of the address. | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 18 | County | Text[30] | Specifies the state, province or county as a part of the address. |  |
| 19 | Fax No. | Text[30] | Specifies the fax number of the bank where the customer has the bank account. |  |
| 20 | Telex Answer Back | Text[20] | — |  |
| 21 | Language Code | 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"](../table/8.md) |
| 22 | E-Mail | Text[80] | Specifies the email address associated with the bank account. |  |
| 23 | Home Page | Text[255] | Specifies the bank web site. |  |
| 24 | IBAN | Code[50] | Specifies the bank account's international bank account number. |  |
| 25 | SWIFT Code | Code[20] | Specifies the SWIFT code (international bank identifier code) of the bank where the customer has the account. | TableRelation [Table 1210 "SWIFT Code"](../table/1210.md) (SWIFT Code) |
| 1211 | Bank Clearing Code | 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 | 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"](../table/1280.md) (Bank Clearing Standard) |

## Keys

- Key1: Customer No., Code (clustered)

## Events published

- `OnValidateBankAccount(var CustomerBankAccount: Record "Customer Bank Account"; FieldToValidate: Text)` (integration): Raised when validating the bank branch number or bank account number fields.
- `OnBeforeValidateIBAN(var CustomerBankAccount: Record "Customer Bank Account"; var xCustomerBankAccount: Record "Customer Bank Account"; var IsHandled: Boolean)` (integration): Raised before validating the IBAN field.
- `OnGetBankAccount(var Handled: Boolean; CustomerBankAccount: Record "Customer Bank Account"; var ResultBankAccountNo: Text)` (integration): Raised when getting the bank account number to allow custom retrieval logic.
- `OnBeforeValidateCity(var CustomerBankAccount: Record "Customer Bank Account"; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)` (integration): Raised before validating the city field.
- `OnBeforeUpdateCustPreferredBankAccountCode(var CustomerBankAccount: Record "Customer Bank Account"; var IsHandled: Boolean)` (integration): Raised before updating the customer's preferred bank account code when deleting a bank account.
- `OnBeforeValidatePostCode(var CustomerBankAccount: Record "Customer Bank Account"; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)` (integration): Raised before validating the post code field.

## Procedures

- `GetBankAccountNoWithCheck(): Text`: Gets the bank account number or IBAN, raising an error if both are empty.
- `GetBankAccountNo(): Text`: Gets the bank account number, preferring IBAN if available.

Plus 1 local procedures.

## Triggers

OnDelete, OnRename

## Relations

- drill-down page [Page 424 "Customer Bank Account List"](../page/424.md)
- lookup page [Page 424 "Customer Bank Account List"](../page/424.md)
- SWIFT Code: TableRelation [Table 1210 "SWIFT Code"](../table/1210.md)
- Bank Clearing Standard: TableRelation [Table 1280 "Bank Clearing Standard"](../table/1280.md)
- Customer No.: TableRelation [Table 18 "Customer"](../table/18.md)
- City: TableRelation [Table 225 "Post Code"](../table/225.md) (conditional)
- Post Code: TableRelation [Table 225 "Post Code"](../table/225.md) (conditional)
- Currency Code: TableRelation [Table 4 "Currency"](../table/4.md)
- Language Code: TableRelation [Table 8 "Language"](../table/8.md)
- Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)

## Referenced by

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

- [Table 1230 "SEPA Direct Debit Mandate"](../table/1230.md): Customer Bank Account Code
- [Table 18 "Customer"](../table/18.md): Preferred Bank Account Code
- [Table 181 "Posted Gen. Journal Line"](../table/181.md): Recipient Bank Account
- [Table 21 "Cust. Ledger Entry"](../table/21.md): Recipient Bank Account
- [Table 81 "Gen. Journal Line"](../table/81.md): Recipient Bank Account

## Pages and codeunits on this table

- [Page 423 "Customer Bank Account Card"](../page/423.md) (source table)
- [Page 424 "Customer Bank Account List"](../page/424.md) (source table)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: BC24, BC26-27, BC29

## Countries that replace it

[BE](../../localizations/be.md), [CA](../../localizations/ca.md), [CH](../../localizations/ch.md), [ES](../../localizations/es.md), [FI](../../localizations/fi.md), [FR](../../localizations/fr.md), [IT](../../localizations/it.md), [MX](../../localizations/mx.md), [NL](../../localizations/nl.md), [RU](../../localizations/ru.md), [US](../../localizations/us.md)

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