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

Table	Column	Type	Size	Nulls	Auto	Default
a_asset	a_qty_current	numeric	0	√		null	Current Qty
a_asset	a_qty_original	numeric	0	√		null	A_QTY_Original
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
s_resource	chargeableqty	numeric	0	√		0	Chargeable Quantity
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_order	chargeamt	numeric	0	√		0	Charge Amount
m_inout	chargeamt	numeric	0	√		0	Charge Amount
c_project	committedamt	numeric	0			0	The (legal) commitment amount
c_projectline	committedamt	numeric	0	√		0	The (legal) commitment amount
c_projectphase	committedamt	numeric	0			0	The (legal) commitment amount
c_projecttask	committedamt	numeric	0			0	The (legal) commitment amount
c_project	committedqty	numeric	0			0	The (legal) commitment Quantity
c_projectline	committedqty	numeric	0	√		0	The (legal) commitment Quantity
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
s_timeexpenseline	convertedamt	numeric	0	√		0	Converted Amount
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
s_resource	dailycapacity	numeric	0	√		null	Daily Capacity
c_orderline	discount	numeric	0	√		null	Discount in percent
c_paymentterm	discount	numeric	0				Discount in percent
c_paymentterm	discount2	numeric	0				Discount in percent
s_timeexpenseline	expenseamt	numeric	0	√		0	Amount for this expense
c_bpartner	flatdiscount	numeric	0	√		null	Flat discount percentage
c_order	freightamt	numeric	0	√		0	Freight Amount
c_orderline	freightamt	numeric	0			0	Freight Amount
m_inout	freightamt	numeric	0	√		0	Freight Amount
c_invoice	grandtotal	numeric	0			0	Total amount of document
c_order	grandtotal	numeric	0			0	Total amount of document
c_project	invoicedamt	numeric	0			0	The amount invoiced
c_projectline	invoicedamt	numeric	0			0	The amount invoiced
c_project	invoicedqty	numeric	0			0	The quantity invoiced
c_projectline	invoicedqty	numeric	0			0	The quantity invoiced
s_timeexpenseline	invoiceprice	numeric	0	√		0	Unit price to be invoiced or 0 for default price
a_asset	lifeuseunits	numeric	0	√		null	Units of use until the asset is not usable anymore
c_invoiceline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
c_projectissue	movementqty	numeric	0			0	Quantity of a product moved.
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
m_transaction	movementqty	numeric	0			0	Quantity of a product moved.
s_resource	percentutilization	numeric	0			(100)::numeric	% Utilization
m_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
c_project	plannedamt	numeric	0			0	Planned amount for this project
c_projectline	plannedamt	numeric	0			0	Planned amount for this project
c_projectphase	plannedamt	numeric	0			0	Planned amount for this project
c_projecttask	plannedamt	numeric	0			0	Planned amount for this project
c_project	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_projectline	plannedmarginamt	numeric	0			0	Project's planned margin amount
c_projectline	plannedprice	numeric	0			0	Planned price for this project line
c_project	plannedqty	numeric	0			0	Planned quantity for this project
c_projectline	plannedqty	numeric	0			0	Planned quantity for this project
c_bpartner	potentiallifetimevalue	numeric	0	√		0	Total Revenue expected
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_orderline	priceactual	numeric	0			0	Actual Price
c_projectphase	priceactual	numeric	0	√		0	Actual Price
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
c_invoiceline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_orderline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
s_timeexpenseline	priceinvoiced	numeric	0	√		null	The priced invoiced to the customer (in the currency of the customer's AR price list) - 0 for default 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
s_timeexpenseline	pricereimbursed	numeric	0	√		null	The reimbursed price (in currency of the employee's AP price list)
c_invoice	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_order	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
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
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
a_asset	qty	numeric	0	√		null	Quantity
c_projectphase	qty	numeric	0	√		0	Quantity
c_projecttask	qty	numeric	0	√		0	Quantity
s_timeexpenseline	qty	numeric	0	√		0	Quantity
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
c_invoiceline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_orderline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
m_inoutline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_invoiceline	qtyinvoiced	numeric	0			0	Invoiced Quantity
c_orderline	qtyinvoiced	numeric	0			0	Invoiced Quantity
s_timeexpenseline	qtyinvoiced	numeric	0	√		null	Invoiced Quantity
c_orderline	qtylostsales	numeric	0			0	Quantity of potential sales
c_orderline	qtyordered	numeric	0			0	Ordered Quantity
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
s_timeexpenseline	qtyreimbursed	numeric	0	√		null	The reimbursed quantity
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
s_resource	queuingtime	numeric	0	√		null	Queue time is the time a job waits at a work center before begin handled.
c_cyclestep	relativeweight	numeric	0				Relative weight of this step (0 = ignored)
c_invoiceline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_orderline	rramt	numeric	0	√		null	Revenue Recognition Amount
m_inoutline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_product	shelfheight	numeric	0	√		null	Shelf height required
c_bpartner	so_creditlimit	numeric	0	√		0	Total outstanding invoice amounts allowed
c_bpartner	so_creditused	numeric	0	√		0	Current open balance
c_phase	standardqty	numeric	0			0	Standard Quantity
c_task	standardqty	numeric	0			0	Standard Quantity
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
c_invoice	totallines	numeric	0			0	Total of all document lines
c_order	totallines	numeric	0			0	Total of all document lines
c_bpartner	totalopenbalance	numeric	0	√		null	Total Open Balance Amount in primary Accounting Currency
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
a_asset	useunits	numeric	0	√		null	Currently used units of the assets
c_order	volume	numeric	0	√		null	Volume of a product
m_inout	volume	numeric	0	√		null	Volume of a product
m_product	volume	numeric	0	√		0	Volume of a product
s_resource	waitingtime	numeric	0	√		null	Workflow Simulation Waiting time
c_order	weight	numeric	0	√		null	Weight of a product
m_inout	weight	numeric	0	√		null	Weight of a product
m_product	weight	numeric	0	√		0	Weight of a product
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
c_paymentterm	afterdelivery	bpchar	1			'N'::bpchar	Due after delivery rather than after invoicing
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
c_order	copyfrom	bpchar	1	√		null	Copy From Record
c_project	copyfrom	bpchar	1	√		null	Copy From Record
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
m_inout	createconfirm	bpchar	1	√		null	Create Confirm
c_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_inout	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_inout	createpackage	bpchar	1	√		null	Create Package
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
c_bpartner	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
m_inout	deliveryrule	bpchar	1				Defines the timing of Delivery
c_bpartner	deliveryviarule	bpchar	1	√		null	How the order will be delivered
c_order	deliveryviarule	bpchar	1				How the order will be delivered
m_inout	deliveryviarule	bpchar	1				How the order will be delivered
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
c_projectline	dopricing	bpchar	1	√		'Y'::bpchar	Pricing
c_bpartner	freightcostrule	bpchar	1	√		null	Method for charging Freight
c_order	freightcostrule	bpchar	1				Method for charging Freight
m_inout	freightcostrule	bpchar	1				Method for charging Freight
c_projectphase	generateorder	bpchar	1	√		null	Generate Order
c_invoice	generateto	bpchar	1	√		null	Generate To
c_project	generateto	bpchar	1	√		null	Generate To
m_inout	generateto	bpchar	1	√		null	Generate To
m_inout	insurance	bpchar	1	√		NULL::bpchar	Insurance
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
c_bpartner	invoicerule	bpchar	1	√		null	Frequency and method of invoicing
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
c_bpartner	is1099vendor	bpchar	1			'N'::bpchar	1099 Vendor
a_asset	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_activity	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_cycle	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_cyclephase	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_cyclestep	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_invoice	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_order	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_paymentterm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_phase	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_project	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_projectline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projectphase	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projecttask	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projecttype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_task	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_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_transaction	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
s_resource	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
s_timeexpenseline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inout	isalternatereturnaddress	bpchar	1			'N'::bpchar	Alternate Return Address
c_invoice	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
c_order	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
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_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
s_resource	isavailable	bpchar	1			'Y'::bpchar	Resource is available
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
c_project	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_projectphase	iscommitceiling	bpchar	1			'N'::bpchar	The commitment amount/quantity is the chargeable ceiling
c_project	iscommitment	bpchar	1			'Y'::bpchar	Is this document a (legal) commitment?
c_projectphase	iscomplete	bpchar	1			'N'::bpchar	It is complete
c_order	iscreditapproved	bpchar	1			'N'::bpchar	Credit has been approved
c_bpartner	iscustomer	bpchar	1			'Y'::bpchar	Indicates if this Business Partner is a Customer
c_paymentterm	isdefault	bpchar	1	√		'N'::bpchar	Default value
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
a_asset	isdepreciated	bpchar	1			'Y'::bpchar	The asset will be depreciated
c_invoiceline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
c_orderline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_inoutline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_bpartner	isdiscountprinted	bpchar	1	√		'Y'::bpchar	Print Discount on Invoice and Order
c_invoice	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
c_order	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
a_asset	isdisposed	bpchar	1			'N'::bpchar	The asset is disposed
c_order	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
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
c_paymentterm	isduefixed	bpchar	1			'N'::bpchar	Payment is due on a fixed date
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
c_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
a_asset	isfullydepreciated	bpchar	1			'N'::bpchar	The asset is fully depreciated
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
m_inout	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
a_asset	isinposession	bpchar	1			'Y'::bpchar	The asset is in the possession of the organization
m_inout	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_warehouse	isintransit	bpchar	1	√		'N'::bpchar	Movement is in transit
c_order	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_inoutline	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
s_timeexpenseline	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_bpartner	ismanufacturer	bpchar	1	√		'N'::bpchar	Indicate role of this Business partner as Manufacturer
s_resource	ismanufacturingresource	bpchar	1	√		'N'::bpchar	Manufacturing Resource
c_paymentterm	isnextbusinessday	bpchar	1	√		'Y'::bpchar	Payment due on the next business day
c_bpartner	isonetime	bpchar	1			'N'::bpchar	One time transaction
c_invoice	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
a_asset	isowned	bpchar	1			'Y'::bpchar	The asset is owned by the organization
c_invoice	ispaid	bpchar	1			'N'::bpchar	The document is paid
c_invoice	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
c_order	ispayschedulevalid	bpchar	1			'N'::bpchar	Is the Payment Schedule is valid
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_bpartner	ispotaxexempt	bpchar	1			'N'::bpchar	Business partner is exempt from tax on purchases
c_invoice	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_invoiceline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
c_order	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_projectline	isprinted	bpchar	1			'Y'::bpchar	Indicates if this document / line is printed
m_inout	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
c_bpartner	isprospect	bpchar	1			'N'::bpchar	Indicates this is a Prospect
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
c_bpartner	issalesrep	bpchar	1			'N'::bpchar	Indicates if the business partner is a sales representative or company agent
c_order	isselected	bpchar	1			'N'::bpchar	Selected
c_invoice	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_order	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	isselfservice	bpchar	1			'Y'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
m_product	issold	bpchar	1			'Y'::bpchar	Organization sells this product
c_invoice	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_order	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_inout	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
c_activity	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_project	issummary	bpchar	1			'N'::bpchar	This is a summary entity
m_product	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_bpartner	istaxexempt	bpchar	1	√		'N'::bpchar	Business partner is exempt from tax on sales
c_invoice	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_order	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
s_timeexpenseline	istimereport	bpchar	1			'N'::bpchar	Line is a time report only (no expense)
m_product	istoformule	bpchar	1	√		null
c_invoice	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_order	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_paymentterm	isvalid	bpchar	1			'N'::bpchar	Element is valid
c_bpartner	isvendor	bpchar	1			'N'::bpchar	Indicates if this Business Partner is a Vendor
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
c_paymentterm	netday	bpchar	1	√		null	Day when payment is due net
c_bpartner	paymentrule	bpchar	1	√		null	How you pay the invoice
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_order	paymentrule	bpchar	1				How you pay the invoice
c_bpartner	paymentrulepo	bpchar	1	√		null	Purchase payment option
c_paymentterm	paymenttermusage	bpchar	1			'B'::bpchar	Payment term usage indicates if this payment term is used for sales, purchases or both.
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
c_order	posted	bpchar	1			'N'::bpchar	Posting status
c_projectissue	posted	bpchar	1			'N'::bpchar	Posting status
m_inout	posted	bpchar	1			'N'::bpchar	Posting status
c_order	priorityrule	bpchar	1				Priority of a document
m_inout	priorityrule	bpchar	1				Priority of a document
m_pricelist_version	proccreate	bpchar	1	√		null	Create
a_asset	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoice	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoiceline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_order	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_project	processed	bpchar	1			'N'::bpchar	The document has been processed
c_projectissue	processed	bpchar	1			'N'::bpchar	The document has been processed
c_projectline	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
s_timeexpenseline	processed	bpchar	1			'N'::bpchar	The document has been processed
a_asset	processing	bpchar	1	√		'N'::bpchar	Process Now
c_invoice	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_paymentterm	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
c_projectissue	processing	bpchar	1	√		null	Process Now
m_inout	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
c_projecttype	projectcategory	bpchar	1			'N'::bpchar	Project Category
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
c_projectphase	projinvoicerule	bpchar	1	√		null	Invoice Rule for the project
c_projecttask	projinvoicerule	bpchar	1	√		null	Invoice Rule for the project
c_bpartner	rating	bpchar	1	√		null	Classification or Importance
c_bpartner	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_inout	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_warehouse	separator	bpchar	1				Element Separator
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
c_bpartner	socreditstatus	bpchar	1	√		'O'::bpchar	Business Partner Credit Status
a_asset	a_asset_action	varchar	2			'MD'::character varying	Asset Action
a_asset	a_asset_status	varchar	2			'NW'::character varying	Asset Status
c_invoice	docaction	bpchar	2				The targeted status of the document
c_order	docaction	bpchar	2				The targeted status of the document
c_projectissue	docaction	bpchar	2			'CO'::bpchar	The targeted status of the document
m_inout	docaction	bpchar	2				The targeted status of the document
c_invoice	docstatus	bpchar	2				The current status of the document
c_order	docstatus	bpchar	2				The current status of the document
c_projectissue	docstatus	varchar	2			'DR'::character varying	The current status of the document
m_inout	docstatus	bpchar	2				The current status of the document
s_resource	manufacturingresourcetype	bpchar	2	√		null	Manufacturing Resource Type
m_inout	movementtype	bpchar	2				Method of moving the inventory
m_transaction	movementtype	bpchar	2				Method of moving the inventory
a_asset	a_assettype	varchar	3			'MFX'::character varying	Asset Type
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
c_bpartner	ad_language	varchar	6	√		null	Language for this entity
c_bpartner	naics	varchar	6	√		null	Standard Industry Code or its successor NAIC - http://www.osha.gov/oshstats/sicser.html
a_asset	a_asset_class_id	numeric	10	√		NULL::numeric	Asset class
a_asset	a_asset_group_id	numeric	10				Group of Assets
c_invoiceline	a_asset_group_id	numeric	10	√		null	Group of Assets
a_asset	a_asset_id	numeric	10				Asset used internally or by customers
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
a_asset	a_asset_type_id	numeric	10	√		null	Asset Type
a_asset	a_parent_asset_id	numeric	10	√		null	Parent Asset
a_asset	ad_client_id	numeric	10				Client/Tenant for this installation.
c_activity	ad_client_id	numeric	10				Client/Tenant for this installation.
c_bpartner	ad_client_id	numeric	10				Client/Tenant for this installation.
c_cycle	ad_client_id	numeric	10				Client/Tenant for this installation.
c_cyclephase	ad_client_id	numeric	10				Client/Tenant for this installation.
c_cyclestep	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoice	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoiceline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_order	ad_client_id	numeric	10				Client/Tenant for this installation.
c_orderline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_paymentterm	ad_client_id	numeric	10				Client/Tenant for this installation.
c_phase	ad_client_id	numeric	10				Client/Tenant for this installation.
c_project	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projectissue	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projectline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projectphase	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projecttask	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projecttype	ad_client_id	numeric	10				Client/Tenant for this installation.
c_task	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inout	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inoutline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_pricelist_version	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_transaction	ad_client_id	numeric	10				Client/Tenant for this installation.
m_warehouse	ad_client_id	numeric	10				Client/Tenant for this installation.
s_resource	ad_client_id	numeric	10				Client/Tenant for this installation.
s_timeexpenseline	ad_client_id	numeric	10				Client/Tenant for this installation.
a_asset	ad_org_id	numeric	10				Organizational entity within client
c_activity	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_org_id	numeric	10				Organizational entity within client
c_cycle	ad_org_id	numeric	10				Organizational entity within client
c_cyclephase	ad_org_id	numeric	10				Organizational entity within client
c_cyclestep	ad_org_id	numeric	10				Organizational entity within client
c_invoice	ad_org_id	numeric	10				Organizational entity within client
c_invoiceline	ad_org_id	numeric	10				Organizational entity within client
c_order	ad_org_id	numeric	10				Organizational entity within client
c_orderline	ad_org_id	numeric	10				Organizational entity within client
c_paymentterm	ad_org_id	numeric	10				Organizational entity within client
c_phase	ad_org_id	numeric	10				Organizational entity within client
c_project	ad_org_id	numeric	10				Organizational entity within client
c_projectissue	ad_org_id	numeric	10				Organizational entity within client
c_projectline	ad_org_id	numeric	10				Organizational entity within client
c_projectphase	ad_org_id	numeric	10				Organizational entity within client
c_projecttask	ad_org_id	numeric	10				Organizational entity within client
c_projecttype	ad_org_id	numeric	10				Organizational entity within client
c_task	ad_org_id	numeric	10				Organizational entity within client
m_inout	ad_org_id	numeric	10				Organizational entity within client
m_inoutline	ad_org_id	numeric	10				Organizational entity within client
m_pricelist_version	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_transaction	ad_org_id	numeric	10				Organizational entity within client
m_warehouse	ad_org_id	numeric	10				Organizational entity within client
s_resource	ad_org_id	numeric	10				Organizational entity within client
s_timeexpenseline	ad_org_id	numeric	10				Organizational entity within client
c_bpartner	ad_orgbp_id	numeric	10	√		null	The Business Partner is another Organization for explicit Inter-Org transactions
c_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoiceline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_order	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_orderline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_project	ad_orgtrx_id	numeric	10	√		NULL::numeric	Performing or initiating organization
m_inout	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
c_invoice	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_order	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_project	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
m_inout	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
s_resource	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_order	bill_bpartner_id	numeric	10	√		null	Business Partner to be invoiced
c_order	bill_location_id	numeric	10	√		null	Business Partner Location for invoicing
c_order	bill_user_id	numeric	10	√		null	Business Partner Contact for invoicing
c_bpartner	bpartner_parent_id	numeric	10	√		null	Business Partner Parent
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
a_asset	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
c_activity	c_activity_id	numeric	10				Business Activity
c_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_invoiceline	c_activity_id	numeric	10	√		null	Business Activity
c_order	c_activity_id	numeric	10	√		null	Business Activity
c_orderline	c_activity_id	numeric	10	√		null	Business Activity
c_project	c_activity_id	numeric	10	√		NULL::numeric	Business Activity
m_inout	c_activity_id	numeric	10	√		null	Business Activity
m_inoutline	c_activity_id	numeric	10	√		null	Business Activity
s_timeexpenseline	c_activity_id	numeric	10	√		null	Business Activity
c_bpartner	c_bp_group_id	numeric	10				Business Partner Group
a_asset	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_bpartner	c_bpartner_id	numeric	10				Identifies a Business Partner
c_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
c_order	c_bpartner_id	numeric	10				Identifies a Business Partner
c_orderline	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_project	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
m_inout	c_bpartner_id	numeric	10				Identifies a Business Partner
s_timeexpenseline	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_invoice	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
c_order	c_bpartner_location_id	numeric	10				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
c_project	c_bpartner_location_id	numeric	10	√		null	Identifies the (ship to) address for this Business Partner
m_inout	c_bpartner_location_id	numeric	10				Identifies the (ship to) address for this Business Partner
a_asset	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
c_project	c_bpartnersr_id	numeric	10	√		null	Business Partner (Agent or Sales Rep)
c_invoice	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoiceline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_order	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_orderline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_project	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inout	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inoutline	c_campaign_id	numeric	10	√		null	Marketing Campaign
s_timeexpenseline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoice	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_order	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_order	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_invoiceline	c_charge_id	numeric	10	√		null	Additional document charges
c_order	c_charge_id	numeric	10	√		null	Additional document charges
c_orderline	c_charge_id	numeric	10	√		null	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
c_invoice	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_order	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
c_cycle	c_currency_id	numeric	10				The Currency for this record
c_invoice	c_currency_id	numeric	10				The Currency for this record
c_order	c_currency_id	numeric	10				The Currency for this record
c_orderline	c_currency_id	numeric	10				The Currency for this record
c_project	c_currency_id	numeric	10				The Currency for this record
s_timeexpenseline	c_currency_id	numeric	10	√		null	The Currency for this record
c_cycle	c_cycle_id	numeric	10				Identifier for this Project Reporting Cycle
c_cyclestep	c_cycle_id	numeric	10				Identifier for this Project Reporting Cycle
c_cyclephase	c_cyclestep_id	numeric	10				The step for this Cycle
c_cyclestep	c_cyclestep_id	numeric	10				The step for this Cycle
c_invoice	c_doctype_id	numeric	10				Document type or rules
c_order	c_doctype_id	numeric	10				Document type or rules
m_inout	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_order	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_bpartner	c_dunning_id	numeric	10	√		null	Dunning Rules for overdue invoices
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_bpartner	c_greeting_id	numeric	10	√		null	Greeting to print on correspondence
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_invoiceline	c_invoice_id	numeric	10				Invoice Identifier
m_inout	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
s_timeexpenseline	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
c_bpartner	c_invoiceschedule_id	numeric	10	√		null	Schedule for generating Invoices
a_asset	c_location_id	numeric	10	√		null	Location or Address
m_warehouse	c_location_id	numeric	10				Location or Address
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_invoice	c_order_id	numeric	10	√		null	Order
c_order	c_order_id	numeric	10				Order
c_orderline	c_order_id	numeric	10				Order
c_projectline	c_order_id	numeric	10	√		null	Order
c_projectphase	c_order_id	numeric	10	√		null	Order
m_inout	c_order_id	numeric	10	√		null	Order
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_id	numeric	10				Sales Order Line
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
s_timeexpenseline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_projectline	c_orderpo_id	numeric	10	√		null	Purchase Order
c_order	c_ordersource_id	numeric	10	√		null	Order Source
c_invoice	c_payment_id	numeric	10	√		null	Payment identifier
c_order	c_payment_id	numeric	10	√		null	Payment identifier
c_bpartner	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_invoice	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_order	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_paymentterm	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
c_cyclephase	c_phase_id	numeric	10				Standard Phase of the Project Type
c_phase	c_phase_id	numeric	10				Standard Phase of the Project Type
c_project	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_projectphase	c_phase_id	numeric	10	√		null	Standard Phase of the Project Type
c_task	c_phase_id	numeric	10				Standard Phase of the Project Type
c_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
a_asset	c_project_id	numeric	10	√		null	Financial Project
c_invoice	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	c_project_id	numeric	10	√		null	Financial Project
c_order	c_project_id	numeric	10	√		null	Financial Project
c_orderline	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_id	numeric	10				Financial Project
c_projectissue	c_project_id	numeric	10				Financial Project
c_projectline	c_project_id	numeric	10				Financial Project
c_projectphase	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
s_timeexpenseline	c_project_id	numeric	10	√		null	Financial Project
c_projectissue	c_projectissue_id	numeric	10				Project Issues (Material, Labor)
c_projectline	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
m_transaction	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
c_projectline	c_projectline_id	numeric	10				Task or step in a project
c_invoiceline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_projectline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_projectphase	c_projectphase_id	numeric	10				Phase of a Project
c_projecttask	c_projectphase_id	numeric	10				Phase of a Project
m_inoutline	c_projectphase_id	numeric	10	√		null	Phase of a Project
s_timeexpenseline	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
c_projectline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_projecttask	c_projecttask_id	numeric	10				Actual Project Task in a Phase
m_inoutline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
s_timeexpenseline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_phase	c_projecttype_id	numeric	10				Type of the project
c_project	c_projecttype_id	numeric	10	√		null	Type of the project
c_projecttype	c_projecttype_id	numeric	10				Type of the project
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_projecttask	c_task_id	numeric	10	√		null	Standard Project Type Task
c_task	c_task_id	numeric	10				Standard Project Type Task
c_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_orderline	c_tax_id	numeric	10				Tax identifier
m_product	c_taxcategory_id	numeric	10				Tax Category
c_bpartner	c_taxgroup_id	numeric	10	√		null	Tax Group
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
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
s_timeexpenseline	c_uom_id	numeric	10	√		null	Unit of Measure
a_asset	createdby	numeric	10				User who created this records
c_activity	createdby	numeric	10				User who created this records
c_bpartner	createdby	numeric	10				User who created this records
c_cycle	createdby	numeric	10				User who created this records
c_cyclephase	createdby	numeric	10				User who created this records
c_cyclestep	createdby	numeric	10				User who created this records
c_invoice	createdby	numeric	10				User who created this records
c_invoiceline	createdby	numeric	10				User who created this records
c_order	createdby	numeric	10				User who created this records
c_orderline	createdby	numeric	10				User who created this records
c_paymentterm	createdby	numeric	10				User who created this records
c_phase	createdby	numeric	10				User who created this records
c_project	createdby	numeric	10				User who created this records
c_projectissue	createdby	numeric	10				User who created this records
c_projectline	createdby	numeric	10				User who created this records
c_projectphase	createdby	numeric	10				User who created this records
c_projecttask	createdby	numeric	10				User who created this records
c_projecttype	createdby	numeric	10				User who created this records
c_task	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_pricelist_version	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_transaction	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
s_resource	createdby	numeric	10				User who created this records
s_timeexpenseline	createdby	numeric	10				User who created this records
c_bpartner	default1099box_id	numeric	10	√		NULL::numeric	Default 1099 Box
c_paymentterm	discountdays	numeric	10				Number of days from invoice date to be eligible for discount
c_paymentterm	discountdays2	numeric	10				Number of days from invoice date to be eligible for discount
c_bpartner	documentcopies	numeric	10	√		null	Number of copies to be printed
c_order	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
m_inout	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
c_order	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
m_inout	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
c_order	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
m_inout	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
c_paymentterm	fixmonthcutoff	numeric	10	√		null	Last day to include for next due date
c_paymentterm	fixmonthday	numeric	10	√		null	Day of the month of the due date
c_paymentterm	fixmonthoffset	numeric	10	√		null	Number of months (0=same, 1=following)
m_inout	fob	varchar	10	√		NULL::character varying	Freight Terms
m_inout	freightcharges	varchar	10	√		NULL::character varying	Freight Charges
c_paymentterm	gracedays	numeric	10				Days after due date to send first dunning letter
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_bpartner	invoice_printformat_id	numeric	10	√		null	Print Format for printing Invoices
a_asset	lastmaintenanceunit	numeric	10	√		null	Last Maintenance Unit
a_asset	lastmaintenanceuseunit	numeric	10	√		null
a_asset	lease_bpartner_id	numeric	10	√		null	The Business Partner who rents or leases
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
c_projectline	line	numeric	10				Unique line for this document
m_inoutline	line	numeric	10				Unique line for this document
s_timeexpenseline	line	numeric	10				Unique line for this document
c_order	link_order_id	numeric	10	√		null	This field links a sales order to the purchase order that is generated from it.
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.
c_bpartner	logo_id	numeric	10	√		NULL::numeric	Logo
m_product	lowlevel	numeric	10			(0)::numeric	The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
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
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_transaction	m_attributesetinstance_id	numeric	10			0	Product Attribute Set Instance
c_bpartner	m_discountschema_id	numeric	10	√		null	Schema to calculate the trade discount percentage
m_pricelist_version	m_discountschema_id	numeric	10				Schema to calculate the trade discount percentage
c_order	m_freightcategory_id	numeric	10	√		NULL::numeric	Category of the Freight
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
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_inoutline	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_transaction	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
a_asset	m_locator_id	numeric	10	√		null	Warehouse Locator
c_projectissue	m_locator_id	numeric	10				Warehouse Locator
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_transaction	m_locator_id	numeric	10				Warehouse Locator
m_transaction	m_movementline_id	numeric	10	√		null	Inventory Move document Line
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
c_bpartner	m_pricelist_id	numeric	10	√		null	Unique identifier of a Price List
c_invoice	m_pricelist_id	numeric	10				Unique identifier of a Price List
c_order	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
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
m_pricelist_version	m_pricelist_version_id	numeric	10				Identifies a unique instance of a Price List
c_projectline	m_product_category_id	numeric	10	√		null	Category of a Product
m_product	m_product_category_id	numeric	10				Category of a Product
a_asset	m_product_id	numeric	10				Product, Service, Item
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
c_phase	m_product_id	numeric	10	√		null	Product, Service, Item
c_projectissue	m_product_id	numeric	10				Product, Service, Item
c_projectline	m_product_id	numeric	10	√		null	Product, Service, Item
c_projectphase	m_product_id	numeric	10	√		null	Product, Service, Item
c_projecttask	m_product_id	numeric	10	√		null	Product, Service, Item
c_task	m_product_id	numeric	10	√		null	Product, Service, Item
m_inoutline	m_product_id	numeric	10	√		null	Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_transaction	m_product_id	numeric	10				Product, Service, Item
s_timeexpenseline	m_product_id	numeric	10	√		null	Product, Service, Item
c_projectline	m_production_id	numeric	10	√		NULL::numeric	Plan for producing a product
m_transaction	m_productionline_id	numeric	10	√		null	Document Line representing a production
c_orderline	m_promotion_id	numeric	10	√		null	Promotion
m_warehouse	m_reservelocator_id	numeric	10	√		NULL::numeric	Reservation Locator (just for reporting purposes)
c_invoice	m_rma_id	numeric	10	√		null	Return Material Authorization
m_inout	m_rma_id	numeric	10	√		null	Return Material Authorization
c_invoiceline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
m_inoutline	m_rmaline_id	numeric	10	√		null	Return Material Authorization Line
c_order	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
c_orderline	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_inout	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_transaction	m_transaction_id	numeric	10				Inventory Transaction
c_order	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_orderline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_inout	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
s_resource	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
a_asset	manufacturedyear	numeric	10	√		NULL::numeric	Manufactured Year
c_paymentterm	netdays	numeric	10				Net Days in which payment is due
a_asset	nextmaintenanceuseunit	numeric	10	√		null
a_asset	nextmaintenenceunit	numeric	10	√		null	Next Maintenence Unit
m_inout	nopackages	numeric	10	√		(1)::numeric	Number of packages shipped
c_bpartner	numberemployees	numeric	10	√		null	Number of employees
c_order	pay_bpartner_id	numeric	10	√		null	Business Partner responsible for the payment
c_order	pay_location_id	numeric	10	√		null	Location of the Business Partner responsible for the payment
s_resource	planninghorizon	numeric	10	√		(0)::numeric	The planning horizon is the amount of time (Days) an organisation will look into the future when preparing a strategic plan.
c_bpartner	po_discountschema_id	numeric	10	√		null	Schema to calculate the purchase trade discount percentage
c_bpartner	po_paymentterm_id	numeric	10	√		null	Payment rules for a purchase order
c_bpartner	po_pricelist_id	numeric	10	√		null	Price List used by this Business Partner
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
m_transaction	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
c_order	quotationorder_id	numeric	10	√		NULL::numeric	Quotation used for generating this order
m_product	r_mailtext_id	numeric	10	√		null	Text templates for mailings
m_inout	ref_inout_id	numeric	10	√		null	Referenced Shipment
m_inoutline	ref_inoutline_id	numeric	10	√		null	Referenced Shipment Line
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_invoiceline	ref_invoiceline_id	numeric	10	√		null	Referenced Invoice Line
c_order	ref_order_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_orderline	ref_orderline_id	numeric	10	√		null	Reference to corresponding Sales/Purchase Order
c_invoice	relatedinvoice_id	numeric	10	√		NULL::numeric	Related Invoice
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_invoice	reversal_id	numeric	10	√		null	ID of document reversal
c_projectissue	reversal_id	numeric	10	√		null	ID of document reversal
m_inout	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_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
s_resource	s_resource_id	numeric	10				Resource
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_orderline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
s_timeexpenseline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
s_resource	s_resourcetype_id	numeric	10				Resource Type
s_timeexpenseline	s_timeexpense_id	numeric	10				Time and Expense Report
c_projectissue	s_timeexpenseline_id	numeric	10	√		null	Time and Expense Report Line
s_timeexpenseline	s_timeexpenseline_id	numeric	10				Time and Expense Report Line
s_timeexpenseline	s_timetype_id	numeric	10	√		null	Type of time recorded
c_bpartner	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_order	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_project	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_inout	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
c_cyclestep	seqno	numeric	10				Method of ordering records; lowest number comes first
c_phase	seqno	numeric	10				Method of ordering records; lowest number comes first
c_projectphase	seqno	numeric	10				Method of ordering records; lowest number comes first
c_projecttask	seqno	numeric	10				Method of ordering records; lowest number comes first
c_task	seqno	numeric	10				Method of ordering records; lowest number comes first
c_bpartner	shareofcustomer	numeric	10	√		null	Share of Customer's business as a percentage
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
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	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
a_asset	updatedby	numeric	10				User who updated this records
c_activity	updatedby	numeric	10				User who updated this records
c_bpartner	updatedby	numeric	10				User who updated this records
c_cycle	updatedby	numeric	10				User who updated this records
c_cyclephase	updatedby	numeric	10				User who updated this records
c_cyclestep	updatedby	numeric	10				User who updated this records
c_invoice	updatedby	numeric	10				User who updated this records
c_invoiceline	updatedby	numeric	10				User who updated this records
c_order	updatedby	numeric	10				User who updated this records
c_orderline	updatedby	numeric	10				User who updated this records
c_paymentterm	updatedby	numeric	10				User who updated this records
c_phase	updatedby	numeric	10				User who updated this records
c_project	updatedby	numeric	10				User who updated this records
c_projectissue	updatedby	numeric	10				User who updated this records
c_projectline	updatedby	numeric	10				User who updated this records
c_projectphase	updatedby	numeric	10				User who updated this records
c_projecttask	updatedby	numeric	10				User who updated this records
c_projecttype	updatedby	numeric	10				User who updated this records
c_task	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_pricelist_version	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_transaction	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
s_resource	updatedby	numeric	10				User who updated this records
s_timeexpenseline	updatedby	numeric	10				User who updated this records
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_invoice	user1_id	numeric	10	√		null	User defined list element #1
c_invoiceline	user1_id	numeric	10	√		null	User defined list element #1
c_order	user1_id	numeric	10	√		null	User defined list element #1
c_orderline	user1_id	numeric	10	√		null	User defined list element #1
m_inout	user1_id	numeric	10	√		null	User defined list element #1
m_inoutline	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	user2_id	numeric	10	√		null	User defined list element #2
c_invoiceline	user2_id	numeric	10	√		null	User defined list element #2
c_order	user2_id	numeric	10	√		null	User defined list element #2
c_orderline	user2_id	numeric	10	√		null	User defined list element #2
m_inout	user2_id	numeric	10	√		null	User defined list element #2
m_inoutline	user2_id	numeric	10	√		null	User defined list element #2
c_bpartner	duns	varchar	11	√		null	Dun & Bradstreet Number
m_product	classification	varchar	12	√		null	Classification for grouping
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
c_bpartner	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_order	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_project	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
m_inout	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_bpartner	taxid	varchar	20	√		null	Tax Identification
a_asset	versionno	varchar	20	√		null	Version Number
m_product	versionno	varchar	20	√		null	Version Number
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
a_asset	a_asset_createdate	timestamp	29,6	√		null	Create Date
a_asset	a_asset_revaldate	timestamp	29,6	√		null	Revaluation Date
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
a_asset	created	timestamp	29,6			now()	Date this record was created
c_activity	created	timestamp	29,6			now()	Date this record was created
c_bpartner	created	timestamp	29,6			now()	Date this record was created
c_cycle	created	timestamp	29,6			now()	Date this record was created
c_cyclephase	created	timestamp	29,6			now()	Date this record was created
c_cyclestep	created	timestamp	29,6			now()	Date this record was created
c_invoice	created	timestamp	29,6			now()	Date this record was created
c_invoiceline	created	timestamp	29,6			now()	Date this record was created
c_order	created	timestamp	29,6			now()	Date this record was created
c_orderline	created	timestamp	29,6			now()	Date this record was created
c_paymentterm	created	timestamp	29,6			now()	Date this record was created
c_phase	created	timestamp	29,6			now()	Date this record was created
c_project	created	timestamp	29,6			now()	Date this record was created
c_projectissue	created	timestamp	29,6			now()	Date this record was created
c_projectline	created	timestamp	29,6			now()	Date this record was created
c_projectphase	created	timestamp	29,6			now()	Date this record was created
c_projecttask	created	timestamp	29,6			now()	Date this record was created
c_projecttype	created	timestamp	29,6			now()	Date this record was created
c_task	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_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_transaction	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
s_resource	created	timestamp	29,6			now()	Date this record was created
s_timeexpenseline	created	timestamp	29,6			now()	Date this record was created
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_order	dateacct	timestamp	29,6				Accounting Date
m_inout	dateacct	timestamp	29,6				Accounting Date
c_project	datecontract	timestamp	29,6	√		null	The (planned) effective date of this document.
c_orderline	datedelivered	timestamp	29,6	√		null	Date when the product was delivered
s_timeexpenseline	dateexpense	timestamp	29,6	√		null	Date of expense
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
c_invoice	dateordered	timestamp	29,6	√		null	Date of Order
c_order	dateordered	timestamp	29,6				Date of Order
c_orderline	dateordered	timestamp	29,6				Date of Order
m_inout	dateordered	timestamp	29,6	√		null	Date of Order
c_invoice	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	dateprinted	timestamp	29,6	√		null	Date the document was printed.
m_inout	dateprinted	timestamp	29,6	√		null	Date the document was printed.
c_order	datepromised	timestamp	29,6	√		null	Date Order was promised
c_orderline	datepromised	timestamp	29,6	√		null	Date Order was promised
m_inout	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	discontinuedby	timestamp	29,6	√		null
c_bpartner	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_projectphase	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_bpartner	firstsale	timestamp	29,6	√		null	Date of First Sale
a_asset	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
a_asset	lastmaintenancedate	timestamp	29,6	√		null	Last Maintenance Date
a_asset	lastmaintenencedate	timestamp	29,6	√		null
a_asset	leaseterminationdate	timestamp	29,6	√		null	Lease Termination Date
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_transaction	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
a_asset	nextmaintenencedate	timestamp	29,6	√		null	Next Maintenence Date
m_inout	pickdate	timestamp	29,6	√		null	Date/Time when picked for Shipment
c_invoiceline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
c_orderline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_inout	shipdate	timestamp	29,6	√		null	Shipment Date/Time
c_projectphase	startdate	timestamp	29,6	√		null	First effective day (inclusive)
a_asset	updated	timestamp	29,6			now()	Date this record was updated
c_activity	updated	timestamp	29,6			now()	Date this record was updated
c_bpartner	updated	timestamp	29,6			now()	Date this record was updated
c_cycle	updated	timestamp	29,6			now()	Date this record was updated
c_cyclephase	updated	timestamp	29,6			now()	Date this record was updated
c_cyclestep	updated	timestamp	29,6			now()	Date this record was updated
c_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceline	updated	timestamp	29,6			now()	Date this record was updated
c_order	updated	timestamp	29,6			now()	Date this record was updated
c_orderline	updated	timestamp	29,6			now()	Date this record was updated
c_paymentterm	updated	timestamp	29,6			now()	Date this record was updated
c_phase	updated	timestamp	29,6			now()	Date this record was updated
c_project	updated	timestamp	29,6			now()	Date this record was updated
c_projectissue	updated	timestamp	29,6			now()	Date this record was updated
c_projectline	updated	timestamp	29,6			now()	Date this record was updated
c_projectphase	updated	timestamp	29,6			now()	Date this record was updated
c_projecttask	updated	timestamp	29,6			now()	Date this record was updated
c_projecttype	updated	timestamp	29,6			now()	Date this record was updated
c_task	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_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_transaction	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
s_resource	updated	timestamp	29,6			now()	Date this record was updated
s_timeexpenseline	updated	timestamp	29,6			now()	Date this record was updated
m_pricelist_version	validfrom	timestamp	29,6				Valid from including this date (first day)
c_invoice	documentno	varchar	30				Document sequence number of the document
c_order	documentno	varchar	30				Document sequence number of the document
m_inout	documentno	varchar	30				Document sequence number of the document
a_asset	inventoryno	varchar	30	√		NULL::character varying	Inventory No
a_asset	manufacturer	varchar	30	√		NULL::character varying	Manufacturer of the Product
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
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)
a_asset	a_asset_uu	varchar	36	√		NULL::character varying	A_Asset_UU
c_activity	c_activity_uu	varchar	36	√		NULL::character varying	C_Activity_UU
c_bpartner	c_bpartner_uu	varchar	36	√		NULL::character varying	C_BPartner_UU
c_cycle	c_cycle_uu	varchar	36	√		NULL::character varying	C_Cycle_UU
c_cyclephase	c_cyclephase_uu	varchar	36	√		NULL::character varying	C_CyclePhase_UU
c_cyclestep	c_cyclestep_uu	varchar	36	√		NULL::character varying	C_CycleStep_UU
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_UU
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_UU
c_orderline	c_orderline_uu	varchar	36	√		NULL::character varying	C_OrderLine_UU
c_paymentterm	c_paymentterm_uu	varchar	36	√		NULL::character varying	C_PaymentTerm_UU
c_phase	c_phase_uu	varchar	36	√		NULL::character varying	C_Phase_UU
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
c_projectissue	c_projectissue_uu	varchar	36	√		NULL::character varying	C_ProjectIssue_UU
c_projectline	c_projectline_uu	varchar	36	√		NULL::character varying	C_ProjectLine_UU
c_projectphase	c_projectphase_uu	varchar	36	√		NULL::character varying	C_ProjectPhase_UU
c_projecttask	c_projecttask_uu	varchar	36	√		NULL::character varying	C_ProjectTask_UU
c_projecttype	c_projecttype_uu	varchar	36	√		NULL::character varying	C_ProjectType_UU
c_task	c_task_uu	varchar	36	√		NULL::character varying	C_Task_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_pricelist_version	m_pricelist_version_uu	varchar	36	√		NULL::character varying	M_PriceList_Version_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
m_transaction	m_transaction_uu	varchar	36	√		NULL::character varying	M_Transaction_UU
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
s_resource	s_resource_uu	varchar	36	√		NULL::character varying	S_Resource_UU
s_timeexpenseline	s_timeexpenseline_uu	varchar	36	√		NULL::character varying	S_TimeExpenseLine_UU
c_bpartner	referenceno	varchar	40	√		null	Your customer or vendor number at the Business Partner's site
m_inout	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
a_asset	value	varchar	40				Search key for the record in the format required - must be unique
c_activity	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
c_paymentterm	value	varchar	40				Search key for the record in the format required - must be unique
c_project	value	varchar	40				Search key for the record in the format required - must be unique
m_product	value	varchar	40				Search key for the record in the format required - must be unique
m_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
s_resource	value	varchar	40				Search key for the record in the format required - must be unique
c_bpartner	customerprofileid	varchar	60	√		NULL::character varying	Customer Profile ID
a_asset	lastmaintenancenote	varchar	60	√		null	Last Maintenance Note
a_asset	name	varchar	60				Alphanumeric identifier of the entity
c_activity	name	varchar	60				Alphanumeric identifier of the entity
c_cycle	name	varchar	60				Alphanumeric identifier of the entity
c_cyclestep	name	varchar	60				Alphanumeric identifier of the entity
c_paymentterm	name	varchar	60				Alphanumeric identifier of the entity
c_phase	name	varchar	60				Alphanumeric identifier of the entity
c_project	name	varchar	60				Alphanumeric identifier of the entity
c_projectphase	name	varchar	60				Alphanumeric identifier of the entity
c_projecttask	name	varchar	60				Alphanumeric identifier of the entity
c_projecttype	name	varchar	60				Alphanumeric identifier of the entity
c_task	name	varchar	60				Alphanumeric identifier of the entity
m_pricelist_version	name	varchar	60				Alphanumeric identifier of the entity
m_warehouse	name	varchar	60				Alphanumeric identifier of the entity
s_resource	name	varchar	60				Alphanumeric identifier of the entity
c_bpartner	name2	varchar	60	√		null	Additional Name
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_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_bpartner	name	varchar	120				Alphanumeric identifier of the entity
c_bpartner	url	varchar	120	√		null	Full URL address - e.g. http://www.idempiere.org
a_asset	description	varchar	255	√		null	Optional short description of the record
c_activity	description	varchar	255	√		null	Optional short description of the record
c_bpartner	description	varchar	255	√		null	Optional short description of the record
c_cycle	description	varchar	255	√		null	Optional short description of the record
c_invoice	description	varchar	255	√		null	Optional short description of the record
c_invoiceline	description	varchar	255	√		null	Optional short description of the record
c_order	description	varchar	255	√		null	Optional short description of the record
c_orderline	description	varchar	255	√		null	Optional short description of the record
c_paymentterm	description	varchar	255	√		null	Optional short description of the record
c_phase	description	varchar	255	√		null	Optional short description of the record
c_project	description	varchar	255	√		null	Optional short description of the record
c_projectissue	description	varchar	255	√		null	Optional short description of the record
c_projectline	description	varchar	255	√		null	Optional short description of the record
c_projectphase	description	varchar	255	√		null	Optional short description of the record
c_projecttask	description	varchar	255	√		null	Optional short description of the record
c_projecttype	description	varchar	255	√		null	Optional short description of the record
c_task	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_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_warehouse	description	varchar	255	√		null	Optional short description of the record
s_resource	description	varchar	255	√		null	Optional short description of the record
s_timeexpenseline	description	varchar	255	√		null	Optional short description of the record
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
a_asset	locationcomment	varchar	255	√		null	Additional comments or remarks concerning the location
a_asset	lot	varchar	255	√		null	Lot number (alphanumeric)
m_product	name	varchar	255				Alphanumeric identifier of the entity
s_timeexpenseline	note	varchar	255	√		null	Optional additional user defined information
a_asset	serno	varchar	255	√		null	Product Serial Number
c_bpartner	so_description	varchar	255	√		null	Description to be used on orders
c_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
c_paymentterm	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
a_asset	help	varchar	2000	√		null	Comment or Hint
c_activity	help	varchar	2000	√		null	Comment or Hint
c_phase	help	varchar	2000	√		null	Comment or Hint
c_projectphase	help	varchar	2000	√		null	Comment or Hint
c_projecttask	help	varchar	2000	√		null	Comment or Hint
c_projecttype	help	varchar	2000	√		null	Comment or Hint
c_task	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
c_project	note	varchar	2000	√		null	Optional additional user defined information