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

Table	Column	Type	Size	Nulls	Auto	Default
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
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	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_discountschema	ad_client_id	numeric	10				Client/Tenant for this installation.
m_discountschemabreak	ad_client_id	numeric	10				Client/Tenant for this installation.
m_discountschemaline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist_version	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_category	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_po	ad_client_id	numeric	10				Client/Tenant for this installation.
m_productprice	ad_client_id	numeric	10				Client/Tenant for this installation.
m_productpricevendorbreak	ad_client_id	numeric	10				Client/Tenant for this installation.
m_promotion	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
m_promotiondistribution	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
m_promotiongroup	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
m_promotiongroupline	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
m_promotionline	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
m_promotionprecondition	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
m_promotionreward	ad_client_id	numeric	10			NULL::numeric	Client/Tenant for this installation.
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_bpartner_product	ad_org_id	numeric	10				Organizational entity within client
m_discountschema	ad_org_id	numeric	10				Organizational entity within client
m_discountschemabreak	ad_org_id	numeric	10				Organizational entity within client
m_discountschemaline	ad_org_id	numeric	10				Organizational entity within client
m_pricelist	ad_org_id	numeric	10				Organizational entity within client
m_pricelist_version	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_product_category	ad_org_id	numeric	10				Organizational entity within client
m_product_po	ad_org_id	numeric	10				Organizational entity within client
m_productprice	ad_org_id	numeric	10				Organizational entity within client
m_productpricevendorbreak	ad_org_id	numeric	10				Organizational entity within client
m_promotion	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
m_promotiondistribution	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
m_promotiongroup	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
m_promotiongroupline	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
m_promotionline	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
m_promotionprecondition	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
m_promotionreward	ad_org_id	numeric	10			NULL::numeric	Organizational entity within client
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
m_promotionreward	amount	numeric	0	√		null	Amount in a defined currency
m_pricelist	basepricelist_id	numeric	10	√		null	Pricelist to be used, if product not found on this pricelist
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
m_discountschemabreak	breakdiscount	numeric	0				Trade Discount in Percent for the break level
m_discountschemabreak	breakvalue	numeric	0				Low Value of trade discount break level
m_productpricevendorbreak	breakvalue	numeric	0				Low Value of trade discount break level
m_promotionprecondition	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
m_promotionprecondition	c_bp_group_id	numeric	10	√		null	Business Partner Group
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_bpartner_product	c_bpartner_id	numeric	10				Identifies a Business Partner
m_discountschemaline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_product_po	c_bpartner_id	numeric	10				Identifies a Business Partner
m_productpricevendorbreak	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_promotionprecondition	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner_product	c_bpartner_product_uu	varchar	36	√		NULL::character varying	C_BPartner_Product_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
m_promotion	c_campaign_id	numeric	10	√		NULL::numeric	Marketing Campaign
m_promotionreward	c_charge_id	numeric	10	√		null	Additional document charges
m_discountschemaline	c_conversiontype_id	numeric	10				Currency Conversion Rate Type
m_pricelist	c_currency_id	numeric	10				The Currency for this record
m_product_po	c_currency_id	numeric	10	√		null	The Currency for this record
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)
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
m_product	c_uom_id	numeric	10				Unit of Measure
m_product_po	c_uom_id	numeric	10	√		null	Unit of Measure
m_discountschemaline	classification	varchar	12	√		null	Classification for grouping
m_product	classification	varchar	12	√		null	Classification for grouping
m_discountschemaline	conversiondate	timestamp	29,6				Date for selecting conversion rate
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_product_po	costperorder	numeric	0	√		0	Fixed Cost Per Order
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_bpartner_product	created	timestamp	29,6			now()	Date this record was created
m_discountschema	created	timestamp	29,6			now()	Date this record was created
m_discountschemabreak	created	timestamp	29,6			now()	Date this record was created
m_discountschemaline	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_pricelist_version	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_category	created	timestamp	29,6			now()	Date this record was created
m_product_po	created	timestamp	29,6			now()	Date this record was created
m_productprice	created	timestamp	29,6			now()	Date this record was created
m_productpricevendorbreak	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_promotion	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_promotiondistribution	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_promotiongroup	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_promotiongroupline	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_promotionline	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_promotionprecondition	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_promotionreward	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_bpartner	createdby	numeric	10				User who created this records
c_bpartner_product	createdby	numeric	10				User who created this records
m_discountschema	createdby	numeric	10				User who created this records
m_discountschemabreak	createdby	numeric	10				User who created this records
m_discountschemaline	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_pricelist_version	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_category	createdby	numeric	10				User who created this records
m_product_po	createdby	numeric	10				User who created this records
m_productprice	createdby	numeric	10				User who created this records
m_productpricevendorbreak	createdby	numeric	10				User who created this records
m_promotion	createdby	numeric	10				User who created this records
m_promotiondistribution	createdby	numeric	10				User who created this records
m_promotiongroup	createdby	numeric	10				User who created this records
m_promotiongroupline	createdby	numeric	10				User who created this records
m_promotionline	createdby	numeric	10				User who created this records
m_promotionprecondition	createdby	numeric	10				User who created this records
m_promotionreward	createdby	numeric	10				User who created this records
m_discountschema	cumulativelevel	bpchar	1	√		null	Level for accumulative calculations
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
m_product_po	deliverytime_actual	numeric	10	√		null	Actual days between order and delivery
m_product_po	deliverytime_promised	numeric	10	√		null	Promised days between order and delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_bpartner_product	description	varchar	255	√		null	Optional short description of the record
m_discountschema	description	varchar	255	√		null	Optional short description of the record
m_discountschemaline	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_pricelist	description	varchar	255	√		null	Optional short description of the record
m_pricelist_version	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_promotion	description	varchar	255	√		null	Optional short description of the record
m_promotiongroup	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product_po	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product_po	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
m_product_po	discontinuedby	timestamp	29,6	√		null
m_discountschema	discounttype	bpchar	1				Type of trade discount calculation
m_promotiondistribution	distributionsorting	bpchar	1	√		null	Quantity distribution sorting by unit price
m_promotionreward	distributionsorting	bpchar	1	√		null	Quantity distribution sorting by unit price
m_promotiondistribution	distributiontype	bpchar	1				Type of quantity distribution calculation using comparison qty and order qty as operand
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
m_promotionprecondition	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
m_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
m_discountschema	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_discountschemaline	group1	varchar	255	√		null	Group1
m_product	group1	varchar	255	√		null	Group1
m_discountschemaline	group2	varchar	255	√		null	Group2
m_product	group2	varchar	255	√		null	Group2
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
m_product	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
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
c_bpartner_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_discountschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_discountschemabreak	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_discountschemaline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist_version	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_po	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_productprice	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_productpricevendorbreak	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_promotion	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_promotiondistribution	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_promotiongroup	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_promotiongroupline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_promotionline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_promotionprecondition	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_promotionreward	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
m_discountschema	isbpartnerflatdiscount	bpchar	1			'N'::bpchar	Use flat discount defined on Business Partner Level
m_discountschemabreak	isbpartnerflatdiscount	bpchar	1			'N'::bpchar	Use flat discount defined on Business Partner Level
m_product_po	iscurrentvendor	bpchar	1			'Y'::bpchar	Use this Vendor for pricing and stock replenishment
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
c_bpartner	isemployee	bpchar	1			'N'::bpchar	Indicates if this Business Partner is an employee
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
m_promotionreward	isforalldistribution	bpchar	1			'N'::bpchar	This reward is for all distribution
m_discountschemaline	isignoreiscurrentvendor	bpchar	1			'N'::bpchar	take all PO prices into account
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
m_pricelist	ismandatory	bpchar	1	√		'N'::bpchar	Data entry is required in this column
m_promotionline	ismandatorypl	bpchar	1			'Y'::bpchar	Order must have this promotion line
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
c_bpartner_product	ismanufacturer	bpchar	1			'N'::bpchar	Indicate role of this Business partner as Manufacturer
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	isPresentForProduct
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
m_discountschema	isquantitybased	bpchar	1			'Y'::bpchar	Trade discount break level based on Quantity (not value)
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
m_promotionreward	issamedistribution	bpchar	1	√		'Y'::bpchar	Use the same distribution for source and target
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product_category	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	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
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_product	istoformule	bpchar	1	√		null
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
m_discountschemaline	limit_addamt	numeric	0			0	Amount added to the converted/copied price before multiplying
m_discountschemaline	limit_base	bpchar	1				Base price for calculation of the new price
m_discountschemaline	limit_discount	numeric	0				Discount in percent to be subtracted from base, if negative it will be added to base price
m_discountschemaline	limit_fixed	numeric	0	√		0	Fixed Limit Price (not calculated)
m_discountschemaline	limit_maxamt	numeric	0			0	Maximum difference to original limit price; ignored if zero
m_discountschemaline	limit_minamt	numeric	0			0	Minimum difference to original limit price; ignored if zero
m_discountschemaline	limit_rounding	bpchar	1				Rounding of the final result
m_discountschemaline	list_addamt	numeric	0			0	List Price Surcharge Amount
m_discountschemaline	list_base	bpchar	1				Price used as the basis for price list calculations
m_discountschemaline	list_discount	numeric	0				Discount from list price as a percentage
m_discountschemaline	list_fixed	numeric	0	√		0	Fixes List Price (not calculated)
m_discountschemaline	list_maxamt	numeric	0			0	Maximum margin for a product
m_discountschemaline	list_minamt	numeric	0			0	Minimum margin for a product
m_discountschemaline	list_rounding	bpchar	1				Rounding rule for final list price
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_discountschema	m_discountschema_id	numeric	10				Schema to calculate the trade discount percentage
m_discountschemabreak	m_discountschema_id	numeric	10				Schema to calculate the trade discount percentage
m_discountschemaline	m_discountschema_id	numeric	10				Schema to calculate the trade discount percentage
m_pricelist_version	m_discountschema_id	numeric	10				Schema to calculate the trade discount percentage
m_discountschema	m_discountschema_uu	varchar	36	√		NULL::character varying	M_DiscountSchema_UU
m_discountschemabreak	m_discountschemabreak_id	numeric	10				Trade Discount Break
m_discountschemabreak	m_discountschemabreak_uu	varchar	36	√		NULL::character varying	M_DiscountSchemaBreak_UU
m_discountschemaline	m_discountschemaline_id	numeric	10				Line of the pricelist trade discount schema
m_discountschemaline	m_discountschemaline_uu	varchar	36	√		NULL::character varying	M_DiscountSchemaLine_UU
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist_version	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_promotionprecondition	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
m_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
m_pricelist_version	m_pricelist_version_base_id	numeric	10	√		null	Source for Price list calculations
m_pricelist_version	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_productprice	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_productpricevendorbreak	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_pricelist_version	m_pricelist_version_uu	varchar	36	√		NULL::character varying	M_PriceList_Version_UU
m_discountschemabreak	m_product_category_id	numeric	10	√		null	Category of a Product
m_discountschemaline	m_product_category_id	numeric	10	√		null	Category of a Product
m_product	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
c_bpartner_product	m_product_id	numeric	10				Product, Service, Item
m_discountschemabreak	m_product_id	numeric	10	√		null	Product, Service, Item
m_discountschemaline	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_product_po	m_product_id	numeric	10				Product, Service, Item
m_productprice	m_product_id	numeric	10				Product, Service, Item
m_productpricevendorbreak	m_product_id	numeric	10				Product, Service, Item
m_promotiongroupline	m_product_id	numeric	10				Product, Service, Item
m_product_po	m_product_po_uu	varchar	36	√		NULL::character varying	M_Product_PO_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_productprice	m_productprice_id	numeric	10			NULL::numeric	Intersection between a Product and a Price List Version
m_productprice	m_productprice_uu	varchar	36	√		NULL::character varying	M_ProductPrice_UU
m_productpricevendorbreak	m_productpricevendorbreak_id	numeric	10				Product Price Break
m_productpricevendorbreak	m_productpricevendorbreak_uu	varchar	36	√		NULL::character varying	M_ProductPriceVendorBreak_UU
m_promotion	m_promotion_id	numeric	10				Promotion
m_promotiondistribution	m_promotion_id	numeric	10				Promotion
m_promotionline	m_promotion_id	numeric	10				Promotion
m_promotionprecondition	m_promotion_id	numeric	10				Promotion
m_promotionreward	m_promotion_id	numeric	10				Promotion
m_promotion	m_promotion_uu	varchar	36	√		NULL::character varying	M_Promotion_UU
m_promotiondistribution	m_promotiondistribution_id	numeric	10				Promotion Distribution
m_promotionreward	m_promotiondistribution_id	numeric	10	√		null	Promotion Distribution
m_promotiondistribution	m_promotiondistribution_uu	varchar	36	√		NULL::character varying	M_PromotionDistribution_UU
m_promotiongroup	m_promotiongroup_id	numeric	10				Promotion Group
m_promotiongroupline	m_promotiongroup_id	numeric	10				Promotion Group
m_promotionline	m_promotiongroup_id	numeric	10	√		null	Promotion Group
m_promotiongroup	m_promotiongroup_uu	varchar	36	√		NULL::character varying	M_PromotionGroup_UU
m_promotiongroupline	m_promotiongroupline_id	numeric	10				Promotion Group Line
m_promotiongroupline	m_promotiongroupline_uu	varchar	36	√		NULL::character varying	M_PromotionGroupLine_UU
m_promotiondistribution	m_promotionline_id	numeric	10				Promotion Line
m_promotionline	m_promotionline_id	numeric	10				Promotion Line
m_promotionline	m_promotionline_uu	varchar	36	√		NULL::character varying	M_PromotionLine_UU
m_promotionprecondition	m_promotionprecondition_id	numeric	10				Promotion Pre Condition
m_promotionprecondition	m_promotionprecondition_uu	varchar	36	√		NULL::character varying	M_PromotionPreCondition_UU
m_promotionreward	m_promotionreward_id	numeric	10				Promotion Reward
m_promotionreward	m_promotionreward_uu	varchar	36	√		NULL::character varying	M_PromotionReward_UU
m_promotionreward	m_targetdistribution_id	numeric	10	√		null	Get product from target distribution to apply the promotion reward
m_promotionprecondition	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
c_bpartner_product	manufacturer	varchar	30	√		null	Manufacturer of the Product
m_product_po	manufacturer	varchar	30	√		null	Manufacturer of the Product
m_promotionline	minimumamt	numeric	0	√		null	Minimum Amount in Document Currency
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
m_discountschema	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist_version	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_product_category	name	varchar	60				Alphanumeric identifier of the entity
m_promotion	name	varchar	60				Alphanumeric identifier of the entity
m_promotiongroup	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
m_promotiondistribution	operation	varchar	2				Compare Operation
m_product_po	order_min	numeric	0	√		0	Minimum order quantity in UOM
m_product_po	order_pack	numeric	0	√		0	Package order size in UOM (e.g. order set of 5 units)
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
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
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
m_product_po	priceeffective	timestamp	29,6	√		null	Effective Date of Price
m_product_po	pricelastinv	numeric	0	√		0	Price of the last invoice for the product
m_product_po	pricelastpo	numeric	0	√		0	Price of the last purchase order for the product
m_productprice	pricelimit	numeric	0			0	Lowest price for a product
m_productpricevendorbreak	pricelimit	numeric	0				Lowest price for a product
m_product_po	pricelist	numeric	0	√		0	List Price
m_productprice	pricelist	numeric	0			0	List Price
m_productpricevendorbreak	pricelist	numeric	0				List Price
m_product_po	pricepo	numeric	0	√		0	Price based on a purchase order
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
m_productprice	pricestd	numeric	0			0	Standard Price
m_productpricevendorbreak	pricestd	numeric	0				Standard Price
m_pricelist_version	proccreate	bpchar	1	√		null	Create
m_discountschema	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
m_promotionprecondition	promotioncode	varchar	30	√		null	User entered promotion code at sales time
m_promotionprecondition	promotioncounter	numeric	10	√		0	Usage counter
m_promotion	promotionpriority	numeric	10			0	Which promotion should be apply to a product
m_promotionprecondition	promotionusagelimit	numeric	10	√		0	Maximum usage limit
m_promotiondistribution	qty	numeric	0			0	Quantity
m_promotionreward	qty	numeric	0	√		null	Quantity
c_bpartner_product	qualityrating	numeric	0	√		null	Method for rating vendors
m_product_po	qualityrating	numeric	0	√		null	Method for rating vendors
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
m_promotionreward	rewardtype	bpchar	1				Type of reward which consists of percentage discount, flat discount or absolute amount
m_product_po	royaltyamt	numeric	0	√		0	(Included) Amount for copyright, etc.
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_bpartner	salesvolume	numeric	10	√		null	Total Volume of Sales in Thousands of Currency
m_discountschema	script	varchar	2000	√		null	Dynamic Java Language Script to calculate result
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_discountschemabreak	seqno	numeric	10				Method of ordering records; lowest number comes first
m_discountschemaline	seqno	numeric	10				Method of ordering records; lowest number comes first
m_promotiondistribution	seqno	numeric	10			NULL::numeric	Method of ordering records; lowest number comes first
m_promotionprecondition	seqno	numeric	10			0	Method of ordering records; lowest number comes first
m_promotionreward	seqno	numeric	10			NULL::numeric	Method of ordering records; lowest number comes first
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner_product	shelflifemindays	numeric	10				Minimum Shelf Life in days based on Product Instance Guarantee Date
c_bpartner	shelflifeminpct	numeric	10	√		null	Minimum Shelf Life in percent based on Product Instance Guarantee Date
c_bpartner_product	shelflifeminpct	numeric	10				Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_product	shelfwidth	numeric	10	√		null	Shelf width required
m_product	sku	varchar	30	√		null	Stock Keeping Unit
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
m_promotionprecondition	startdate	timestamp	29,6				First effective day (inclusive)
m_discountschemaline	std_addamt	numeric	0			0	Amount added to a price as a surcharge
m_discountschemaline	std_base	bpchar	1				Base price for calculating new standard price
m_discountschemaline	std_discount	numeric	0				Discount percentage to subtract from base price
m_discountschemaline	std_fixed	numeric	0	√		0	Fixed Standard Price (not calculated)
m_discountschemaline	std_maxamt	numeric	0			0	Maximum margin allowed for a product
m_discountschemaline	std_minamt	numeric	0			0	Minimum margin allowed for a product
m_discountschemaline	std_rounding	bpchar	1				Rounding rule for calculated price
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
m_product_po	upc	varchar	20	√		null	Bar Code (Universal Product Code or its superset European Article Number)
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner_product	updated	timestamp	29,6			now()	Date this record was updated
m_discountschema	updated	timestamp	29,6			now()	Date this record was updated
m_discountschemabreak	updated	timestamp	29,6			now()	Date this record was updated
m_discountschemaline	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist_version	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_category	updated	timestamp	29,6			now()	Date this record was updated
m_product_po	updated	timestamp	29,6			now()	Date this record was updated
m_productprice	updated	timestamp	29,6			now()	Date this record was updated
m_productpricevendorbreak	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_promotion	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_promotiondistribution	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_promotiongroup	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_promotiongroupline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_promotionline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_promotionprecondition	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_promotionreward	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_bpartner	updatedby	numeric	10				User who updated this records
c_bpartner_product	updatedby	numeric	10				User who updated this records
m_discountschema	updatedby	numeric	10				User who updated this records
m_discountschemabreak	updatedby	numeric	10				User who updated this records
m_discountschemaline	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_pricelist_version	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_category	updatedby	numeric	10				User who updated this records
m_product_po	updatedby	numeric	10				User who updated this records
m_productprice	updatedby	numeric	10				User who updated this records
m_productpricevendorbreak	updatedby	numeric	10				User who updated this records
m_promotion	updatedby	numeric	10				User who updated this records
m_promotiondistribution	updatedby	numeric	10				User who updated this records
m_promotiongroup	updatedby	numeric	10				User who updated this records
m_promotiongroupline	updatedby	numeric	10				User who updated this records
m_promotionline	updatedby	numeric	10				User who updated this records
m_promotionprecondition	updatedby	numeric	10				User who updated this records
m_promotionreward	updatedby	numeric	10				User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
m_discountschema	validfrom	timestamp	29,6				Valid from including this date (first day)
m_pricelist_version	validfrom	timestamp	29,6				Valid from including this date (first day)
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	40				Search key for the record in the format required - must be unique
m_product_category	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner_product	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
m_discountschemaline	vendorcategory	varchar	30	√		NULL::character varying	Product Category of the Business Partner
m_product_po	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
c_bpartner_product	vendorproductno	varchar	30	√		null	Product Key of the Business Partner
m_product_po	vendorproductno	varchar	40				Product Key of the Business Partner
m_product	versionno	varchar	20	√		null	Version Number
m_product	volume	numeric	0	√		0	Volume of a product
m_product	weight	numeric	0	√		0	Weight of a product