ERP/3.0/Developers Guide/Database Model/org.openbravo.model.common.businesspartner/C BP BankAccount
C_BP_BankAccount
- Name:C_BP_BankAccount
- Classname:BusinessPartnerBankAccount
This table contains the following columns:
Name | Nullable | Data Type | Description
|
AccountNo | Yes | NVARCHAR (100) | Bank account number in a generic format. |
BankAccountType | Yes | VARCHAR (60) | The Bank Account Type field indicates the type of account (savings, checking etc) this account is defined as. |
IsActive | No | CHAR (1) | 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. |
BankFormat | No | VARCHAR (60) | Bank Account Format used for generating the Displayed Account Number |
Bank_Name | Yes | NVARCHAR (50) | Name of the bank |
C_BPartner_ID | No | VARCHAR (32) | A Business Partner is anyone with whom you transact. This can include a customer, vendor, employee or any combination of these. |
CreditCardType | Yes | VARCHAR (60) | The Credit Card drop down list box is used for selecting the type of Credit Card presented for payment. |
A_City | Yes | NVARCHAR (60) | The Account City indicates the City of the Credit Card or Account holder |
AD_Client_ID | No | VARCHAR (32) | A Client is a company or a legal entity. You cannot share data between Clients. |
C_Country_ID | Yes | VARCHAR (32) | The Country defines a Country. Each Country must be defined before it can be used in any document. |
A_Country | Yes | NVARCHAR (40) | Account Country Name |
CreatedBy | No | VARCHAR (32) | The Created By field indicates the user who created this record. |
Created | No | TIMESTAMP (7) | The Created field indicates the date that this record was created. |
CreditCardNumber | Yes | NVARCHAR (20) | The Credit Card number indicates the number on the credit card, without blanks or spaces. |
Displayedaccount | Yes | NVARCHAR (120) | Text that will identify this bank account |
A_Ident_DL | Yes | NVARCHAR (20) | The Driver's License being used as identification. |
A_EMail | Yes | NVARCHAR (40) | The EMail Address indicates the EMail address off the Credit Card or Account holder. |
CreditCardExpMM | Yes | DECIMAL (10,0) | The Expiry Month indicates the expiry month for this credit card. |
CreditCardExpYY | Yes | DECIMAL (10,0) | The Expiry Year indicates the expiry year for this credit card. |
Iban | Yes | NVARCHAR (34) | 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. |
A_Name | Yes | NVARCHAR (60) | The Name of the Credit Card or Account holder. |
AD_Org_ID | No | VARCHAR (32) | An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations. |
C_BP_BankAccount_ID | No | VARCHAR (32) | The Partner Bank Account identifies the bank account to be used for this Business Partner |
A_Zip | Yes | NVARCHAR (20) | The Zip Code of the Credit Card or Account Holder. |
RoutingNo | Yes | NVARCHAR (20) | The Bank Routing Number (ABA Number) identifies a legal Bank. It is used in routing checks and electronic transactions. |
A_Ident_SSN | Yes | NVARCHAR (20) | The Social Security number being used as identification. |
A_State | Yes | NVARCHAR (40) | The State of the Credit Card or Account holder |
A_Street | Yes | NVARCHAR (60) | The Street Address of the Credit Card or Account holder. |
SwiftCode | Yes | NVARCHAR (20) | The SWIFT Code is an identifier of a Bank |
Updated | No | TIMESTAMP (7) | The Updated field indicates the date that this record was updated. |
UpdatedBy | No | VARCHAR (32) | The Updated By field indicates the user who updated this record. |
AD_User_ID | Yes | VARCHAR (32) | The User identifies a unique user in the system. This could be an internal user or a business partner contact |
R_AvsZip | Yes | VARCHAR (60) | The Zip Verified indicates if the zip code has been verified by the Credit Card Company. |
Columns
Account No.
- Physical column name: AccountNo
- Property Name: accountNo
- Reference: String
Account Type
- 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)
Active
- Physical column name: IsActive
- Property Name: active
- Reference: YesNo
- Default value: Y
Bank Format
- Physical column name: BankFormat
- Property Name: bankFormat
- Reference: List
- Default value: GENERIC
It has a validation "BankFormat List exclude Spanish", with the following code
UPPER(Value)<>'SPANISH'
List values: Bank Account Format
The allowed values for this list are:
- GENERIC (Use Generic Account No.)
- IBAN (Use IBAN)
- SWIFT (Use SWIFT + Generic Account No.)
- SPANISH (Use Spanish)
Bank Name
- Physical column name: Bank_Name
- Property Name: bankName
- Reference: String
Business Partner
- Physical column name: C_BPartner_ID
- Property Name: businessPartner
- Reference: Search
- This column is a child for a business object (is Parent)
Foreign key column to C_BPartner table, (column: C_BPartner_ID)
CC Type
- Physical column name: CreditCardType
- Property Name: cCType
- Reference: List
List values: C_Payment CreditCard Type
The allowed values for this list are:
- D (Diners)
- N (Discover)
- P (Purchase Card): Corporate Purchase Card
- A (Amex)
- M (MasterCard)
- V (Visa)
- C (ATM)
City
- Physical column name: A_City
- Property Name: city
- Reference: String
Client
- Physical column name: AD_Client_ID
- Property Name: client
- Reference: TableDir
Foreign key column to AD_Client table, (column: AD_Client_ID)
Country
- Physical column name: C_Country_ID
- Property Name: country
- Reference: TableDir
Foreign key column to C_Country table, (column: C_Country_ID)
Country Name
- Physical column name: A_Country
- Property Name: countryName
- Reference: String
Created By
- Physical column name: CreatedBy
- Property Name: createdBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
Creation Date
- Physical column name: Created
- Property Name: creationDate
- Reference: DateTime
- Default value: SYSDATE
Credit Card No.
- Physical column name: CreditCardNumber
- Property Name: creditCardNo
- Reference: String
Displayed Account
- Physical column name: Displayedaccount
- Property Name: displayedAccount
- Reference: String
- This column is part of the table's identifier
Driver's License No.
- Physical column name: A_Ident_DL
- Property Name: driversLicenseNo
- Reference: String
- Physical column name: A_EMail
- Property Name: email
- Reference: String
Expiry Month
- Physical column name: CreditCardExpMM
- Property Name: expiryMonth
- Reference: Integer
Expiry Year
- Physical column name: CreditCardExpYY
- Property Name: expiryYear
- Reference: Integer
IBAN
- Physical column name: Iban
- Property Name: iBAN
- Reference: String
Name
- Physical column name: A_Name
- Property Name: name
- Reference: String
Organization
- Physical column name: AD_Org_ID
- Property Name: organization
- Reference: TableDir
Foreign key column to AD_Org table, (column: AD_Org_ID)
Partner Bank Account
- Physical column name: C_BP_BankAccount_ID
- Property Name: id
- Reference: ID
Postal Code
- Physical column name: A_Zip
- Property Name: postalCode
- Reference: String
Routing No
- Physical column name: RoutingNo
- Property Name: routingNo
- Reference: String
Social Security No.
- Physical column name: A_Ident_SSN
- Property Name: socialSecurityNo
- Reference: String
State
- Physical column name: A_State
- Property Name: state
- Reference: String
Street
- Physical column name: A_Street
- Property Name: street
- Reference: String
Swift code
- Physical column name: SwiftCode
- Property Name: swiftCode
- Reference: String
Updated
- Physical column name: Updated
- Property Name: updated
- Reference: DateTime
- Default value: SYSDATE
Updated By
- Physical column name: UpdatedBy
- Property Name: updatedBy
- Reference: Search
Foreign key column to AD_User table, (column: AD_User_ID)
User/Contact
- Physical column name: AD_User_ID
- Property Name: userContact
- Reference: TableDir
Foreign key column to AD_User table, (column: AD_User_ID)
It has a validation "AD_User C_BPartner User/Contacts", with the following code
AD_User.C_BPartner_ID=@C_BPartner_ID@
Zip verified
- Physical column name: R_AvsZip
- Property Name: zipVerified
- Reference: List
List values: C_Payment AVS
The allowed values for this list are:
- Y (Match)
- N (No Match)
- X (Unavailable)
Other Info
Indices
These are the indices for this table (for each index there is a list of all the columns included within it):
- C_BPBANKACCT_BPARTNER Not Unique. Columns:
- C_BPARTNER_ID
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_SHOWGENERIC_CHK: UPPER(BANKFORMAT) = UPPER('GENERIC') AND ACCOUNTNO IS NOT NULL OR UPPER(BANKFORMAT) <> UPPER('GENERIC')
- C_BP_BACC_SHOWIBAN_CHK: UPPER(BANKFORMAT) = UPPER('IBAN') AND IBAN IS NOT NULL OR UPPER(BANKFORMAT) <> UPPER('IBAN')
- C_BP_BACC_SHOWSWIFT_CHK: UPPER(BANKFORMAT) = UPPER('SWIFT') AND SWIFTCODE IS NOT NULL AND ACCOUNTNO IS NOT NULL OR UPPER(BANKFORMAT) <> UPPER('SWIFT')
- C_BP_BANKACCOUNT_ISACTIVE_CHK: ISACTIVE IN ('Y', 'N')