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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment/FIN Financial Account

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.financialmgmt.payment

Index

Contents

FIN_Financial_Account

This table contains the following columns:

Name Nullable Data Type Description
Fin_Financial_Account_ID NVARCHAR2(32)Financial account used to deposit / withdrawal money such as bank accounts or petty cash
AD_Client_ID NVARCHAR2(32)Client for this installation.
AD_Org_ID NVARCHAR2(32)Organizational entity within client
Created NDATEThe date that this record is completed.
Createdby NVARCHAR2(32)User who created this records
Updated NDATEx not implemented
Updatedby NVARCHAR2(32)User who updated this records
Isactive YCHAR(1)A flag indicating whether this record is available for use or de-activated.
C_Currency_ID NVARCHAR2(32)An accepted medium of monetary exchange that may vary across countries.
Name NNVARCHAR2(60)A non-unique identifier for a record/document often used as a search tool.
Description YNVARCHAR2(255)A space to write additional related information.
Type NVARCHAR2(60)A distinct item characteristic used for processes and sometimes grouped within a category.
C_Bpartner_ID YVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
C_Location_ID YVARCHAR2(32)A specific place or residence.
Routingno YNVARCHAR2(20)Bank Routing Number
Swiftcode YNVARCHAR2(20)Swift Code (Society of Worldwide Interbank Financial Telecommunications)
Codebank YNVARCHAR2(4)Code of the bank
Codebranch YNVARCHAR2(4)Code of the branch
Bank_Digitcontrol YNVARCHAR2(1)null
INE_Number YNVARCHAR2(9)INE Number.
Account_Digitcontrol YNVARCHAR2(1)null
Codeaccount YNVARCHAR2(10)Code of the account
Accountno YNVARCHAR2(20)Account Number
Currentbalance NNUMBERCurrent Balance
InitialBalance NNUMBERInitial balance of the financial account. Amount of the account at the time of registering the financial account.
Creditlimit NNUMBERAmount of Credit allowed
Iban YNVARCHAR2(34)International standard for identifying bank accounts across national borders
Isdefault NCHAR(1)A value that is shown whenever a record is created.
FIN_Matching_Algorithm_ID YVARCHAR2(32)Identifies the algorithm used to match the imported bank statement lines

Other Info

Check constraints

These are the check constraints for this table:

top

Indexes

These are the indexes for this table (for each index there is a list of all the columns included within it):

Unique

top

Columns

Account

Financial account used to deposit / withdrawal money such as bank accounts or petty cash

top

Client

Foreign key column to AD_Client table, (column: AD_Client_ID)


Validation Rule AD_Client Security validation: Clients with user access rights. With the following code:

 
AD_Client.AD_Client_ID IN (@#User_Client@)

top

Organization

Foreign key column to AD_Org table, (column: AD_Org_ID)


Validation Rule AD_Org Trx Security validation: null. With the following code:

 
AD_Org.AD_Org_ID<> '0' AND AD_Org.IsReady='Y'

top

Creation Date

The Created field indicates the date that this record was created.

top

Created By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Updated

The Updated field indicates the date that this record was updated.

top

Updated By

Foreign key column to AD_User table, (column: AD_User_ID)

top

Active

There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records:
(1) The system requires the record for auditing purposes.
(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.

top

Currency

Foreign key column to C_Currency table, (column: C_Currency_ID)

top

Name

A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.

top

Description

A description is limited to 255 characters.

top

Type

The Type indicates the type of validation that will occur. This can be SQL, Java Script or Java Language.

List values: Financial account type

The allowed values for this list are:

top

Business Partner

Foreign key column to C_Bpartner table, (column: C_BPartner_ID)

top

Location / Address

Address/Location of the the Financial Account within the Enterprise.

Foreign key column to C_Location table, (column: C_Location_ID)

top

Routing No

The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions.

top

Swift code

The SWIFT code is an identifier of a Bank

top

Bank Code

First four numbers of the bank account number which identifies the bank uniquely.

top

Branch Code

Second group of four numbers of the bank account which identifies the branch uniquely.

top

Bank_Digitcontrol

Tenth number of the bank account.

top

INE No.

Number provided by the bank to configurate remittances.

top

Account_Digitcontrol

top

Partial Account No.

Last ten numbers of the bank account.

top

Account No.

The Account Number indicates the Number assigned to this account

top

Current Balance

The Current Balance field indicates the current balance in this account.

top

InitialBalance

Amount of the account at the time of registering the financial account. This amount is used to initialize financial account and will be used as last reconciliation amount for first reconciliation in OB for the given financial account.

top

Credit Limit

The Credit Limit field indicates the credit limit for this account.

top

IBAN

Code that 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). It is up to each country's national banking community to decide on the length of the BBAN for accounts in that country, but its length must be fixed for any given country.

top

Default

The Default Checkbox indicates if this record will be used as a default value.

top

Matching Algorithm

Foreign key column to FIN_Matching_Algorithm table, (column: FIN_Matching_Algorithm_ID)

top

Related tables

Tables that link this table:

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.financialmgmt.payment/FIN_Financial_Account"

This page has been accessed 2,927 times. This page was last modified on 14 June 2011, at 11:04. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.