Table 287 "Customer Bank Account"
Base Application · Microsoft.Sales.Customer
Across versions
- BC23present
- BC241 fields changed
- BC25unchanged
- BC2622 fields changed
- BC271 fields changed
- BC28unchanged
- BC292 fields changed
- BC30unchanged
Neighbourhood 16 connected objects and pages
Base Application · Microsoft.Sales.Customer · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 423 “Customer Bank Account Card” (2 Learn pages), Page 424 “Customer Bank Account List” (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”; NotBlank |
| 2 | Code Δ BC26 | Code[20] | Specifies a code to identify this customer bank account. | NotBlank |
| 3 | Name Δ BC26 | Text[100] | Specifies the name of the bank where the customer has the bank account. | |
| 5 | Name 2 | Text[50] | — | |
| 6 | Address Δ BC26 | Text[100] | Specifies the address of the bank where the customer has the bank account. | |
| 7 | Address 2 Δ BC26 | Text[50] | Specifies additional address information. | |
| 8 | City Δ BC26 | Text[30] | Specifies the city of the bank where the customer 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 Δ BC26 | 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 Δ BC26 | Text[100] | Specifies the name of the bank employee regularly contacted in connection with this bank account. | |
| 11 | Phone No. Δ BC26 | 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. Δ BC26 | Text[20] | Specifies the number of the bank branch. | |
| 14 | Bank Account No. Δ BC26 Δ BC29 | Text[30] | Specifies the number used by the bank for the bank account. | |
| 15 | Transit No. Δ BC26 | Text[20] | Specifies a bank identification number of your own choice. | |
| 16 | Currency Code Δ BC26 | Code[10] | Specifies the relevant currency code for the bank account. | TableRelation Table 4 “Currency” |
| 17 | Country/Region Code Δ BC26 | Code[10] | Specifies the country/region of the address. | TableRelation Table 9 “Country/Region” (Country/Region) |
| 18 | County Δ BC26 | Text[30] | Specifies the state, province or county as a part of the address. | |
| 19 | Fax No. Δ BC26 | 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 Δ BC26 | 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 Δ BC26 | Text[80] | Specifies the email address associated with the bank account. | |
| 23 | Home Page Δ BC24 Δ BC26 Δ BC27 | Text[255] | Specifies the bank web site. | |
| 24 | IBAN Δ BC26 Δ BC29 | Code[50] | Specifies the bank account’s international bank account number. | |
| 25 | SWIFT Code Δ BC26 | Code[20] | Specifies the SWIFT code (international bank identifier code) of the bank where the customer has the account. | TableRelation Table 1210 “SWIFT Code” (SWIFT Code) |
| 1211 | Bank Clearing Code Δ BC26 | 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 Δ BC26 | 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: 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”
- lookup page Page 424 “Customer Bank Account List”
- SWIFT Code: TableRelation Table 1210 “SWIFT Code”
- Bank Clearing Standard: TableRelation Table 1280 “Bank Clearing Standard”
- Customer No.: TableRelation Table 18 “Customer”
- City: TableRelation Table 225 “Post Code” (conditional)
- Post Code: TableRelation Table 225 “Post Code” (conditional)
- Currency Code: TableRelation Table 4 “Currency”
- Language Code: TableRelation Table 8 “Language”
- Country/Region Code: TableRelation Table 9 “Country/Region”
Referenced by
5 fields in 5 objects relate to this table (TableRelation or CalcFormula).
- Table 1230 “SEPA Direct Debit Mandate”: Customer Bank Account Code
- Table 18 “Customer”: Preferred Bank Account Code
- Table 181 “Posted Gen. Journal Line”: Recipient Bank Account
- Table 21 “Cust. Ledger Entry”: Recipient Bank Account
- Table 81 “Gen. Journal Line”: Recipient Bank Account
Pages and codeunits on this table
- Page 423 “Customer Bank Account Card” (source table)
- Page 424 “Customer Bank Account List” (source table)
Countries that replace it
BE, CA, CH, ES, FI, FR, IT, MX, NL, 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). 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.