BPartner Group

C_BP_Group

Business Partner Group

Overview

Table NameC_BP_Group
Access LevelSystem + Client
Entity TypeD
Is DocumentNo
Is ViewNo
Has UUIDYes
Parent TableAD_PrintColor
WikiView on iDempiere Wiki

Columns (27)

Column Type Required Default Description
AD_PrintColor_ID Table Direct(22) No - Color used for printing and display
C_Business_Entity_ID Table Direct(10) No - -
C_TaxGroup_ID Table Direct(10) No - -
IsDiscountPrinted Yes-No(1) Yes Y Print Discount on Invoice and Order
SalesRep_ID Table(10) No - Sales Representative or Company Agent
Name String(60) Yes - Alphanumeric identifier of the entity
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
C_BP_Group_ID ID(22) Yes - Business Partner Group
C_BP_Group_UU String(36) No - -
C_Dunning_ID Table Direct(10) No - Dunning Rules for overdue invoices
Created Date+Time(7) Yes SYSDATE Date this record was created
CreatedBy Search(22) Yes - User who created this records
CreditWatchPercent Number(22) No - Credit Watch - Percent of Credit Limit when OK switches to Watch
Description String(255) No - Optional short description of the record
IsActive Yes-No(1) Yes Y The record is active in the system
IsConfidentialInfo Yes-No(1) Yes N Can enter confidential information
IsDefault Yes-No(1) Yes - Default value
M_DiscountSchema_ID Search(10) No - Schema to calculate the trade discount percentage
M_PriceList_ID Table Direct(10) No - Unique identifier of a Price List
PO_DiscountSchema_ID Search(10) No - Schema to calculate the purchase trade discount percentage
PO_PriceList_ID Table(10) No - Price List used by this Business Partner
PriceMatchTolerance Number(22) No - PO-Invoice Match Price Tolerance in percent of the purchase price
PriorityBase List(1) No - Base of Priority
Updated Date+Time(7) Yes SYSDATE Date this record was updated
UpdatedBy Search(22) Yes - User who updated this records
Value String(40) Yes - Search key for the record in the format required - must be unique

Foreign Keys

Column References Description
AD_PrintColor_ID AD_PrintColor.AD_PrintColor_ID Color used for printing and display
C_Business_Entity_ID C_Business_Entity.C_Business_Entity_ID -
C_TaxGroup_ID C_TaxGroup.C_TaxGroup_ID -
SalesRep_ID SalesRep.SalesRep_ID Sales Representative or Company Agent
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_Dunning_ID C_Dunning.C_Dunning_ID Dunning Rules for overdue invoices
M_DiscountSchema_ID M_DiscountSchema.M_DiscountSchema_ID Schema to calculate the trade discount percentage
M_PriceList_ID M_PriceList.M_PriceList_ID Unique identifier of a Price List
PO_DiscountSchema_ID PO_DiscountSchema.PO_DiscountSchema_ID Schema to calculate the purchase trade discount percentage
PO_PriceList_ID PO_PriceList.PO_PriceList_ID Price List used by this Business Partner

Generated on 2026-05-03T16:41:11.859706986Z