Business Partner
C_BPartner
Identifies a Business Partner
Overview
| Table Name | C_BPartner |
|---|---|
| Access Level | System + Client |
| Entity Type | D |
| Is Document | No |
| Is View | No |
| Has UUID | Yes |
| Parent Table | AD_OrgBP |
| Wiki | View on iDempiere Wiki |
Columns (101)
| Column | Type | Required | Default | Description |
|---|---|---|---|---|
ABCAnalysisGroup |
List(10) | No | - | Materials management ABC analysis or Selective Inventory Control |
AD_OrgBP_ID |
Button(22) | No | - | The Business Partner is another Organization for explicit Inter-Org transactions |
AD_TenantBP_ID |
Table(10) | No | - | The Business Partner is another Tenant for Account Management |
AlertMessagePO |
Text(2000) | No | - | Message of the PO Alert |
AlertMessageSO |
Text(2000) | No | - | Message of the SO Alert |
BPartner_Parent_ID |
ID(22) | No | - | Business Partner Parent |
BPVerification |
List(1) | No | - | Business Partner verification |
C_Business_Entity_ID |
Table Direct(10) | No | - | - |
C_Industry_ID |
Table Direct(10) | No | - | Define Lead or Business Partners Industry |
C_Location_ID |
Location (Address)(22) | No | - | Location or Address |
CompRegDetails |
String(255) | No | - | Company Registration Details |
CompRegNo |
String(22) | No | - | Company Registration Number |
C_TaxGroup_ID |
Table Direct(10) | No | - | - |
CustomerProfileID |
String(60) | No | - | - |
CustomerServRep_ID |
Table(10) | No | - | Customer Service Representative or ServiceDesk Agent |
Default1099Box_ID |
Table(10) | No | - | - |
DeliveryTime_Promised |
Quantity(10) | No | - | Promised days between order and delivery |
DunningGrace |
Date(7) | No | - | - |
Fax |
String(40) | No | - | Facsimile number |
FlatDiscount |
Number(22) | No | - | Flat discount percentage |
InternalNote |
Text(2000) | No | - | - |
InvoiceConsolidationRule |
List(2) | Yes | NC | - |
Invoice_PrintFormat_ID |
Table(22) | No | - | Print Format for printing Invoices |
Is1099Vendor |
Yes-No(1) | Yes | N | - |
ISDN |
String(40) | No | - | ISDN or modem line |
IsExcludeAutoInvoice |
Yes-No(1) | No | N | Exclude from automatic Invoicing |
IsManufacturer |
Yes-No(1) | No | 'N' | Indicate role of this Business partner as Manufacturer |
LocationName |
String(200) | No | - | - |
Logo_ID |
Image(10) | No | - | - |
M_DiscountSchema_ID |
Search(22) | No | - | Schema to calculate the trade discount percentage |
M_Shipper_ID |
Table(10) | No | - | Method or manner of product delivery |
Phone |
String(40) | No | - | Identifies a telephone number |
Phone2 |
String(40) | No | - | Identifies an alternate telephone number. |
PO_CreditLimit |
Number(22) | No | 0.00 | Total outstanding invoice (vendor) amounts allowed |
PO_DiscountSchema_ID |
Search(22) | No | - | Schema to calculate the purchase trade discount percentage |
PO_PaymentTerm_ID |
Table(22) | No | - | Payment rules for a purchase order |
SalesRep2_ID |
Table(22) | No | - | Sales Representative or Company Agent |
SendEMail |
Yes-No(1) | Yes | - | Enable sending Document EMail |
ShelfLifeMinPct |
Integer(22) | No | - | Minimum Shelf Life in percent based on Product Instance Guarantee Date |
Shipment_PrintFormat_ID |
Table(22) | No | - | Print Format for Shipments, Receipts, Pick Lists |
SOCreditStatus |
List(1) | No | - | Business Partner Credit Status |
TaxID_Alternative |
String(15) | No | - | Tax Identification Alternative |
TotalOpenBalance |
Amount(22) | No | - | Total Open Balance Amount in primary Accounting Currency |
ValidTo |
Date(7) | No | - | Valid to including this date (last day) |
VerificationURL |
URL(255) | No | - | Full Verification URL address |
Name |
String(120) | Yes | - | Alphanumeric identifier of the entity |
AcqusitionCost |
Costs+Prices(22) | No | - | The cost of gaining the prospect as a customer |
ActualLifeTimeValue |
Amount(22) | No | - | Actual Life Time Revenue |
AD_Client_ID |
Table Direct(22) | Yes | @#AD_Client_ID@ | Tenant for this installation. |
AD_Language |
Table(6) | No | - | Language for this entity |
AD_Org_ID |
Table Direct(22) | Yes | @#AD_Org_ID@ | Organizational entity within tenant |
C_BPartner_ID |
ID(22) | Yes | - | Identifies a Business Partner |
C_BPartner_UU |
String(36) | No | - | - |
C_BP_Group_ID |
Table Direct(22) | Yes | - | Business Partner Group |
C_Dunning_ID |
Table Direct(22) | No | - | Dunning Rules for overdue invoices |
C_Greeting_ID |
Table Direct(22) | No | - | Greeting to print on correspondence |
C_InvoiceSchedule_ID |
Table Direct(22) | No | - | Schedule for generating Invoices |
C_PaymentTerm_ID |
Table(22) | No | - | The terms of Payment (timing, discount) |
Created |
Date+Time(7) | Yes | SYSDATE | Date this record was created |
CreatedBy |
Search(22) | Yes | - | User who created this records |
DeliveryRule |
List(1) | No | - | Defines the timing of Delivery |
DeliveryViaRule |
List(1) | No | - | How the order will be delivered |
Description |
String(255) | No | - | Optional short description of the record |
DocumentCopies |
Integer(22) | No | - | Number of copies to be printed |
DUNS |
String(11) | No | - | Dun & Bradstreet Number |
FirstSale |
Date(7) | No | - | Date of First Sale |
FreightCostRule |
List(1) | No | - | Method for charging Freight |
InvoiceRule |
List(1) | No | - | Frequency and method of invoicing |
IsActive |
Yes-No(1) | Yes | Y | The record is active in the system |
IsCustomer |
Yes-No(1) | Yes | - | Indicates if this Business Partner is a Customer |
IsDiscountPrinted |
Yes-No(1) | No | - | Print Discount on Invoice and Order |
IsEmployee |
Yes-No(1) | Yes | - | Indicates if this Business Partner is an employee |
IsOneTime |
Yes-No(1) | Yes | - | - |
IsPOTaxExempt |
Yes-No(1) | Yes | N | Business partner is exempt from tax on purchases |
IsProspect |
Yes-No(1) | Yes | N | Indicates a Prospect or Customer |
IsSalesRep |
Yes-No(1) | Yes | - | Indicates if the business partner is a sales representative or company agent |
IsSummary |
Yes-No(1) | Yes | - | This is a summary entity |
IsTaxExempt |
Yes-No(1) | No | - | Business partner is exempt from tax |
IsVendor |
Yes-No(1) | Yes | - | Indicates if this Business Partner is a Vendor |
M_PriceList_ID |
Search(22) | No | - | Unique identifier of a Price List |
NAICS |
String(6) | No | - | Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html |
Name2 |
String(60) | No | - | Additional Name |
NumberEmployees |
Integer(22) | No | - | Number of employees |
PaymentRule |
List(1) | No | - | How you pay the invoice |
PaymentRulePO |
List(1) | No | - | Purchase payment option |
PO_PriceList_ID |
Search(22) | No | - | Price List used by this Business Partner |
POReference |
String(20) | No | - | Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner |
PotentialLifeTimeValue |
Amount(22) | No | - | Total Revenue expected |
Rating |
String(1) | No | - | Classification or Importance |
ReferenceNo |
String(40) | No | - | Your customer or vendor number at the Business Partner's site |
SalesRep_ID |
Table(22) | No | - | Sales Representative or Company Agent |
SalesVolume |
Integer(22) | No | - | Total Volume of Sales in Thousands of Currency |
ShareOfCustomer |
Integer(22) | No | - | Share of Customer's business as a percentage |
SO_CreditLimit |
Amount(22) | Yes | - | Total outstanding invoice amounts allowed |
SO_CreditUsed |
Amount(22) | Yes | - | Current open balance |
SO_Description |
String(255) | No | - | Description to be used on orders |
TaxID |
String(20) | No | - | Tax Identification |
Updated |
Date+Time(7) | Yes | SYSDATE | Date this record was updated |
UpdatedBy |
Search(22) | Yes | - | User who updated this records |
URL |
URL(120) | No | - | URL |
Value |
String(40) | Yes | - | Search key for the record in the format required - must be unique |
Foreign Keys
| Column | References | Description |
|---|---|---|
AD_OrgBP_ID |
AD_OrgBP.AD_OrgBP_ID | The Business Partner is another Organization for explicit Inter-Org transactions |
AD_TenantBP_ID |
AD_TenantBP.AD_TenantBP_ID | The Business Partner is another Tenant for Account Management |
BPartner_Parent_ID |
BPartner_Parent.BPartner_Parent_ID | Business Partner Parent |
C_Business_Entity_ID |
C_Business_Entity.C_Business_Entity_ID | - |
C_Industry_ID |
C_Industry.C_Industry_ID | Define Lead or Business Partners Industry |
C_Location_ID |
C_Location.C_Location_ID | Location or Address |
C_TaxGroup_ID |
C_TaxGroup.C_TaxGroup_ID | - |
CustomerServRep_ID |
CustomerServRep.CustomerServRep_ID | Customer Service Representative or ServiceDesk Agent |
Default1099Box_ID |
Default1099Box.Default1099Box_ID | - |
Invoice_PrintFormat_ID |
Invoice_PrintFormat.Invoice_PrintFormat_ID | Print Format for printing Invoices |
Logo_ID |
Logo.Logo_ID | - |
M_DiscountSchema_ID |
M_DiscountSchema.M_DiscountSchema_ID | Schema to calculate the trade discount percentage |
M_Shipper_ID |
M_Shipper.M_Shipper_ID | Method or manner of product delivery |
PO_DiscountSchema_ID |
PO_DiscountSchema.PO_DiscountSchema_ID | Schema to calculate the purchase trade discount percentage |
PO_PaymentTerm_ID |
PO_PaymentTerm.PO_PaymentTerm_ID | Payment rules for a purchase order |
SalesRep2_ID |
SalesRep2.SalesRep2_ID | Sales Representative or Company Agent |
Shipment_PrintFormat_ID |
Shipment_PrintFormat.Shipment_PrintFormat_ID | Print Format for Shipments, Receipts, Pick Lists |
AD_Client_ID |
AD_Client.AD_Client_ID | Tenant for this installation. |
AD_Org_ID |
AD_Org.AD_Org_ID | Organizational entity within tenant |
C_BP_Group_ID |
C_BP_Group.C_BP_Group_ID | Business Partner Group |
C_Dunning_ID |
C_Dunning.C_Dunning_ID | Dunning Rules for overdue invoices |
C_Greeting_ID |
C_Greeting.C_Greeting_ID | Greeting to print on correspondence |
C_InvoiceSchedule_ID |
C_InvoiceSchedule.C_InvoiceSchedule_ID | Schedule for generating Invoices |
C_PaymentTerm_ID |
C_PaymentTerm.C_PaymentTerm_ID | The terms of Payment (timing, discount) |
M_PriceList_ID |
M_PriceList.M_PriceList_ID | Unique identifier of a Price List |
PO_PriceList_ID |
PO_PriceList.PO_PriceList_ID | Price List used by this Business Partner |
SalesRep_ID |
SalesRep.SalesRep_ID | Sales Representative or Company Agent |
Generated on 2026-05-03T15:21:38.266680408Z