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
ad_user.c_bpartner_id cbpartner_aduser C
c_bpartner.bpartner_parent_id cbpartner_cpbartnerparent R
c_payment.c_bpartner_id cbpartner_cpayment R
c_pos.c_bpartnercashtrx_id cbpartnercashtrx_cpos R
Identifies a Business Partner
ad_client_id numeric 10 Client/Tenant for this installation.
ad_org_id numeric 10 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 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 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 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 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 Schema to calculate the trade discount percentage
c_dunning_id numeric 10  √  null 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 Schema to calculate the purchase trade discount percentage
po_paymentterm_id numeric 10  √  null Payment rules for a purchase order
documentcopies numeric 10  √  null Number of copies to be printed
c_greeting_id numeric 10  √  null 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 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 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 Tax Group
logo_id numeric 10  √  NULL::numeric 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 Default 1099 Box
is1099vendor bpchar 1 'N'::bpchar 1099 Vendor

Table contained 17 rows at 2021-12-25 14:53 +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

Close relationships  within of separation: