ERP 2.50:Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BP BankAccount
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.
- Name:BusinessPartnerBankAccount
- Classname:BankAccount
This table contains the following columns:
Name | Nullable | Data Type | Description |
C_BP_BankAccount_ID | N | VARCHAR2(32) | Bank Account of the Business Partner |
AD_Client_ID | N | VARCHAR2(32) | Client for this installation. |
AD_Org_ID | N | VARCHAR2(32) | Organizational entity within client |
Created | N | DATE | The date that this record is completed. |
Updated | N | DATE | x not implemented |
IsActive | N | CHAR(1) | A flag indicating whether this record is available for use or de-activated. |
CreatedBy | N | VARCHAR2(32) | User who created this records |
UpdatedBy | N | VARCHAR2(32) | User who updated this records |
C_BPartner_ID | N | VARCHAR2(32) | Anyone who takes part in daily business operations by acting as a customer, employee, etc. |
BankAccountType | Y | VARCHAR2(60) | Bank Account Type |
RoutingNo | Y | NVARCHAR2(20) | Bank Routing Number |
AccountNo | Y | NVARCHAR2(20) | Account Number |
CreditCardType | Y | VARCHAR2(60) | Credit Card (Visa, MC, AmEx) |
CreditCardNumber | Y | NVARCHAR2(20) | Credit Card Number |
CreditCardExpMM | Y | NUMBER(10, 0) | Expiry Month |
CreditCardExpYY | Y | NUMBER(10, 0) | Expiry Year |
A_Name | Y | NVARCHAR2(60) | Name on Credit Card or Account holder |
A_Street | Y | NVARCHAR2(60) | Street address of the Credit Card or Account holder |
A_City | Y | NVARCHAR2(60) | City or the Credit Card or Account Holder |
A_State | Y | NVARCHAR2(40) | State of the Credit Card or Account holder |
A_Zip | Y | NVARCHAR2(20) | Zip Code of the Credit Card or Account Holder |
A_Ident_DL | Y | NVARCHAR2(20) | Payment Identification - Driver License |
A_EMail | Y | NVARCHAR2(40) | Email Address |
A_Ident_SSN | Y | NVARCHAR2(20) | Payment Identification - Social Security No |
R_AvsZip | Y | VARCHAR2(60) | The Zip Code has been verified |
A_Country | Y | NVARCHAR2(40) | Country Name |
AD_User_ID | Y | VARCHAR2(32) | An acquaintance to reach for information related to the business partner. |
Bank_Name | Y | NVARCHAR2(50) | Name of the bank |
Iban | Y | NVARCHAR2(34) | International standard for identifying bank accounts across national borders |
ShowAccountNo | Y | CHAR(1) | Show Generic |
Showiban | Y | CHAR(1) | Show IBAN |
Displayedaccount | Y | NVARCHAR2(34) | Text that will identify this bank account |
C_Country_ID | Y | VARCHAR2(32) | A state or a nation. |
SwiftCode | Y | NVARCHAR2(20) | Swift Code (Society of Worldwide Interbank Financial Telecommunications) |
Other Info
Check constraints
These are the check constraints for this table:
- C_BP_BACC_COUNTRY_CHECK: (IBAN IS NULL) OR (C_COUNTRY_ID IS NOT NULL)
- C_BP_BACC_IBAN_CHECK: (((SHOWIBAN = 'Y') AND (SHOWACCOUNTNO = 'N')) AND (IBAN IS NOT NULL)) OR (((SHOWIBAN = 'N') AND (SHOWACCOUNTNO = 'Y')) AND (ACCOUNTNO IS NOT NULL))
- C_BP_BANKACCOUNT_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')
Indexes
These are the indexes for this table (for each index there is a list of all the columns included within it):
Non Unique
- C_BPBANKACCT_BPARTNER
Unique
- C_BP_BANKACCOUNT_KEY
Columns
Partner Bank Account
The Partner Bank Account identifies the bank account to be used for this Business Partner
- Physical column name: C_BP_BankAccount_ID
- Property Name: id
- Reference: ID
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
- Default value: @AD_CLIENT_ID@
Foreign key column to AD_Client table, (column: AD_Client_ID)
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
- Default value: @AD_Org_ID@
Foreign key column to AD_Org table, (column: AD_Org_ID)
Creation Date
The Created field indicates the date that this record was created.
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
Updated
The Updated field indicates the date that this record was updated.
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
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.
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
- This column is a child for a buisiness object (is Parent)
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
Account Type
The Bank Account Type field indicates the type of account (savings, checking etc) this account is defined as.
- Physical column name: BankAccountType
- Property Name: accountType
- Reference: List
List values: C_Bank Account Type
The allowed values for this list are:
- C (Checking)
- S (Savings)
Routing No
The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions.
- Physical column name: RoutingNo
- Property Name: routingNo
- Reference: String
Account No.
The Account Number indicates the Number assigned to this account
- Physical column name: AccountNo
- Property Name: accountNo
- Reference: String
CC Type
The Credit Card drop down list box is used for selecting the type of Credit Card presented for payment.
- Physical column name: CreditCardType
- Property Name: cCType
- Reference: List
List values: C_Payment CreditCard Type
The allowed values for this list are:
- A (Amex)
- C (ATM)
- D (Diners)
- M (MasterCard)
- N (Discover)
- P (Purchase Card): Corporate Purchase Card
- V (Visa)
Credit Card No.
The Credit Card number indicates the number on the credit card, without blanks or spaces.
- Physical column name: CreditCardNumber
- Property Name: creditCardNo
- Reference: String
Expiry Month
The Expiry Month indicates the expiry month for this credit card.
- Physical column name: CreditCardExpMM
- Property Name: expiryMonth
- Reference: Integer
Expiry Year
The Expiry Year indicates the expiry year for this credit card.
- Physical column name: CreditCardExpYY
- Property Name: expiryYear
- Reference: Integer
- Default value: 2000
Name
The Name of the Credit Card or Account holder.
- Physical column name: A_Name
- Property Name: name
- Reference: String
Street
The Street Address of the Credit Card or Account holder.
- Physical column name: A_Street
- Property Name: street
- Reference: String
City
The Account City indicates the City of the Credit Card or Account holder
- Physical column name: A_City
- Property Name: city
- Reference: String
State
The State of the Credit Card or Account holder
- Physical column name: A_State
- Property Name: state
- Reference: String
Postal Code
The Zip Code of the Credit Card or Account Holder.
- Physical column name: A_Zip
- Property Name: postalCode
- Reference: String
Driver's License No.
The Driver's License being used as identification.
- Physical column name: A_Ident_DL
- Property Name: driversLicenseNo
- Reference: String
The EMail Address indicates the EMail address off the Credit Card or Account holder.
- Physical column name: A_EMail
- Property Name: email
- Reference: String
Social Security No.
The Social Security number being used as identification.
- Physical column name: A_Ident_SSN
- Property Name: socialSecurityNo
- Reference: String
Zip verified
The Zip Verified indicates if the zip code has been verified by the Credit Card Company.
- Physical column name: R_AvsZip
- Property Name: zipVerified
- Reference: List
List values: C_Payment AVS
The allowed values for this list are:
- N (No Match)
- X (Unavailable)
- Y (Match)
Country Name
Account Country Name
- Physical column name: A_Country
- Property Name: countryName
- Reference: String
User/Contact
- Physical column name: AD_User_ID
- Property Name: userContact
- Reference: TableDir
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@
Bank Name
Name of the bank
- Physical column name: Bank_Name
- Property Name: bankName
- Reference: String
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.
- Physical column name: Iban
- Property Name: iBAN
- Reference: String
Show Generic
Show Generic
- Physical column name: ShowAccountNo
- Property Name: showGeneric
- Reference: YesNo
Show IBAN
Show IBAN
- Physical column name: Showiban
- Property Name: showIBAN
- Reference: YesNo
Displayed Account
Text that will identify this bank account
- Physical column name: Displayedaccount
- Property Name: displayedAccount
- Reference: String
- This column is part of the table's identifier
Country
- Physical column name: C_Country_ID
- Property Name: country
- Reference: TableDir
Foreign key column to C_Country table, (column: C_Country_ID)
Swift code
The SWIFT code is an identifier of a Bank
- Physical column name: SwiftCode
- Property Name: swiftCode
- Reference: String