idempiere11.adempiere contains 1095 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
m_transactionallocation	allocationstrategytype	bpchar	1				Allocation Strategy
qm_specificationline	andor	bpchar	1				Logical operation: AND or OR
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_inventory	costingmethod	bpchar	1	√		NULL::bpchar	Indicates how Costs will be calculated
m_perpetualinv	counthighmovement	bpchar	1			'N'::bpchar	Count High Movement products
m_inout	createconfirm	bpchar	1	√		null	Create Confirm
m_inout	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_movement	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_production	createfrom	bpchar	1	√		'N'::bpchar	Process which will generate a new document lines based on an existing document
m_shipper	createfrom	bpchar	1	√		NULL::bpchar	Process which will generate a new document lines based on an existing document
m_inout	createlinesfrom	bpchar	1	√		NULL::bpchar	Process which will generate a new document lines based on an existing document
m_inout	createpackage	bpchar	1	√		null	Create Package
m_inout	deliveryrule	bpchar	1				Defines the timing of Delivery
m_movement	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
m_inout	deliveryviarule	bpchar	1				How the order will be delivered
m_movement	deliveryviarule	bpchar	1	√		null	How the order will be delivered
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_pricelist	enforcepricelimit	bpchar	1			'N'::bpchar	Do not allow prices below the limit price
m_inout	freightcostrule	bpchar	1				Method for charging Freight
m_movement	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_inventory	generatelist	bpchar	1	√		'Y'::bpchar	Generate List
m_inout	generateto	bpchar	1	√		null	Generate To
c_doctype	hascharges	bpchar	1			'N'::bpchar	Charges can be added to the document
c_doctype	hasproforma	bpchar	1	√		'N'::bpchar	Indicates if Pro Forma Invoices can be generated from this document
m_inout	insurance	bpchar	1	√		NULL::bpchar	Insurance
m_inventoryline	inventorytype	bpchar	1			'D'::bpchar	Type of inventory difference
c_charge	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_doctype	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_projectissuema	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_attributesetinstance	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inout	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_inoutlinema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inoutlinema_returned	isactive	bpchar	1	√		null
m_inventory	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_inventorylinema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_locator	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_locatortype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_movement	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_movementlinema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_parttype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_perpetualinv	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_pricelist_version	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_bom	isactive	bpchar	1	√		null	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_qualitytest	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_production	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_productionlinema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_productionplan	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_qualitytest	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_qualitytestresult	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_shipper	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_storage	isactive	bpchar	1	√		null	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_storagereservationlog	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_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
m_warehouse	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
qm_specification	isactive	bpchar	1				The record is active in the system
qm_specificationline	isactive	bpchar	1				The record is active in the system
t_transaction	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_transactionallocation	isallocated	bpchar	1			'N'::bpchar	Indicates if the payment has been allocated
m_inout	isalternatereturnaddress	bpchar	1			'N'::bpchar	Alternate Return Address
c_projectissue	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inout	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inventory	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_movement	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inoutlinema	isautogenerated	bpchar	1	√		'N'::bpchar	Auto Generated
m_inoutlinema_returned	isautogenerated	bpchar	1	√		null
m_inventorylinema	isautogenerated	bpchar	1	√		'N'::bpchar	Auto Generated
m_movementlinema	isautogenerated	bpchar	1	√		'N'::bpchar	Auto Generated
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_locatortype	isavailableforreplenishment	bpchar	1			'Y'::bpchar	Available for Replenishment
m_locatortype	isavailableforreservation	bpchar	1			'Y'::bpchar	Available for Reservation
m_locatortype	isavailableforshipping	bpchar	1			'Y'::bpchar	Available for Shipping
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
c_doctype	ischargeorproductmandatory	bpchar	1	√		'N'::bpchar	Mandatory Charge or Product
m_production	iscomplete	bpchar	1	√		NULL::bpchar	It is complete
c_doctype	iscreatecounter	bpchar	1			'Y'::bpchar	Create Counter Document
m_production	iscreated	bpchar	1			'N'::bpchar	Records created
m_product_po	iscurrentvendor	bpchar	1			'Y'::bpchar	Use this Vendor for pricing and stock replenishment
c_doctype	isdefault	bpchar	1			'N'::bpchar	Default value
c_uom	isdefault	bpchar	1			'N'::bpchar	Default value
m_locator	isdefault	bpchar	1			'N'::bpchar	Default value
m_pricelist	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
c_doctype	isdefaultcounterdoc	bpchar	1			'N'::bpchar	The document type is the default counter document type
m_inoutline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_doctype	isdocnocontrolled	bpchar	1			'N'::bpchar	The document has a document sequence
m_inout	isdropship	bpchar	1	√		'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
m_productionline	isendproduct	bpchar	1	√		NULL::bpchar	End Product of production
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
c_doctype	isindexed	bpchar	1			'Y'::bpchar	Index the document for the internal search engine
m_inout	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_doctype	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_inout	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_movement	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
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_pricelist	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_doctype	isnopricelistcheck	bpchar	1	√		'N'::bpchar	Allow Product Without Price List
c_doctype	isoverwritedateoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Date on Complete
c_doctype	isoverwriteseqoncomplete	bpchar	1	√		'N'::bpchar	Overwrite Sequence on Complete
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_doctype	ispickqaconfirm	bpchar	1			'N'::bpchar	Require Pick or QA Confirmation before processing
c_doctype	ispreparesplitdocument	bpchar	1			'Y'::bpchar	Prepare generated split shipment/receipt document
m_pricelist	ispresentforproduct	bpchar	1	√		'N'::bpchar	Is Present For Product
m_inout	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
m_qualitytestresult	isqcpass	bpchar	1			'N'::bpchar	QC Pass
c_charge	issamecurrency	bpchar	1			'N'::bpchar	Same Currency
c_charge	issametax	bpchar	1			'N'::bpchar	Use the same tax as the main transaction
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
c_doctype	isshipconfirm	bpchar	1			'N'::bpchar	Require Ship or Receipt Confirmation before processing
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
m_pricelist	issopricelist	bpchar	1			'Y'::bpchar	This is a Sales Price List
c_doctype	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_inout	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_storagereservation	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_storagereservationlog	issotrx	bpchar	1				This is a Sales Transaction
c_doctype	issplitwhendifference	bpchar	1			'N'::bpchar	Split document when there is a difference
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_charge	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_pricelist	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
m_product	istoformule	bpchar	1	√		null
m_production	isuseproductionplan	bpchar	1			'N'::bpchar	Use Production Plan
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_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
c_projectissue	posted	bpchar	1			'N'::bpchar	Posting status
m_inout	posted	bpchar	1			'N'::bpchar	Posting status
m_inventory	posted	bpchar	1			'N'::bpchar	Posting status
m_movement	posted	bpchar	1			'N'::bpchar	Posting status
m_production	posted	bpchar	1			'N'::bpchar	Posting status
m_inout	priorityrule	bpchar	1				Priority of a document
m_movement	priorityrule	bpchar	1	√		null	Priority of a document
m_pricelist_version	proccreate	bpchar	1	√		null	Create
c_projectissue	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inout	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventory	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventoryline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movement	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movementline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_production	processed	bpchar	1			'N'::bpchar	The document has been processed
m_productionline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_productionplan	processed	bpchar	1			'N'::bpchar	The document has been processed
m_qualitytestresult	processed	bpchar	1			'N'::bpchar	The document has been processed
c_projectissue	processing	bpchar	1	√		null	Process Now
m_inout	processing	bpchar	1	√		null	Process Now
m_inventory	processing	bpchar	1	√		null	Process Now
m_movement	processing	bpchar	1	√		null	Process Now
m_perpetualinv	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_production	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
m_replenish	replenishtype	bpchar	1				Method for re-ordering a product
t_replenish	replenishtype	bpchar	1				Method for re-ordering a product
m_inout	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_warehouse	separator	bpchar	1				Element Separator
m_inventory	updateqty	bpchar	1	√		'N'::bpchar	Update Quantities
c_projectissue	docaction	bpchar	2			'CO'::bpchar	The targeted status of the document
m_inout	docaction	bpchar	2				The targeted status of the document
m_inventory	docaction	bpchar	2				The targeted status of the document
m_movement	docaction	bpchar	2				The targeted status of the document
m_production	docaction	bpchar	2			'CO'::bpchar	The targeted status of the document
m_inout	docstatus	bpchar	2				The current status of the document
m_inventory	docstatus	bpchar	2				The current status of the document
m_movement	docstatus	bpchar	2				The current status of the document
c_doctype	docsubtypeso	bpchar	2	√		null	Sales Order Sub Type
m_inout	movementtype	bpchar	2				Method of moving the inventory
m_transaction	movementtype	bpchar	2				Method of moving the inventory
t_transaction	movementtype	bpchar	2				Method of moving the inventory
qm_specificationline	operation	bpchar	2				Compare Operation
c_doctype	docbasetype	bpchar	3				Logical type of document
t_replenish	replenishmentcreate	bpchar	3	√		null	Create from Replenishment
m_inventory	approvalamt	numeric	0	√		null	Document Approval Amount
m_movement	approvalamt	numeric	0	√		null	Document Approval Amount
m_product_bom	bomqty	numeric	0	√		null	Bill of Materials Quantity
m_productpricevendorbreak	breakvalue	numeric	0				Low Value of trade discount break level
c_charge	chargeamt	numeric	0			0	Charge Amount
m_inout	chargeamt	numeric	0	√		0	Charge Amount
m_movement	chargeamt	numeric	0	√		null	Charge Amount
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_movementline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_product_po	costperorder	numeric	0	√		0	Fixed Cost Per Order
m_inventoryline	currentcostprice	numeric	0	√		(0)::numeric	The currently used cost price
m_storagereservationlog	deltaqty	numeric	0				Quantity Difference
c_uom_conversion	dividerate	numeric	0			0	To convert Source number to Target number, the Source is divided
m_inout	freightamt	numeric	0	√		0	Freight Amount
m_movement	freightamt	numeric	0	√		null	Freight Amount
m_replenish	level_max	numeric	0			0	Maximum Inventory level for this product
t_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
t_replenish	level_min	numeric	0			0	Minimum Inventory level for this product
c_projectissue	movementqty	numeric	0			0	Quantity of a product moved.
c_projectissuema	movementqty	numeric	0			0	Quantity of a product moved.
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
m_inoutlinema	movementqty	numeric	0			(1)::numeric	Quantity of a product moved.
m_inoutlinema_returned	movementqty	numeric	0	√		null
m_inventorylinema	movementqty	numeric	0			(1)::numeric	Quantity of a product moved.
m_movementline	movementqty	numeric	0			0	Quantity of a product moved.
m_movementlinema	movementqty	numeric	0	√		(1)::numeric	Quantity of a product moved.
m_productionline	movementqty	numeric	0			0	Quantity of a product moved.
m_productionlinema	movementqty	numeric	0			0	Quantity of a product moved.
m_transaction	movementqty	numeric	0			0	Quantity of a product moved.
t_transaction	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.
m_inventoryline	newcostprice	numeric	0	√		(0)::numeric	New current cost price after processing of M_CostDetail
m_storagereservationlog	newqty	numeric	0				New current quantity after processing of M_CostDetail
m_storagereservationlog	oldqty	numeric	0				Old current quantity before the processing of M_CostDetail
m_product_po	order_min	numeric	0	√		0	Minimum order quantity in UOM
t_replenish	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)
t_replenish	order_pack	numeric	0			0	Package order size in UOM (e.g. order set of 5 units)
m_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
m_productionline	plannedqty	numeric	0	√		null	Planned quantity for this project
m_product_po	pricelastinv	numeric	0	√		0	Price of the last invoice for the product
m_product_po	pricelastpo	numeric	0	√		0	Price of the last purchase order for the product
m_productprice	pricelimit	numeric	0			0	Lowest price for a product
m_productpricevendorbreak	pricelimit	numeric	0				Lowest price for a product
m_product_po	pricelist	numeric	0	√		0	List Price
m_productprice	pricelist	numeric	0			0	List Price
m_productpricevendorbreak	pricelist	numeric	0				List Price
m_product_po	pricepo	numeric	0	√		0	Price based on a purchase order
m_productprice	pricestd	numeric	0			0	Standard Price
m_productpricevendorbreak	pricestd	numeric	0				Standard Price
c_projectissue	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_inout	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_inventory	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_movement	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_production	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_production	productionqty	numeric	0			0	Quantity of products to produce
m_productionplan	productionqty	numeric	0			0	Quantity of products to produce
m_storagereservation	qty	numeric	0				Quantity
m_transactionallocation	qty	numeric	0			0	Quantity
m_replenish	qtybatchsize	numeric	0	√		null	Qty Batch Size
m_inventoryline	qtybook	numeric	0			0	Book Quantity
m_inventoryline	qtycount	numeric	0			0	Counted Quantity
m_inventoryline	qtycsv	numeric	0			0	Qty Csv
m_inoutline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
m_inventoryline	qtyinternaluse	numeric	0	√		null	Internal Use Quantity removed from Inventory
m_storage	qtyonhand	numeric	0	√		null	On Hand Quantity
m_storageonhand	qtyonhand	numeric	0				On Hand Quantity
t_replenish	qtyonhand	numeric	0			0	On Hand Quantity
m_storage	qtyordered	numeric	0	√		null	Ordered Quantity
t_replenish	qtyordered	numeric	0			0	Ordered Quantity
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
m_storage	qtyreserved	numeric	0	√		null	Reserved Quantity
t_replenish	qtyreserved	numeric	0			0	Reserved Quantity
t_replenish	qtytoorder	numeric	0			0	Quantity to Order
m_productionline	qtyused	numeric	0	√		null	Quantity Used
m_product_po	qualityrating	numeric	0	√		null	Method for rating vendors
m_inoutlinema_returned	returnedqty	numeric	0	√		null
m_product_po	royaltyamt	numeric	0	√		0	(Included) Amount for copyright, etc.
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
m_product	shelfheight	numeric	0	√		null	Shelf height required
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
m_movementline	targetqty	numeric	0	√		0	Target Movement Quantity
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
m_inout	volume	numeric	0	√		null	Volume of a product
m_product	volume	numeric	0	√		0	Volume of a product
m_inout	weight	numeric	0	√		null	Weight of a product
m_product	weight	numeric	0	√		0	Weight of a product
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
c_charge	ad_client_id	numeric	10				Tenant for this installation.
c_doctype	ad_client_id	numeric	10				Tenant for this installation.
c_projectissue	ad_client_id	numeric	10				Tenant for this installation.
c_projectissuema	ad_client_id	numeric	10				Tenant for this installation.
c_uom	ad_client_id	numeric	10				Tenant for this installation.
c_uom_conversion	ad_client_id	numeric	10				Tenant for this installation.
m_attributesetinstance	ad_client_id	numeric	10				Tenant for this installation.
m_inout	ad_client_id	numeric	10				Tenant for this installation.
m_inoutline	ad_client_id	numeric	10				Tenant for this installation.
m_inoutlinema	ad_client_id	numeric	10				Tenant for this installation.
m_inoutlinema_returned	ad_client_id	numeric	10	√		null
m_inventory	ad_client_id	numeric	10				Tenant for this installation.
m_inventoryline	ad_client_id	numeric	10				Tenant for this installation.
m_inventorylinema	ad_client_id	numeric	10				Tenant for this installation.
m_locator	ad_client_id	numeric	10				Tenant for this installation.
m_locatortype	ad_client_id	numeric	10				Tenant for this installation.
m_movement	ad_client_id	numeric	10				Tenant for this installation.
m_movementline	ad_client_id	numeric	10				Tenant for this installation.
m_movementlinema	ad_client_id	numeric	10				Tenant for this installation.
m_parttype	ad_client_id	numeric	10				Tenant for this installation.
m_perpetualinv	ad_client_id	numeric	10				Tenant for this installation.
m_pricelist	ad_client_id	numeric	10				Tenant for this installation.
m_pricelist_version	ad_client_id	numeric	10				Tenant for this installation.
m_product	ad_client_id	numeric	10				Tenant for this installation.
m_product_bom	ad_client_id	numeric	10	√		null	Tenant for this installation.
m_product_category	ad_client_id	numeric	10				Tenant for this installation.
m_product_po	ad_client_id	numeric	10				Tenant for this installation.
m_product_qualitytest	ad_client_id	numeric	10				Tenant for this installation.
m_production	ad_client_id	numeric	10				Tenant for this installation.
m_productionline	ad_client_id	numeric	10				Tenant for this installation.
m_productionlinema	ad_client_id	numeric	10				Tenant for this installation.
m_productionplan	ad_client_id	numeric	10				Tenant for this installation.
m_productprice	ad_client_id	numeric	10				Tenant for this installation.
m_productpricevendorbreak	ad_client_id	numeric	10				Tenant for this installation.
m_qualitytest	ad_client_id	numeric	10				Tenant for this installation.
m_qualitytestresult	ad_client_id	numeric	10				Tenant for this installation.
m_replenish	ad_client_id	numeric	10				Tenant for this installation.
m_shipper	ad_client_id	numeric	10				Tenant for this installation.
m_storage	ad_client_id	numeric	10	√		null	Tenant for this installation.
m_storageonhand	ad_client_id	numeric	10				Tenant for this installation.
m_storagereservation	ad_client_id	numeric	10				Tenant for this installation.
m_storagereservationlog	ad_client_id	numeric	10				Tenant for this installation.
m_substitute	ad_client_id	numeric	10				Tenant for this installation.
m_transaction	ad_client_id	numeric	10				Tenant for this installation.
m_transactionallocation	ad_client_id	numeric	10				Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Tenant for this installation.
qm_specification	ad_client_id	numeric	10				Tenant for this installation.
qm_specificationline	ad_client_id	numeric	10				Tenant for this installation.
t_replenish	ad_client_id	numeric	10				Tenant for this installation.
t_transaction	ad_client_id	numeric	10				Tenant for this installation.
c_charge	ad_org_id	numeric	10				Organizational entity within tenant
c_doctype	ad_org_id	numeric	10				Organizational entity within tenant
c_projectissue	ad_org_id	numeric	10				Organizational entity within tenant
c_projectissuema	ad_org_id	numeric	10				Organizational entity within tenant
c_uom	ad_org_id	numeric	10				Organizational entity within tenant
c_uom_conversion	ad_org_id	numeric	10				Organizational entity within tenant
m_attributesetinstance	ad_org_id	numeric	10				Organizational entity within tenant
m_inout	ad_org_id	numeric	10				Organizational entity within tenant
m_inoutline	ad_org_id	numeric	10				Organizational entity within tenant
m_inoutlinema	ad_org_id	numeric	10				Organizational entity within tenant
m_inoutlinema_returned	ad_org_id	numeric	10	√		null
m_inventory	ad_org_id	numeric	10				Organizational entity within tenant
m_inventoryline	ad_org_id	numeric	10				Organizational entity within tenant
m_inventorylinema	ad_org_id	numeric	10				Organizational entity within tenant
m_locator	ad_org_id	numeric	10				Organizational entity within tenant
m_locatortype	ad_org_id	numeric	10				Organizational entity within tenant
m_movement	ad_org_id	numeric	10				Organizational entity within tenant
m_movementline	ad_org_id	numeric	10				Organizational entity within tenant
m_movementlinema	ad_org_id	numeric	10				Organizational entity within tenant
m_parttype	ad_org_id	numeric	10				Organizational entity within tenant
m_perpetualinv	ad_org_id	numeric	10				Organizational entity within tenant
m_pricelist	ad_org_id	numeric	10				Organizational entity within tenant
m_pricelist_version	ad_org_id	numeric	10				Organizational entity within tenant
m_product	ad_org_id	numeric	10				Organizational entity within tenant
m_product_bom	ad_org_id	numeric	10	√		null	Organizational entity within tenant
m_product_category	ad_org_id	numeric	10				Organizational entity within tenant
m_product_po	ad_org_id	numeric	10				Organizational entity within tenant
m_product_qualitytest	ad_org_id	numeric	10				Organizational entity within tenant
m_production	ad_org_id	numeric	10				Organizational entity within tenant
m_productionline	ad_org_id	numeric	10				Organizational entity within tenant
m_productionlinema	ad_org_id	numeric	10				Organizational entity within tenant
m_productionplan	ad_org_id	numeric	10				Organizational entity within tenant
m_productprice	ad_org_id	numeric	10				Organizational entity within tenant
m_productpricevendorbreak	ad_org_id	numeric	10				Organizational entity within tenant
m_qualitytest	ad_org_id	numeric	10				Organizational entity within tenant
m_qualitytestresult	ad_org_id	numeric	10				Organizational entity within tenant
m_replenish	ad_org_id	numeric	10				Organizational entity within tenant
m_shipper	ad_org_id	numeric	10				Organizational entity within tenant
m_storage	ad_org_id	numeric	10	√		null	Organizational entity within tenant
m_storageonhand	ad_org_id	numeric	10				Organizational entity within tenant
m_storagereservation	ad_org_id	numeric	10				Organizational entity within tenant
m_storagereservationlog	ad_org_id	numeric	10				Organizational entity within tenant
m_substitute	ad_org_id	numeric	10				Organizational entity within tenant
m_transaction	ad_org_id	numeric	10				Organizational entity within tenant
m_transactionallocation	ad_org_id	numeric	10				Organizational entity within tenant
m_warehouse	ad_org_id	numeric	10				Organizational entity within tenant
qm_specification	ad_org_id	numeric	10				Organizational entity within tenant
qm_specificationline	ad_org_id	numeric	10				Organizational entity within tenant
t_replenish	ad_org_id	numeric	10				Organizational entity within tenant
t_transaction	ad_org_id	numeric	10				Organizational entity within tenant
m_inout	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inoutline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inventory	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_movement	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_production	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
t_replenish	ad_pinstance_id	numeric	10				Instance of the process
t_transaction	ad_pinstance_id	numeric	10				Instance of the process
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
c_doctype	ad_printformat_id	numeric	10	√		null	Data Print Format
m_storagereservationlog	ad_table_id	numeric	10				Database Table information
m_inout	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
m_movement	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
qm_specification	ad_workflow_id	numeric	10	√		null	Workflow or combination of tasks
m_pricelist	basepricelist_id	numeric	10	√		null	Pricelist to be used, if product not found on this pricelist
m_inout	c_activity_id	numeric	10	√		null	Business Activity
m_inoutline	c_activity_id	numeric	10	√		null	Business Activity
m_inventory	c_activity_id	numeric	10	√		null	Business Activity
m_movement	c_activity_id	numeric	10	√		null	Business Activity
m_production	c_activity_id	numeric	10	√		null	Business Activity
c_charge	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_inout	c_bpartner_id	numeric	10				Identifies a Business Partner
m_movement	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_product_po	c_bpartner_id	numeric	10				Identifies a Business Partner
m_production	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a Business Partner
m_productpricevendorbreak	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_shipper	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
t_replenish	c_bpartner_id	numeric	10				Identifies a Business Partner
m_inout	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
m_movement	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
m_inout	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inoutline	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inventory	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_movement	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_production	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_charge	c_charge_id	numeric	10				Additional document charges
m_inout	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
m_movement	c_charge_id	numeric	10	√		null	Additional document charges
c_charge	c_chargetype_id	numeric	10	√		null	Charge Type
m_inventory	c_conversiontype_id	numeric	10	√		NULL::numeric	Currency Conversion Rate Type
m_inventory	c_currency_id	numeric	10	√		NULL::numeric	The Currency for this record
m_pricelist	c_currency_id	numeric	10				The Currency for this record
m_product_po	c_currency_id	numeric	10	√		null	The Currency for this record
c_doctype	c_doctype_id	numeric	10				Document type or rules
m_inout	c_doctype_id	numeric	10				Document type or rules
m_inventory	c_doctype_id	numeric	10				Document type or rules
m_movement	c_doctype_id	numeric	10				Document type or rules
m_production	c_doctype_id	numeric	10			NULL::numeric	Document type or rules
m_storagereservationlog	c_doctype_id	numeric	10	√		null	Document type or rules
t_replenish	c_doctype_id	numeric	10	√		null	Document type or rules
c_doctype	c_doctypedifference_id	numeric	10	√		null	Document type for generating in dispute Shipments
c_doctype	c_doctypeinvoice_id	numeric	10	√		null	Document type used for invoices generated from this sales document
c_doctype	c_doctypeproforma_id	numeric	10	√		null	Document type used for pro forma invoices generated from this sales document
c_doctype	c_doctypeshipment_id	numeric	10	√		null	Document type used for shipments generated from this sales document
m_inout	c_invoice_id	numeric	10	√		null	Invoice Identifier
m_warehouse	c_location_id	numeric	10				Location or Address
m_inout	c_order_id	numeric	10	√		null	Order
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
m_production	c_orderline_id	numeric	10	√		NULL::numeric	Sales Order Line
c_projectissue	c_project_id	numeric	10				Financial Project
m_inout	c_project_id	numeric	10	√		null	Financial Project
m_inoutline	c_project_id	numeric	10	√		null	Financial Project
m_inventory	c_project_id	numeric	10	√		null	Financial Project
m_movement	c_project_id	numeric	10	√		null	Financial Project
m_production	c_project_id	numeric	10	√		null	Financial Project
t_transaction	c_project_id	numeric	10	√		null	Financial Project
c_projectissue	c_projectissue_id	numeric	10				Project Issues (Material, Labor)
c_projectissuema	c_projectissue_id	numeric	10				Project Issues (Material, Labor)
m_transaction	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
t_transaction	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
m_inoutline	c_projectphase_id	numeric	10	√		null	Phase of a Project
m_production	c_projectphase_id	numeric	10	√		NULL::numeric	Phase of a Project
m_inoutline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_production	c_projecttask_id	numeric	10	√		NULL::numeric	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_charge	c_taxcategory_id	numeric	10	√		null	Tax Category
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_inoutline	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
m_product_po	c_uom_id	numeric	10	√		null	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_charge	createdby	numeric	10				User who created this records
c_doctype	createdby	numeric	10				User who created this records
c_projectissue	createdby	numeric	10				User who created this records
c_projectissuema	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_attributesetinstance	createdby	numeric	10				User who created this records
m_inout	createdby	numeric	10				User who created this records
m_inoutline	createdby	numeric	10				User who created this records
m_inoutlinema	createdby	numeric	10				User who created this records
m_inoutlinema_returned	createdby	numeric	10	√		null
m_inventory	createdby	numeric	10				User who created this records
m_inventoryline	createdby	numeric	10				User who created this records
m_inventorylinema	createdby	numeric	10				User who created this records
m_locator	createdby	numeric	10				User who created this records
m_locatortype	createdby	numeric	10				User who created this records
m_movement	createdby	numeric	10				User who created this records
m_movementline	createdby	numeric	10				User who created this records
m_movementlinema	createdby	numeric	10				User who created this records
m_parttype	createdby	numeric	10				User who created this records
m_perpetualinv	createdby	numeric	10				User who created this records
m_pricelist	createdby	numeric	10				User who created this records
m_pricelist_version	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_bom	createdby	numeric	10	√		null	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_qualitytest	createdby	numeric	10				User who created this records
m_production	createdby	numeric	10				User who created this records
m_productionline	createdby	numeric	10				User who created this records
m_productionlinema	createdby	numeric	10				User who created this records
m_productionplan	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_qualitytest	createdby	numeric	10				User who created this records
m_qualitytestresult	createdby	numeric	10				User who created this records
m_replenish	createdby	numeric	10				User who created this records
m_shipper	createdby	numeric	10				User who created this records
m_storage	createdby	numeric	10	√		null	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_storagereservationlog	createdby	numeric	10				User who created this records
m_substitute	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_warehouse	createdby	numeric	10				User who created this records
qm_specification	createdby	numeric	10				User who created this records
qm_specificationline	createdby	numeric	10				User who created this records
t_transaction	createdby	numeric	10				User who created this records
m_movement	dd_order_id	numeric	10	√		null	Distribution Order
m_movementline	dd_orderline_id	numeric	10	√		null	Distribution Order Line
c_doctype	definitesequence_id	numeric	10	√		null	Definite Sequence
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_doctype	docnosequence_id	numeric	10	√		null	Document sequence determines the numbering of documents
c_doctype	documentcopies	numeric	10				Number of copies to be printed
m_inout	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
m_inout	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
m_inout	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
c_doctype	gl_category_id	numeric	10				General Ledger Category
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
c_projectissue	line	numeric	10				Unique line for this document
m_inoutline	line	numeric	10				Unique line for this document
m_inventoryline	line	numeric	10	√		null	Unique line for this document
m_movementline	line	numeric	10	√		null	Unique line for this document
m_product_bom	line	numeric	10	√		null	Unique line for this document
m_productionline	line	numeric	10				Unique line for this document
m_productionplan	line	numeric	10				Unique line for this document
m_storagereservationlog	lineno	numeric	10	√		NULL::numeric	Line No
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
qm_specificationline	m_attribute_id	numeric	10				Product Attribute
m_attributesetinstance	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
qm_specification	m_attributeset_id	numeric	10				Product Attribute Set
c_projectissue	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_projectissuema	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_attributesetinstance	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutlinema	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_inoutlinema_returned	m_attributesetinstance_id	numeric	10	√		null
m_inventoryline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inventorylinema	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_movementline	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_movementlinema	m_attributesetinstance_id	numeric	10				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_productionlinema	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_qualitytestresult	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_storage	m_attributesetinstance_id	numeric	10	√		null	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_storagereservationlog	m_attributesetinstance_id	numeric	10				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
t_transaction	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_movementline	m_attributesetinstanceto_id	numeric	10	√		null	Target Product Attribute Set Instance
m_pricelist_version	m_discountschema_id	numeric	10				Schema to calculate the trade discount percentage
m_product	m_freightcategory_id	numeric	10	√		null	Category of the Freight
m_inout	m_inout_id	numeric	10				Material Shipment Document
m_inoutline	m_inout_id	numeric	10				Material Shipment Document
t_transaction	m_inout_id	numeric	10	√		null	Material Shipment Document
c_projectissue	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_inoutlinema	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_inoutlinema_returned	m_inoutline_id	numeric	10	√		null
m_production	m_inoutline_id	numeric	10	√		NULL::numeric	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
t_transaction	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_inventory	m_inventory_id	numeric	10				Parameters for a Physical Inventory
m_inventoryline	m_inventory_id	numeric	10				Parameters for a Physical Inventory
t_transaction	m_inventory_id	numeric	10	√		null	Parameters for a Physical Inventory
m_inventoryline	m_inventoryline_id	numeric	10				Unique line in an Inventory document
m_inventorylinema	m_inventoryline_id	numeric	10				Unique line in an Inventory 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
t_transaction	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
c_projectissue	m_locator_id	numeric	10				Warehouse Locator
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_inventoryline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_locator	m_locator_id	numeric	10				Warehouse Locator
m_movementline	m_locator_id	numeric	10				Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_production	m_locator_id	numeric	10	√		null	Warehouse Locator
m_productionline	m_locator_id	numeric	10				Warehouse Locator
m_productionplan	m_locator_id	numeric	10				Warehouse Locator
m_replenish	m_locator_id	numeric	10	√		null	Warehouse Locator
m_storage	m_locator_id	numeric	10	√		null	Warehouse Locator
m_storageonhand	m_locator_id	numeric	10				Warehouse Locator
m_transaction	m_locator_id	numeric	10				Warehouse Locator
t_transaction	m_locator_id	numeric	10				Warehouse Locator
m_movementline	m_locatorto_id	numeric	10				Location inventory is moved to
m_locator	m_locatortype_id	numeric	10	√		NULL::numeric	Locator Type
m_locatortype	m_locatortype_id	numeric	10				Locator Type
m_attributesetinstance	m_lot_id	numeric	10	√		null	Product Lot Definition
m_movement	m_movement_id	numeric	10				Movement of Inventory
m_movementline	m_movement_id	numeric	10				Movement of Inventory
t_transaction	m_movement_id	numeric	10	√		null	Movement of Inventory
m_movementline	m_movementline_id	numeric	10				Inventory Move document Line
m_movementlinema	m_movementline_id	numeric	10				Inventory Move document Line
m_transaction	m_movementline_id	numeric	10	√		null	Inventory Move document Line
t_transaction	m_movementline_id	numeric	10	√		null	Inventory Move document Line
m_parttype	m_parttype_id	numeric	10				Part Type
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
m_inventory	m_perpetualinv_id	numeric	10	√		null	Rules for generating physical inventory
m_perpetualinv	m_perpetualinv_id	numeric	10				Rules for generating physical inventory
m_pricelist	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist_version	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_pricelist_version	m_pricelist_version_base_id	numeric	10	√		null	Source for Price list calculations
m_pricelist_version	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_productprice	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_productpricevendorbreak	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
m_product_bom	m_product_bom_id	numeric	10	√		null	BOM Line
m_perpetualinv	m_product_category_id	numeric	10	√		null	Category of a Product
m_product	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
c_projectissue	m_product_id	numeric	10				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_inventoryline	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_product_bom	m_product_id	numeric	10	√		null	Product, Service, Item
m_product_po	m_product_id	numeric	10				Product, Service, Item
m_product_qualitytest	m_product_id	numeric	10				Product, Service, Item
m_production	m_product_id	numeric	10	√		null	Product, Service, Item
m_productionline	m_product_id	numeric	10				Product, Service, Item
m_productionplan	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_replenish	m_product_id	numeric	10				Product, Service, Item
m_storage	m_product_id	numeric	10	√		null	Product, Service, Item
m_storageonhand	m_product_id	numeric	10				Product, Service, Item
m_storagereservation	m_product_id	numeric	10				Product, Service, Item
m_storagereservationlog	m_product_id	numeric	10				Product, Service, Item
m_substitute	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
qm_specification	m_product_id	numeric	10				Product, Service, Item
t_replenish	m_product_id	numeric	10				Product, Service, Item
t_transaction	m_product_id	numeric	10				Product, Service, Item
m_product_qualitytest	m_product_qualitytest_id	numeric	10				Product Quality Test
m_product_bom	m_productbom_id	numeric	10	√		null	Bill of Material Component Product
m_production	m_production_id	numeric	10				Plan for producing a product
m_productionline	m_production_id	numeric	10	√		null	Plan for producing a product
m_productionplan	m_production_id	numeric	10				Plan for producing a product
t_transaction	m_production_id	numeric	10	√		null	Plan for producing a product
m_productionline	m_productionline_id	numeric	10				Document Line representing a production
m_productionlinema	m_productionline_id	numeric	10				Document Line representing a production
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
t_transaction	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
m_productionplan	m_productionplan_id	numeric	10				Plan for how a product is produced
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_product_qualitytest	m_qualitytest_id	numeric	10				Quality Test
m_qualitytest	m_qualitytest_id	numeric	10				Quality Test
m_qualitytestresult	m_qualitytest_id	numeric	10				Quality Test
m_qualitytestresult	m_qualitytestresult_id	numeric	10				Quality Test Result
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
m_inout	m_rma_id	numeric	10	√		null	Return Material Authorization
m_inoutline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
m_inout	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_movement	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_shipper	m_shipper_id	numeric	10				Method or manner of product delivery
m_shipper	m_shippercfg_id	numeric	10	√		NULL::numeric	Shipper Configuration
m_shipper	m_shippingprocessor_id	numeric	10	√		NULL::numeric	Shipping Processor
m_storagereservationlog	m_storagereservationlog_id	numeric	10				Log for every storage reservation quantity change
m_transaction	m_transaction_id	numeric	10				Inventory Transaction
m_transactionallocation	m_transaction_id	numeric	10				Inventory Transaction
t_transaction	m_transaction_id	numeric	10				Inventory Transaction
m_inout	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_inventory	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_locator	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_movement	m_warehouse_id	numeric	10	√		NULL::numeric	Storage Warehouse and Service Point
m_perpetualinv	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_replenish	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_storagereservation	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_storagereservationlog	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
t_replenish	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_replenish	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
t_replenish	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
m_movement	m_warehouseto_id	numeric	10	√		NULL::numeric	To Storage Warehouse and Service Point
m_perpetualinv	noinventorycount	numeric	10				Frequency of inventory counts per year
m_inout	nopackages	numeric	10	√		(1)::numeric	Number of packages shipped
m_perpetualinv	noproductcount	numeric	10				Frequency of product counts per year
m_perpetualinv	numberofruns	numeric	10				Frequency of processing Perpetual Inventory
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
m_transaction	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
m_production	pp_product_bom_id	numeric	10	√		NULL::numeric	BOM & Formula
qm_specification	pp_product_bom_id	numeric	10	√		null	BOM & Formula
m_pricelist	priceprecision	numeric	10			2	Precision (number of decimals) for the Price
m_locator	priorityno	numeric	10				Where inventory should be picked from first
qm_specification	qm_specification_id	numeric	10				Quality Specification
qm_specificationline	qm_specification_id	numeric	10	√		null	Quality Specification
qm_specificationline	qm_specificationline_id	numeric	10				QM Specification Line
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
m_storagereservationlog	record_id	numeric	10				Direct internal record ID
m_inout	ref_inout_id	numeric	10	√		null	Referenced Shipment
m_inoutline	ref_inoutline_id	numeric	10	√		null	Referenced Shipment Line
m_inout	returnbpartner_id	numeric	10	√		NULL::numeric	Return Partner
m_inout	returnlocation_id	numeric	10	√		NULL::numeric	Return Location
m_inout	returnuser_id	numeric	10	√		NULL::numeric	Return User/Contact
c_projectissue	reversal_id	numeric	10	√		null	ID of document reversal
m_inout	reversal_id	numeric	10	√		null	ID of document reversal
m_inventory	reversal_id	numeric	10	√		null	ID of document reversal
m_movement	reversal_id	numeric	10	√		null	ID of document reversal
m_production	reversal_id	numeric	10	√		NULL::numeric	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
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_projectissue	s_timeexpenseline_id	numeric	10	√		null	Time and Expense Report Line
m_inout	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_movement	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
t_transaction	search_inout_id	numeric	10	√		null	Material Shipment Document
t_transaction	search_invoice_id	numeric	10	√		null	Search Invoice Identifier
t_transaction	search_order_id	numeric	10	√		null	Order Identifier
qm_specificationline	seqno	numeric	10	√		null	Method of ordering records; lowest number comes first
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfwidth	numeric	10	√		null	Shelf width required
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_charge	updatedby	numeric	10				User who updated this records
c_doctype	updatedby	numeric	10				User who updated this records
c_projectissue	updatedby	numeric	10				User who updated this records
c_projectissuema	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_attributesetinstance	updatedby	numeric	10				User who updated this records
m_inout	updatedby	numeric	10				User who updated this records
m_inoutline	updatedby	numeric	10				User who updated this records
m_inoutlinema	updatedby	numeric	10				User who updated this records
m_inoutlinema_returned	updatedby	numeric	10	√		null
m_inventory	updatedby	numeric	10				User who updated this records
m_inventoryline	updatedby	numeric	10				User who updated this records
m_inventorylinema	updatedby	numeric	10				User who updated this records
m_locator	updatedby	numeric	10				User who updated this records
m_locatortype	updatedby	numeric	10				User who updated this records
m_movement	updatedby	numeric	10				User who updated this records
m_movementline	updatedby	numeric	10				User who updated this records
m_movementlinema	updatedby	numeric	10				User who updated this records
m_parttype	updatedby	numeric	10				User who updated this records
m_perpetualinv	updatedby	numeric	10				User who updated this records
m_pricelist	updatedby	numeric	10				User who updated this records
m_pricelist_version	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_bom	updatedby	numeric	10	√		null	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_qualitytest	updatedby	numeric	10				User who updated this records
m_production	updatedby	numeric	10				User who updated this records
m_productionline	updatedby	numeric	10				User who updated this records
m_productionlinema	updatedby	numeric	10				User who updated this records
m_productionplan	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_qualitytest	updatedby	numeric	10				User who updated this records
m_qualitytestresult	updatedby	numeric	10				User who updated this records
m_replenish	updatedby	numeric	10				User who updated this records
m_shipper	updatedby	numeric	10				User who updated this records
m_storage	updatedby	numeric	10	√		null	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_storagereservationlog	updatedby	numeric	10				User who updated this records
m_substitute	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
m_warehouse	updatedby	numeric	10				User who updated this records
qm_specification	updatedby	numeric	10				User who updated this records
qm_specificationline	updatedby	numeric	10				User who updated this records
t_replenish	updatedby	numeric	10	√		null	User who updated this records
t_transaction	updatedby	numeric	10				User who updated this records
m_inout	user1_id	numeric	10	√		null	User defined list element #1
m_inoutline	user1_id	numeric	10	√		null	User defined list element #1
m_inventory	user1_id	numeric	10	√		null	User defined list element #1
m_movement	user1_id	numeric	10	√		null	User defined list element #1
m_production	user1_id	numeric	10	√		null	User defined list element #1
m_inout	user2_id	numeric	10	√		null	User defined list element #2
m_inoutline	user2_id	numeric	10	√		null	User defined list element #2
m_inventory	user2_id	numeric	10	√		null	User defined list element #2
m_movement	user2_id	numeric	10	√		null	User defined list element #2
m_production	user2_id	numeric	10	√		null	User defined list element #2
c_charge	created	timestamp	29,6			now()	Date this record was created
c_doctype	created	timestamp	29,6			now()	Date this record was created
c_projectissue	created	timestamp	29,6			now()	Date this record was created
c_projectissuema	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_attributesetinstance	created	timestamp	29,6			now()	Date this record was created
m_inout	created	timestamp	29,6			now()	Date this record was created
m_inoutline	created	timestamp	29,6			now()	Date this record was created
m_inoutlinema	created	timestamp	29,6			now()	Date this record was created
m_inoutlinema_returned	created	timestamp	29,6	√		null
m_inventory	created	timestamp	29,6			now()	Date this record was created
m_inventoryline	created	timestamp	29,6			now()	Date this record was created
m_inventorylinema	created	timestamp	29,6			now()	Date this record was created
m_locator	created	timestamp	29,6			now()	Date this record was created
m_locatortype	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_movement	created	timestamp	29,6			now()	Date this record was created
m_movementline	created	timestamp	29,6			now()	Date this record was created
m_movementlinema	created	timestamp	29,6			now()	Date this record was created
m_parttype	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_perpetualinv	created	timestamp	29,6			now()	Date this record was created
m_pricelist	created	timestamp	29,6			now()	Date this record was created
m_pricelist_version	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_bom	created	timestamp	29,6	√		null	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_qualitytest	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_production	created	timestamp	29,6			now()	Date this record was created
m_productionline	created	timestamp	29,6			now()	Date this record was created
m_productionlinema	created	timestamp	29,6			now()	Date this record was created
m_productionplan	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_qualitytest	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_qualitytestresult	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_replenish	created	timestamp	29,6			now()	Date this record was created
m_shipper	created	timestamp	29,6			now()	Date this record was created
m_storage	created	timestamp	29,6	√		null	Date this record was created
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_storagereservationlog	created	timestamp	29,6				Date this record was created
m_substitute	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
m_warehouse	created	timestamp	29,6			now()	Date this record was created
qm_specification	created	timestamp	29,6			statement_timestamp()	Date this record was created
qm_specificationline	created	timestamp	29,6			statement_timestamp()	Date this record was created
t_transaction	created	timestamp	29,6			now()	Date this record was created
m_inout	dateacct	timestamp	29,6				Accounting Date
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_perpetualinv	datelastrun	timestamp	29,6	√		null	Date the process was last run.
m_inoutlinema	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
m_inoutlinema_returned	datematerialpolicy	timestamp	29,6	√		null
m_inventorylinema	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
m_movementlinema	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
m_productionlinema	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
m_storage	datematerialpolicy	timestamp	29,6	√		null	Time used for LIFO and FIFO Material Policy
m_storageonhand	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
m_perpetualinv	datenextrun	timestamp	29,6				Date the process will run next
m_inout	dateordered	timestamp	29,6	√		null	Date of Order
m_inout	dateprinted	timestamp	29,6	√		null	Date the document was printed.
m_production	datepromised	timestamp	29,6	√		null	Date Order was promised
m_inout	datereceived	timestamp	29,6	√		null	Date a product was received
m_movement	datereceived	timestamp	29,6	√		null	Date a product was received
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_attributesetinstance	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
c_projectissue	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inout	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inventory	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_movement	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_production	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
t_transaction	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inout	pickdate	timestamp	29,6	√		null	Date/Time when picked for Shipment
m_product_po	priceeffective	timestamp	29,6	√		null	Effective Date of Price
m_inout	shipdate	timestamp	29,6	√		null	Shipment Date/Time
c_charge	updated	timestamp	29,6			now()	Date this record was updated
c_doctype	updated	timestamp	29,6			now()	Date this record was updated
c_projectissue	updated	timestamp	29,6			now()	Date this record was updated
c_projectissuema	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_attributesetinstance	updated	timestamp	29,6			now()	Date this record was updated
m_inout	updated	timestamp	29,6			now()	Date this record was updated
m_inoutline	updated	timestamp	29,6			now()	Date this record was updated
m_inoutlinema	updated	timestamp	29,6			now()	Date this record was updated
m_inoutlinema_returned	updated	timestamp	29,6	√		null
m_inventory	updated	timestamp	29,6			now()	Date this record was updated
m_inventoryline	updated	timestamp	29,6			now()	Date this record was updated
m_inventorylinema	updated	timestamp	29,6			now()	Date this record was updated
m_locator	updated	timestamp	29,6			now()	Date this record was updated
m_locatortype	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_movement	updated	timestamp	29,6			now()	Date this record was updated
m_movementline	updated	timestamp	29,6			now()	Date this record was updated
m_movementlinema	updated	timestamp	29,6			now()	Date this record was updated
m_parttype	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_perpetualinv	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist_version	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_bom	updated	timestamp	29,6	√		null	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_qualitytest	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_production	updated	timestamp	29,6			now()	Date this record was updated
m_productionline	updated	timestamp	29,6			now()	Date this record was updated
m_productionlinema	updated	timestamp	29,6			now()	Date this record was updated
m_productionplan	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_qualitytest	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_qualitytestresult	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_replenish	updated	timestamp	29,6			now()	Date this record was updated
m_shipper	updated	timestamp	29,6			now()	Date this record was updated
m_storage	updated	timestamp	29,6	√		null	Date this record was updated
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
m_storagereservationlog	updated	timestamp	29,6				Date this record was updated
m_substitute	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
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
qm_specification	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
qm_specificationline	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_replenish	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
t_transaction	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist_version	validfrom	timestamp	29,6				Valid from including this date (first day)
qm_specification	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
qm_specification	validto	timestamp	29,6	√		null	Valid to including this date (last day)
qm_specificationline	validto	timestamp	29,6	√		null	Valid to including this date (last day)
c_projectissue	docstatus	varchar	2			'DR'::character varying	The current status of the document
m_production	docstatus	varchar	2			'DR'::character varying	The current status of the document
c_doctype	docsubtypeinv	varchar	2	√		NULL::character varying	Inventory Sub Type
c_uom	uomtype	varchar	2	√		NULL::character varying	UOM Type
c_uom	x12de355	varchar	4				UOM EDI X12 Code
m_inout	fob	varchar	10	√		NULL::character varying	Freight Terms
m_inout	freightcharges	varchar	10	√		NULL::character varying	Freight Charges
c_uom	uomsymbol	varchar	10	√		null	Symbol for a Unit of Measure
m_product	classification	varchar	12	√		null	Classification for grouping
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
m_inout	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_movement	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_product_po	upc	varchar	20	√		null	Bar Code (Universal Product Code or its superset European Article Number)
m_product	versionno	varchar	20	√		null	Version Number
qm_specificationline	validfrom	varchar	22	√		null	Valid from including this date (first day)
m_inout	documentno	varchar	30				Document sequence number of the document
m_inventory	documentno	varchar	30				Document sequence number of the document
m_movement	documentno	varchar	30				Document sequence number of the document
m_production	documentno	varchar	30				Document sequence number of the document
m_product_po	manufacturer	varchar	30	√		null	Manufacturer of the Product
m_product	sku	varchar	30	√		null	Stock Keeping Unit
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
m_product_po	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
c_charge	c_charge_uu	varchar	36	√		NULL::character varying	C_Charge_UU
c_doctype	c_doctype_uu	varchar	36	√		NULL::character varying	C_DocType_UU
c_projectissue	c_projectissue_uu	varchar	36	√		NULL::character varying	C_ProjectIssue_UU
c_projectissuema	c_projectissuema_uu	varchar	36	√		NULL::character varying	C_ProjectIssueMA_UU
c_uom_conversion	c_uom_conversion_uu	varchar	36	√		NULL::character varying	C_UOM_Conversion_UU
c_uom	c_uom_uu	varchar	36	√		NULL::character varying	C_UOM_UU
m_attributesetinstance	m_attributesetinstance_uu	varchar	36	√		NULL::character varying	M_AttributeSetInstance_UU
m_inout	m_inout_uu	varchar	36	√		NULL::character varying	M_InOut_UU
m_inoutline	m_inoutline_uu	varchar	36	√		NULL::character varying	M_InOutLine_UU
m_inoutlinema	m_inoutlinema_uu	varchar	36	√		NULL::character varying	M_InOutLineMA_UU
m_inoutlinema_returned	m_inoutlinema_uu	varchar	36	√		null
m_inventory	m_inventory_uu	varchar	36	√		NULL::character varying	M_Inventory_UU
m_inventoryline	m_inventoryline_uu	varchar	36	√		NULL::character varying	M_InventoryLine_UU
m_inventorylinema	m_inventorylinema_uu	varchar	36	√		NULL::character varying	M_InventoryLineMA_UU
m_locator	m_locator_uu	varchar	36	√		NULL::character varying	M_Locator_UU
m_locatortype	m_locatortype_uu	varchar	36	√		NULL::character varying	M_LocatorType_UU
m_movement	m_movement_uu	varchar	36	√		NULL::character varying	M_Movement_UU
m_movementline	m_movementline_uu	varchar	36	√		NULL::character varying	M_MovementLine_UU
m_movementlinema	m_movementlinema_uu	varchar	36	√		NULL::character varying	M_MovementLineMA_UU
m_parttype	m_parttype_uu	varchar	36	√		NULL::character varying	M_PartType_UU
m_perpetualinv	m_perpetualinv_uu	varchar	36	√		NULL::character varying	M_PerpetualInv_UU
m_pricelist	m_pricelist_uu	varchar	36	√		NULL::character varying	M_PriceList_UU
m_pricelist_version	m_pricelist_version_uu	varchar	36	√		NULL::character varying	M_PriceList_Version_UU
m_product_bom	m_product_bom_uu	varchar	36	√		null	M_Product_BOM_UU
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
m_product_po	m_product_po_uu	varchar	36	√		NULL::character varying	M_Product_PO_UU
m_product_qualitytest	m_product_qualitytest_uu	varchar	36	√		NULL::character varying	M_Product_QualityTest_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_production	m_production_uu	varchar	36	√		NULL::character varying	M_Production_UU
m_productionline	m_productionline_uu	varchar	36	√		NULL::character varying	M_ProductionLine_UU
m_productionlinema	m_productionlinema_uu	varchar	36	√		NULL::character varying	M_ProductionLineMA_UU
m_productionplan	m_productionplan_uu	varchar	36	√		NULL::character varying	M_ProductionPlan_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_qualitytest	m_qualitytest_uu	varchar	36	√		NULL::character varying	M_QualityTest_UU
m_qualitytestresult	m_qualitytestresult_uu	varchar	36	√		NULL::character varying	M_QualityTestResult_UU
m_replenish	m_replenish_uu	varchar	36	√		NULL::character varying	M_Replenish_UU
m_shipper	m_shipper_uu	varchar	36	√		NULL::character varying	M_Shipper_UU
m_storage	m_storage_uu	varchar	36	√		null	M_Storage_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_storagereservationlog	m_storagereservationlog_uu	varchar	36				M_StorageReservationLog_UU
m_substitute	m_substitute_uu	varchar	36	√		NULL::character varying	M_Substitute_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
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
qm_specification	qm_specification_uu	varchar	36	√		NULL::character varying	QM_Specification_UU
qm_specificationline	qm_specificationline_uu	varchar	36	√		NULL::character varying	QM_SpecificationLine_UU
t_replenish	t_replenish_uu	varchar	36	√		NULL::character varying	T_Replenish_UU
t_transaction	t_transaction_uu	varchar	36	√		NULL::character varying	T_Transaction_UU
m_attributesetinstance	lot	varchar	40	√		null	Lot number (alphanumeric)
m_attributesetinstance	serno	varchar	40	√		null	Product Serial Number
m_inout	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
m_locator	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_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
qm_specification	value	varchar	40	√		null	Search key for the record in the format required - must be unique
qm_specificationline	value	varchar	40	√		null	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_charge	name	varchar	60				Alphanumeric identifier of the entity
c_doctype	name	varchar	60				Alphanumeric identifier of the entity
c_uom	name	varchar	60				Alphanumeric identifier of the entity
m_locatortype	name	varchar	60				Alphanumeric identifier of the entity
m_perpetualinv	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist_version	name	varchar	60				Alphanumeric identifier of the entity
m_product_category	name	varchar	60				Alphanumeric identifier of the entity
m_production	name	varchar	60	√		null	Alphanumeric identifier of the entity
m_qualitytest	name	varchar	60				Alphanumeric identifier of the entity
m_shipper	name	varchar	60			NULL::character varying	Alphanumeric identifier of the entity
m_substitute	name	varchar	60	√		null	Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
qm_specification	name	varchar	60	√		null	Alphanumeric identifier of the entity
c_doctype	printname	varchar	60				The label text to be printed on a document or correspondence.
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
m_inout	trackingno	varchar	60	√		null	Number to track the shipment
m_locator	x	varchar	60	√		null	X dimension, e.g., Aisle
m_locator	y	varchar	60	√		null	Y dimension, e.g., Bin
m_locator	z	varchar	60	√		null	Z dimension, e.g., Level
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	downloadurl	varchar	120	√		null
m_product	imageurl	varchar	120	√		null	URL of image
c_charge	description	varchar	255	√		null	Optional short description of the record
c_doctype	description	varchar	255	√		null	Optional short description of the record
c_projectissue	description	varchar	255	√		null	Optional short description of the record
c_uom	description	varchar	255	√		null	Optional short description of the record
m_attributesetinstance	description	varchar	255	√		null	Optional short description of the record
m_inout	description	varchar	255	√		null	Optional short description of the record
m_inoutline	description	varchar	255	√		null	Optional short description of the record
m_inventory	description	varchar	255	√		null	Optional short description of the record
m_inventoryline	description	varchar	255	√		null	Optional short description of the record
m_locatortype	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_movement	description	varchar	255	√		null	Optional short description of the record
m_movementline	description	varchar	255	√		null	Optional short description of the record
m_parttype	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_perpetualinv	description	varchar	255	√		null	Optional short description of the record
m_pricelist	description	varchar	255	√		null	Optional short description of the record
m_pricelist_version	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_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_production	description	varchar	255	√		null	Optional short description of the record
m_productionline	description	varchar	255	√		null	Optional short description of the record
m_productionplan	description	varchar	255	√		null	Optional short description of the record
m_qualitytest	description	varchar	255	√		NULL::character varying	Optional short description of the record
m_substitute	description	varchar	255	√		null	Optional short description of the record
m_warehouse	description	varchar	255	√		null	Optional short description of the record
qm_specification	description	varchar	255	√		null	Optional short description of the record
m_storagereservationlog	documentno	varchar	255	√		null	Document sequence number of the document
m_product_qualitytest	expectedresult	varchar	255				Expected Result
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_parttype	name	varchar	255				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_qualitytestresult	result	varchar	255	√		NULL::character varying	Result of the action taken
m_product	value	varchar	510				Search key for the record in the format required - must be unique
c_doctype	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_locatortype	help	varchar	2000	√		NULL::character varying	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
m_qualitytest	help	varchar	2000	√		NULL::character varying	Comment or Hint
m_product_bom	bomtype	varchar	2147483647	√		null	Type of BOM