View source | Discuss this page | Page history | Printable version   

CloudERP IDL Financial Accounts


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, ...

Retrieved from ""

This page has been accessed 1,185 times. This page was last modified on 18 June 2014, at 09:00. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.