Modules:IDL Bank Accounts
Introduction
Bank accounts are financial accounts with a banking institution, recording the financial transactions between the customer and the bank and the resulting financial position of the customer with the bank.
Input file definition
Field name | Type | Nullable | Description | Accepted values |
---|---|---|---|---|
Organization | String(40) | No | Indicates the organization to be used when processing documents. | [Organization search key] |
TransactionalOrg | String(40) | No | Indicates the organization to be used when processing transactional documents. | [Organization search key] |
Name | String(60) | No | Bank name | |
Location1stLine | String(60) | Yes | Identifies the address for an entity's location | |
Location2ndLine | String(60) | Yes | Provides additional address information for an entity. It can be used for building location, apartment number or similar information. | |
LocationPostalCode | String(10) | Yes | Identifies the postal code for this entity's address. | |
LocationCity | String(60) | Yes | City in a country. | |
LocationRegion | String(60) | Yes | Identifies a unique Region for this Country. | [Country name] |
LocationCountry | String(60) | Yes | Defines a Country. Each Country must be defined before it can be used in any document. | [Region name] |
BankCode | String(4) | Yes | First four numbers of the bank account number which identifies the bank uniquely. | |
BranchCode | String(4) | Yes | Second group of four numbers of the bank account which identifies the branch uniquely. | |
BankControlDigit | String(1) | Yes | Ninth number of the bank account. | |
INENo | String(9) | Yes | Number provided by the bank to configurate remittances. | |
SwiftCode | String(20) | Yes | The SWIFT code is an identifier of a Bank. | |
AccountType | String(60) | No | The Bank Account Type field indicates the type of account this account is defined as. | [C_Bank Account type reference list] |
Currency | String(3) | No | Indicates the currency to be used when processing this document. | [Currency ISO code] |
IsDefault | Boolean | Yes | Indicates if this bank account will be the default. | {TRUE, FALSE} |
AccountControlDigit | String(1) | Yes | Tenth number of the bank account. | |
PartialAccountNo | String(10) | Yes | Last ten numbers of the bank account. | {TRUE, FALSE} |
GenericAccount | String(50) | Yes | Number of the bank account, in a generic format. Usefull if the bank does not use nor IBAN nor our country bank account number's structure. | |
IBAN | String(34) | Yes | Identifies uniquely one bank account, no matter the country it belongs to. It consists of a ISO 3166-1 alpha-2 country code, followed by two check digits, and up to thirty alphanumeric characters for the domestic bank account number, called the BBAN (Basic Bank Account Number). | [IBAN] |
ShowSpanish | Boolean | No | {TRUE, FALSE} | |
ShowGeneric | Boolean | No | {TRUE, FALSE} | |
ShowIBAN | Boolean | No | {TRUE, FALSE} | |
InitialBalance | Numeric | No | Quantity to initialize the bank account. | Number. Decimal separator = . |
BankStatementName | String(60) | No | Indicates the name of the Bank Statement record. | |
GLItem | String(60) | No* | General Ledger item | [GL Item name] |
BusinessPartner | String(60) | Yes | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. | [Business Partner search key ] |
* This fields can be NULL if they have a default value associated.
Default Value definition
Field name | Type | Accepted values | Examples |
---|---|---|---|
Organization | String(40) | [search_key] column from [AD_Org] table | |
TransactionalOrg | String(40) | [search_key] column from [AD_Org] table | |
Currency | String(3) | [iso_code] column from [c_currency] table | EUR, USD, GBP, ... |
Country | String(60) | [name] column from [c_country] table | Spain, United States, United Kingdom, France, ... |
AccountType | String(10) | [C_Bank Account type reference list] | English: {Checking, Savings} |
IsDefault | Boolean | TRUE / True / true / FALSE / False / false | |
GLItem | String(60) | [name] column from [c_glitem] table | Salaries, Social Security, ... |
BPCategory | String(60) | [name] column from [c_bp_taxcategory] table | General, VIP, ... |