View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

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

Retrieved from "http://wiki.openbravo.com/wiki/Modules:IDL_Bank_Accounts"

This page has been accessed 464 times. This page was last modified on 22 October 2012, at 14:05. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.