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

Table	Column	Type	Size	Nulls	Auto	Default
c_invoiceline	a_asset_group_id	numeric	10	√		null	Group of Assets
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
ad_org	ad_org_uu	varchar	36	√		NULL::character varying	AD_Org_UU
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_inoutline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
ad_org	ad_replicationstrategy_id	numeric	0	√		null	Data Replication Strategy
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
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
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_elementvalue	bpartnertype	bpchar	1	√		NULL::bpchar	Business Partner Type
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
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_inoutline	c_activity_id	numeric	10	√		null	Business Activity
c_activity	c_activity_uu	varchar	36	√		NULL::character varying	C_Activity_UU
c_elementvalue	c_bankaccount_id	numeric	10	√		null	Account at the Bank
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_requisitionline	c_bpartner_id	numeric	10	√		NULL::numeric	Identifies a 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
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_inoutline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_campaign	c_campaign_uu	varchar	36	√		NULL::character varying	C_Campaign_UU
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_campaign	c_channel_id	numeric	10	√		null	Sales Channel
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_inoutline	c_charge_id	numeric	10	√		null	Additional document charges
m_requisitionline	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_elementvalue	c_currency_id	numeric	10	√		null	The Currency for this record
m_product_po	c_currency_id	numeric	10	√		null	The Currency for this record
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_elementvalue	c_elementvalue_uu	varchar	36	√		NULL::character varying	C_ElementValue_UU
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
m_matchpo	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_UU
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_invoice	c_order_id	numeric	10	√		null	Order
c_projectphase	c_order_id	numeric	10	√		null	Order
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_UU
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
m_requisitionline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderline	c_orderline_uu	varchar	36	√		NULL::character varying	C_OrderLine_UU
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_project	c_paymentterm_id	numeric	10	√		null	The terms of Payment (timing, discount)
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_order	c_pos_id	numeric	10	√		null	Point of Sales Terminal
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
m_inoutline	c_project_id	numeric	10	√		null	Financial Project
c_project	c_project_uu	varchar	36	√		NULL::character varying	C_Project_UU
c_invoiceline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
m_inoutline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_projectphase	c_projectphase_uu	varchar	36	√		NULL::character varying	C_ProjectPhase_UU
c_invoiceline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_orderline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_inoutline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_projecttask	c_projecttask_uu	varchar	36	√		NULL::character varying	C_ProjectTask_UU
c_project	c_projecttype_id	numeric	10	√		null	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_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
m_product_po	c_uom_id	numeric	10	√		null	Unit of Measure
m_requisitionline	c_uom_id	numeric	10	√		NULL::numeric	Unit of Measure
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
c_order	chargeamt	numeric	0	√		0	Charge Amount
m_product	classification	varchar	12	√		null	Classification for grouping
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
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_product_po	costperorder	numeric	0	√		0	Fixed Cost Per Order
c_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
c_orderline	createproduction	bpchar	1	√		'N'::bpchar	Create Production
c_orderline	createshipment	bpchar	1	√		'N'::bpchar	Create Shipment
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
m_matchinv	dateacct	timestamp	29,6	√		null	Accounting Date
m_matchpo	dateacct	timestamp	29,6	√		null	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
c_project	datefinish	timestamp	29,6	√		null	Finish or (planned) completion date
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
c_invoice	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.
c_order	datepromised	timestamp	29,6	√		null	Date Order was promised
c_orderline	datepromised	timestamp	29,6	√		null	Date Order was promised
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
ad_org	description	varchar	255	√		null	Optional short description of the record
c_activity	description	varchar	255	√		null	Optional short description of the record
c_campaign	description	varchar	255	√		null	Optional short description of the record
c_elementvalue	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_project	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
m_inoutline	description	varchar	255	√		null	Optional short description of the record
m_matchinv	description	varchar	255	√		null	Optional short description of the record
m_matchpo	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_requisition	description	varchar	255	√		null	Optional short description of the record
m_requisitionline	description	varchar	255	√		null	Optional short description of the record
m_product	descriptionurl	varchar	120	√		null	URL for the description
m_product	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product_po	discontinued	bpchar	1	√		'N'::bpchar	This product is no longer available
m_product	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product_po	discontinuedat	timestamp	29,6	√		null	Discontinued At indicates Date when product was discontinued
m_product	discontinuedby	timestamp	29,6	√		null
m_product_po	discontinuedby	timestamp	29,6	√		null
c_orderline	discount	numeric	0	√		null	Discount in percent
m_matchinv	documentno	varchar	30	√		null	Document sequence number of the document
m_matchpo	documentno	varchar	30	√		null	Document sequence number of the document
m_product	documentnote	varchar	2000	√		null	Additional information for a Document
m_product	downloadurl	varchar	120	√		null
c_order	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
c_order	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
c_campaign	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_projectphase	enddate	timestamp	29,6	√		null	Last effective date (inclusive)
c_order	freightamt	numeric	0	√		0	Freight Amount
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_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_product	guaranteedays	numeric	10	√		null	Number of days the product is guaranteed or available
m_product	guaranteedaysmin	numeric	10	√		null	Minimum number of guarantee days
c_activity	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
m_product	help	varchar	2000	√		null	Comment or Hint
m_requisition	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
m_matchpo	isapproved	bpchar	1	√		'Y'::bpchar	Indicates if this document requires approval
m_inoutline	isautoproduce	bpchar	1	√		'N'::bpchar	Auto create production to fulfill shipment
c_elementvalue	isbankaccount	bpchar	1	√		'N'::bpchar	Indicates if this is the Bank Account
c_elementvalue	isdoccontrolled	bpchar	1	√		'N'::bpchar	Control account - If an account is controlled by a document, you cannot post manually to it
c_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_elementvalue	isforeigncurrency	bpchar	1	√		'N'::bpchar	Balances in foreign currency accounts are held in the nominated currency
m_product	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	istoformule	bpchar	1	√		null
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
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.
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_matchinv	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_matchpo	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_requisitionline	m_attributesetinstance_id	numeric	0	√		null	Product Attribute Set Instance
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
c_invoiceline	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_matchinv	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_matchpo	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_inoutline	m_inoutline_uu	varchar	36	√		NULL::character varying	M_InOutLine_UU
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_matchinv	m_matchinv_uu	varchar	36	√		NULL::character varying	M_MatchInv_UU
m_matchpo	m_matchpo_uu	varchar	36	√		NULL::character varying	M_MatchPO_UU
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
c_project	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
c_projectphase	m_product_id	numeric	10	√		null	Product, Service, Item
c_projecttask	m_product_id	numeric	10	√		null	Product, Service, Item
m_inoutline	m_product_id	numeric	10	√		null	Product, Service, Item
m_matchinv	m_product_id	numeric	10	√		null	Product, Service, Item
m_matchpo	m_product_id	numeric	10	√		null	Product, Service, Item
m_requisitionline	m_product_id	numeric	10	√		null	Product, Service, Item
m_product_po	m_product_po_uu	varchar	36	√		NULL::character varying	M_Product_PO_UU
m_product	m_product_uu	varchar	36	√		NULL::character varying	M_Product_UU
c_orderline	m_promotion_id	numeric	10	√		null	Promotion
m_requisition	m_requisition_uu	varchar	36	√		NULL::character varying	M_Requisition_UU
m_requisitionline	m_requisitionline_uu	varchar	36	√		NULL::character varying	M_RequisitionLine_UU
c_invoice	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
c_project	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_product_po	manufacturer	varchar	30	√		null	Manufacturer of the Product
c_project	note	varchar	2000	√		null	Optional additional user defined information
m_product_po	order_min	numeric	0	√		0	Minimum order quantity in UOM
m_product_po	order_pack	numeric	0	√		0	Package order size in UOM (e.g. order set of 5 units)
c_order	ordertype	varchar	510	√		null	Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
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
m_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
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
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
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.)
m_product_po	priceeffective	timestamp	29,6	√		null	Effective Date of Price
m_product_po	pricelastinv	numeric	0	√		0	Price of the last invoice for the product
m_product_po	pricelastpo	numeric	0	√		0	Price of the last purchase order for the product
m_product_po	pricelist	numeric	0	√		0	List Price
m_matchpo	pricematchdifference	numeric	0	√		null	Difference between Purchase and Invoice Price per matched line
m_product_po	pricepo	numeric	0	√		0	Price based on a purchase order
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
m_matchinv	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_matchpo	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_requisition	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
c_invoice	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_project	processing	bpchar	1	√		null	Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_requisition	processing	bpchar	1	√		null	Process Now
c_project	projectcategory	bpchar	1	√		'N'::bpchar	Project Category
c_projectphase	projinvoicerule	bpchar	1	√		null	Invoice Rule for the project
c_projecttask	projinvoicerule	bpchar	1	√		null	Invoice Rule for the project
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
c_projectphase	qty	numeric	0	√		0	Quantity
c_projecttask	qty	numeric	0	√		0	Quantity
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
m_product_po	qualityrating	numeric	0	√		null	Method for rating vendors
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_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
m_matchinv	ref_matchinv_id	numeric	10	√		NULL::numeric	Referenced Match Invoice
m_matchpo	ref_matchpo_id	numeric	10	√		NULL::numeric	Referenced Match PO
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
c_invoice	reversal_id	numeric	10	√		null	ID of document reversal
m_matchinv	reversal_id	numeric	10	√		NULL::numeric	ID of document reversal
m_matchpo	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_product_po	royaltyamt	numeric	0	√		0	(Included) Amount for copyright, etc.
c_invoiceline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_orderline	rramt	numeric	0	√		null	Revenue Recognition Amount
c_invoiceline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
c_orderline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_product	s_expensetype_id	numeric	10	√		null	Expense report type
m_product	s_resource_id	numeric	10	√		null	Resource
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_orderline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_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_product	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_inoutline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
m_product	shelfwidth	numeric	10	√		null	Shelf width required
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
m_product	sku	varchar	30	√		null	Stock Keeping Unit
c_campaign	startdate	timestamp	29,6	√		null	First effective day (inclusive)
c_projectphase	startdate	timestamp	29,6	√		null	First effective day (inclusive)
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
m_product	upc	varchar	30	√		null	Bar Code (Universal Product Code or its superset European Article Number)
m_product_po	upc	varchar	20	√		null	Bar Code (Universal Product Code or its superset European Article Number)
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_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_inoutline	user2_id	numeric	10	√		null	User defined list element #2
c_elementvalue	validfrom	timestamp	29,6	√		null	Valid from including this date (first day)
c_elementvalue	validto	timestamp	29,6	√		null	Valid to including this date (last day)
m_product_po	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
m_product	versionno	varchar	20	√		null	Version Number
c_order	volume	numeric	0	√		null	Volume of a product
m_product	volume	numeric	0	√		0	Volume of a product
c_order	weight	numeric	0	√		null	Weight of a product
m_product	weight	numeric	0	√		0	Weight of a product
c_elementvalue	accountsign	bpchar	1				Indicates the Natural Sign of the Account as a Debit or Credit
c_elementvalue	accounttype	bpchar	1				Indicates the type of account
ad_org	ad_client_id	numeric	10				Client/Tenant for this installation.
c_activity	ad_client_id	numeric	10				Client/Tenant for this installation.
c_campaign	ad_client_id	numeric	10				Client/Tenant for this installation.
c_elementvalue	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_project	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.
m_inoutline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_matchinv	ad_client_id	numeric	10				Client/Tenant for this installation.
m_matchpo	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_po	ad_client_id	numeric	10				Client/Tenant for this installation.
m_requisition	ad_client_id	numeric	10				Client/Tenant for this installation.
m_requisitionline	ad_client_id	numeric	10				Client/Tenant for this installation.
ad_org	ad_org_id	numeric	10				Organizational entity within client
c_activity	ad_org_id	numeric	10				Organizational entity within client
c_campaign	ad_org_id	numeric	10				Organizational entity within client
c_elementvalue	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_project	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
m_inoutline	ad_org_id	numeric	10				Organizational entity within client
m_matchinv	ad_org_id	numeric	10				Organizational entity within client
m_matchpo	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_product_po	ad_org_id	numeric	10				Organizational entity within client
m_requisition	ad_org_id	numeric	10				Organizational entity within client
m_requisitionline	ad_org_id	numeric	10				Organizational entity within client
m_requisition	ad_user_id	numeric	10				User within the system - Internal or Business Partner Contact
c_activity	c_activity_id	numeric	10				Business Activity
c_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
c_order	c_bpartner_id	numeric	10				Identifies a Business Partner
m_product_po	c_bpartner_id	numeric	10				Identifies a 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_campaign	c_campaign_id	numeric	10				Marketing Campaign
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
c_invoice	c_doctype_id	numeric	10				Document type or rules
c_order	c_doctype_id	numeric	10				Document type or rules
m_requisition	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_elementvalue	c_element_id	numeric	10				Accounting Element
c_elementvalue	c_elementvalue_id	numeric	10				Account Element
c_invoice	c_invoice_id	numeric	10				Invoice Identifier
c_invoiceline	c_invoice_id	numeric	10				Invoice Identifier
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
m_matchinv	c_invoiceline_id	numeric	10				Invoice Detail Line
c_order	c_order_id	numeric	10				Order
c_orderline	c_order_id	numeric	10				Order
c_orderline	c_orderline_id	numeric	10				Sales Order Line
m_matchpo	c_orderline_id	numeric	10				Sales Order Line
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_project	c_project_id	numeric	10				Financial Project
c_projectphase	c_project_id	numeric	10				Financial Project
c_projectphase	c_projectphase_id	numeric	10				Phase of a Project
c_projecttask	c_projectphase_id	numeric	10				Phase of a Project
c_projecttask	c_projecttask_id	numeric	10				Actual Project Task in a Phase
c_orderline	c_tax_id	numeric	10				Tax identifier
m_product	c_taxcategory_id	numeric	10				Tax Category
c_orderline	c_uom_id	numeric	10				Unit of Measure
m_inoutline	c_uom_id	numeric	10				Unit of Measure
m_product	c_uom_id	numeric	10				Unit of Measure
c_project	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_campaign	costs	numeric	0			0	Costs in accounting currency
ad_org	created	timestamp	29,6			now()	Date this record was created
c_activity	created	timestamp	29,6			now()	Date this record was created
c_campaign	created	timestamp	29,6			now()	Date this record was created
c_elementvalue	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_project	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
m_inoutline	created	timestamp	29,6			now()	Date this record was created
m_matchinv	created	timestamp	29,6			now()	Date this record was created
m_matchpo	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_po	created	timestamp	29,6			now()	Date this record was created
m_requisition	created	timestamp	29,6			now()	Date this record was created
m_requisitionline	created	timestamp	29,6			now()	Date this record was created
ad_org	createdby	numeric	10				User who created this records
c_activity	createdby	numeric	10				User who created this records
c_campaign	createdby	numeric	10				User who created this records
c_elementvalue	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_project	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
m_inoutline	createdby	numeric	10				User who created this records
m_matchinv	createdby	numeric	10				User who created this records
m_matchpo	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_po	createdby	numeric	10				User who created this records
m_requisition	createdby	numeric	10				User who created this records
m_requisitionline	createdby	numeric	10				User who created this records
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_order	dateacct	timestamp	29,6				Accounting Date
m_requisition	datedoc	timestamp	29,6			now()	Date of the Document
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_order	dateordered	timestamp	29,6				Date of Order
c_orderline	dateordered	timestamp	29,6				Date of Order
m_requisition	daterequired	timestamp	29,6				Date when required
m_matchinv	datetrx	timestamp	29,6				Transaction Date
m_matchpo	datetrx	timestamp	29,6				Transaction Date
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
c_order	deliveryviarule	bpchar	1				How the order will be delivered
c_invoice	docaction	bpchar	2				The targeted status of the document
c_order	docaction	bpchar	2				The targeted status of the document
m_requisition	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
m_requisition	docstatus	bpchar	2				The current status of the document
c_invoice	documentno	varchar	30				Document sequence number of the document
c_order	documentno	varchar	30				Document sequence number of the document
m_requisition	documentno	varchar	30				Document sequence number of the document
c_orderline	freightamt	numeric	0			0	Freight Amount
c_order	freightcostrule	bpchar	1				Method for charging Freight
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_project	invoicedqty	numeric	0			0	The quantity invoiced
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
ad_org	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_campaign	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_elementvalue	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_project	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
m_inoutline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_matchinv	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_matchpo	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_po	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_requisition	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_requisitionline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
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
m_requisition	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
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
m_product_po	iscurrentvendor	bpchar	1			'Y'::bpchar	Use this Vendor for pricing and stock replenishment
c_order	isdelivered	bpchar	1			'N'::bpchar	Delivered
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
c_elementvalue	isdetailbpartner	bpchar	1			'N'::bpchar	Manage Business Partners
c_elementvalue	isdetailproduct	bpchar	1			'N'::bpchar	Manage Products
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
c_order	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_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
c_order	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_inoutline	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
m_product	isinvoiceprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the invoice
m_product	iskanban	bpchar	1			'N'::bpchar	This part is Kanban controlled
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
c_invoice	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
m_product	isownbox	bpchar	1			'N'::bpchar	Own Box
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	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
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_order	ispriviledgedrate	bpchar	1			'N'::bpchar	Priviledged Rate
m_product	ispurchased	bpchar	1			'Y'::bpchar	Organization purchases this product
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_product	isstocked	bpchar	1			'Y'::bpchar	Organization stocks this product
ad_org	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_activity	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_campaign	issummary	bpchar	1			'N'::bpchar	This is a summary entity
c_elementvalue	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_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
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)
m_product	isverified	bpchar	1			'N'::bpchar	The BOM configuration has been verified
m_product	iswebstorefeatured	bpchar	1			'N'::bpchar	If selected, the product is displayed in the initial or any empty search
c_invoiceline	line	numeric	10				Unique line for this document
c_orderline	line	numeric	10				Unique line for this document
m_inoutline	line	numeric	10				Unique line for this document
m_requisitionline	line	numeric	10				Unique line for this document
c_invoiceline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
m_requisitionline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
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_inoutline	m_inout_id	numeric	10				Material Shipment Document
m_inoutline	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_matchinv	m_matchinv_id	numeric	10				Match Shipment/Receipt to Invoice
m_matchpo	m_matchpo_id	numeric	10				Match Purchase Order to Shipment/Receipt and Invoice
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_requisition	m_pricelist_id	numeric	10				Unique identifier of a Price List
m_product	m_product_category_id	numeric	10				Category of a Product
m_product	m_product_id	numeric	10				Product, Service, Item
m_product_po	m_product_id	numeric	10				Product, Service, Item
m_requisition	m_requisition_id	numeric	10				Material Requisition
m_requisitionline	m_requisition_id	numeric	10				Material Requisition
m_requisitionline	m_requisitionline_id	numeric	10				Material Requisition Line
c_order	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
c_orderline	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_requisition	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
ad_org	name	varchar	60				Alphanumeric identifier of the entity
c_activity	name	varchar	60				Alphanumeric identifier of the entity
c_campaign	name	varchar	60				Alphanumeric identifier of the entity
c_elementvalue	name	varchar	120				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
m_product	name	varchar	255				Alphanumeric identifier of the entity
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_order	paymentrule	bpchar	1				How you pay the invoice
c_project	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_project	plannedqty	numeric	0			0	Planned quantity for this project
c_elementvalue	postactual	bpchar	1			'Y'::bpchar	Actual Values can be posted
c_elementvalue	postbudget	bpchar	1			'Y'::bpchar	Budget values can be posted
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
c_order	posted	bpchar	1			'N'::bpchar	Posting status
m_matchinv	posted	bpchar	1			'N'::bpchar	Posting status
m_matchpo	posted	bpchar	1			'N'::bpchar	Posting status
m_requisition	posted	bpchar	1			'N'::bpchar	Posting status
c_elementvalue	postencumbrance	bpchar	1			'Y'::bpchar	Post commitments to this account
c_elementvalue	poststatistical	bpchar	1			'Y'::bpchar	Post statistical quantities to this account?
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_orderline	priceactual	numeric	0			0	Actual Price
m_requisitionline	priceactual	numeric	0			0	Actual Price
c_invoiceline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_orderline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_invoiceline	pricelimit	numeric	0			0	Lowest price for a product
c_orderline	pricelimit	numeric	0			0	Lowest price for a product
c_invoiceline	pricelist	numeric	0			0	List Price
c_orderline	pricelist	numeric	0			0	List Price
c_order	priorityrule	bpchar	1				Priority of a document
m_requisition	priorityrule	bpchar	1				Priority of a document
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
m_inoutline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_matchinv	processed	bpchar	1			'N'::bpchar	The document has been processed
m_matchpo	processed	bpchar	1			'N'::bpchar	The document has been processed
m_requisition	processed	bpchar	1			'N'::bpchar	The document has been processed
m_matchinv	processing	bpchar	1				Process Now
m_matchpo	processing	bpchar	1				Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_project	projectbalanceamt	numeric	0			0	Total Project Balance
c_project	projectlinelevel	bpchar	1			'P'::bpchar	Project Line Level
c_project	projinvoicerule	bpchar	1			'-'::bpchar	Invoice Rule for the project
m_matchinv	qty	numeric	0			0	Quantity
m_matchpo	qty	numeric	0			0	Quantity
m_requisitionline	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
c_orderline	qtylostsales	numeric	0			0	Quantity of potential sales
c_orderline	qtyordered	numeric	0			0	Ordered Quantity
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
c_order	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
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_invoice	totallines	numeric	0			0	Total of all document lines
c_order	totallines	numeric	0			0	Total of all document lines
m_requisition	totallines	numeric	0			0	Total of all document lines
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
ad_org	updated	timestamp	29,6			now()	Date this record was updated
c_activity	updated	timestamp	29,6			now()	Date this record was updated
c_campaign	updated	timestamp	29,6			now()	Date this record was updated
c_elementvalue	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_project	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
m_inoutline	updated	timestamp	29,6			now()	Date this record was updated
m_matchinv	updated	timestamp	29,6			now()	Date this record was updated
m_matchpo	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_po	updated	timestamp	29,6			now()	Date this record was updated
m_requisition	updated	timestamp	29,6			now()	Date this record was updated
m_requisitionline	updated	timestamp	29,6			now()	Date this record was updated
ad_org	updatedby	numeric	10				User who updated this records
c_activity	updatedby	numeric	10				User who updated this records
c_campaign	updatedby	numeric	10				User who updated this records
c_elementvalue	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_project	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
m_inoutline	updatedby	numeric	10				User who updated this records
m_matchinv	updatedby	numeric	10				User who updated this records
m_matchpo	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_po	updatedby	numeric	10				User who updated this records
m_requisition	updatedby	numeric	10				User who updated this records
m_requisitionline	updatedby	numeric	10				User who updated this records
ad_org	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_campaign	value	varchar	40				Search key for the record in the format required - must be unique
c_elementvalue	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_product_po	vendorproductno	varchar	40				Product Key of the Business Partner