ExternalBankAccounts
ExternalBankAccounts
Columns
| Name | Type | Description |
| BankAccountNumber | String | Account number of the external bank account. |
| CountryCode | String | Country code of the external bank account. |
| BankBranchIdentifier | Long | Identifier of the bank branch where the external bank account is present. |
| BankIdentifier | Long | Identifier of the bank where the external bank account is present. |
| BankAccountId [KEY] | Long | Identifier of the external bank account. |
| CurrencyCode | String | Currency code of the external bank account. |
| IBAN | String | International Bank Account Number (IBAN), which is an alphanumeric sequence that conforms to the ISO standard for uniquely identifying a bank account number internationally. The standard IBAN carries all the routing information needed to get a payment from one bank to another. |
| CheckDigits | String | Number added to the external bank account number to derive a further number as a means of verifying the accuracy or validity of the external account number as it is printed or transmitted. |
| AccountType | String | Type of external bank account. Possible values are Savings and Checking. |
| AccountSuffix | String | Two or three digits added to the end of an external bank account number in some countries, such as New Zealand. This format allows customers to have a single account number with differing suffixes that represent different types of accounts. |
| AgencyLocationCode | String | Agency location code of the external bank account. |
| AllowInternationalPaymentIndicator | String | Indicates whether the external bank account can be used for foreign payments or only for domestic payments. |
| SecondaryAccountReference | String | Reference number of a secondary external bank account, such as the Building Society Roll Number used in the United Kingdom. |
| StartDate | Date | Date when the external bank account becomes active. |
| EndDate | Date | Date when the external bank account becomes inactive. |
| BankAccountName | String | Name of the external bank account. |
| AlternateAccountName | String | Alternate name of the external bank account. |
| BankBranchPartyIndicator | String | Indicates whether an external bank account is associated with any external bank and branch created in Trading Community Architecture (TCA). If the value is Yes or Null, external bank and branch information is stored in TCA and the external bank and branch identifiers are stored on the external bank account. If the value is No, external bank and branch attributes are stored on the external bank account. |
| BankName | String | Name of the bank where the customer has an external bank account. |
| BankNumber | String | Code or identifier issued to an external bank by a banking regulatory authority. |
| BankBranchName | String | Name of the bank branch where the customer or supplier has an external bank account. |
| BankBranchNumber | String | Number of a bank branch. This is known as a routing transit number in the United States and a sort code in the United Kingdom. |
| BIC | String | Bank Identifier Code (BIC), which is the identifier code used by SWIFT to identify an external bank or bank branch. The BIC is a universal method of identifying financial institutions to facilitate the automated processing of telecommunication messages in banking and related financial environments. |
| VendorId | Long | VendorId of ExternalBankAccounts |
| PersonId | Long | Person identifier when the account owner is an employee. |
| Intent | String | Purpose of the external bank account. The value is based on the payment function of the external payee or the external payer of the account owner. The following are the expected values: PAYABLES_DISB - Supplier, EMPLOYEE_EXP - Person, EMPLOYEE_EXP - Employee, AR_CUSTOMER_REFUNDS - Refund, CUSTOMER_PAYMENT - Customer, ONETIME_PAYMENT - Onetime, and ADHOC_PAYMENT - Adhoc. |
| PartyId | Long | Party identifier of the external bank account owner. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |