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

Table	Column	Type	Size	Nulls	Auto	Default
c_projectissue	docaction	bpchar	2			'CO'::bpchar	The targeted status of the document
m_inventoryline	inventorytype	bpchar	1			'D'::bpchar	Type of inventory difference
ad_table	entitytype	varchar	40			'D'::character varying	Dictionary Entity Type; Determines ownership and synchronization
c_projectissue	docstatus	varchar	2			'DR'::character varying	The current status of the document
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
ad_table	replicationtype	bpchar	1			'L'::bpchar	Type of Data Replication
a_asset	a_asset_action	varchar	2			'MD'::character varying	Asset Action
a_asset	a_assettype	varchar	3			'MFX'::character varying	Asset Type
m_attributeset	m_attributeset_type	varchar	3	√		'MMS'::character varying	AttributeSet Type
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_attributeset	isautogeneratelot	bpchar	1	√		'N'::bpchar	IsAutoGenerateLot
m_inoutline	isautoproduce	bpchar	1	√		'N'::bpchar	Auto create production to fulfill shipment
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
a_asset	processing	bpchar	1	√		'N'::bpchar	Process Now
m_attributeset	useguaranteedateformpolicy	bpchar	1	√		'N'::bpchar	Use Guarantee Date for Material Policy
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
m_transactionallocation	isallocated	bpchar	1			'N'::bpchar	Indicates if the payment has been allocated
c_projectissue	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
ad_table	ischangelog	bpchar	1			'N'::bpchar	Maintain a log of changes
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
a_asset	isdisposed	bpchar	1			'N'::bpchar	The asset is disposed
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
a_asset	isfullydepreciated	bpchar	1			'N'::bpchar	The asset is fully depreciated
m_attributeset	isguaranteedate	bpchar	1			'N'::bpchar	Product has Guarantee or Expiry Date
m_attributeset	isguaranteedatemandatory	bpchar	1			'N'::bpchar	The entry of a Guarantee Date is mandatory when creating a Product Instance
ad_table	ishighvolume	bpchar	1			'N'::bpchar	Use Search instead of Pick list
m_attribute	isinstanceattribute	bpchar	1			'N'::bpchar	The product attribute is specific to the instance (like Serial No, Lot or Guarantee Date)
m_attributeset	isinstanceattribute	bpchar	1			'N'::bpchar	The product attribute is specific to the instance (like Serial No, Lot or Guarantee Date)
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_attributeset	islotmandatory	bpchar	1			'N'::bpchar	The entry of Lot info is mandatory when creating a Product Instance
m_attribute	ismandatory	bpchar	1			'N'::bpchar	Data entry is required in this column
m_transactionallocation	ismanual	bpchar	1			'N'::bpchar	This is a manual process
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
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	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
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
ad_table	issecurityenabled	bpchar	1			'N'::bpchar	If security is enabled, user access to data can be restricted via Roles
m_attributeset	issernomandatory	bpchar	1			'N'::bpchar	The entry of a Serial No is mandatory when creating a Product Instance
m_lotctlexclude	issotrx	bpchar	1			'N'::bpchar	This is a Sales Transaction
m_sernoctlexclude	issotrx	bpchar	1			'N'::bpchar	This is a Sales Transaction
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	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
ad_table	isview	bpchar	1			'N'::bpchar	This is a view
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
m_attributeset	mandatorytype	bpchar	1			'N'::bpchar	The specification of a Product Attribute Instance is mandatory
c_projectissue	posted	bpchar	1			'N'::bpchar	Posting status
a_asset	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoiceline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_projectissue	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventoryline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movementline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_productionline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
a_asset	a_asset_status	varchar	2			'NW'::character varying	Asset Status
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
m_attribute	attributevaluetype	bpchar	1			'S'::bpchar	Type of Attribute Value
ad_table	iscentrallymaintained	bpchar	1	√		'Y'::bpchar	Information maintained in System Element table
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
a_asset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
ad_table	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
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
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_projectissue	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_rfqline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attribute	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributeinstance	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributesearch	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributeset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributesetexclude	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributesetinstance	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributeuse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributevalue	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_inventoryline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_lot	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_lotctl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_lotctlexclude	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_movementline	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_productionline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_sernoctl	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_sernoctlexclude	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_storageonhand	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_storagereservation	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_transaction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_transactionallocation	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
ad_table	isdeleteable	bpchar	1			'Y'::bpchar	Indicates if records can be deleted from the database
a_asset	isdepreciated	bpchar	1			'Y'::bpchar	The asset will be depreciated
a_asset	isinposession	bpchar	1			'Y'::bpchar	The asset is in the possession of the organization
m_attributeset	islot	bpchar	1			'Y'::bpchar	The product instances have a Lot Number
a_asset	isowned	bpchar	1			'Y'::bpchar	The asset is owned by the organization
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_attributeset	isserno	bpchar	1			'Y'::bpchar	The product instances have Serial Numbers
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_attributesetexclude	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_storagereservation	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
m_inventoryline	currentcostprice	numeric	0	√		(0)::numeric	The currently used cost price
m_inventoryline	newcostprice	numeric	0	√		(0)::numeric	New current cost price after processing of M_CostDetail
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
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
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_movementline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
c_rfqline	deliverydays	numeric	10	√		0	Number of Days (planned) until Delivery
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
a_asset	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_projectissue	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_rfqline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inventoryline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_productionline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
m_inoutline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_movementline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
m_movementline	targetqty	numeric	0	√		0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
m_product	volume	numeric	0	√		0	Volume of a product
m_product	weight	numeric	0	√		0	Weight of a product
c_orderline	freightamt	numeric	0			0	Freight Amount
c_rfqline	line	numeric	10			0	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
m_attributeinstance	m_attributesetinstance_id	numeric	10			0	Product Attribute Set Instance
m_transaction	m_attributesetinstance_id	numeric	10			0	Product Attribute Set Instance
m_transactionallocation	m_attributesetinstance_id	numeric	10			0	Product Attribute Set Instance
c_projectissue	movementqty	numeric	0			0	Quantity of a product moved.
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
m_movementline	movementqty	numeric	0			0	Quantity of a product moved.
m_productionline	movementqty	numeric	0			0	Quantity of a product moved.
m_transaction	movementqty	numeric	0			0	Quantity of a product moved.
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_orderline	priceactual	numeric	0			0	Actual Price
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
m_transactionallocation	qty	numeric	0			0	Quantity
m_inventoryline	qtybook	numeric	0			0	Book Quantity
m_inventoryline	qtycount	numeric	0			0	Counted Quantity
m_inventoryline	qtycsv	numeric	0			0	QtyCsv
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
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
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
a_asset	created	timestamp	29,6			now()	Date this record was created
ad_table	created	timestamp	29,6			now()	Date this record was created
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
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_projectissue	created	timestamp	29,6			now()	Date this record was created
c_rfqline	created	timestamp	29,6			now()	Date this record was created
m_attribute	created	timestamp	29,6			now()	Date this record was created
m_attributeinstance	created	timestamp	29,6			now()	Date this record was created
m_attributesearch	created	timestamp	29,6			now()	Date this record was created
m_attributeset	created	timestamp	29,6			now()	Date this record was created
m_attributesetexclude	created	timestamp	29,6			now()	Date this record was created
m_attributesetinstance	created	timestamp	29,6			now()	Date this record was created
m_attributeuse	created	timestamp	29,6			now()	Date this record was created
m_attributevalue	created	timestamp	29,6			now()	Date this record was created
m_inoutline	created	timestamp	29,6			now()	Date this record was created
m_inventoryline	created	timestamp	29,6			now()	Date this record was created
m_lot	created	timestamp	29,6			now()	Date this record was created
m_lotctl	created	timestamp	29,6			now()	Date this record was created
m_lotctlexclude	created	timestamp	29,6			now()	Date this record was created
m_movementline	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_productionline	created	timestamp	29,6			now()	Date this record was created
m_sernoctl	created	timestamp	29,6			now()	Date this record was created
m_sernoctlexclude	created	timestamp	29,6			now()	Date this record was created
m_transaction	created	timestamp	29,6			now()	Date this record was created
m_transactionallocation	created	timestamp	29,6			now()	Date this record was created
a_asset	updated	timestamp	29,6			now()	Date this record was updated
ad_table	updated	timestamp	29,6			now()	Date this record was updated
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
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_projectissue	updated	timestamp	29,6			now()	Date this record was updated
c_rfqline	updated	timestamp	29,6			now()	Date this record was updated
m_attribute	updated	timestamp	29,6			now()	Date this record was updated
m_attributeinstance	updated	timestamp	29,6			now()	Date this record was updated
m_attributesearch	updated	timestamp	29,6			now()	Date this record was updated
m_attributeset	updated	timestamp	29,6			now()	Date this record was updated
m_attributesetexclude	updated	timestamp	29,6			now()	Date this record was updated
m_attributesetinstance	updated	timestamp	29,6			now()	Date this record was updated
m_attributeuse	updated	timestamp	29,6			now()	Date this record was updated
m_attributevalue	updated	timestamp	29,6			now()	Date this record was updated
m_inoutline	updated	timestamp	29,6			now()	Date this record was updated
m_inventoryline	updated	timestamp	29,6			now()	Date this record was updated
m_lot	updated	timestamp	29,6			now()	Date this record was updated
m_lotctl	updated	timestamp	29,6			now()	Date this record was updated
m_lotctlexclude	updated	timestamp	29,6			now()	Date this record was updated
m_movementline	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_productionline	updated	timestamp	29,6			now()	Date this record was updated
m_sernoctl	updated	timestamp	29,6			now()	Date this record was updated
m_sernoctlexclude	updated	timestamp	29,6			now()	Date this record was updated
m_transaction	updated	timestamp	29,6			now()	Date this record was updated
m_transactionallocation	updated	timestamp	29,6			now()	Date this record was updated
a_asset	a_asset_createdate	timestamp	29,6	√		null	Create Date
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
a_asset	a_asset_revaldate	timestamp	29,6	√		null	Revaluation Date
a_asset	a_asset_type_id	numeric	10	√		null	Asset Type
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
a_asset	a_parent_asset_id	numeric	10	√		null	Parent Asset
a_asset	a_qty_current	numeric	0	√		null	Current Qty
a_asset	a_qty_original	numeric	0	√		null	A_QTY_Original
m_storage	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
m_storage	ad_org_id	numeric	10	√		null	Organizational entity within client
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
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
a_asset	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
ad_table	ad_val_rule_id	numeric	10	√		null	Dynamic Validation Rule
ad_table	ad_window_id	numeric	10	√		null	Data entry or display window
a_asset	assetactivationdate	timestamp	29,6	√		null	Activation Date
a_asset	assetdepreciationdate	timestamp	29,6	√		null	Date of last depreciation
a_asset	assetdisposaldate	timestamp	29,6	√		null	Date when the asset is/was disposed
a_asset	assetservicedate	timestamp	29,6	√		null	Date when Asset was put into service
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
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
a_asset	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_orderline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
a_asset	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
c_orderline	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
a_asset	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
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
m_inventoryline	c_charge_id	numeric	10	√		null	Additional document charges
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
a_asset	c_location_id	numeric	10	√		null	Location or Address
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
a_asset	c_project_id	numeric	10	√		null	Financial Project
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
m_transaction	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
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_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
m_product	classification	varchar	12	√		null	Classification for grouping
ad_table	copycolumnsfromtable	varchar	1	√		null	Copy Columns From Table
m_storage	created	timestamp	29,6	√		null	Date this record was created
m_storage	createdby	numeric	10	√		null	User who created this records
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
m_lot	datefrom	timestamp	29,6	√		null	Starting date for a range
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
m_storage	datelastinventory	timestamp	29,6	√		null	Date of Last Inventory Count
m_storageonhand	datelastinventory	timestamp	29,6	√		null	Date of Last Inventory Count
m_storagereservation	datelastinventory	timestamp	29,6	√		null	Date of Last Inventory Count
m_storage	datematerialpolicy	timestamp	29,6	√		null	Time used for LIFO and FIFO Material Policy
c_orderline	datepromised	timestamp	29,6	√		null	Date Order was promised
m_lot	dateto	timestamp	29,6	√		null	End date of a date range
c_rfqline	dateworkcomplete	timestamp	29,6	√		null	Date when work is (planned to be) complete
c_rfqline	dateworkstart	timestamp	29,6	√		null	Date when work is (planned to be) started
m_movementline	dd_orderline_id	numeric	10	√		null	Distribution Order Line
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
a_asset	description	varchar	255	√		null	Optional short description of the record
ad_table	description	varchar	255	√		null	Optional short description of the record
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
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_projectissue	description	varchar	255	√		null	Optional short description of the record
c_rfqline	description	varchar	255	√		null	Optional short description of the record
m_attribute	description	varchar	255	√		null	Optional short description of the record
m_attributesearch	description	varchar	255	√		null	Optional short description of the record
m_attributeset	description	varchar	255	√		null	Optional short description of the record
m_attributesetinstance	description	varchar	255	√		null	Optional short description of the record
m_attributevalue	description	varchar	255	√		null	Optional short description of the record
m_inoutline	description	varchar	255	√		null	Optional short description of the record
m_inventoryline	description	varchar	255	√		null	Optional short description of the record
m_lot	description	varchar	255	√		null	Optional short description of the record
m_lotctl	description	varchar	255	√		null	Optional short description of the record
m_movementline	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_productionline	description	varchar	255	√		null	Optional short description of the record
m_sernoctl	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
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_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
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
a_asset	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
m_attributesetinstance	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
m_attributeset	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
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
a_asset	help	varchar	2000	√		null	Comment or Hint
ad_table	help	varchar	2000	√		null	Comment or Hint
c_rfqline	help	varchar	2000	√		null	Comment or Hint
m_lot	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
ad_table	importtable	bpchar	1	√		null	Import Table Columns from Database
c_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
m_storage	isactive	bpchar	1	√		null	The record is active in the system
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
m_product	istoformule	bpchar	1	√		null
a_asset	lastmaintenancedate	timestamp	29,6	√		null	Last Maintenance Date
a_asset	lastmaintenancenote	varchar	60	√		null	Last Maintenance Note
a_asset	lastmaintenanceunit	numeric	10	√		null	Last Maintenance Unit
a_asset	lastmaintenanceuseunit	numeric	10	√		null
a_asset	lastmaintenencedate	timestamp	29,6	√		null
a_asset	lease_bpartner_id	numeric	10	√		null	The Business Partner who rents or leases
a_asset	leaseterminationdate	timestamp	29,6	√		null	Lease Termination Date
a_asset	lifeuseunits	numeric	0	√		null	Units of use until the asset is not usable anymore
m_inventoryline	line	numeric	10	√		null	Unique line for this document
m_movementline	line	numeric	10	√		null	Unique line for this document
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.
ad_table	loadseq	numeric	10	√		null	Sequence
a_asset	locationcomment	varchar	255	√		null	Additional comments or remarks concerning the location
a_asset	lot	varchar	255	√		null	Lot number (alphanumeric)
m_attributesetinstance	lot	varchar	40	√		null	Lot number (alphanumeric)
m_attributeset	lotchareoverwrite	bpchar	1	√		null	Lot/Batch End Indicator overwrite - default »
m_attributeset	lotcharsoverwrite	bpchar	1	√		null	Lot/Batch Start Indicator overwrite - default «
m_attribute	m_attributesearch_id	numeric	10	√		null	Common Search Attribute
m_attributesetinstance	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_movementline	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_storage	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_movementline	m_attributesetinstanceto_id	numeric	10	√		null	Target Product Attribute Set Instance
m_attributeinstance	m_attributevalue_id	numeric	10	√		null	Product Attribute Value
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
a_asset	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
c_invoiceline	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
c_projectissue	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_transaction	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_transactionallocation	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_transaction	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
m_transactionallocation	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
a_asset	m_locator_id	numeric	10	√		null	Warehouse Locator
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_inventoryline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_storage	m_locator_id	numeric	10	√		null	Warehouse Locator
m_attributesetinstance	m_lot_id	numeric	10	√		null	Product Lot Definition
m_attributeset	m_lotctl_id	numeric	10	√		null	Product Lot Control
m_lot	m_lotctl_id	numeric	10	√		null	Product Lot Control
m_transaction	m_movementline_id	numeric	10	√		null	Inventory Move document Line
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
c_rfqline	m_product_id	numeric	10	√		null	Product, Service, Item
m_inoutline	m_product_id	numeric	10	√		null	Product, Service, Item
m_storage	m_product_id	numeric	10	√		null	Product, Service, Item
m_productionline	m_production_id	numeric	10	√		null	Plan for producing a product
m_transaction	m_productionline_id	numeric	10	√		null	Document Line representing a production
m_transactionallocation	m_productionline_id	numeric	10	√		null	Document Line representing a production
m_productionline	m_productionplan_id	numeric	10	√		null	Plan for how a product is produced
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
m_attributeset	m_sernoctl_id	numeric	10	√		null	Product Serial Number Control
c_orderline	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_storage	m_storage_uu	varchar	36	√		null	M_Storage_UU
c_bpartner_product	manufacturer	varchar	30	√		null	Manufacturer of the Product
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
c_bpartner	name2	varchar	60	√		null	Additional Name
a_asset	nextmaintenanceuseunit	numeric	10	√		null
a_asset	nextmaintenencedate	timestamp	29,6	√		null	Next Maintenence Date
a_asset	nextmaintenenceunit	numeric	10	√		null	Next Maintenence Unit
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
m_transactionallocation	out_m_inoutline_id	numeric	10	√		null	Outgoing Shipment/Receipt
m_transactionallocation	out_m_inventoryline_id	numeric	10	√		null	Outgoing Inventory Line
m_transactionallocation	out_m_productionline_id	numeric	10	√		null	Outgoing Production Line
m_transactionallocation	out_m_transaction_id	numeric	10	√		null	Outgoing Transaction
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
m_productionline	plannedqty	numeric	0	√		null	Planned quantity for this project
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
ad_table	po_window_id	numeric	10	√		null	Purchase Order Window
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
m_transaction	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
m_lotctl	prefix	varchar	10	√		null	Prefix before the sequence number
m_sernoctl	prefix	varchar	10	√		null	Prefix before the sequence number
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
c_projectissue	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_projectissue	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
a_asset	qty	numeric	0	√		null	Quantity
m_inventoryline	qtyinternaluse	numeric	0	√		null	Internal Use Quantity removed from Inventory
m_storage	qtyonhand	numeric	0	√		null	On Hand Quantity
m_storage	qtyordered	numeric	0	√		null	Ordered Quantity
m_storage	qtyreserved	numeric	0	√		null	Reserved Quantity
m_productionline	qtyused	numeric	0	√		null	Quantity Used
c_bpartner_product	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
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
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
c_projectissue	reversal_id	numeric	10	√		null	ID of document reversal
m_inoutline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
m_inventoryline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
m_movementline	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
c_projectissue	s_timeexpenseline_id	numeric	10	√		null	Time and Expense Report Line
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
a_asset	serno	varchar	255	√		null	Product Serial Number
m_attributesetinstance	serno	varchar	40	√		null	Product Serial Number
m_attributeset	sernochareoverwrite	bpchar	1	√		null	Serial Number End Indicator overwrite - default empty
m_attributeset	sernocharsoverwrite	bpchar	1	√		null	Serial Number Start Indicator overwrite - default #
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	shelflifeminpct	numeric	10	√		null	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_description	varchar	255	√		null	Description to be used on orders
m_lotctl	suffix	varchar	10	√		null	Suffix after the number
m_sernoctl	suffix	varchar	10	√		null	Suffix after the number
c_bpartner	taxid	varchar	20	√		null	Tax Identification
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
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_storage	updated	timestamp	29,6	√		null	Date this record was updated
m_storage	updatedby	numeric	10	√		null	User who updated this records
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
a_asset	uselifemonths	numeric	10	√		null	Months of the usable life of the asset
a_asset	uselifeyears	numeric	10	√		null	Years of the usable life of the asset
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
a_asset	useunits	numeric	0	√		null	Currently used units of the assets
m_attributeinstance	value	varchar	40	√		null	Search key for the record in the format required - must be unique
m_attributeinstance	valuedate	timestamp	29,6	√		null	Value Date
m_attributeinstance	valuenumber	numeric	0	√		null	Numeric Value
c_bpartner_product	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
c_bpartner_product	vendorproductno	varchar	30	√		null	Product Key of the Business Partner
a_asset	versionno	varchar	20	√		null	Version Number
m_product	versionno	varchar	20	√		null	Version Number
a_asset	a_asset_group_id	numeric	10				Group of Assets
a_asset	a_asset_id	numeric	10				Asset used internally or by customers
ad_table	accesslevel	bpchar	1				Access Level required
a_asset	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_table	ad_client_id	numeric	10				Client/Tenant for this installation.
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.
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_projectissue	ad_client_id	numeric	10				Client/Tenant for this installation.
c_rfqline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attribute	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributeinstance	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributesearch	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributeset	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributesetexclude	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributesetinstance	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributeuse	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributevalue	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inoutline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inventoryline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_lot	ad_client_id	numeric	10				Client/Tenant for this installation.
m_lotctl	ad_client_id	numeric	10				Client/Tenant for this installation.
m_lotctlexclude	ad_client_id	numeric	10				Client/Tenant for this installation.
m_movementline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_productionline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_sernoctl	ad_client_id	numeric	10				Client/Tenant for this installation.
m_sernoctlexclude	ad_client_id	numeric	10				Client/Tenant for this installation.
m_storageonhand	ad_client_id	numeric	10				Client/Tenant for this installation.
m_storagereservation	ad_client_id	numeric	10				Client/Tenant for this installation.
m_transaction	ad_client_id	numeric	10				Client/Tenant for this installation.
m_transactionallocation	ad_client_id	numeric	10				Client/Tenant for this installation.
a_asset	ad_org_id	numeric	10				Organizational entity within client
ad_table	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_bpartner_product	ad_org_id	numeric	10				Organizational entity within client
c_invoiceline	ad_org_id	numeric	10				Organizational entity within client
c_orderline	ad_org_id	numeric	10				Organizational entity within client
c_projectissue	ad_org_id	numeric	10				Organizational entity within client
c_rfqline	ad_org_id	numeric	10				Organizational entity within client
m_attribute	ad_org_id	numeric	10				Organizational entity within client
m_attributeinstance	ad_org_id	numeric	10				Organizational entity within client
m_attributesearch	ad_org_id	numeric	10				Organizational entity within client
m_attributeset	ad_org_id	numeric	10				Organizational entity within client
m_attributesetexclude	ad_org_id	numeric	10				Organizational entity within client
m_attributesetinstance	ad_org_id	numeric	10				Organizational entity within client
m_attributeuse	ad_org_id	numeric	10				Organizational entity within client
m_attributevalue	ad_org_id	numeric	10				Organizational entity within client
m_inoutline	ad_org_id	numeric	10				Organizational entity within client
m_inventoryline	ad_org_id	numeric	10				Organizational entity within client
m_lot	ad_org_id	numeric	10				Organizational entity within client
m_lotctl	ad_org_id	numeric	10				Organizational entity within client
m_lotctlexclude	ad_org_id	numeric	10				Organizational entity within client
m_movementline	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_productionline	ad_org_id	numeric	10				Organizational entity within client
m_sernoctl	ad_org_id	numeric	10				Organizational entity within client
m_sernoctlexclude	ad_org_id	numeric	10				Organizational entity within client
m_storageonhand	ad_org_id	numeric	10				Organizational entity within client
m_storagereservation	ad_org_id	numeric	10				Organizational entity within client
m_transaction	ad_org_id	numeric	10				Organizational entity within client
m_transactionallocation	ad_org_id	numeric	10				Organizational entity within client
ad_table	ad_table_id	numeric	10				Database Table information
m_attributesetexclude	ad_table_id	numeric	10				Database Table information
m_lotctlexclude	ad_table_id	numeric	10				Database Table information
m_sernoctlexclude	ad_table_id	numeric	10				Database Table information
m_transactionallocation	allocationstrategytype	bpchar	1				Allocation Strategy
c_bpartner	c_bp_group_id	numeric	10				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
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_orderline	c_order_id	numeric	10				Order
c_orderline	c_orderline_id	numeric	10				Sales Order Line
c_projectissue	c_project_id	numeric	10				Financial Project
c_projectissue	c_projectissue_id	numeric	10				Project Issues (Material, Labor)
c_rfqline	c_rfq_id	numeric	10				Request for Quotation
c_rfqline	c_rfqline_id	numeric	10				Request for Quotation Line
c_orderline	c_tax_id	numeric	10				Tax identifier
m_product	c_taxcategory_id	numeric	10				Tax Category
c_orderline	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
a_asset	createdby	numeric	10				User who created this records
ad_table	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_bpartner_product	createdby	numeric	10				User who created this records
c_invoiceline	createdby	numeric	10				User who created this records
c_orderline	createdby	numeric	10				User who created this records
c_projectissue	createdby	numeric	10				User who created this records
c_rfqline	createdby	numeric	10				User who created this records
m_attribute	createdby	numeric	10				User who created this records
m_attributeinstance	createdby	numeric	10				User who created this records
m_attributesearch	createdby	numeric	10				User who created this records
m_attributeset	createdby	numeric	10				User who created this records
m_attributesetexclude	createdby	numeric	10				User who created this records
m_attributesetinstance	createdby	numeric	10				User who created this records
m_attributeuse	createdby	numeric	10				User who created this records
m_attributevalue	createdby	numeric	10				User who created this records
m_inoutline	createdby	numeric	10				User who created this records
m_inventoryline	createdby	numeric	10				User who created this records
m_lot	createdby	numeric	10				User who created this records
m_lotctl	createdby	numeric	10				User who created this records
m_lotctlexclude	createdby	numeric	10				User who created this records
m_movementline	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_productionline	createdby	numeric	10				User who created this records
m_sernoctl	createdby	numeric	10				User who created this records
m_sernoctlexclude	createdby	numeric	10				User who created this records
m_storageonhand	createdby	numeric	10				User who created this records
m_storagereservation	createdby	numeric	10				User who created this records
m_transaction	createdby	numeric	10				User who created this records
m_transactionallocation	createdby	numeric	10				User who created this records
m_lotctl	currentnext	numeric	10				The next number to be used
m_sernoctl	currentnext	numeric	10				The next number to be used
m_storageonhand	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
c_orderline	dateordered	timestamp	29,6				Date of Order
m_lotctl	incrementno	numeric	10				The number to increment the last document number by
m_sernoctl	incrementno	numeric	10				The number to increment the last document number by
c_invoiceline	line	numeric	10				Unique line for this document
c_orderline	line	numeric	10				Unique line for this document
c_projectissue	line	numeric	10				Unique line for this document
m_inoutline	line	numeric	10				Unique line for this document
m_productionline	line	numeric	10				Unique line for this document
m_attribute	m_attribute_id	numeric	10				Product Attribute
m_attributeinstance	m_attribute_id	numeric	10				Product Attribute
m_attributeuse	m_attribute_id	numeric	10				Product Attribute
m_attributevalue	m_attribute_id	numeric	10				Product Attribute
m_attributesearch	m_attributesearch_id	numeric	10				Common Search Attribute
m_attributeset	m_attributeset_id	numeric	10				Product Attribute Set
m_attributesetexclude	m_attributeset_id	numeric	10				Product Attribute Set
m_attributeuse	m_attributeset_id	numeric	10				Product Attribute Set
m_attributesetexclude	m_attributesetexclude_id	numeric	10				Exclude the ability to enter Attribute Sets
m_attributesetinstance	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_storageonhand	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_storagereservation	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_attributevalue	m_attributevalue_id	numeric	10				Product Attribute Value
m_inoutline	m_inout_id	numeric	10				Material Shipment Document
m_inoutline	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_inventoryline	m_inventory_id	numeric	10				Parameters for a Physical Inventory
m_inventoryline	m_inventoryline_id	numeric	10				Unique line in an Inventory document
c_projectissue	m_locator_id	numeric	10				Warehouse Locator
m_movementline	m_locator_id	numeric	10				Warehouse Locator
m_productionline	m_locator_id	numeric	10				Warehouse Locator
m_storageonhand	m_locator_id	numeric	10				Warehouse Locator
m_transaction	m_locator_id	numeric	10				Warehouse Locator
m_movementline	m_locatorto_id	numeric	10				Location inventory is moved to
m_lot	m_lot_id	numeric	10				Product Lot Definition
m_lotctl	m_lotctl_id	numeric	10				Product Lot Control
m_lotctlexclude	m_lotctl_id	numeric	10				Product Lot Control
m_lotctlexclude	m_lotctlexclude_id	numeric	10				Exclude the ability to create Lots in Attribute Sets
m_movementline	m_movement_id	numeric	10				Movement of Inventory
m_movementline	m_movementline_id	numeric	10				Inventory Move document Line
m_product	m_product_category_id	numeric	10				Category of a Product
a_asset	m_product_id	numeric	10				Product, Service, Item
c_bpartner_product	m_product_id	numeric	10				Product, Service, Item
c_projectissue	m_product_id	numeric	10				Product, Service, Item
m_inventoryline	m_product_id	numeric	10				Product, Service, Item
m_lot	m_product_id	numeric	10				Product, Service, Item
m_movementline	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_productionline	m_product_id	numeric	10				Product, Service, Item
m_storageonhand	m_product_id	numeric	10				Product, Service, Item
m_storagereservation	m_product_id	numeric	10				Product, Service, Item
m_transaction	m_product_id	numeric	10				Product, Service, Item
m_transactionallocation	m_product_id	numeric	10				Product, Service, Item
m_productionline	m_productionline_id	numeric	10				Document Line representing a production
m_sernoctl	m_sernoctl_id	numeric	10				Product Serial Number Control
m_sernoctlexclude	m_sernoctl_id	numeric	10				Product Serial Number Control
m_sernoctlexclude	m_sernoctlexclude_id	numeric	10				Exclude the ability to create Serial Numbers in Attribute Sets
m_transaction	m_transaction_id	numeric	10				Inventory Transaction
m_transactionallocation	m_transaction_id	numeric	10				Inventory Transaction
c_orderline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_storagereservation	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_projectissue	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_transaction	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_transaction	movementtype	bpchar	2				Method of moving the inventory
a_asset	name	varchar	60				Alphanumeric identifier of the entity
ad_table	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name	varchar	120				Alphanumeric identifier of the entity
m_attribute	name	varchar	60				Alphanumeric identifier of the entity
m_attributesearch	name	varchar	60				Alphanumeric identifier of the entity
m_attributeset	name	varchar	60				Alphanumeric identifier of the entity
m_attributevalue	name	varchar	60				Alphanumeric identifier of the entity
m_lot	name	varchar	60				Alphanumeric identifier of the entity
m_lotctl	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_sernoctl	name	varchar	60				Alphanumeric identifier of the entity
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
m_storagereservation	qty	numeric	0				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
m_storageonhand	qtyonhand	numeric	0				On Hand Quantity
m_attributeuse	seqno	numeric	10				Method of ordering records; lowest number comes first
c_bpartner_product	shelflifemindays	numeric	10				Minimum Shelf Life in days based on Product Instance Guarantee Date
c_bpartner_product	shelflifeminpct	numeric	10				Minimum Shelf Life in percent based on Product Instance Guarantee Date
m_lotctl	startno	numeric	10				Starting number/position
m_sernoctl	startno	numeric	10				Starting number/position
ad_table	tablename	varchar	40				Name of the table in the database
a_asset	updatedby	numeric	10				User who updated this records
ad_table	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_bpartner_product	updatedby	numeric	10				User who updated this records
c_invoiceline	updatedby	numeric	10				User who updated this records
c_orderline	updatedby	numeric	10				User who updated this records
c_projectissue	updatedby	numeric	10				User who updated this records
c_rfqline	updatedby	numeric	10				User who updated this records
m_attribute	updatedby	numeric	10				User who updated this records
m_attributeinstance	updatedby	numeric	10				User who updated this records
m_attributesearch	updatedby	numeric	10				User who updated this records
m_attributeset	updatedby	numeric	10				User who updated this records
m_attributesetexclude	updatedby	numeric	10				User who updated this records
m_attributesetinstance	updatedby	numeric	10				User who updated this records
m_attributeuse	updatedby	numeric	10				User who updated this records
m_attributevalue	updatedby	numeric	10				User who updated this records
m_inoutline	updatedby	numeric	10				User who updated this records
m_inventoryline	updatedby	numeric	10				User who updated this records
m_lot	updatedby	numeric	10				User who updated this records
m_lotctl	updatedby	numeric	10				User who updated this records
m_lotctlexclude	updatedby	numeric	10				User who updated this records
m_movementline	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_productionline	updatedby	numeric	10				User who updated this records
m_sernoctl	updatedby	numeric	10				User who updated this records
m_sernoctlexclude	updatedby	numeric	10				User who updated this records
m_storageonhand	updatedby	numeric	10				User who updated this records
m_storagereservation	updatedby	numeric	10				User who updated this records
m_transaction	updatedby	numeric	10				User who updated this records
m_transactionallocation	updatedby	numeric	10				User who updated this records
a_asset	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	value	varchar	40				Search key for the record in the format required - must be unique
m_attributevalue	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
ad_table	copycomponentsfromview	bpchar	1	√		NULL::bpchar	Copy Components From View
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
ad_table	createwindowfromtable	bpchar	1	√		NULL::bpchar	Create Window From Table
ad_table	databaseviewdrop	bpchar	1	√		NULL::bpchar	Drop view
m_productionline	isendproduct	bpchar	1	√		NULL::bpchar	End Product of production
ad_table	processing	bpchar	1	√		NULL::bpchar	Process Now
a_asset	a_asset_uu	varchar	36	√		NULL::character varying	A_Asset_UU
ad_table	ad_table_uu	varchar	36	√		NULL::character varying	AD_Table_UU
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
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_UU
c_orderline	c_orderline_uu	varchar	36	√		NULL::character varying	C_OrderLine_UU
c_projectissue	c_projectissue_uu	varchar	36	√		NULL::character varying	C_ProjectIssue_UU
c_rfqline	c_rfqline_uu	varchar	36	√		NULL::character varying	C_RfQLine_UU
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
m_attribute	dateformat	varchar	20	√		NULL::character varying	Date format used in the input format
a_asset	inventoryno	varchar	30	√		NULL::character varying	Inventory No
m_attribute	m_attribute_uu	varchar	36	√		NULL::character varying	M_Attribute_UU
m_attributeinstance	m_attributeinstance_uu	varchar	36	√		NULL::character varying	M_AttributeInstance_UU
m_attributesearch	m_attributesearch_uu	varchar	36	√		NULL::character varying	M_AttributeSearch_UU
m_attributeset	m_attributeset_uu	varchar	36	√		NULL::character varying	M_AttributeSet_UU
m_attributesetexclude	m_attributesetexclude_uu	varchar	36	√		NULL::character varying	M_AttributeSetExclude_UU
m_attributesetinstance	m_attributesetinstance_uu	varchar	36	√		NULL::character varying	M_AttributeSetInstance_UU
m_attributeuse	m_attributeuse_uu	varchar	36	√		NULL::character varying	M_AttributeUse_UU
m_attributevalue	m_attributevalue_uu	varchar	36	√		NULL::character varying	M_AttributeValue_UU
m_inoutline	m_inoutline_uu	varchar	36	√		NULL::character varying	M_InOutLine_UU
m_inventoryline	m_inventoryline_uu	varchar	36	√		NULL::character varying	M_InventoryLine_UU
m_lot	m_lot_uu	varchar	36	√		NULL::character varying	M_Lot_UU
m_lotctl	m_lotctl_uu	varchar	36	√		NULL::character varying	M_LotCtl_UU
m_lotctlexclude	m_lotctlexclude_uu	varchar	36	√		NULL::character varying	M_LotCtlExclude_UU
m_movementline	m_movementline_uu	varchar	36	√		NULL::character varying	M_MovementLine_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_productionline	m_productionline_uu	varchar	36	√		NULL::character varying	M_ProductionLine_UU
m_sernoctl	m_sernoctl_uu	varchar	36	√		NULL::character varying	M_SerNoCtl_UU
m_sernoctlexclude	m_sernoctlexclude_uu	varchar	36	√		NULL::character varying	M_SerNoCtlExclude_UU
m_storageonhand	m_storageonhand_uu	varchar	36	√		NULL::character varying	M_StorageOnHand_UU
m_storagereservation	m_storagereservation_uu	varchar	36	√		NULL::character varying	M_StorageReservation_UU
m_transaction	m_transaction_uu	varchar	36	√		NULL::character varying	M_Transaction_UU
m_transactionallocation	m_transactionallocation_uu	varchar	36	√		NULL::character varying	M_TransactionAllocation_UU
a_asset	manufacturer	varchar	30	√		NULL::character varying	Manufacturer of the Product
a_asset	a_asset_class_id	numeric	10	√		NULL::numeric	Asset class
m_attribute	ad_reference_id	numeric	10	√		NULL::numeric	System Reference and Validation
m_attribute	ad_reference_value_id	numeric	10	√		NULL::numeric	Required to specify, if data type is Table or List
m_attribute	ad_val_rule_id	numeric	10	√		NULL::numeric	Dynamic Validation Rule
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
a_asset	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
a_asset	manufacturedyear	numeric	10	√		NULL::numeric	Manufactured Year
m_storageonhand	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_storagereservation	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_storageonhand	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_storagereservation	updated	timestamp	29,6			statement_timestamp()	Date this record was updated