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

Table	Column	Type	Size	Nulls	Auto	Default
c_invoiceline	a_asset_group_id	numeric	10	√		null	Group of Assets
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
c_invoiceline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_orderline	ad_client_id	numeric	10				Client/Tenant for this installation.
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_inoutline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoiceline	ad_org_id	numeric	10				Organizational entity within client
c_orderline	ad_org_id	numeric	10				Organizational entity within client
c_uom	ad_org_id	numeric	10				Organizational entity within client
c_uom_conversion	ad_org_id	numeric	10				Organizational entity within client
m_inoutline	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
c_invoiceline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_orderline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inoutline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
c_invoiceline	c_activity_id	numeric	10	√		null	Business Activity
c_orderline	c_activity_id	numeric	10	√		null	Business Activity
m_inoutline	c_activity_id	numeric	10	√		null	Business Activity
c_orderline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_orderline	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_invoiceline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_orderline	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inoutline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoiceline	c_charge_id	numeric	10	√		null	Additional document charges
c_orderline	c_charge_id	numeric	10	√		null	Additional document charges
m_inoutline	c_charge_id	numeric	10	√		null	Additional document charges
c_orderline	c_currency_id	numeric	10				The Currency for this record
c_invoiceline	c_invoice_id	numeric	10				Invoice Identifier
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_UU
c_orderline	c_order_id	numeric	10				Order
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_id	numeric	10				Sales Order Line
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_uu	varchar	36	√		NULL::character varying	C_OrderLine_UU
c_invoiceline	c_project_id	numeric	10	√		null	Financial Project
c_orderline	c_project_id	numeric	10	√		null	Financial Project
m_inoutline	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
m_inoutline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_invoiceline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_orderline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_inoutline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_orderline	c_tax_id	numeric	10				Tax identifier
m_product	c_taxcategory_id	numeric	10				Tax Category
c_uom_conversion	c_uom_conversion_id	numeric	10				Unit of Measure Conversion
c_uom_conversion	c_uom_conversion_uu	varchar	36	√		NULL::character varying	C_UOM_Conversion_UU
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
c_orderline	c_uom_id	numeric	10				Unit of Measure
c_uom	c_uom_id	numeric	10				Unit of Measure
c_uom_conversion	c_uom_id	numeric	10				Unit of Measure
m_inoutline	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	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
m_product	classification	varchar	12	√		null	Classification for grouping
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
c_uom	costingprecision	numeric	10				Rounding used costing calculations
c_invoiceline	created	timestamp	29,6			now()	Date this record was created
c_orderline	created	timestamp	29,6			now()	Date this record was created
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_inoutline	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
c_invoiceline	createdby	numeric	10				User who created this records
c_orderline	createdby	numeric	10				User who created this records
c_uom	createdby	numeric	10				User who created this records
c_uom_conversion	createdby	numeric	10				User who created this records
m_inoutline	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
c_orderline	datedelivered	timestamp	29,6	√		null	Date when the product was delivered
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
c_orderline	dateordered	timestamp	29,6				Date of Order
c_orderline	datepromised	timestamp	29,6	√		null	Date Order was promised
c_invoiceline	description	varchar	255	√		null	Optional short description of the record
c_orderline	description	varchar	255	√		null	Optional short description of the record
c_uom	description	varchar	255	√		null	Optional short description of the record
m_inoutline	description	varchar	255	√		null	Optional short description of the record
m_product	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	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
c_orderline	discount	numeric	0	√		null	Discount in percent
c_uom_conversion	dividerate	numeric	0			0	To convert Source number to Target number, the Source is divided
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
c_orderline	freightamt	numeric	0			0	Freight Amount
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
c_invoiceline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_orderline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
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_inoutline	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_inoutline	isautoproduce	bpchar	1	√		'N'::bpchar	Auto create production to fulfill shipment
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
c_invoiceline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
c_orderline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_inoutline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
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
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
m_inoutline	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
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	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_invoiceline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
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	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	istoformule	bpchar	1	√		null
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
c_invoiceline	line	numeric	10				Unique line for this document
c_orderline	line	numeric	10				Unique line for this document
m_inoutline	line	numeric	10				Unique line for this document
c_invoiceline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
c_orderline	link_orderline_id	numeric	10	√		null	This field links a sales order line to the purchase order line that is generated from it.
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
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
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_inoutline	m_inout_id	numeric	10				Material Shipment Document
c_invoiceline	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_inoutline	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_inoutline	m_inoutline_uu	varchar	36	√		NULL::character varying	M_InOutLine_UU
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
m_product	m_product_category_id	numeric	10				Category of a Product
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
c_uom_conversion	m_product_id	numeric	10	√		null	Product, Service, Item
m_inoutline	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
c_orderline	m_promotion_id	numeric	10	√		null	Promotion
c_invoiceline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
m_inoutline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
c_orderline	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_orderline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
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_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_orderline	priceactual	numeric	0			0	Actual Price
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
c_invoiceline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_orderline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_invoiceline	pricelimit	numeric	0			0	Lowest price for a product
c_orderline	pricelimit	numeric	0			0	Lowest price for a product
c_invoiceline	pricelist	numeric	0			0	List Price
c_orderline	pricelist	numeric	0			0	List Price
c_invoiceline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_product	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
c_invoiceline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_orderline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
m_inoutline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_invoiceline	qtyinvoiced	numeric	0			0	Invoiced Quantity
c_orderline	qtyinvoiced	numeric	0			0	Invoiced Quantity
c_orderline	qtylostsales	numeric	0			0	Quantity of potential sales
c_orderline	qtyordered	numeric	0			0	Ordered Quantity
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
m_inoutline	ref_inoutline_id	numeric	10	√		null	Referenced Shipment Line
c_invoiceline	ref_invoiceline_id	numeric	10	√		null	Referenced Invoice Line
c_orderline	ref_orderline_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
m_inoutline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
c_invoiceline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_orderline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_invoiceline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
c_orderline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_orderline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_inoutline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
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
c_uom	stdprecision	numeric	10				Rule for rounding calculated amounts
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
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
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)
c_invoiceline	updated	timestamp	29,6			now()	Date this record was updated
c_orderline	updated	timestamp	29,6			now()	Date this record was updated
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_inoutline	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceline	updatedby	numeric	10				User who updated this records
c_orderline	updatedby	numeric	10				User who updated this records
c_uom	updatedby	numeric	10				User who updated this records
c_uom_conversion	updatedby	numeric	10				User who updated this records
m_inoutline	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
c_invoiceline	user1_id	numeric	10	√		null	User defined list element #1
c_orderline	user1_id	numeric	10	√		null	User defined list element #1
m_inoutline	user1_id	numeric	10	√		null	User defined list element #1
c_invoiceline	user2_id	numeric	10	√		null	User defined list element #2
c_orderline	user2_id	numeric	10	√		null	User defined list element #2
m_inoutline	user2_id	numeric	10	√		null	User defined list element #2
m_product	value	varchar	40				Search key for the record in the format required - must be unique
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	x12de355	varchar	4				UOM EDI X12 Code