Table idempiere9.adempiere.c_bpartner
Identifies a Business Partner

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
c_bpartner_id numeric 10
a_asset.c_bpartner_id cbpartner_aasset R
a_asset.c_bpartnersr_id cbpartnersr_aasset R
a_asset.lease_bpartner_id leasebpartner_aasset R
a_asset_change.c_bpartner_id cbpartner_aassetchange R
a_asset_info_fin.c_bpartner_id cbpartner_aassetinfofin R
a_registration.c_bpartner_id cbpartner_aregistration R
ad_archive.c_bpartner_id cbpartner_adarchive R
ad_clientinfo.c_bpartnercashtrx_id cbpartnercashtrx_adclientinfo R
ad_user.c_bpartner_id cbpartner_aduser C
ad_wf_node.c_bpartner_id cbpartner_adwfnode R
c_acctschema_element.c_bpartner_id cbuspartner_caschemaelement R
c_allocationline.c_bpartner_id cbpartner_callocationline R
c_bankstatementline.c_bpartner_id cbpartner_cbankstatementline R
c_bp_bankaccount.c_bpartner_id cbpartner_cbpbankaccount C
c_bp_customer_acct.c_bpartner_id cbuspartner_cbpcustomer_acct C
c_bp_edi.c_bpartner_id c_bpartner_cbpedi R
c_bp_employee_acct.c_bpartner_id cbuspartner_c_bpemployeeacct C
c_bp_relation.c_bpartner_id cbpartner_cbprelation R
c_bp_relation.c_bpartnerrelation_id cbpartner_cbprelationbp R
c_bp_shippingacct.c_bpartner_id cbpartner_cbpshippingacct R
c_bp_vendor_acct.c_bpartner_id c_buspartner_c_bp_vendor_acct C
c_bp_withholding.c_bpartner_id cbpartner_cbpwithholding C
c_bpartner.bpartner_parent_id cbpartner_cpbartnerparent R
c_bpartner_location.c_bpartner_id cbpartner_cbplocation C
c_bpartner_product.c_bpartner_id cbpartner_cbpproduct C
c_cashplan.c_bpartner_id cbpartner_ccashplan R
c_cashplanline.c_bpartner_id cbpartner_ccashplanline R
c_charge.c_bpartner_id cbpartner_ccharge R
c_commission.c_bpartner_id cbpartner_ccommission R
c_commissionline.c_bpartner_id cbpartner_ccommissionline R
c_dunningrunentry.c_bpartner_id cbpartner_cdunningrunentry R
c_invoice.c_bpartner_id cbpartner_cinvoice R
c_invoicebatchline.c_bpartner_id cbpartner_cinvoicebatchline R
c_opportunity.c_bpartner_id cbpartner_copportunity R
c_order.bill_bpartner_id cbpartnerbill_corder R
c_order.c_bpartner_id cbpartner_corder R
c_order.dropship_bpartner_id dropshipbpartner_corder R
c_order.pay_bpartner_id cbpartnerpay_corder R
c_orderline.c_bpartner_id cbpartner_soline R
c_payment.c_bpartner_id cbpartner_cpayment R
c_paymenttransaction.c_bpartner_id cbpartner_cpaymenttransaction R
c_payselectioncheck.c_bpartner_id cbpartner_cpayselectioncheck R
c_pos.c_bpartnercashtrx_id cbpartnercashtrx_cpos R
c_project.c_bpartner_id cbpartner_cproject R
c_project.c_bpartnersr_id cbpartnersr_cproject R
c_rfq.c_bpartner_id cbpartner_crfq R
c_rfq_topicsubscriber.c_bpartner_id cbpartner_crfqtopicsubr R
c_rfqresponse.c_bpartner_id cbpartner_crfqresponse R
c_subscription.c_bpartner_id cbpartner_csubscription R
c_taxdeclarationline.c_bpartner_id cbpartner_ctaxdeclline R
c_taxdefinition.c_bpartner_id cbpartner_ctaxdefinition R
c_validcombination.c_bpartner_id cbpartner_vc R
c_withholding.beneficiary benefici_cwithholding R
dd_order.c_bpartner_id cbpartner_ddorder R
fact_acct.c_bpartner_id c_buspartner_fact_acct R
fact_acct_summary.c_bpartner_id cbpartner_factacctsummary R
gl_distribution.c_bpartner_id cbpartner_gldist R
gl_distributionline.c_bpartner_id cbpartner_gldistline R
gl_journalgeneratorline.c_bpartner_id cbpartner_qssjournalgeneratorl R
gl_journalline.c_bpartner_id cbpartner_gljournalline R
hr_attribute.c_bpartner_id cbpartner_hrattribute R
hr_contract.c_bpartner_id cbpartner_hrcontract R
hr_employee.c_bpartner_id cbpartner_hremployee R
hr_movement.c_bpartner_id cbpartner_hrmovement R
hr_process.c_bpartner_id cbpartner_hrprocess R
i_asset.c_bpartner_id cbpartner_iasset R
i_bankstatement.c_bpartner_id cbpartner_ibankstatement N
i_bpartner.c_bpartner_id cbpartner_ibpartner N
i_fajournal.c_bpartner_id cbpartner_ifajournal R
i_fixedasset.c_bpartnersr_id cbpartnersr_ifixedasset R
i_gljournal.c_bpartner_id cbpartner_igljournal N
i_hr_movement.c_bpartner_id cbpartner_ihrmovement R
i_invoice.c_bpartner_id cbpartner_iinvoice N
i_movement.c_bpartner_id cbpartner_imovement R
i_order.c_bpartner_id cbpartner_iorder N
i_payment.c_bpartner_id cbpartner_ipayment N
i_pricelist.c_bpartner_id cbpartner_ipricelist R
i_product.c_bpartner_id cbpartner_iproduct N
i_productplanning.c_bpartner_id cbpartner_iproductplanning R
m_bp_price.c_bpartner_id cbpartner_mbpprice R
m_discountschemaline.c_bpartner_id cbpartner_mdiscountsline R
m_distributionlistline.c_bpartner_id cbpartner_mdistlistline R
m_distributionrun.c_bpartner_id cbpartner_mdistributionrun R
m_inout.c_bpartner_id cbpartner_minout R
m_inout.dropship_bpartner_id dropshipbpartner_minout R
m_inout.returnbpartner_id returnbpartner_minout R
m_movement.c_bpartner_id cbpartner_mmovement R
m_product_po.c_bpartner_id c_buspartner_m_product_po R
m_production.c_bpartner_id cbpartner_mproduction R
m_productpricevendorbreak.c_bpartner_id cbpartner_mproductpricevendorb R
m_promotionprecondition.c_bpartner_id cbpartner_mpromotionpreconditi R
m_requisitionline.c_bpartner_id cbpartner_mrequisitionline R
m_rma.c_bpartner_id cbpartner_mrma R
m_shipper.c_bpartner_id cbpartner_mshipper R
m_shippingtransaction.c_bpartner_id cbpartner_mshippingtransaction R
m_shippingtransaction.returnbpartner_id returnbpartner_mshippingtransa R
pa_goalrestriction.c_bpartner_id cbpartner_pagoalrestriction R
pa_reportcolumn.c_bpartner_id cbpartner_pareportcolumn R
pa_reportsource.c_bpartner_id cbpartner_pareportsource R
pa_sla_goal.c_bpartner_id cbpartner_paslagoal R
pp_mrp.c_bpartner_id cbpartner_ppmrp R
pp_order_node.c_bpartner_id cbpartner_ppordernode R
r_request.c_bpartner_id c_bpartner_rrequest R
r_requestaction.c_bpartner_id cbpartner_rrequestaction R
s_timeexpense.c_bpartner_id cbpartner_stimeexpense R
s_timeexpenseline.c_bpartner_id cbpartner_stimeexpenseline R
t_aging.c_bpartner_id cbpartner_taging C
t_distributionrundetail.c_bpartner_id cbpartner_tdrdetail C
u_posterminal.c_cashbpartner_id ccashbpartner_uposterminal R
u_posterminal.c_templatebpartner_id ctemplatebpartner_uposterminal R
w_advertisement.c_bpartner_id cbpartner_wadvertisement R
w_basket.c_bpartner_id cbpartner_wbasket R
w_clickcount.c_bpartner_id cbpartner_wclickcount R
w_countercount.c_bpartner_id cbpartner_wcountercount R
Identifies a Business Partner
ad_client_id numeric 10
ad_client.ad_client_id adclient_cbpartner R
Client/Tenant for this installation.
ad_org_id numeric 10
ad_org.ad_org_id adorg_cbpartner R
Organizational entity within client
isactive bpchar 1 'Y'::bpchar The record is active in the system
created timestamp 29,6 now() Date this record was created
createdby numeric 10 User who created this records
updated timestamp 29,6 now() Date this record was updated
updatedby numeric 10 User who updated this records
value varchar 40 Search key for the record in the format required - must be unique
name varchar 120 Alphanumeric identifier of the entity
name2 varchar 60  √  null Additional Name
description varchar 255  √  null Optional short description of the record
issummary bpchar 1 'N'::bpchar This is a summary entity
c_bp_group_id numeric 10
c_bp_group.c_bp_group_id cbpgroup_cbpartner R
Business Partner Group
isonetime bpchar 1 'N'::bpchar One time transaction
isprospect bpchar 1 'N'::bpchar Indicates this is a Prospect
isvendor bpchar 1 'N'::bpchar Indicates if this Business Partner is a Vendor
iscustomer bpchar 1 'Y'::bpchar Indicates if this Business Partner is a Customer
isemployee bpchar 1 'N'::bpchar Indicates if this Business Partner is an employee
issalesrep bpchar 1 'N'::bpchar Indicates if the business partner is a sales representative or company agent
referenceno varchar 40  √  null Your customer or vendor number at the Business Partner's site
duns varchar 11  √  null Dun & Bradstreet Number
url varchar 120  √  null Full URL address - e.g. http://www.idempiere.org
ad_language varchar 6  √  null
ad_language.ad_language ad_language_c_buspartner R
Language for this entity
taxid varchar 20  √  null Tax Identification
istaxexempt bpchar 1  √  'N'::bpchar Business partner is exempt from tax on sales
c_invoiceschedule_id numeric 10  √  null
c_invoiceschedule.c_invoiceschedule_id cinvoiceschedule_cbpartner R
Schedule for generating Invoices
rating bpchar 1  √  null Classification or Importance
salesvolume numeric 10  √  null Total Volume of Sales in Thousands of Currency
numberemployees numeric 10  √  null Number of employees
naics varchar 6  √  null Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
firstsale timestamp 29,6  √  null Date of First Sale
acqusitioncost numeric 0  √  0 The cost of gaining the prospect as a customer
potentiallifetimevalue numeric 0  √  0 Total Revenue expected
actuallifetimevalue numeric 0  √  0 Actual Life Time Revenue
shareofcustomer numeric 10  √  null Share of Customer's business as a percentage
paymentrule bpchar 1  √  null How you pay the invoice
so_creditlimit numeric 0  √  0 Total outstanding invoice amounts allowed
so_creditused numeric 0  √  0 Current open balance
c_paymentterm_id numeric 10  √  null
c_paymentterm.c_paymentterm_id cpaymentterm_cbpartner R
The terms of Payment (timing, discount)
m_pricelist_id numeric 10  √  null
m_pricelist.m_pricelist_id mpricelist_cbpartner N
Unique identifier of a Price List
m_discountschema_id numeric 10  √  null
m_discountschema.m_discountschema_id mdiscounts_cbpartner R
Schema to calculate the trade discount percentage
c_dunning_id numeric 10  √  null
c_dunning.c_dunning_id cdunning_cbpartner R
Dunning Rules for overdue invoices
isdiscountprinted bpchar 1  √  'Y'::bpchar Print Discount on Invoice and Order
so_description varchar 255  √  null Description to be used on orders
poreference varchar 20  √  null Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
paymentrulepo bpchar 1  √  null Purchase payment option
po_pricelist_id numeric 10  √  null
m_pricelist.m_pricelist_id mpricelistpo_cbuspartner N
Price List used by this Business Partner
po_discountschema_id numeric 10  √  null
m_discountschema.m_discountschema_id mdiscountspo_cbpartner R
Schema to calculate the purchase trade discount percentage
po_paymentterm_id numeric 10  √  null
c_paymentterm.c_paymentterm_id cpopaymentterm_cbpartner R
Payment rules for a purchase order
documentcopies numeric 10  √  null Number of copies to be printed
c_greeting_id numeric 10  √  null
c_greeting.c_greeting_id cgreeting_cbpartner R
Greeting to print on correspondence
invoicerule bpchar 1  √  null Frequency and method of invoicing
deliveryrule bpchar 1  √  null Defines the timing of Delivery
freightcostrule bpchar 1  √  null Method for charging Freight
deliveryviarule bpchar 1  √  null How the order will be delivered
salesrep_id numeric 10  √  null
ad_user.ad_user_id adusersalesrep_cbpartner N
Sales Representative or Company Agent
sendemail bpchar 1 'N'::bpchar Enable sending Document EMail
bpartner_parent_id numeric 10  √  null
c_bpartner.c_bpartner_id cbpartner_cpbartnerparent R
Business Partner Parent
invoice_printformat_id numeric 10  √  null
ad_printformat.ad_printformat_id adprintformatinv_cbpartner R
Print Format for printing Invoices
socreditstatus bpchar 1  √  'O'::bpchar Business Partner Credit Status
shelflifeminpct numeric 10  √  null Minimum Shelf Life in percent based on Product Instance Guarantee Date
ad_orgbp_id numeric 10  √  null
ad_org.ad_org_id adorg_cbpartnerorg R
The Business Partner is another Organization for explicit Inter-Org transactions
flatdiscount numeric 0  √  null Flat discount percentage
totalopenbalance numeric 0  √  null Total Open Balance Amount in primary Accounting Currency
dunninggrace timestamp 29,6  √  null Dunning Grace Date
c_taxgroup_id numeric 10  √  null
c_taxgroup.c_taxgroup_id ctaxgroup_cbpartner R
Tax Group
logo_id numeric 10  √  NULL::numeric
ad_image.ad_image_id logo_cbpartner R
Logo
ispotaxexempt bpchar 1 'N'::bpchar Business partner is exempt from tax on purchases
ismanufacturer bpchar 1  √  'N'::bpchar Indicate role of this Business partner as Manufacturer
c_bpartner_uu varchar 36  √  NULL::character varying C_BPartner_UU
customerprofileid varchar 60  √  NULL::character varying Customer Profile ID
default1099box_id numeric 10  √  NULL::numeric
c_1099box.c_1099box_id default1099box_cbpartner R
Default 1099 Box
is1099vendor bpchar 1 'N'::bpchar 1099 Vendor

Table contained 17 rows at 2021-12-25 14:43 +0100

Indexes:
Column(s) Type Sort Constraint Name
c_bpartner_id Primary key Asc c_bpartner_pkey
ad_orgbp_id Performance Asc c_bpartner_bporg
name Performance Asc c_bpartner_name
c_bpartner_uu Must be unique Asc c_bpartner_uu_idx
ad_client_id + value Must be unique Asc/Asc c_bpartner_value


SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.