Table "Customer Bank Account"
Stores customer bank account information including IBAN, SWIFT code, and bank details.
Properties
| Name | Value |
|---|---|
| Caption | Customer Bank Account |
| DataCaptionFields | 1,2,3 |
| DrillDownPageID | Page Microsoft.Sales.Customer."Customer Bank Account List" |
| LookupPageID | Page Microsoft.Sales.Customer."Customer Bank Account List" |
| DataClassification | CustomerContent |
Fields
| Name | Type | Description |
|---|---|---|
| "Customer No." | Code[20] | Specifies the customer that owns this bank account. |
| Code | Code[20] | Specifies a unique code to identify this bank account among the customer's bank accounts. |
| Name | Text[100] | Specifies the name of the bank where the customer holds this account. |
| "Name 2" | Text[50] | Specifies additional name information for the bank. |
| Address | Text[100] | Specifies the street address of the bank. |
| "Address 2" | Text[50] | Specifies additional address details for the bank location. |
| City | Text[30] | Specifies the city where the bank is located. |
| "Post Code" | Code[20] | Specifies the postal code for the bank's address. |
| Contact | Text[100] | Specifies the name of the bank contact person for this account. |
| "Phone No." | Text[30] | Specifies the telephone number of the bank. |
| "Telex No." | Text[20] | Specifies the telex number for the bank. |
| "Bank Branch No." | Text[20] | Specifies the bank's branch number for routing purposes. |
| "Bank Account No." | Text[30] | Specifies the customer's account number at the bank. |
| "Transit No." | Text[20] | Specifies the transit routing number for the bank. |
| "Currency Code" | Code[10] | Specifies the currency used for transactions in this bank account. |
| "Country/Region Code" | Code[10] | Specifies the country or region where the bank is located. |
| County | Text[30] | Specifies the state, province, or county where the bank is located. |
| "Fax No." | Text[30] | Specifies the fax number of the bank. |
| "Telex Answer Back" | Text[20] | Specifies the telex answer back code for the bank. |
| "Language Code" | Code[10] | Specifies the language code for communication with the bank. |
| "E-Mail" | Text[80] | Specifies the email address associated with the bank account. |
| "Home Page" | Text[255] | Specifies the bank's website URL. |
| IBAN | Code[50] | Specifies the International Bank Account Number for this account. |
| "SWIFT Code" | Code[20] | Specifies the SWIFT code for international bank transfers. |
| "Bank Clearing Code" | Text[50] | Specifies the bank clearing code required for payment processing. |
| "Bank Clearing Standard" | Text[50] | Specifies the format standard used for bank clearing codes. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemCreatedByUserName | Text[50] | |
| SystemCreatedByFullName | Text[80] | |
| SystemModifiedByUserName | Text[50] | |
| SystemModifiedByFullName | Text[80] | |
| SystemRowVersion | BigInteger |
Methods
GetBankAccountNoWithCheck
Gets the bank account number or IBAN, raising an error if both are empty.
procedure GetBankAccountNoWithCheck(): TextReturns
| Type | Description |
|---|---|
| Text |
The bank account number or IBAN. |
GetBankAccountNo
Gets the bank account number, preferring IBAN if available.
procedure GetBankAccountNo(): TextReturns
| Type | Description |
|---|---|
| Text |
The IBAN (without spaces) or bank account number, or empty if neither is specified. |
Events
OnValidateBankAccount
Raised when validating the bank branch number or bank account number fields.
[IntegrationEvent(False,False)]
local procedure OnValidateBankAccount(var CustomerBankAccount: Record "Customer Bank Account"; FieldToValidate: Text)Parameters
| Name | Type | Description |
|---|---|---|
| CustomerBankAccount | Table Microsoft.Sales.Customer."Customer Bank Account" |
The customer bank account record being validated. |
| FieldToValidate | Text |
The name of the field being validated. |
OnBeforeValidateIBAN
Raised before validating the IBAN field.
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateIBAN(var CustomerBankAccount: Record "Customer Bank Account"; var xCustomerBankAccount: Record "Customer Bank Account"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| CustomerBankAccount | Table Microsoft.Sales.Customer."Customer Bank Account" |
The customer bank account record. |
| xCustomerBankAccount | Table Microsoft.Sales.Customer."Customer Bank Account" |
The previous customer bank account record. |
| IsHandled | Boolean |
Set to true to skip the default IBAN validation. |
OnGetBankAccount
Raised when getting the bank account number to allow custom retrieval logic.
[IntegrationEvent(False,False)]
local procedure OnGetBankAccount(var Handled: Boolean; CustomerBankAccount: Record "Customer Bank Account"; var ResultBankAccountNo: Text)Parameters
| Name | Type | Description |
|---|---|---|
| Handled | Boolean |
Set to true to indicate custom handling was performed. |
| CustomerBankAccount | Table Microsoft.Sales.Customer."Customer Bank Account" |
The customer bank account record. |
| ResultBankAccountNo | Text |
Set to the bank account number to return. |
OnBeforeValidateCity
Raised before validating the city field.
[IntegrationEvent(False,False)]
local procedure OnBeforeValidateCity(var CustomerBankAccount: Record "Customer Bank Account"; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| CustomerBankAccount | Table Microsoft.Sales.Customer."Customer Bank Account" |
The customer bank account record. |
| PostCodeRec | Table Microsoft.Foundation.Address."Post Code" |
The post code record for validation. |
| CurrentFieldNo | Integer |
The current field number being validated. |
| IsHandled | Boolean |
Set to true to skip the default validation. |
OnBeforeUpdateCustPreferredBankAccountCode
Raised before updating the customer's preferred bank account code when deleting a bank account.
[IntegrationEvent(False,False)]
local procedure OnBeforeUpdateCustPreferredBankAccountCode(var CustomerBankAccount: Record "Customer Bank Account"; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| CustomerBankAccount | Table Microsoft.Sales.Customer."Customer Bank Account" |
The customer bank account record being deleted. |
| IsHandled | Boolean |
Set to true to skip the default update. |
OnBeforeValidatePostCode
Raised before validating the post code field.
[IntegrationEvent(False,False)]
local procedure OnBeforeValidatePostCode(var CustomerBankAccount: Record "Customer Bank Account"; var PostCodeRec: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean)Parameters
| Name | Type | Description |
|---|---|---|
| CustomerBankAccount | Table Microsoft.Sales.Customer."Customer Bank Account" |
The customer bank account record. |
| PostCodeRec | Table Microsoft.Foundation.Address."Post Code" |
The post code record for validation. |
| CurrentFieldNo | Integer |
The current field number being validated. |
| IsHandled | Boolean |
Set to true to skip the default validation. |