Partner Bank Account
C_BP_BankAccount
Bank Account of the Business Partner
Overview
| Table Name | C_BP_BankAccount |
|---|---|
| Access Level | Client Only |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | C_PaymentProcessor |
| Wiki | View on iDempiere Wiki |
Columns (38)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
AccountNoPrefix |
String(20) | No | - | Account Number Prefix |
A_Country |
String(40) | No | - | Country |
C_PaymentProcessor_ID |
Table Direct(10) | No | - | Payment processor for electronic payments |
CustomerPaymentProfileID |
String(60) | No | - | - |
GenerateIBAN |
Button(1) | No | - | - |
IBAN |
String(40) | No | - | International Bank Account Number |
RoutingNo |
String(20) | No | - | Bank Routing Number |
A_Name |
String(60) | Yes | - | Name on Credit Card or Account holder |
AccountNo |
String(30) | No | - | Account Number |
C_Bank_ID |
Search(22) | No | - | Bank |
A_City |
String(60) | No | - | City or the Credit Card or Account Holder |
AD_Client_ID |
Table Direct(22) | Yes | @AD_Client_ID@ | Tenant for this installation. |
AD_Org_ID |
Table Direct(22) | Yes | @AD_Org_ID@ | Organizational entity within tenant |
AD_User_ID |
Table Direct(22) | No | -1 | User within the system - Internal or Business Partner Contact |
A_EMail |
String(60) | No | - | Email Address |
A_Ident_DL |
String(20) | No | - | Payment Identification - Driver License |
A_Ident_SSN |
String(20) | No | - | Payment Identification - Social Security No |
A_State |
String(40) | No | - | State of the Credit Card or Account holder |
A_Street |
String(60) | No | - | Street address of the Credit Card or Account holder |
A_Zip |
String(20) | No | - | Zip Code of the Credit Card or Account Holder |
BankAccountType |
List(1) | No | - | Bank Account Type |
BPBankAcctUse |
List(1) | No | B | Business Partner Bank Account usage |
C_BPartner_ID |
Search(22) | Yes | - | Identifies a Business Partner |
C_BP_BankAccount_ID |
ID(22) | Yes | - | Bank Account of the Business Partner |
C_BP_BankAccount_UU |
String(36) | No | - | - |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
CreditCardExpMM |
Integer(22) | No | - | Expiry Month |
CreditCardExpYY |
Integer(22) | No | 2000 | Expiry Year |
CreditCardNumber |
String(20) | No | - | Credit Card Number |
CreditCardType |
List(1) | No | - | Credit Card (Visa, MC, AmEx) |
CreditCardVV |
String(4) | No | - | Credit Card Verification code on credit card |
IsACH |
Yes-No(1) | Yes | @IsACH@='true' | Automatic Clearing House |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
R_AvsAddr |
List(1) | No | - | This address has been verified |
R_AvsZip |
List(1) | No | - | The Zip Code has been verified |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
Foreign Keys
| Column | References | Description |
|---|---|---|
C_PaymentProcessor_ID |
C_PaymentProcessor.C_PaymentProcessor_ID | Payment processor for electronic payments |
C_Bank_ID |
C_Bank.C_Bank_ID | Bank |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
AD_User_ID |
AD_User.AD_User_ID | User within the system - Internal or Business Partner Contact |
C_BPartner_ID |
C_BPartner.C_BPartner_ID | Identifies a Business Partner |
Generated on 2026-05-03T16:42:05.712351922Z