idempiere9.adempiere contains 91 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
c_bpartner	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_locator	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
m_locator	isdefault	bpchar	1			'N'::bpchar	Default value
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
c_bpartner	acqusitioncost	numeric	0	√		0	The cost of gaining the prospect as a customer
c_bpartner	actuallifetimevalue	numeric	0	√		0	Actual Life Time Revenue
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
m_locator	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
m_locator	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_bpartner	createdby	numeric	10				User who created this records
m_locator	createdby	numeric	10				User who created this records
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_locator	m_locator_id	numeric	10				Warehouse Locator
m_locator	m_locatortype_id	numeric	10	√		NULL::numeric	Locator Type
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_locator	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
m_locator	priorityno	numeric	10				Where inventory should be picked from first
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner	updatedby	numeric	10				User who updated this records
m_locator	updatedby	numeric	10				User who updated this records
c_bpartner	created	timestamp	29,6			now()	Date this record was created
m_locator	created	timestamp	29,6			now()	Date this record was created
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
m_locator	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
m_locator	m_locator_uu	varchar	36	√		NULL::character varying	M_Locator_UU
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_locator	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
c_bpartner	name2	varchar	60	√		null	Additional Name
m_locator	x	varchar	60	√		null	X dimension, e.g., Aisle
m_locator	y	varchar	60	√		null	Y dimension, e.g., Bin
m_locator	z	varchar	60	√		null	Z dimension, e.g., Level
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders