idempiere9.adempiere contains 1202 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
m_product_category	a_asset_group_id	numeric	10	√		null	Group of Assets
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
c_acctschema	ad_client_id	numeric	10				Client/Tenant for this installation.
c_allocationline	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_landedcost	ad_client_id	numeric	10				Client/Tenant for this installation.
c_landedcostallocation	ad_client_id	numeric	10				Client/Tenant for this installation.
c_order	ad_client_id	numeric	10				Client/Tenant for this installation.
c_orderlandedcost	ad_client_id	numeric	10				Client/Tenant for this installation.
c_orderlandedcostallocation	ad_client_id	numeric	10				Client/Tenant for this installation.
c_orderline	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projectissue	ad_client_id	numeric	10				Client/Tenant for this installation.
c_projectissuema	ad_client_id	numeric	10				Client/Tenant for this installation.
m_attributesetinstance	ad_client_id	numeric	10				Client/Tenant for this installation.
m_cost	ad_client_id	numeric	10				Client/Tenant for this installation.
m_costdetail	ad_client_id	numeric	10				Client/Tenant for this installation.
m_costelement	ad_client_id	numeric	10				Client/Tenant for this installation.
m_costhistory	ad_client_id	numeric	10				Client/Tenant for this installation.
m_costmovement_v	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
m_costqueue	ad_client_id	numeric	10				Client/Tenant for this installation.
m_costtype	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_inoutlinema	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inventoryline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inventorylinema	ad_client_id	numeric	10				Client/Tenant for this installation.
m_locator	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_movementline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_movementlinema	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_category	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_category_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
m_product_po	ad_client_id	numeric	10				Client/Tenant for this installation.
m_productionline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_productionlinema	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.
m_warehouse_acct	ad_client_id	numeric	10				Client/Tenant for this installation.
s_resource	ad_client_id	numeric	10				Client/Tenant for this installation.
t_inventoryvalue	ad_client_id	numeric	10	√		null	Client/Tenant for this installation.
c_acctschema	ad_org_id	numeric	10				Organizational entity within client
c_allocationline	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_landedcost	ad_org_id	numeric	10				Organizational entity within client
c_landedcostallocation	ad_org_id	numeric	10				Organizational entity within client
c_order	ad_org_id	numeric	10				Organizational entity within client
c_orderlandedcost	ad_org_id	numeric	10				Organizational entity within client
c_orderlandedcostallocation	ad_org_id	numeric	10				Organizational entity within client
c_orderline	ad_org_id	numeric	10				Organizational entity within client
c_projectissue	ad_org_id	numeric	10				Organizational entity within client
c_projectissuema	ad_org_id	numeric	10				Organizational entity within client
m_attributesetinstance	ad_org_id	numeric	10				Organizational entity within client
m_cost	ad_org_id	numeric	10				Organizational entity within client
m_costdetail	ad_org_id	numeric	10				Organizational entity within client
m_costelement	ad_org_id	numeric	10				Organizational entity within client
m_costhistory	ad_org_id	numeric	10				Organizational entity within client
m_costmovement_v	ad_org_id	numeric	10	√		null	Organizational entity within client
m_costqueue	ad_org_id	numeric	10				Organizational entity within client
m_costtype	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_inoutlinema	ad_org_id	numeric	10				Organizational entity within client
m_inventoryline	ad_org_id	numeric	10				Organizational entity within client
m_inventorylinema	ad_org_id	numeric	10				Organizational entity within client
m_locator	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_movementline	ad_org_id	numeric	10				Organizational entity within client
m_movementlinema	ad_org_id	numeric	10				Organizational entity within client
m_product	ad_org_id	numeric	10				Organizational entity within client
m_product_acct	ad_org_id	numeric	10				Organizational entity within client
m_product_category	ad_org_id	numeric	10				Organizational entity within client
m_product_category_acct	ad_org_id	numeric	10				Organizational entity within client
m_product_po	ad_org_id	numeric	10				Organizational entity within client
m_productionline	ad_org_id	numeric	10				Organizational entity within client
m_productionlinema	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
m_warehouse_acct	ad_org_id	numeric	10				Organizational entity within client
s_resource	ad_org_id	numeric	10				Organizational entity within client
t_inventoryvalue	ad_org_id	numeric	10	√		null	Organizational entity within client
c_acctschema	ad_orgonly_id	numeric	10	√		null	Create posting entries only for this organization
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
m_inout	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_inoutline	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
t_inventoryvalue	ad_pinstance_id	numeric	10				Instance of the process
m_product_category	ad_printcolor_id	numeric	10	√		null	Color used for printing and display
c_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
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_allocationline	allocationno	numeric	10	√		null
c_allocationline	amount	numeric	0			0	Amount in a defined currency
c_order	amountrefunded	numeric	22,2	√		null	AmountRefunded
c_order	amounttendered	numeric	22,2	√		null	AmountTendered
c_landedcostallocation	amt	numeric	0			0	Amount
c_orderlandedcost	amt	numeric	0			(0)::numeric	Amount
c_orderlandedcostallocation	amt	numeric	0				Amount
m_costdetail	amt	numeric	0			0	Amount
m_costmovement_v	amt	numeric	0	√		null	Amount
c_acctschema	autoperiodcontrol	bpchar	1			'N'::bpchar	If selected, the periods are automatically opened and closed
c_landedcostallocation	base	numeric	0			0	Calculation Base
c_orderlandedcostallocation	base	numeric	0				Calculation Base
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_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
c_acctschema	c_acctschema_id	numeric	10				Rules for accounting
m_cost	c_acctschema_id	numeric	10				Rules for accounting
m_costdetail	c_acctschema_id	numeric	10				Rules for accounting
m_costmovement_v	c_acctschema_id	numeric	10	√		null	Rules for accounting
m_costqueue	c_acctschema_id	numeric	10				Rules for accounting
m_product_acct	c_acctschema_id	numeric	10				Rules for accounting
m_product_category_acct	c_acctschema_id	numeric	10				Rules for accounting
m_warehouse_acct	c_acctschema_id	numeric	10				Rules for accounting
c_acctschema	c_acctschema_uu	varchar	36	√		NULL::character varying	C_AcctSchema_UU
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
m_inout	c_activity_id	numeric	10	√		null	Business Activity
m_inoutline	c_activity_id	numeric	10	√		null	Business Activity
c_allocationline	c_allocationhdr_id	numeric	10				Payment allocation
c_allocationline	c_allocationline_id	numeric	10				Allocation Line
c_allocationline	c_allocationline_uu	varchar	36	√		NULL::character varying	C_AllocationLine_UU
c_allocationline	c_bpartner_id	numeric	10	√		null	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
m_inout	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_orderline	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
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
m_inout	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inoutline	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_allocationline	c_cashline_id	numeric	10	√		null	Cash Journal Line
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_allocationline	c_charge_id	numeric	10	√		NULL::numeric	Additional document charges
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
m_inventoryline	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_acctschema	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
m_product_po	c_currency_id	numeric	10	√		null	The Currency for this record
t_inventoryvalue	c_currency_id	numeric	10	√		null	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_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_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
c_allocationline	c_invoice_id	numeric	10	√		null	Invoice Identifier
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_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
c_landedcost	c_invoiceline_id	numeric	10				Invoice Detail Line
c_landedcostallocation	c_invoiceline_id	numeric	10				Invoice Detail Line
m_costdetail	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
m_costmovement_v	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
m_matchinv	c_invoiceline_id	numeric	10				Invoice Detail Line
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_landedcost	c_landedcost_id	numeric	10				Landed cost to be allocated to material receipts
c_landedcost	c_landedcost_uu	varchar	36	√		NULL::character varying	C_LandedCost_UU
c_landedcostallocation	c_landedcostallocation_id	numeric	10				Allocation for Land Costs
c_landedcostallocation	c_landedcostallocation_uu	varchar	36	√		NULL::character varying	C_LandedCostAllocation_UU
m_warehouse	c_location_id	numeric	10				Location or Address
c_order	c_opportunity_id	numeric	10	√		NULL::numeric	Sales Opportunity
c_allocationline	c_order_id	numeric	10	√		null	Order
c_invoice	c_order_id	numeric	10	√		null	Order
c_order	c_order_id	numeric	10				Order
c_orderlandedcost	c_order_id	numeric	10				Order
c_orderline	c_order_id	numeric	10				Order
m_inout	c_order_id	numeric	10	√		null	Order
c_order	c_order_uu	varchar	36	√		NULL::character varying	C_Order_UU
c_orderlandedcost	c_orderlandedcost_id	numeric	10				Estimated Landed Cost
c_orderlandedcostallocation	c_orderlandedcost_id	numeric	10				Estimated Landed Cost
c_orderlandedcost	c_orderlandedcost_uu	varchar	36	√		NULL::character varying	C_OrderLandedCost_UU
c_orderlandedcostallocation	c_orderlandedcostallocation_id	numeric	10				Estimated Landed Cost Allocation
c_orderlandedcostallocation	c_orderlandedcostallocation_uu	varchar	36	√		NULL::character varying	C_OrderLandedCostAllocation_UU
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_orderlandedcostallocation	c_orderline_id	numeric	10				Sales Order Line
c_orderline	c_orderline_id	numeric	10				Sales Order Line
m_costdetail	c_orderline_id	numeric	10	√		null	Sales Order Line
m_costmovement_v	c_orderline_id	numeric	10	√		null	Sales Order Line
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
m_matchpo	c_orderline_id	numeric	10				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_allocationline	c_payment_id	numeric	10	√		null	Payment identifier
c_invoice	c_payment_id	numeric	10	√		null	Payment identifier
c_order	c_payment_id	numeric	10	√		null	Payment identifier
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_acctschema	c_period_id	numeric	10	√		null	Period of the Calendar
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
c_projectissue	c_project_id	numeric	10				Financial Project
m_inout	c_project_id	numeric	10	√		null	Financial Project
m_inoutline	c_project_id	numeric	10	√		null	Financial Project
c_projectissue	c_projectissue_id	numeric	10				Project Issues (Material, Labor)
c_projectissuema	c_projectissue_id	numeric	10				Project Issues (Material, Labor)
m_costdetail	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
m_costmovement_v	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
m_transaction	c_projectissue_id	numeric	10	√		null	Project Issues (Material, Labor)
c_projectissue	c_projectissue_uu	varchar	36	√		NULL::character varying	C_ProjectIssue_UU
c_projectissuema	c_projectissuema_uu	varchar	36	√		NULL::character varying	C_ProjectIssueMA_UU
c_invoiceline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_orderline	c_projectphase_id	numeric	10	√		null	Phase of a Project
m_inoutline	c_projectphase_id	numeric	10	√		null	Phase of a Project
c_invoiceline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_orderline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_inoutline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
m_product	c_revenuerecognition_id	numeric	10	√		null	Method for recording revenue
m_product	c_subscriptiontype_id	numeric	10	√		null	Type of subscription
c_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_orderline	c_tax_id	numeric	10				Tax identifier
m_product	c_taxcategory_id	numeric	10				Tax Category
c_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
m_product_po	c_uom_id	numeric	10	√		null	Unit of Measure
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
m_product	classification	varchar	12	√		null	Classification for grouping
c_acctschema	commitmenttype	bpchar	1			'N'::bpchar	Create Commitment and/or Reservations for Budget Control
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_movementline	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
m_product	copyfrom	bpchar	1	√		NULL::bpchar	Copy From Record
t_inventoryvalue	cost	numeric	0	√		0	Cost information
t_inventoryvalue	costamt	numeric	0	√		0	Value with Cost
m_costelement	costelementtype	bpchar	1				Type of Cost Element
c_acctschema	costinglevel	bpchar	1			'C'::bpchar	The lowest level to accumulate Costing Information
m_product_category_acct	costinglevel	bpchar	1	√		null	The lowest level to accumulate Costing Information
c_acctschema	costingmethod	bpchar	1				Indicates how Costs will be calculated
m_costelement	costingmethod	bpchar	1	√		null	Indicates how Costs will be calculated
m_product_category_acct	costingmethod	bpchar	1	√		null	Indicates how Costs will be calculated
m_product_po	costperorder	numeric	0	√		0	Fixed Cost Per Order
t_inventoryvalue	coststandard	numeric	0	√		0	Standard Costs
t_inventoryvalue	coststandardamt	numeric	0	√		0	Value in Standard Costs
m_inout	createconfirm	bpchar	1	√		null	Create Confirm
c_acctschema	created	timestamp	29,6			now()	Date this record was created
c_allocationline	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_landedcost	created	timestamp	29,6			now()	Date this record was created
c_landedcostallocation	created	timestamp	29,6			now()	Date this record was created
c_order	created	timestamp	29,6			now()	Date this record was created
c_orderlandedcost	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_orderlandedcostallocation	created	timestamp	29,6			statement_timestamp()	Date this record was created
c_orderline	created	timestamp	29,6			now()	Date this record was created
c_projectissue	created	timestamp	29,6			now()	Date this record was created
c_projectissuema	created	timestamp	29,6			now()	Date this record was created
m_attributesetinstance	created	timestamp	29,6			now()	Date this record was created
m_cost	created	timestamp	29,6			now()	Date this record was created
m_costdetail	created	timestamp	29,6			now()	Date this record was created
m_costelement	created	timestamp	29,6			now()	Date this record was created
m_costhistory	created	timestamp	29,6			statement_timestamp()	Date this record was created
m_costmovement_v	created	timestamp	29,6	√		null	Date this record was created
m_costqueue	created	timestamp	29,6			now()	Date this record was created
m_costtype	created	timestamp	29,6			now()	Date this record was created
m_inout	created	timestamp	29,6			now()	Date this record was created
m_inoutline	created	timestamp	29,6			now()	Date this record was created
m_inoutlinema	created	timestamp	29,6			now()	Date this record was created
m_inventoryline	created	timestamp	29,6			now()	Date this record was created
m_inventorylinema	created	timestamp	29,6			now()	Date this record was created
m_locator	created	timestamp	29,6			now()	Date this record was created
m_matchinv	created	timestamp	29,6			now()	Date this record was created
m_matchpo	created	timestamp	29,6			now()	Date this record was created
m_movementline	created	timestamp	29,6			now()	Date this record was created
m_movementlinema	created	timestamp	29,6			now()	Date this record was created
m_product	created	timestamp	29,6			now()	Date this record was created
m_product_acct	created	timestamp	29,6			now()	Date this record was created
m_product_category	created	timestamp	29,6			now()	Date this record was created
m_product_category_acct	created	timestamp	29,6			now()	Date this record was created
m_product_po	created	timestamp	29,6			now()	Date this record was created
m_productionline	created	timestamp	29,6			now()	Date this record was created
m_productionlinema	created	timestamp	29,6			now()	Date this record was created
m_transaction	created	timestamp	29,6			now()	Date this record was created
m_warehouse	created	timestamp	29,6			now()	Date this record was created
m_warehouse_acct	created	timestamp	29,6			now()	Date this record was created
s_resource	created	timestamp	29,6			now()	Date this record was created
c_acctschema	createdby	numeric	10				User who created this records
c_allocationline	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_landedcost	createdby	numeric	10				User who created this records
c_landedcostallocation	createdby	numeric	10				User who created this records
c_order	createdby	numeric	10				User who created this records
c_orderlandedcost	createdby	numeric	10				User who created this records
c_orderlandedcostallocation	createdby	numeric	10				User who created this records
c_orderline	createdby	numeric	10				User who created this records
c_projectissue	createdby	numeric	10				User who created this records
c_projectissuema	createdby	numeric	10				User who created this records
m_attributesetinstance	createdby	numeric	10				User who created this records
m_cost	createdby	numeric	10				User who created this records
m_costdetail	createdby	numeric	10				User who created this records
m_costelement	createdby	numeric	10				User who created this records
m_costhistory	createdby	numeric	10				User who created this records
m_costmovement_v	createdby	numeric	10	√		null	User who created this records
m_costqueue	createdby	numeric	10				User who created this records
m_costtype	createdby	numeric	10				User who created this records
m_inout	createdby	numeric	10				User who created this records
m_inoutline	createdby	numeric	10				User who created this records
m_inoutlinema	createdby	numeric	10				User who created this records
m_inventoryline	createdby	numeric	10				User who created this records
m_inventorylinema	createdby	numeric	10				User who created this records
m_locator	createdby	numeric	10				User who created this records
m_matchinv	createdby	numeric	10				User who created this records
m_matchpo	createdby	numeric	10				User who created this records
m_movementline	createdby	numeric	10				User who created this records
m_movementlinema	createdby	numeric	10				User who created this records
m_product	createdby	numeric	10				User who created this records
m_product_acct	createdby	numeric	10				User who created this records
m_product_category	createdby	numeric	10				User who created this records
m_product_category_acct	createdby	numeric	10				User who created this records
m_product_po	createdby	numeric	10				User who created this records
m_productionline	createdby	numeric	10				User who created this records
m_productionlinema	createdby	numeric	10				User who created this records
m_transaction	createdby	numeric	10				User who created this records
m_warehouse	createdby	numeric	10				User who created this records
m_warehouse_acct	createdby	numeric	10				User who created this records
s_resource	createdby	numeric	10				User who created this records
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
m_cost	cumulatedamt	numeric	0	√		0	Total Amount
m_costdetail	cumulatedamt	numeric	0	√		null	Total Amount
m_cost	cumulatedqty	numeric	0	√		0	Total Quantity
m_costdetail	cumulatedqty	numeric	0	√		null	Total Quantity
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
m_cost	currentcostprice	numeric	0				The currently used cost price
m_costdetail	currentcostprice	numeric	0	√		null	The currently used cost price
m_costqueue	currentcostprice	numeric	0			0	The currently used cost price
m_inventoryline	currentcostprice	numeric	0	√		(0)::numeric	The currently used cost price
m_cost	currentcostpricell	numeric	0	√		0	Current Price Lower Level Is the sum of the costs of the components of this product manufactured for this level.
m_cost	currentqty	numeric	0			0	Current Quantity
m_costdetail	currentqty	numeric	0	√		null	Current Quantity
m_costqueue	currentqty	numeric	0			0	Current Quantity
m_product	customstariffnumber	varchar	20	√		null	Customs Tariff Number, usually the HS-Code
s_resource	dailycapacity	numeric	0	√		null	Daily Capacity
c_invoice	dateacct	timestamp	29,6				Accounting Date
c_order	dateacct	timestamp	29,6				Accounting Date
m_inout	dateacct	timestamp	29,6				Accounting Date
m_matchinv	dateacct	timestamp	29,6	√		null	Accounting Date
m_matchpo	dateacct	timestamp	29,6	√		null	Accounting Date
c_orderline	datedelivered	timestamp	29,6	√		null	Date when the product was delivered
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_orderline	dateinvoiced	timestamp	29,6	√		null	Date printed on Invoice
m_inoutlinema	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
m_inventorylinema	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
m_movementlinema	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
m_productionlinema	datematerialpolicy	timestamp	29,6				Time used for LIFO and FIFO Material Policy
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
c_allocationline	datetrx	timestamp	29,6	√		null	Transaction Date
m_matchinv	datetrx	timestamp	29,6				Transaction Date
m_matchpo	datetrx	timestamp	29,6				Transaction Date
t_inventoryvalue	datevalue	timestamp	29,6	√		null	Date of valuation
m_movementline	dd_orderline_id	numeric	10	√		null	Distribution Order Line
c_order	deliveryrule	bpchar	1				Defines the timing of Delivery
m_inout	deliveryrule	bpchar	1				Defines the timing of Delivery
m_product_po	deliverytime_actual	numeric	10	√		null	Actual days between order and delivery
m_product_po	deliverytime_promised	numeric	10	√		null	Promised days between order and delivery
c_order	deliveryviarule	bpchar	1				How the order will be delivered
m_inout	deliveryviarule	bpchar	1				How the order will be delivered
m_costdetail	deltaamt	numeric	0	√		0	Difference Amount
m_costmovement_v	deltaamt	numeric	0	√		null	Difference Amount
m_costdetail	deltaqty	numeric	0	√		0	Quantity Difference
m_costmovement_v	deltaqty	numeric	0	√		null	Quantity Difference
c_acctschema	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_landedcost	description	varchar	255	√		null	Optional short description of the record
c_order	description	varchar	255	√		null	Optional short description of the record
c_orderlandedcost	description	varchar	255	√		NULL::character varying	Optional short description of the record
c_orderline	description	varchar	255	√		null	Optional short description of the record
c_projectissue	description	varchar	255	√		null	Optional short description of the record
m_attributesetinstance	description	varchar	255	√		null	Optional short description of the record
m_cost	description	varchar	255	√		null	Optional short description of the record
m_costdetail	description	varchar	255	√		null	Optional short description of the record
m_costelement	description	varchar	255	√		null	Optional short description of the record
m_costmovement_v	description	varchar	255	√		null	Optional short description of the record
m_costtype	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_inventoryline	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_movementline	description	varchar	255	√		null	Optional short description of the record
m_product	description	varchar	255	√		null	Optional short description of the record
m_product_category	description	varchar	255	√		null	Optional short description of the record
m_productionline	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
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
c_allocationline	discountamt	numeric	0			0	Calculated amount of discount
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
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
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
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_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
m_inout	fob	varchar	10	√		NULL::character varying	Freight Terms
c_order	freightamt	numeric	0	√		0	Freight Amount
c_orderline	freightamt	numeric	0			0	Freight Amount
m_inout	freightamt	numeric	0	√		0	Freight Amount
m_inout	freightcharges	varchar	10	√		NULL::character varying	Freight Charges
c_order	freightcostrule	bpchar	1				Method for charging Freight
m_inout	freightcostrule	bpchar	1				Method for charging Freight
m_cost	futurecostprice	numeric	0	√		null	Future Cost Price
m_cost	futurecostpricell	numeric	0	√		null	Future Cost Price Lower Level
c_acctschema	gaap	bpchar	2				Generally Accepted Accounting Principles
c_invoice	generateto	bpchar	1	√		null	Generate To
m_inout	generateto	bpchar	1	√		null	Generate To
c_invoice	grandtotal	numeric	0			0	Total amount of document
c_order	grandtotal	numeric	0			0	Total amount of document
m_product	group1	varchar	255	√		null	Group1
m_product	group2	varchar	255	√		null	Group2
m_attributesetinstance	guaranteedate	timestamp	29,6	√		null	Date when guarantee expires
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_acctschema	hasalias	bpchar	1			'Y'::bpchar	Ability to select (partial) account combinations by an Alias
c_acctschema	hascombination	bpchar	1			'Y'::bpchar	Combination of account elements are checked
m_costtype	help	varchar	2000	√		null	Comment or Hint
m_product	help	varchar	2000	√		null	Comment or Hint
m_product	imageurl	varchar	120	√		null	URL of image
m_inout	insurance	bpchar	1	√		NULL::bpchar	Insurance
m_inventoryline	inventorytype	bpchar	1			'D'::bpchar	Type of inventory difference
c_invoice	invoicecollectiontype	bpchar	1	√		null	Invoice Collection Status
c_order	invoicerule	bpchar	1				Frequency and method of invoicing
c_acctschema	isaccrual	bpchar	1			'Y'::bpchar	Indicates if Accrual or Cash Based accounting will be used
c_acctschema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_allocationline	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_orderlandedcost	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_orderlandedcostallocation	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_orderline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projectissue	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
c_projectissuema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_attributesetinstance	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_cost	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_costdetail	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_costelement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_costhistory	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_costmovement_v	isactive	bpchar	1	√		null	The record is active in the system
m_costqueue	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_costtype	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inout	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inoutline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inoutlinema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inventoryline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inventorylinema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_locator	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_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_movementline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_movementlinema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_acct	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_product_category_acct	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_productionline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_productionlinema	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_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
m_warehouse_acct	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
c_acctschema	isadjustcogs	bpchar	1			'N'::bpchar	Adjust Cost of Good Sold
c_acctschema	isallownegativeposting	bpchar	1	√		'Y'::bpchar	Allow to post negative accounting values
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_matchpo	isapproved	bpchar	1	√		'Y'::bpchar	Indicates if this document requires approval
m_inoutlinema	isautogenerated	bpchar	1	√		'N'::bpchar	Auto Generated
m_inventorylinema	isautogenerated	bpchar	1	√		'N'::bpchar	Auto Generated
m_movementlinema	isautogenerated	bpchar	1	√		'N'::bpchar	Auto Generated
m_inoutline	isautoproduce	bpchar	1	√		'N'::bpchar	Auto create production to fulfill shipment
m_product	isautoproduce	bpchar	1			'N'::bpchar	Auto create production to fulfill shipment
s_resource	isavailable	bpchar	1			'Y'::bpchar	Resource is available
m_product	isbom	bpchar	1			'N'::bpchar	Bill of Materials
m_costelement	iscalculated	bpchar	1			'N'::bpchar	The value is calculated by the system
m_cost	iscostfrozen	bpchar	1	√		'N'::bpchar	Indicated that the Standard Cost is frozen
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
m_locator	isdefault	bpchar	1			'N'::bpchar	Default value
m_product_category	isdefault	bpchar	1			'N'::bpchar	Default value
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
m_warehouse	isdisallownegativeinv	bpchar	1			'N'::bpchar	Negative Inventory is not allowed in this warehouse
c_acctschema	isdiscountcorrectstax	bpchar	1			'N'::bpchar	Correct the tax for payment discount and charges
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_inout	isdropship	bpchar	1	√		'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
m_product	isdropship	bpchar	1			'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
m_productionline	isendproduct	bpchar	1	√		NULL::bpchar	End Product of production
m_product	isexcludeautodelivery	bpchar	1			'N'::bpchar	Exclude from automatic Delivery
c_acctschema	isexplicitcostadjustment	bpchar	1			'N'::bpchar	Post the cost adjustment explicitly
c_invoice	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoiceline	isfixedassetinvoice	bpchar	1	√		null	IsFixedAssetInvoice
c_invoice	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
m_inout	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
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?
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
c_allocationline	ismanual	bpchar	1	√		'N'::bpchar	This is a manual process
m_product	ismanufactured	bpchar	1			'N'::bpchar	This product is manufactured
s_resource	ismanufacturingresource	bpchar	1	√		'N'::bpchar	Manufacturing Resource
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	isphantom	bpchar	1	√		'N'::bpchar	Phantom Component
m_product	ispicklistprintdetails	bpchar	1			'N'::bpchar	Print detail BOM elements on the pick list
c_acctschema	ispostifclearingequal	bpchar	1	√		'Y'::bpchar	This flag controls if Adempiere must post when clearing (transit) and final accounts are the same
c_acctschema	ispostservices	bpchar	1			'N'::bpchar	Differentiate between Services and Product Receivable/Payables
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
m_inout	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_category	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_costdetail	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
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
m_product	istoformule	bpchar	1	√		null
c_acctschema	istradediscountposted	bpchar	1			'N'::bpchar	Generate postings for trade discounts
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_landedcost	landedcostdistribution	bpchar	1				Landed Cost Distribution
c_orderlandedcost	landedcostdistribution	bpchar	1			'Q'::bpchar	Landed Cost Distribution
c_invoiceline	line	numeric	10				Unique line for this document
c_orderline	line	numeric	10				Unique line for this document
c_projectissue	line	numeric	10				Unique line for this document
m_inoutline	line	numeric	10				Unique line for this document
m_inventoryline	line	numeric	10	√		null	Unique line for this document
m_movementline	line	numeric	10	√		null	Unique line for this document
m_productionline	line	numeric	10				Unique line for this document
c_invoiceline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_orderline	linenetamt	numeric	0			0	Line Extended Amount (Quantity * Actual Price) without Freight and Charges
c_invoiceline	linetotalamt	numeric	0	√		0	Total line amount incl. Tax
c_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_attributesetinstance	lot	varchar	40	√		null	Lot number (alphanumeric)
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_attributesetinstance	m_attributeset_id	numeric	10	√		null	Product Attribute Set
m_product	m_attributeset_id	numeric	10	√		null	Product Attribute Set
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_landedcostallocation	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
c_orderline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_projectissue	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
c_projectissuema	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_attributesetinstance	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_cost	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_costdetail	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_costhistory	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_costmovement_v	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_costqueue	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutlinema	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_inventoryline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inventorylinema	m_attributesetinstance_id	numeric	10				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_movementline	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_movementlinema	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_product	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_productionline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_productionlinema	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_transaction	m_attributesetinstance_id	numeric	10			0	Product Attribute Set Instance
t_inventoryvalue	m_attributesetinstance_id	numeric	10				Product Attribute Set Instance
m_attributesetinstance	m_attributesetinstance_uu	varchar	36	√		NULL::character varying	M_AttributeSetInstance_UU
m_movementline	m_attributesetinstanceto_id	numeric	10	√		null	Target Product Attribute Set Instance
m_cost	m_cost_uu	varchar	36	√		NULL::character varying	M_Cost_UU
m_costdetail	m_costdetail_id	numeric	10				Cost Detail Information
m_costhistory	m_costdetail_id	numeric	10				Cost Detail Information
m_costmovement_v	m_costdetail_id	numeric	10	√		null	Cost Detail Information
m_costdetail	m_costdetail_uu	varchar	36	√		NULL::character varying	M_CostDetail_UU
c_landedcost	m_costelement_id	numeric	10				Product Cost Element
c_landedcostallocation	m_costelement_id	numeric	10				Product Cost Element
c_orderlandedcost	m_costelement_id	numeric	10				Product Cost Element
m_cost	m_costelement_id	numeric	10				Product Cost Element
m_costdetail	m_costelement_id	numeric	10	√		null	Product Cost Element
m_costelement	m_costelement_id	numeric	10				Product Cost Element
m_costhistory	m_costelement_id	numeric	10				Product Cost Element
m_costmovement_v	m_costelement_id	numeric	10	√		null	Product Cost Element
m_costqueue	m_costelement_id	numeric	10				Product Cost Element
t_inventoryvalue	m_costelement_id	numeric	10	√		null	Product Cost Element
m_costelement	m_costelement_uu	varchar	36	√		NULL::character varying	M_CostElement_UU
m_costhistory	m_costhistory_id	numeric	10				Movement history for M_Cost
m_costmovement_v	m_costhistory_id	numeric	10	√		null	Movement history for M_Cost
m_costhistory	m_costhistory_uu	varchar	36				Cost History UUID
m_costqueue	m_costqueue_id	numeric	10				FiFo/LiFo Cost Queue
m_costqueue	m_costqueue_uu	varchar	36	√		NULL::character varying	M_CostQueue_UU
c_acctschema	m_costtype_id	numeric	10	√		null	Type of Cost (e.g. Current, Plan, Future)
m_cost	m_costtype_id	numeric	10				Type of Cost (e.g. Current, Plan, Future)
m_costhistory	m_costtype_id	numeric	10				Type of Cost (e.g. Current, Plan, Future)
m_costmovement_v	m_costtype_id	numeric	10	√		null	Type of Cost (e.g. Current, Plan, Future)
m_costqueue	m_costtype_id	numeric	10				Type of Cost (e.g. Current, Plan, Future)
m_costtype	m_costtype_id	numeric	10				Type of Cost (e.g. Current, Plan, Future)
m_costtype	m_costtype_uu	varchar	36	√		NULL::character varying	M_CostType_UU
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_landedcost	m_inout_id	numeric	10	√		null	Material Shipment Document
m_inout	m_inout_id	numeric	10				Material Shipment Document
m_inoutline	m_inout_id	numeric	10				Material Shipment Document
m_inout	m_inout_uu	varchar	36	√		NULL::character varying	M_InOut_UU
c_invoiceline	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
c_landedcost	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
c_landedcostallocation	m_inoutline_id	numeric	10	√		NULL::numeric	Line on Shipment or Receipt document
c_projectissue	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_costdetail	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_costmovement_v	m_inoutline_id	numeric	10	√		null	Line on Shipment or Receipt document
m_inoutline	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_inoutlinema	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_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_transaction	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_inoutlinema	m_inoutlinema_uu	varchar	36	√		NULL::character varying	M_InOutLineMA_UU
m_inventoryline	m_inventory_id	numeric	10				Parameters for a Physical Inventory
m_costdetail	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
m_costmovement_v	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
m_inventoryline	m_inventoryline_id	numeric	10				Unique line in an Inventory document
m_inventorylinema	m_inventoryline_id	numeric	10				Unique line in an Inventory document
m_transaction	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
m_inventoryline	m_inventoryline_uu	varchar	36	√		NULL::character varying	M_InventoryLine_UU
m_inventorylinema	m_inventorylinema_uu	varchar	36	√		NULL::character varying	M_InventoryLineMA_UU
c_projectissue	m_locator_id	numeric	10				Warehouse Locator
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_inventoryline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_locator	m_locator_id	numeric	10				Warehouse Locator
m_movementline	m_locator_id	numeric	10				Warehouse Locator
m_product	m_locator_id	numeric	10	√		null	Warehouse Locator
m_productionline	m_locator_id	numeric	10				Warehouse Locator
m_transaction	m_locator_id	numeric	10				Warehouse Locator
m_locator	m_locator_uu	varchar	36	√		NULL::character varying	M_Locator_UU
m_movementline	m_locatorto_id	numeric	10				Location inventory is moved to
m_locator	m_locatortype_id	numeric	10	√		NULL::numeric	Locator Type
m_attributesetinstance	m_lot_id	numeric	10	√		null	Product Lot Definition
m_costdetail	m_matchinv_id	numeric	10	√		NULL::numeric	Match Shipment/Receipt to Invoice
m_costmovement_v	m_matchinv_id	numeric	10	√		null	Match Shipment/Receipt to Invoice
m_matchinv	m_matchinv_id	numeric	10				Match Shipment/Receipt to Invoice
m_matchinv	m_matchinv_uu	varchar	36	√		NULL::character varying	M_MatchInv_UU
m_matchpo	m_matchpo_id	numeric	10				Match Purchase Order to Shipment/Receipt and Invoice
m_matchpo	m_matchpo_uu	varchar	36	√		NULL::character varying	M_MatchPO_UU
m_movementline	m_movement_id	numeric	10				Movement of Inventory
m_costdetail	m_movementline_id	numeric	10	√		null	Inventory Move document Line
m_costmovement_v	m_movementline_id	numeric	10	√		null	Inventory Move document Line
m_movementline	m_movementline_id	numeric	10				Inventory Move document Line
m_movementlinema	m_movementline_id	numeric	10				Inventory Move document Line
m_transaction	m_movementline_id	numeric	10	√		null	Inventory Move document Line
m_movementline	m_movementline_uu	varchar	36	√		NULL::character varying	M_MovementLine_UU
m_movementlinema	m_movementlinema_uu	varchar	36	√		NULL::character varying	M_MovementLineMA_UU
m_product	m_parttype_id	numeric	10	√		NULL::numeric	Part Type
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
t_inventoryvalue	m_pricelist_version_id	numeric	10	√		null	Identifies a unique instance of a Price List
m_product_acct	m_product_acct_uu	varchar	36	√		NULL::character varying	M_Product_Acct_UU
m_product_category_acct	m_product_category_acct_uu	varchar	36	√		NULL::character varying	M_Product_Category_Acct_UU
m_product	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_id	numeric	10				Category of a Product
m_product_category_acct	m_product_category_id	numeric	10				Category of a Product
m_product_category	m_product_category_parent_id	numeric	10	√		null	Parent Product Category
m_product_category	m_product_category_uu	varchar	36	√		NULL::character varying	M_Product_Category_UU
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
c_landedcost	m_product_id	numeric	10	√		null	Product, Service, Item
c_landedcostallocation	m_product_id	numeric	10				Product, Service, Item
c_orderline	m_product_id	numeric	10	√		null	Product, Service, Item
c_projectissue	m_product_id	numeric	10				Product, Service, Item
m_cost	m_product_id	numeric	10				Product, Service, Item
m_costdetail	m_product_id	numeric	10				Product, Service, Item
m_costmovement_v	m_product_id	numeric	10	√		null	Product, Service, Item
m_costqueue	m_product_id	numeric	10				Product, Service, Item
m_inoutline	m_product_id	numeric	10	√		null	Product, Service, Item
m_inventoryline	m_product_id	numeric	10				Product, Service, Item
m_matchinv	m_product_id	numeric	10	√		null	Product, Service, Item
m_matchpo	m_product_id	numeric	10	√		null	Product, Service, Item
m_movementline	m_product_id	numeric	10				Product, Service, Item
m_product	m_product_id	numeric	10				Product, Service, Item
m_product_acct	m_product_id	numeric	10				Product, Service, Item
m_product_po	m_product_id	numeric	10				Product, Service, Item
m_productionline	m_product_id	numeric	10				Product, Service, Item
m_transaction	m_product_id	numeric	10				Product, Service, Item
t_inventoryvalue	m_product_id	numeric	10				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
m_productionline	m_production_id	numeric	10	√		null	Plan for producing a product
m_costdetail	m_productionline_id	numeric	10	√		null	Document Line representing a production
m_costmovement_v	m_productionline_id	numeric	10	√		null	Document Line representing a production
m_productionline	m_productionline_id	numeric	10				Document Line representing a production
m_productionlinema	m_productionline_id	numeric	10				Document Line representing a production
m_transaction	m_productionline_id	numeric	10	√		null	Document Line representing a production
m_productionline	m_productionline_uu	varchar	36	√		NULL::character varying	M_ProductionLine_UU
m_productionlinema	m_productionlinema_uu	varchar	36	√		NULL::character varying	M_ProductionLineMA_UU
m_productionline	m_productionplan_id	numeric	10	√		null	Plan for how a product is produced
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
m_transaction	m_transaction_uu	varchar	36	√		NULL::character varying	M_Transaction_UU
m_warehouse_acct	m_warehouse_acct_uu	varchar	36	√		NULL::character varying	M_Warehouse_Acct_UU
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_inout	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_locator	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse_acct	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
s_resource	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
t_inventoryvalue	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_warehouse	m_warehouse_uu	varchar	36	√		NULL::character varying	M_Warehouse_UU
m_warehouse	m_warehousesource_id	numeric	10	√		null	Optional Warehouse to replenish from
m_product_po	manufacturer	varchar	30	√		null	Manufacturer of the Product
s_resource	manufacturingresourcetype	bpchar	2	√		null	Manufacturing Resource Type
m_product_category	mmpolicy	bpchar	1			'F'::bpchar	Material Movement Policy
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
c_projectissue	movementqty	numeric	0			0	Quantity of a product moved.
c_projectissuema	movementqty	numeric	0			0	Quantity of a product moved.
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
m_inoutlinema	movementqty	numeric	0			(1)::numeric	Quantity of a product moved.
m_inventorylinema	movementqty	numeric	0			(1)::numeric	Quantity of a product moved.
m_movementline	movementqty	numeric	0			0	Quantity of a product moved.
m_movementlinema	movementqty	numeric	0	√		(1)::numeric	Quantity of a product moved.
m_productionline	movementqty	numeric	0			0	Quantity of a product moved.
m_productionlinema	movementqty	numeric	0			0	Quantity of a product moved.
m_transaction	movementqty	numeric	0			0	Quantity of a product moved.
m_inout	movementtype	bpchar	2				Method of moving the inventory
m_transaction	movementtype	bpchar	2				Method of moving the inventory
c_acctschema	name	varchar	60				Alphanumeric identifier of the entity
m_costelement	name	varchar	60				Alphanumeric identifier of the entity
m_costtype	name	varchar	60				Alphanumeric identifier of the entity
m_product	name	varchar	255				Alphanumeric identifier of the entity
m_product_category	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
m_costhistory	newcamt	numeric	0	√		null	Accumulated Amt after processing of M_CostDetail
m_costmovement_v	newcamt	numeric	0	√		null	Accumulated Amt after processing of M_CostDetail
m_costhistory	newcostprice	numeric	0				New current cost price after processing of M_CostDetail
m_costmovement_v	newcostprice	numeric	0	√		null	New current cost price after processing of M_CostDetail
m_inventoryline	newcostprice	numeric	0	√		(0)::numeric	New current cost price after processing of M_CostDetail
m_costhistory	newcqty	numeric	0	√		null	New Accumulated Qty after processing of M_CostDetail
m_costmovement_v	newcqty	numeric	0	√		null	New Accumulated Qty after processing of M_CostDetail
m_costhistory	newqty	numeric	0				New current quantity after processing of M_CostDetail
m_costmovement_v	newqty	numeric	0	√		null	New current quantity after processing of M_CostDetail
m_inout	nopackages	numeric	10	√		(1)::numeric	Number of packages shipped
m_costhistory	oldcamt	numeric	0	√		null	Old accumulated amt before the processing of M_CostDetail
m_costmovement_v	oldcamt	numeric	0	√		null	Old accumulated amt before the processing of M_CostDetail
m_costhistory	oldcostprice	numeric	0				Old current cost price before the processing of M_CostDetail
m_costmovement_v	oldcostprice	numeric	0	√		null	Old current cost price before the processing of M_CostDetail
m_costhistory	oldcqty	numeric	0	√		null	Old accumulated qty before the processing of M_CostDetail
m_costmovement_v	oldcqty	numeric	0	√		null	Old accumulated qty before the processing of M_CostDetail
m_costhistory	oldqty	numeric	0				Old current quantity before the processing of M_CostDetail
m_costmovement_v	oldqty	numeric	0	√		null	Old current quantity before the processing of M_CostDetail
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_allocationline	overunderamt	numeric	0	√		0	Over-Payment (unallocated) or Under-Payment (partial payment) Amount
m_product_acct	p_asset_acct	numeric	10				Account for Product Asset (Inventory)
m_product_category_acct	p_asset_acct	numeric	10				Account for Product Asset (Inventory)
m_product_acct	p_averagecostvariance_acct	numeric	10	√		NULL::numeric	Average Cost Variance
m_product_category_acct	p_averagecostvariance_acct	numeric	10	√		NULL::numeric	Average Cost Variance
m_product_acct	p_burden_acct	numeric	10	√		null	The Burden account is the account used Manufacturing Order
m_product_category_acct	p_burden_acct	numeric	10	√		null	The Burden account is the account used Manufacturing Order
m_product_acct	p_cogs_acct	numeric	10				Account for Cost of Goods Sold
m_product_category_acct	p_cogs_acct	numeric	10				Account for Cost of Goods Sold
m_product_acct	p_costadjustment_acct	numeric	10	√		null	Product Cost Adjustment Account
m_product_category_acct	p_costadjustment_acct	numeric	10	√		null	Product Cost Adjustment Account
m_product_acct	p_costofproduction_acct	numeric	10	√		null	The Cost Of Production account is the account used Manufacturing Order
m_product_category_acct	p_costofproduction_acct	numeric	10	√		null	The Cost Of Production account is the account used Manufacturing Order
m_product_acct	p_expense_acct	numeric	10				Account for Product Expense
m_product_category_acct	p_expense_acct	numeric	10				Account for Product Expense
m_product_acct	p_floorstock_acct	numeric	10	√		null	The Floor Stock account is the account used Manufacturing Order
m_product_category_acct	p_floorstock_acct	numeric	10	√		null	The Floor Stock account is the account used Manufacturing Order
m_product_acct	p_inventoryclearing_acct	numeric	10	√		null	Product Inventory Clearing Account
m_product_category_acct	p_inventoryclearing_acct	numeric	10	√		null	Product Inventory Clearing Account
m_product_acct	p_invoicepricevariance_acct	numeric	10				Difference between Costs and Invoice Price (IPV)
m_product_category_acct	p_invoicepricevariance_acct	numeric	10				Difference between Costs and Invoice Price (IPV)
m_product_acct	p_labor_acct	numeric	10	√		null	The Labor account is the account used Manufacturing Order
m_product_category_acct	p_labor_acct	numeric	10	√		null	The Labor account is the account used Manufacturing Order
m_product_acct	p_landedcostclearing_acct	numeric	10	√		NULL::numeric	Product Landed Cost Clearing Account
m_product_category_acct	p_landedcostclearing_acct	numeric	10	√		NULL::numeric	Product Landed Cost Clearing Account
m_product_acct	p_methodchangevariance_acct	numeric	10	√		null	The Method Change Variance account is the account used Manufacturing Order
m_product_category_acct	p_methodchangevariance_acct	numeric	10	√		null	The Method Change Variance account is the account used Manufacturing Order
m_product_acct	p_mixvariance_acct	numeric	10	√		null	The Mix Variance account is the account used Manufacturing Order
m_product_category_acct	p_mixvariance_acct	numeric	10	√		null	The Mix Variance account is the account used Manufacturing Order
m_product_acct	p_outsideprocessing_acct	numeric	10	√		null	The Outside Processing Account is the account used in Manufacturing Order
m_product_category_acct	p_outsideprocessing_acct	numeric	10	√		null	The Outside Processing Account is the account used in Manufacturing Order
m_product_acct	p_overhead_acct	numeric	10	√		null	The Overhead account is the account used in Manufacturing Order
m_product_category_acct	p_overhead_acct	numeric	10	√		null	The Overhead account is the account used in Manufacturing Order
m_product_acct	p_purchasepricevariance_acct	numeric	10				Difference between Standard Cost and Purchase Price (PPV)
m_product_category_acct	p_purchasepricevariance_acct	numeric	10				Difference between Standard Cost and Purchase Price (PPV)
m_product_acct	p_ratevariance_acct	numeric	10	√		null	The Rate Variance account is the account used Manufacturing Order
m_product_category_acct	p_ratevariance_acct	numeric	10	√		null	The Rate Variance account is the account used Manufacturing Order
m_product_acct	p_revenue_acct	numeric	10				Account for Product Revenue (Sales Account)
m_product_category_acct	p_revenue_acct	numeric	10				Account for Product Revenue (Sales Account)
m_product_acct	p_scrap_acct	numeric	10	√		null	The Scrap account is the account used in Manufacturing Order
m_product_category_acct	p_scrap_acct	numeric	10	√		null	The Scrap account is the account used in Manufacturing Order
m_product_acct	p_tradediscountgrant_acct	numeric	10				Trade Discount Granted Account
m_product_category_acct	p_tradediscountgrant_acct	numeric	10				Trade Discount Granted Account
m_product_acct	p_tradediscountrec_acct	numeric	10				Trade Discount Receivable Account
m_product_category_acct	p_tradediscountrec_acct	numeric	10				Trade Discount Receivable Account
m_product_acct	p_usagevariance_acct	numeric	10	√		null	The Usage Variance account is the account used Manufacturing Order
m_product_category_acct	p_usagevariance_acct	numeric	10	√		null	The Usage Variance account is the account used Manufacturing Order
m_product_acct	p_wip_acct	numeric	10	√		null	The Work in Process account is the account used Manufacturing Order
m_product_category_acct	p_wip_acct	numeric	10	√		null	The Work in Process account is the account used Manufacturing Order
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
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_order	paymentrule	bpchar	1				How you pay the invoice
m_cost	percent	numeric	10	√		0	Percentage
s_resource	percentutilization	numeric	0			(100)::numeric	% Utilization
c_acctschema	period_openfuture	numeric	10	√		null	Number of days to be able to post to a future date (based on system date)
c_acctschema	period_openhistory	numeric	10	√		null	Number of days to be able to post in the past (based on system date)
m_inout	pickdate	timestamp	29,6	√		null	Date/Time when picked for Shipment
m_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
m_product_category	plannedmargin	numeric	0				Project's planned margin as a percentage
m_productionline	plannedqty	numeric	0	√		null	Planned quantity for this project
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_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
m_inout	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
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
m_matchinv	posted	bpchar	1			'N'::bpchar	Posting status
m_matchpo	posted	bpchar	1			'N'::bpchar	Posting status
c_orderline	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
m_costdetail	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
m_transaction	pp_cost_collector_id	numeric	10	√		null	Manufacturing Cost Collector
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_orderline	priceactual	numeric	0			0	Actual Price
c_orderline	pricecost	numeric	0	√		null	Price per Unit of Measure including all indirect costs (Freight, etc.)
m_product_po	priceeffective	timestamp	29,6	√		null	Effective Date of 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
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
c_invoiceline	pricelimit	numeric	0			0	Lowest price for a product
c_orderline	pricelimit	numeric	0			0	Lowest price for a product
t_inventoryvalue	pricelimit	numeric	0	√		0	Lowest price for a product
t_inventoryvalue	pricelimitamt	numeric	0	√		0	Value with limit price
c_invoiceline	pricelist	numeric	0			0	List Price
c_orderline	pricelist	numeric	0			0	List Price
m_product_po	pricelist	numeric	0	√		0	List Price
t_inventoryvalue	pricelist	numeric	0	√		0	List Price
t_inventoryvalue	pricelistamt	numeric	0	√		0	Valuation with 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
t_inventoryvalue	pricepo	numeric	0	√		0	Price based on a purchase order
t_inventoryvalue	pricepoamt	numeric	0	√		0	Valuation with PO Price
t_inventoryvalue	pricestd	numeric	0	√		0	Standard Price
t_inventoryvalue	pricestdamt	numeric	0	√		0	Valuation with standard price
m_locator	priorityno	numeric	10				Where inventory should be picked from first
c_order	priorityrule	bpchar	1				Priority of a document
m_inout	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_orderlandedcost	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderlandedcostallocation	processed	bpchar	1			'N'::bpchar	The document has been processed
c_orderline	processed	bpchar	1			'N'::bpchar	The document has been processed
c_projectissue	processed	bpchar	1			'N'::bpchar	The document has been processed
m_costdetail	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inout	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventoryline	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_movementline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_productionline	processed	bpchar	1			'N'::bpchar	The document has been processed
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
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
c_acctschema	processing	bpchar	1	√		null	Process Now
c_invoice	processing	bpchar	1	√		null	Process Now
c_landedcost	processing	bpchar	1	√		null	Process Now
c_order	processing	bpchar	1	√		null	Process Now
c_projectissue	processing	bpchar	1	√		null	Process Now
m_inout	processing	bpchar	1	√		null	Process Now
m_matchinv	processing	bpchar	1				Process Now
m_matchpo	processing	bpchar	1				Process Now
m_product	processing	bpchar	1	√		null	Process Now
m_product_category_acct	processing	bpchar	1	√		null	Process Now
m_product	producttype	bpchar	1			'I'::bpchar	Type of product
c_order	promotioncode	varchar	30	√		null	User entered promotion code at sales time
c_landedcostallocation	qty	numeric	0			0	Quantity
c_orderlandedcostallocation	qty	numeric	0				Quantity
m_costdetail	qty	numeric	0			0	Quantity
m_costmovement_v	qty	numeric	0	√		null	Quantity
m_matchinv	qty	numeric	0			0	Quantity
m_matchpo	qty	numeric	0			0	Quantity
m_inventoryline	qtybook	numeric	0			0	Book Quantity
m_inventoryline	qtycount	numeric	0			0	Counted Quantity
m_inventoryline	qtycsv	numeric	0			0	QtyCsv
c_orderline	qtydelivered	numeric	0			0	Delivered Quantity
c_invoiceline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
c_orderline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
m_inoutline	qtyentered	numeric	0				The Quantity Entered is based on the selected UoM
m_inventoryline	qtyinternaluse	numeric	0	√		null	Internal Use Quantity removed from Inventory
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
t_inventoryvalue	qtyonhand	numeric	0	√		0	On Hand Quantity
c_orderline	qtyordered	numeric	0			0	Ordered Quantity
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
c_orderline	qtyreserved	numeric	0			0	Reserved Quantity
m_productionline	qtyused	numeric	0	√		null	Quantity Used
m_product_po	qualityrating	numeric	0	√		null	Method for rating vendors
s_resource	queuingtime	numeric	0	√		null	Queue time is the time a job waits at a work center before begin handled.
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
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
m_warehouse	replenishmentclass	varchar	60	√		null	Custom class to calculate Quantity to Order
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_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_inventoryline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
m_movementline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
m_product_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
s_resource	s_resource_id	numeric	10				Resource
s_resource	s_resource_uu	varchar	36	√		NULL::character varying	S_Resource_UU
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_orderline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
s_resource	s_resourcetype_id	numeric	10				Resource Type
c_projectissue	s_timeexpenseline_id	numeric	10	√		null	Time and Expense Report Line
c_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_order	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
m_inoutline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_movementline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
c_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
c_acctschema	separator	bpchar	1				Element Separator
m_warehouse	separator	bpchar	1				Element Separator
m_attributesetinstance	serno	varchar	40	√		null	Product Serial Number
m_product	shelfdepth	numeric	10	√		null	Shelf depth required
m_product	shelfheight	numeric	0	√		null	Shelf height required
m_product	shelfwidth	numeric	10	√		null	Shelf width required
m_inout	shipdate	timestamp	29,6	√		null	Shipment Date/Time
m_inout	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
c_order	shippingrateinquiry	bpchar	1	√		NULL::bpchar	Rate Inquiry
m_product	sku	varchar	30	√		null	Stock Keeping Unit
t_inventoryvalue	t_inventoryvalue_uu	varchar	36	√		NULL::character varying	T_InventoryValue_UU
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
m_movementline	targetqty	numeric	0	√		0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
c_acctschema	taxcorrectiontype	bpchar	1	√		null	Type of Tax Correction
c_invoice	totallines	numeric	0			0	Total of all document lines
c_order	totallines	numeric	0			0	Total of all document lines
m_inout	trackingno	varchar	60	√		null	Number to track the shipment
m_product	unitsperpack	numeric	10			1	The Units Per Pack indicates the no of units of a product packed together.
m_product	unitsperpallet	numeric	0	√		null	Units Per Pallet
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_acctschema	updated	timestamp	29,6			now()	Date this record was updated
c_allocationline	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_landedcost	updated	timestamp	29,6			now()	Date this record was updated
c_landedcostallocation	updated	timestamp	29,6			now()	Date this record was updated
c_order	updated	timestamp	29,6			now()	Date this record was updated
c_orderlandedcost	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_orderlandedcostallocation	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
c_orderline	updated	timestamp	29,6			now()	Date this record was updated
c_projectissue	updated	timestamp	29,6			now()	Date this record was updated
c_projectissuema	updated	timestamp	29,6			now()	Date this record was updated
m_attributesetinstance	updated	timestamp	29,6			now()	Date this record was updated
m_cost	updated	timestamp	29,6			now()	Date this record was updated
m_costdetail	updated	timestamp	29,6			now()	Date this record was updated
m_costelement	updated	timestamp	29,6			now()	Date this record was updated
m_costhistory	updated	timestamp	29,6			statement_timestamp()	Date this record was updated
m_costmovement_v	updated	timestamp	29,6	√		null	Date this record was updated
m_costqueue	updated	timestamp	29,6			now()	Date this record was updated
m_costtype	updated	timestamp	29,6			now()	Date this record was updated
m_inout	updated	timestamp	29,6			now()	Date this record was updated
m_inoutline	updated	timestamp	29,6			now()	Date this record was updated
m_inoutlinema	updated	timestamp	29,6			now()	Date this record was updated
m_inventoryline	updated	timestamp	29,6			now()	Date this record was updated
m_inventorylinema	updated	timestamp	29,6			now()	Date this record was updated
m_locator	updated	timestamp	29,6			now()	Date this record was updated
m_matchinv	updated	timestamp	29,6			now()	Date this record was updated
m_matchpo	updated	timestamp	29,6			now()	Date this record was updated
m_movementline	updated	timestamp	29,6			now()	Date this record was updated
m_movementlinema	updated	timestamp	29,6			now()	Date this record was updated
m_product	updated	timestamp	29,6			now()	Date this record was updated
m_product_acct	updated	timestamp	29,6			now()	Date this record was updated
m_product_category	updated	timestamp	29,6			now()	Date this record was updated
m_product_category_acct	updated	timestamp	29,6			now()	Date this record was updated
m_product_po	updated	timestamp	29,6			now()	Date this record was updated
m_productionline	updated	timestamp	29,6			now()	Date this record was updated
m_productionlinema	updated	timestamp	29,6			now()	Date this record was updated
m_transaction	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse	updated	timestamp	29,6			now()	Date this record was updated
m_warehouse_acct	updated	timestamp	29,6			now()	Date this record was updated
s_resource	updated	timestamp	29,6			now()	Date this record was updated
c_acctschema	updatedby	numeric	10				User who updated this records
c_allocationline	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_landedcost	updatedby	numeric	10				User who updated this records
c_landedcostallocation	updatedby	numeric	10				User who updated this records
c_order	updatedby	numeric	10				User who updated this records
c_orderlandedcost	updatedby	numeric	10				User who updated this records
c_orderlandedcostallocation	updatedby	numeric	10				User who updated this records
c_orderline	updatedby	numeric	10				User who updated this records
c_projectissue	updatedby	numeric	10				User who updated this records
c_projectissuema	updatedby	numeric	10				User who updated this records
m_attributesetinstance	updatedby	numeric	10				User who updated this records
m_cost	updatedby	numeric	10				User who updated this records
m_costdetail	updatedby	numeric	10				User who updated this records
m_costelement	updatedby	numeric	10				User who updated this records
m_costhistory	updatedby	numeric	10				User who updated this records
m_costmovement_v	updatedby	numeric	10	√		null	User who updated this records
m_costqueue	updatedby	numeric	10				User who updated this records
m_costtype	updatedby	numeric	10				User who updated this records
m_inout	updatedby	numeric	10				User who updated this records
m_inoutline	updatedby	numeric	10				User who updated this records
m_inoutlinema	updatedby	numeric	10				User who updated this records
m_inventoryline	updatedby	numeric	10				User who updated this records
m_inventorylinema	updatedby	numeric	10				User who updated this records
m_locator	updatedby	numeric	10				User who updated this records
m_matchinv	updatedby	numeric	10				User who updated this records
m_matchpo	updatedby	numeric	10				User who updated this records
m_movementline	updatedby	numeric	10				User who updated this records
m_movementlinema	updatedby	numeric	10				User who updated this records
m_product	updatedby	numeric	10				User who updated this records
m_product_acct	updatedby	numeric	10				User who updated this records
m_product_category	updatedby	numeric	10				User who updated this records
m_product_category_acct	updatedby	numeric	10				User who updated this records
m_product_po	updatedby	numeric	10				User who updated this records
m_productionline	updatedby	numeric	10				User who updated this records
m_productionlinema	updatedby	numeric	10				User who updated this records
m_transaction	updatedby	numeric	10				User who updated this records
m_warehouse	updatedby	numeric	10				User who updated this records
m_warehouse_acct	updatedby	numeric	10				User who updated this records
s_resource	updatedby	numeric	10				User who updated this records
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
m_locator	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_category	value	varchar	40				Search key for the record in the format required - must be unique
m_warehouse	value	varchar	40				Search key for the record in the format required - must be unique
s_resource	value	varchar	40				Search key for the record in the format required - must be unique
m_product_po	vendorcategory	varchar	30	√		null	Product Category of the Business Partner
m_product_po	vendorproductno	varchar	40				Product Key of the Business Partner
m_product	versionno	varchar	20	√		null	Version Number
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
m_warehouse_acct	w_differences_acct	numeric	10				Warehouse Differences Account
m_warehouse_acct	w_invactualadjust_acct	numeric	10	√		null	Account for Inventory value adjustments for Actual Costing
m_warehouse_acct	w_inventory_acct	numeric	10	√		null	Warehouse Inventory Asset Account - Currently not used
m_warehouse_acct	w_revaluation_acct	numeric	10	√		null	Account for Inventory Revaluation
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_allocationline	writeoffamt	numeric	0			0	Amount to write-off
m_locator	x	varchar	60	√		null	X dimension, e.g., Aisle
m_locator	y	varchar	60	√		null	Y dimension, e.g., Bin
m_locator	z	varchar	60	√		null	Z dimension, e.g., Level