idempiere9.adempiere contains 300 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
m_product_bom	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
m_product_bom	ad_org_id	numeric	10	√		null	Organizational entity within client
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
m_product_bom	bomqty	numeric	0	√		null	Bill of Materials Quantity
m_product_bom	bomtype	varchar	2147483647	√		null	Type of BOM
m_productpricevendorbreak	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_product_po	c_currency_id	numeric	10	√		null	The Currency for this record
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_uom_conversion	c_uom_conversion_uu	varchar	36	√		NULL::character varying	C_UOM_Conversion_UU
m_product_po	c_uom_id	numeric	10	√		null	Unit of Measure
c_uom	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
m_product	classification	varchar	12	√		null	Classification for grouping
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_product_po	costperorder	numeric	0	√		0	Fixed Cost Per Order
m_product_bom	created	timestamp	29,6	√		null	Date this record was created
m_product_bom	createdby	numeric	10	√		null	User who created this records
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
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_uom	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_bom	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_product_trl	description	varchar	255	√		null	Optional short description of the record
m_relatedproduct	description	varchar	255	√		null	Optional short description of the record
m_substitute	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_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product_trl	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
m_product	group1	varchar	255	√		null	Group1
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
m_product_bom	isactive	bpchar	1	√		null	The record is active in the system
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	istoformule	bpchar	1	√		null
m_product_bom	line	numeric	10	√		null	Unique line for this document
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_replenish	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
m_product_acct	m_product_acct_uu	varchar	36	√		NULL::character varying	M_Product_Acct_UU
m_product_bom	m_product_bom_id	numeric	10	√		null	BOM Line
m_product_bom	m_product_bom_uu	varchar	36	√		null	M_Product_BOM_UU
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_uom_conversion	m_product_id	numeric	10	√		null	Product, Service, Item
m_product_bom	m_product_id	numeric	10	√		null	Product, Service, Item
m_product_po	m_product_po_uu	varchar	36	√		NULL::character varying	M_Product_PO_UU
m_product_trl	m_product_trl_uu	varchar	36	√		NULL::character varying	M_Product_Trl_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_product_bom	m_productbom_id	numeric	10	√		null	Bill of Material Component Product
m_productdownload	m_productdownload_uu	varchar	36	√		NULL::character varying	M_ProductDownload_UU
m_productprice	m_productprice_uu	varchar	36	√		NULL::character varying	M_ProductPrice_UU
m_productpricevendorbreak	m_productpricevendorbreak_uu	varchar	36	√		NULL::character varying	M_ProductPriceVendorBreak_UU
m_relatedproduct	m_relatedproduct_uu	varchar	36	√		NULL::character varying	M_RelatedProduct_UU
m_replenish	m_replenish_uu	varchar	36	√		NULL::character varying	M_Replenish_UU
m_substitute	m_substitute_uu	varchar	36	√		NULL::character varying	M_Substitute_UU
m_replenish	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
m_product_po	manufacturer	varchar	30	√		null	Manufacturer of the Product
m_substitute	name	varchar	60	√		null	Alphanumeric identifier of the entity
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)
m_product_acct	p_averagecostvariance_acct	numeric	10	√		NULL::numeric	Average Cost Variance
m_product_acct	p_burden_acct	numeric	10	√		null	The Burden account is the account used Manufacturing Order
m_product_acct	p_costadjustment_acct	numeric	10	√		null	Product Cost Adjustment Account
m_product_acct	p_costofproduction_acct	numeric	10	√		null	The Cost Of Production account is the account used Manufacturing Order
m_product_acct	p_floorstock_acct	numeric	10	√		null	The Floor Stock account is the account used Manufacturing Order
m_product_acct	p_inventoryclearing_acct	numeric	10	√		null	Product Inventory Clearing Account
m_product_acct	p_labor_acct	numeric	10	√		null	The Labor account is the account used Manufacturing Order
m_product_acct	p_landedcostclearing_acct	numeric	10	√		NULL::numeric	Product Landed Cost Clearing Account
m_product_acct	p_methodchangevariance_acct	numeric	10	√		null	The Method Change Variance account is the account used Manufacturing Order
m_product_acct	p_mixvariance_acct	numeric	10	√		null	The Mix Variance account is the account used Manufacturing Order
m_product_acct	p_outsideprocessing_acct	numeric	10	√		null	The Outside Processing Account is the account used in Manufacturing Order
m_product_acct	p_overhead_acct	numeric	10	√		null	The Overhead account is the account used in Manufacturing Order
m_product_acct	p_ratevariance_acct	numeric	10	√		null	The Rate Variance account is the account used Manufacturing Order
m_product_acct	p_scrap_acct	numeric	10	√		null	The Scrap account is the account used in Manufacturing Order
m_product_acct	p_usagevariance_acct	numeric	10	√		null	The Usage Variance account is the account used Manufacturing Order
m_product_acct	p_wip_acct	numeric	10	√		null	The Work in Process account is the account used Manufacturing Order
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_product_po	pricelist	numeric	0	√		0	List Price
m_product_po	pricepo	numeric	0	√		0	Price based on a purchase order
m_product	processing	bpchar	1	√		null	Process Now
m_replenish	qtybatchsize	numeric	0	√		null	Qty Batch Size
m_product_po	qualityrating	numeric	0	√		null	Method for rating vendors
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
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
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
m_product	shelfwidth	numeric	10	√		null	Shelf width required
m_product	sku	varchar	30	√		null	Stock Keeping Unit
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
c_uom	uomsymbol	varchar	10	√		null	Symbol for a Unit of Measure
c_uom	uomtype	varchar	2	√		NULL::character varying	UOM Type
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)
m_product_bom	updated	timestamp	29,6	√		null	Date this record was updated
m_product_bom	updatedby	numeric	10	√		null	User who updated this records
m_product_po	vendorcategory	varchar	30	√		null	Product Category 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
c_uom	ad_client_id	numeric	10				Client/Tenant for this installation.
c_uom_conversion	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_acct	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_product_trl	ad_client_id	numeric	10				Client/Tenant for this installation.
m_productdownload	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_relatedproduct	ad_client_id	numeric	10				Client/Tenant for this installation.
m_replenish	ad_client_id	numeric	10				Client/Tenant for this installation.
m_substitute	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_trl	ad_language	varchar	6				Language for this entity
c_uom	ad_org_id	numeric	10				Organizational entity within client
c_uom_conversion	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_product_acct	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_product_trl	ad_org_id	numeric	10				Organizational entity within client
m_productdownload	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_relatedproduct	ad_org_id	numeric	10				Organizational entity within client
m_replenish	ad_org_id	numeric	10				Organizational entity within client
m_substitute	ad_org_id	numeric	10				Organizational entity within client
m_productpricevendorbreak	breakvalue	numeric	0				Low Value of trade discount break level
m_product_acct	c_acctschema_id	numeric	10				Rules for accounting
m_product_po	c_bpartner_id	numeric	10				Identifies a Business Partner
m_product	c_taxcategory_id	numeric	10				Tax Category
c_uom_conversion	c_uom_conversion_id	numeric	10				Unit of Measure Conversion
c_uom	c_uom_id	numeric	10				Unit of Measure
c_uom_conversion	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
c_uom_conversion	c_uom_to_id	numeric	10				Target or destination Unit of Measure
c_uom	costingprecision	numeric	10				Rounding used costing calculations
c_uom	created	timestamp	29,6			now()	Date this record was created
c_uom_conversion	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_acct	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_product_trl	created	timestamp	29,6			now()	Date this record was created
m_productdownload	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_relatedproduct	created	timestamp	29,6			now()	Date this record was created
m_replenish	created	timestamp	29,6			now()	Date this record was created
m_substitute	created	timestamp	29,6			now()	Date this record was created
c_uom	createdby	numeric	10				User who created this records
c_uom_conversion	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_acct	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_product_trl	createdby	numeric	10				User who created this records
m_productdownload	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_relatedproduct	createdby	numeric	10				User who created this records
m_replenish	createdby	numeric	10				User who created this records
m_substitute	createdby	numeric	10				User who created this records
c_uom_conversion	dividerate	numeric	0			0	To convert Source number to Target number, the Source is divided
m_productdownload	downloadurl	varchar	120				URL of the Download files
c_uom	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_uom_conversion	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_acct	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_product_trl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_productdownload	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_relatedproduct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_replenish	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_substitute	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_product_po	iscurrentvendor	bpchar	1			'Y'::bpchar	Use this Vendor for pricing and stock replenishment
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
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_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
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_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product_trl	istranslated	bpchar	1			'N'::bpchar	This column is translated
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_replenish	level_max	numeric	0			0	Maximum Inventory level for this product
m_replenish	level_min	numeric	0			0	Minimum Inventory level for this product
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_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_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	m_product_id	numeric	10				Product, Service, Item
m_product_acct	m_product_id	numeric	10				Product, Service, Item
m_product_po	m_product_id	numeric	10				Product, Service, Item
m_product_trl	m_product_id	numeric	10				Product, Service, Item
m_productdownload	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_relatedproduct	m_product_id	numeric	10				Product, Service, Item
m_replenish	m_product_id	numeric	10				Product, Service, Item
m_substitute	m_product_id	numeric	10				Product, Service, Item
m_productdownload	m_productdownload_id	numeric	10				Product downloads
m_productprice	m_productprice_id	numeric	10			NULL::numeric	Intersection between a Product and a Price List Version
m_productpricevendorbreak	m_productpricevendorbreak_id	numeric	10				Product Price Break
m_replenish	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
c_uom_conversion	multiplyrate	numeric	0			0	Rate to multiple the source by to calculate the target.
c_uom	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_product_trl	name	varchar	255				Alphanumeric identifier of the entity
m_productdownload	name	varchar	60				Alphanumeric identifier of the entity
m_relatedproduct	name	varchar	60				Alphanumeric identifier of the entity
m_product_acct	p_asset_acct	numeric	10				Account for Product Asset (Inventory)
m_product_acct	p_cogs_acct	numeric	10				Account for Cost of Goods Sold
m_product_acct	p_expense_acct	numeric	10				Account for Product Expense
m_product_acct	p_invoicepricevariance_acct	numeric	10				Difference between Costs and Invoice Price (IPV)
m_product_acct	p_purchasepricevariance_acct	numeric	10				Difference between Standard Cost and Purchase Price (PPV)
m_product_acct	p_revenue_acct	numeric	10				Account for Product Revenue (Sales Account)
m_product_acct	p_tradediscountgrant_acct	numeric	10				Trade Discount Granted Account
m_product_acct	p_tradediscountrec_acct	numeric	10				Trade Discount Receivable Account
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
m_productprice	pricelimit	numeric	0			0	Lowest price for a product
m_productpricevendorbreak	pricelimit	numeric	0				Lowest price for a product
m_productprice	pricelist	numeric	0			0	List Price
m_productpricevendorbreak	pricelist	numeric	0				List Price
m_productprice	pricestd	numeric	0			0	Standard Price
m_productpricevendorbreak	pricestd	numeric	0				Standard Price
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
m_relatedproduct	relatedproduct_id	numeric	10				Related Product
m_relatedproduct	relatedproducttype	bpchar	1				Related Product Type
m_replenish	replenishtype	bpchar	1				Method for re-ordering a product
c_uom	stdprecision	numeric	10				Rule for rounding calculated amounts
m_substitute	substitute_id	numeric	10				Entity which can be used in place of this entity
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
c_uom	updated	timestamp	29,6			now()	Date this record was updated
c_uom_conversion	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_acct	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_product_trl	updated	timestamp	29,6			now()	Date this record was updated
m_productdownload	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_relatedproduct	updated	timestamp	29,6			now()	Date this record was updated
m_replenish	updated	timestamp	29,6			now()	Date this record was updated
m_substitute	updated	timestamp	29,6			now()	Date this record was updated
c_uom	updatedby	numeric	10				User who updated this records
c_uom_conversion	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_acct	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_product_trl	updatedby	numeric	10				User who updated this records
m_productdownload	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_relatedproduct	updatedby	numeric	10				User who updated this records
m_replenish	updatedby	numeric	10				User who updated this records
m_substitute	updatedby	numeric	10				User who updated this records
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
m_product_po	vendorproductno	varchar	40				Product Key of the Business Partner
c_uom	x12de355	varchar	4				UOM EDI X12 Code