ExternalBankAccounts
Stores external bank account details for payments or reimbursements, supporting account creation, modifications, and usage tracking.
Columns
| Name | Type | Description |
| BankAccountNumber | String | Account number of the external bank account, used to identify the account within the banking system. |
| CountryCode | String | Country code of the external bank account, specifying the country in which the account is held. |
| BankBranchIdentifier | Long | Unique identifier of the bank branch where the external bank account is maintained. |
| BankIdentifier | Long | Unique identifier of the bank where the external bank account is held, used for routing and identification purposes. |
| BankAccountId [KEY] | Long | Unique identifier for the external bank account, used for tracking and managing the account details. |
| CurrencyCode | String | Currency code of the external bank account, indicating the currency in which the account is denominated. |
| IBAN | String | International Bank Account Number (IBAN), an alphanumeric sequence that conforms to the ISO standard for uniquely identifying a bank account internationally. |
| CheckDigits | String | Digits used to verify the accuracy or validity of the external bank account number, ensuring that the account number is correct. |
| AccountType | String | Type of external bank account. Possible values include 'Savings' and 'Checking', indicating the nature of the account. |
| AccountSuffix | String | Suffix added to the bank account number in some countries, used to differentiate between various accounts held by the same customer. |
| AgencyLocationCode | String | Agency location code associated with the external bank account, used for identifying the location of the bank branch. |
| AllowInternationalPaymentIndicator | String | Indicates whether the external bank account can be used for international payments or is restricted to domestic payments only. |
| SecondaryAccountReference | String | Reference number for a secondary external bank account, used in certain countries for categorizing bank accounts (for example, the Building Society Roll Number in the UK). |
| StartDate | Date | Date when the external bank account became active, marking the start of its use for transactions. |
| EndDate | Date | Date when the external bank account becomes inactive, marking the end of its use for transactions. |
| BankAccountName | String | Name associated with the external bank account, typically the account holder’s name or business name. |
| AlternateAccountName | String | Alternate name for the external bank account, often used for differentiating accounts or in cases where the account is shared. |
| BankBranchPartyIndicator | String | Indicates whether the external bank account is linked to a bank and branch created in Trading Community Architecture (TCA), used for managing bank-party relationships. |
| BankName | String | Name of the bank where the external bank account is held, identifying the financial institution. |
| BankNumber | String | Unique code or identifier assigned to the external bank by a banking regulatory authority, used for identifying the bank in transactions. |
| BankBranchName | String | Name of the bank branch where the external bank account is maintained, providing further identification of the account’s location. |
| BankBranchNumber | String | Number associated with a specific bank branch, known as a routing transit number in the United States or a sort code in the United Kingdom. |
| BIC | String | Bank Identifier Code (BIC), used by SWIFT to identify the external bank or branch, enabling the automated processing of telecommunication messages in banking. |
| VendorId | Long | Unique identifier for the vendor associated with the external bank account, used for supplier-related transactions. |
| PersonId | Long | Unique identifier for the person who owns the external bank account, typically used when the account owner is an employee. |
| Intent | String | Purpose of the external bank account, defining the intended use of the account for payment functions such as PAYABLES_DISB (Supplier), EMPLOYEE_EXP (Person/Employee), and CUSTOMER_PAYMENT (Customer). |
| PartyId | Long | Unique identifier for the party associated with the external bank account, typically representing the account holder or organization. |
| PayeeCreation | String | Indicates whether the external payee and associated instrument assignments should be created along with the bank account. Valid values are 'Y' for Yes and 'N' for No. |
| Finder | String | Search term or identifier used to locate and retrieve records related to external bank accounts in the system. |