CloudERP IDL Financial Accounts
Introduction
An account used to hold cash or near cash. The currency of the financial account is configurable (and once defined can not be changed). Payment events that use a financial account will automatically default to the currency of that financial account. Financial accounts in foreign currency must account in the currency of the schema to which they are associated using the exchange rate ruling at the transaction date. The balance of the account must be maintained in both the currency of the associated schema and the selected currency of the financial account. It should be possible to see the balance of a foreign currency account in the schema currency as at a selected date (using the exchange rate ruling at that date) and any exchange rate gain or loss displayed.
Input file definition
| Field name | Type | Nullable | Description | Accepted values | Comment |
|---|---|---|---|---|---|
| Organization | String(40) | No | Indicates the organization to be used when processing documents. | [Organization search key] | |
| Name | String(60) | No | Financial Account name | ||
| Description | String(255) | Yes | More information about the financial account. | The description for the financial account. | |
| Currency | String(3) | No | Indicates the currency to be used when processing this document. | [Currency ISO code] | |
| Type | String(60) | No | Financial Account Type (Financial account type reference list) | {Bank, Cash} | If Cash is selected some of the following fields are not applicable. View Comments column. |
| IsDefault | Boolean | Yes | Indicates if this bank account will be the default. | {TRUE, FALSE} | |
| 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] | |
| 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. | N/A for Cash type. | |
| BranchCode | String(4) | Yes | Second group of four numbers of the bank account which identifies the branch uniquely. | N/A for Cash type. | |
| BankControlDigit | String(1) | Yes | Ninth number of the bank account. | N/A for Cash type. | |
| INENo | String(9) | Yes | Number provided by the bank to configurate remittances. | N/A for Cash type. | |
| SwiftCode | String(20) | Yes | The SWIFT code is an identifier of a Bank. | N/A for Cash type. | |
| AccountControlDigit | String(1) | Yes | Tenth number of the bank account. | N/A for Cash type. | |
| PartialAccountNo | String(10) | Yes | Last ten numbers of the bank account. | N/A for Cash type. | |
| AccountNo | 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. | N/A for Cash type. | |
| 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] | N/A for Cash type. |
| InitialBalance | Numeric | Yes | Quantity to initialize the financial account. FIN_Financial_Account.CurrentBalance | Number. Decimal separator = . | If null, will take the database default value = 0.0 |
| CreditLimit | Numeric | Yes | Amount of credit allowed. | Number. Decimal separator = . | If null, will take the database default value = 0.0 |
| MatchingAlgorithm | String(60) | Yes | Identifies the algorithm used to match the imported bank statement lines | FIN_Matching_Algorithm.Name | N/A for Cash type. |
* 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 | |
| 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, ... |
| Type | String(10) | Financial account type reference list | English: {Bank, Cash} |
| IsDefault | Boolean | TRUE / True / true / FALSE / False / false | |
| MatchingAlgorithm | String(60) | Identifies the algorithm used to match the imported bank statement lines | FIN_Matching_Algorithm.Name |
| BPCategory | String(60) | [name] column from [c_bp_taxcategory] table | General, VIP, ... |