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

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BP BankAccount

ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.businesspartner

Index

Contents

C_BP_BankAccount

The Define Bank Account Tab defines the banking information for this business partner. This data is used for processing payments and remittances.

This table contains the following columns:

Name Nullable Data Type Description
C_BP_BankAccount_ID NVARCHAR2(32)Bank Account of the Business Partner
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.
Updated NDATEx not implemented
IsActive NCHAR(1)A flag indicating whether this record is available for use or de-activated.
CreatedBy NVARCHAR2(32)User who created this records
UpdatedBy NVARCHAR2(32)User who updated this records
C_BPartner_ID NVARCHAR2(32)Anyone who takes part in daily business operations by acting as a customer, employee, etc.
BankAccountType YVARCHAR2(60)Bank Account Type
RoutingNo YNVARCHAR2(20)Bank Routing Number
AccountNo YNVARCHAR2(20)Account Number
CreditCardType YVARCHAR2(60)Credit Card (Visa, MC, AmEx)
CreditCardNumber YNVARCHAR2(20)Credit Card Number
CreditCardExpMM YNUMBER(10, 0)Expiry Month
CreditCardExpYY YNUMBER(10, 0)Expiry Year
A_Name YNVARCHAR2(60)Name on Credit Card or Account holder
A_Street YNVARCHAR2(60)Street address of the Credit Card or Account holder
A_City YNVARCHAR2(60)City or the Credit Card or Account Holder
A_State YNVARCHAR2(40)State of the Credit Card or Account holder
A_Zip YNVARCHAR2(20)Zip Code of the Credit Card or Account Holder
A_Ident_DL YNVARCHAR2(20)Payment Identification - Driver License
A_EMail YNVARCHAR2(40)Email Address
A_Ident_SSN YNVARCHAR2(20)Payment Identification - Social Security No
R_AvsZip YVARCHAR2(60)The Zip Code has been verified
A_Country YNVARCHAR2(40)Country Name
AD_User_ID YVARCHAR2(32)An acquaintance to reach for information related to the business partner.
Bank_Name YNVARCHAR2(50)Name of the bank
Iban YNVARCHAR2(34)International standard for identifying bank accounts across national borders
ShowAccountNo YCHAR(1)Show Generic
Showiban YCHAR(1)Show IBAN
Displayedaccount YNVARCHAR2(34)Text that will identify this bank account
C_Country_ID YVARCHAR2(32)A state or a nation.
SwiftCode YNVARCHAR2(20)Swift Code (Society of Worldwide Interbank Financial Telecommunications)

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):

Non Unique

Unique

top

Columns

Partner Bank Account

The Partner Bank Account identifies the bank account to be used for this Business Partner

top

Client

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

top

Organization

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

top

Creation Date

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

top

Updated

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

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

Created By

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

top

Updated By

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

top

Business Partner

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

top

Account Type

The Bank Account Type field indicates the type of account (savings, checking etc) this account is defined as.

List values: C_Bank Account Type

The allowed values for this list are:

top

Routing No

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

top

Account No.

The Account Number indicates the Number assigned to this account

top

CC Type

The Credit Card drop down list box is used for selecting the type of Credit Card presented for payment.

List values: C_Payment CreditCard Type

The allowed values for this list are:

top

Credit Card No.

The Credit Card number indicates the number on the credit card, without blanks or spaces.

top

Expiry Month

The Expiry Month indicates the expiry month for this credit card.

top

Expiry Year

The Expiry Year indicates the expiry year for this credit card.

top

Name

The Name of the Credit Card or Account holder.

top

Street

The Street Address of the Credit Card or Account holder.

top

City

The Account City indicates the City of the Credit Card or Account holder

top

State

The State of the Credit Card or Account holder

top

Postal Code

The Zip Code of the Credit Card or Account Holder.

top

Driver's License No.

The Driver's License being used as identification.

top

Email

The EMail Address indicates the EMail address off the Credit Card or Account holder.

top

Social Security No.

The Social Security number being used as identification.

top

Zip verified

The Zip Verified indicates if the zip code has been verified by the Credit Card Company.

List values: C_Payment AVS

The allowed values for this list are:

top

Country Name

Account Country Name

top

User/Contact

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


Validation Rule AD_User C_BPartner User/Contacts: null. With the following code:

 
AD_User.C_BPartner_ID=@C_BPartner_ID@

top

Bank Name

Name of the bank

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

Show Generic

Show Generic

top

Show IBAN

Show IBAN

top

Displayed Account

Text that will identify this bank account

top

Country

Foreign key column to C_Country table, (column: C_Country_ID)

top

Swift code

The SWIFT code is an identifier of a Bank

top

Retrieved from "http://wiki.openbravo.com/wiki/ERP_2.50:Developers_Guide/Database_Model/org.openbravo.model.common.businesspartner/C_BP_BankAccount"

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