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

Table	Column	Type	Size	Nulls	Auto	Default
m_inoutconfirm	approvalamt	numeric	0	√		null	Document Approval Amount
m_inventory	approvalamt	numeric	0	√		null	Document Approval Amount
m_movement	approvalamt	numeric	0	√		null	Document Approval Amount
m_movementconfirm	approvalamt	numeric	0	√		0	Document Approval Amount
c_invoice	chargeamt	numeric	0	√		0	Charge Amount
m_inout	chargeamt	numeric	0	√		0	Charge Amount
m_movement	chargeamt	numeric	0	√		null	Charge Amount
m_inoutline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_inoutlineconfirm	confirmedqty	numeric	0			0	Confirmation of a received quantity
m_movementline	confirmedqty	numeric	0	√		0	Confirmation of a received quantity
m_movementlineconfirm	confirmedqty	numeric	0			0	Confirmation of a received quantity
c_invoice	currencyrate	numeric	0	√		null	Currency Conversion Rate
m_inventoryline	currentcostprice	numeric	0	√		(0)::numeric	The currently used cost price
m_inoutlineconfirm	differenceqty	numeric	0	√		null	Difference Quantity
m_movementlineconfirm	differenceqty	numeric	0			0	Difference Quantity
m_inout	freightamt	numeric	0	√		0	Freight Amount
m_movement	freightamt	numeric	0	√		null	Freight Amount
c_invoice	grandtotal	numeric	0			0	Total amount of document
c_invoiceline	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
m_inoutline	movementqty	numeric	0			0	Quantity of a product moved.
m_movementline	movementqty	numeric	0			0	Quantity of a product moved.
m_inventoryline	newcostprice	numeric	0	√		(0)::numeric	New current cost price after processing of M_CostDetail
m_inoutline	pickedqty	numeric	0	√		0	Picked Quantity
c_invoiceline	priceactual	numeric	0			0	Actual Price
c_invoiceline	priceentered	numeric	0				Price Entered - the price based on the selected/base UoM
c_invoiceline	pricelimit	numeric	0			0	Lowest price for a product
c_invoiceline	pricelist	numeric	0			0	List Price
c_invoice	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_inout	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_inventory	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_movement	processedon	numeric	0	√		null	The date+time (expressed in decimal format) when the document has been processed
m_inventoryline	qtybook	numeric	0			0	Book Quantity
m_inventoryline	qtycount	numeric	0			0	Counted Quantity
m_inventoryline	qtycsv	numeric	0			0	QtyCsv
c_invoiceline	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
m_inoutline	qtyoverreceipt	numeric	0	√		0	Over Receipt Quantity
c_invoiceline	rramt	numeric	0	√		null	Revenue Recognition Amount
m_inoutline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_inoutlineconfirm	scrappedqty	numeric	0	√		null	The Quantity scrapped due to QA issues
m_movementline	scrappedqty	numeric	0	√		0	The Quantity scrapped due to QA issues
m_movementlineconfirm	scrappedqty	numeric	0			0	The Quantity scrapped due to QA issues
m_inoutline	targetqty	numeric	0	√		0	Target Movement Quantity
m_inoutlineconfirm	targetqty	numeric	0			0	Target Movement Quantity
m_movementline	targetqty	numeric	0	√		0	Target Movement Quantity
m_movementlineconfirm	targetqty	numeric	0			0	Target Movement Quantity
c_invoiceline	taxamt	numeric	0	√		0	Tax Amount for a document
c_invoice	totallines	numeric	0			0	Total of all document lines
m_inout	volume	numeric	0	√		null	Volume of a product
m_inout	weight	numeric	0	√		null	Weight of a product
c_invoiceline	a_createasset	bpchar	1	√		'N'::bpchar	Create Asset
c_invoiceline	a_processed	bpchar	1	√		'N'::bpchar	Processed
c_invoice	copyfrom	bpchar	1	√		null	Copy From Record
m_inventory	costingmethod	bpchar	1	√		NULL::bpchar	Indicates how Costs will be calculated
m_inout	createconfirm	bpchar	1	√		null	Create Confirm
c_invoice	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_inout	createfrom	bpchar	1	√		null	Process which will generate a new document lines based on an existing document
m_movement	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
m_inoutconfirm	createpackage	bpchar	1	√		null	Create Package
m_inout	deliveryrule	bpchar	1				Defines the timing of Delivery
m_movement	deliveryrule	bpchar	1	√		null	Defines the timing of Delivery
m_inout	deliveryviarule	bpchar	1				How the order will be delivered
m_movement	deliveryviarule	bpchar	1	√		null	How the order will be delivered
m_inout	freightcostrule	bpchar	1				Method for charging Freight
m_movement	freightcostrule	bpchar	1	√		null	Method for charging Freight
m_inventory	generatelist	bpchar	1	√		'Y'::bpchar	Generate List
c_invoice	generateto	bpchar	1	√		null	Generate To
m_inout	generateto	bpchar	1	√		null	Generate To
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_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
m_inout	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inoutconfirm	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_inoutlineconfirm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inventory	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inventoryline	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_movement	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_movementconfirm	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_movementlineconfirm	isactive	bpchar	1			'Y'::bpchar	The record is active in the system
m_inout	isalternatereturnaddress	bpchar	1			'N'::bpchar	Alternate Return Address
c_invoice	isapproved	bpchar	1			'Y'::bpchar	Indicates if this document requires approval
m_inout	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inoutconfirm	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inventory	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_movement	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_movementconfirm	isapproved	bpchar	1			'N'::bpchar	Indicates if this document requires approval
m_inoutline	isautoproduce	bpchar	1	√		'N'::bpchar	Auto create production to fulfill shipment
m_inoutconfirm	iscancelled	bpchar	1			'N'::bpchar	The transaction was cancelled
c_invoiceline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
m_inoutline	isdescription	bpchar	1			'N'::bpchar	if true, the line is just description and no transaction
c_invoice	isdiscountprinted	bpchar	1			'Y'::bpchar	Print Discount on Invoice and Order
m_inout	isdropship	bpchar	1	√		'N'::bpchar	Drop Shipments are sent directly to the Drop Shipment Location
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_inoutconfirm	isindispute	bpchar	1			'N'::bpchar	Document is in dispute
m_inout	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_movement	isintransit	bpchar	1			'N'::bpchar	Movement is in transit
m_inoutline	isinvoiced	bpchar	1			'N'::bpchar	Is this invoiced?
c_invoice	isoverridecurrencyrate	bpchar	1			'N'::bpchar	Override Currency Conversion Rate
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_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
m_inout	isprinted	bpchar	1			'N'::bpchar	Indicates if this document / line is printed
c_invoice	isselfservice	bpchar	1			'N'::bpchar	This is a Self-Service entry or this entry can be changed via Self-Service
c_invoice	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
m_inout	issotrx	bpchar	1			'Y'::bpchar	This is a Sales Transaction
c_invoice	istaxincluded	bpchar	1			'N'::bpchar	Tax is included in the price
c_invoice	istransferred	bpchar	1			'N'::bpchar	Transferred to General Ledger (i.e. accounted)
c_invoice	paymentrule	bpchar	1				How you pay the invoice
c_invoice	posted	bpchar	1			'N'::bpchar	Posting status
m_inout	posted	bpchar	1			'N'::bpchar	Posting status
m_inventory	posted	bpchar	1			'N'::bpchar	Posting status
m_movement	posted	bpchar	1			'N'::bpchar	Posting status
m_inout	priorityrule	bpchar	1				Priority of a document
m_movement	priorityrule	bpchar	1	√		null	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
m_inout	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutconfirm	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inoutlineconfirm	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventory	processed	bpchar	1			'N'::bpchar	The document has been processed
m_inventoryline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movement	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movementconfirm	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movementline	processed	bpchar	1			'N'::bpchar	The document has been processed
m_movementlineconfirm	processed	bpchar	1			'N'::bpchar	The document has been processed
c_invoice	processing	bpchar	1	√		null	Process Now
m_inout	processing	bpchar	1	√		null	Process Now
m_inoutconfirm	processing	bpchar	1	√		null	Process Now
m_inventory	processing	bpchar	1	√		null	Process Now
m_movement	processing	bpchar	1	√		null	Process Now
m_movementconfirm	processing	bpchar	1	√		null	Process Now
c_invoice	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_inout	sendemail	bpchar	1			'N'::bpchar	Enable sending Document EMail
m_inventory	updateqty	bpchar	1	√		'N'::bpchar	Update Quantities
m_inoutconfirm	confirmtype	bpchar	2				Type of confirmation
c_invoice	docaction	bpchar	2				The targeted status of the document
m_inout	docaction	bpchar	2				The targeted status of the document
m_inoutconfirm	docaction	bpchar	2				The targeted status of the document
m_inventory	docaction	bpchar	2				The targeted status of the document
m_movement	docaction	bpchar	2				The targeted status of the document
m_movementconfirm	docaction	bpchar	2				The targeted status of the document
c_invoice	docstatus	bpchar	2				The current status of the document
m_inout	docstatus	bpchar	2				The current status of the document
m_inoutconfirm	docstatus	bpchar	2				The current status of the document
m_inventory	docstatus	bpchar	2				The current status of the document
m_movement	docstatus	bpchar	2				The current status of the document
m_movementconfirm	docstatus	bpchar	2				The current status of the document
m_inout	movementtype	bpchar	2				Method of moving the inventory
c_invoiceline	a_capvsexp	varchar	3	√		null	Capital/Expense
c_invoiceline	a_asset_group_id	numeric	10	√		null	Group of Assets
c_invoiceline	a_asset_id	numeric	10	√		null	Asset used internally or by customers
c_invoice	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoiceline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inout	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inoutconfirm	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inoutline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inoutlineconfirm	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inventory	ad_client_id	numeric	10				Client/Tenant for this installation.
m_inventoryline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_movement	ad_client_id	numeric	10				Client/Tenant for this installation.
m_movementconfirm	ad_client_id	numeric	10				Client/Tenant for this installation.
m_movementline	ad_client_id	numeric	10				Client/Tenant for this installation.
m_movementlineconfirm	ad_client_id	numeric	10				Client/Tenant for this installation.
c_invoice	ad_org_id	numeric	10				Organizational entity within client
c_invoiceline	ad_org_id	numeric	10				Organizational entity within client
m_inout	ad_org_id	numeric	10				Organizational entity within client
m_inoutconfirm	ad_org_id	numeric	10				Organizational entity within client
m_inoutline	ad_org_id	numeric	10				Organizational entity within client
m_inoutlineconfirm	ad_org_id	numeric	10				Organizational entity within client
m_inventory	ad_org_id	numeric	10				Organizational entity within client
m_inventoryline	ad_org_id	numeric	10				Organizational entity within client
m_movement	ad_org_id	numeric	10				Organizational entity within client
m_movementconfirm	ad_org_id	numeric	10				Organizational entity within client
m_movementline	ad_org_id	numeric	10				Organizational entity within client
m_movementlineconfirm	ad_org_id	numeric	10				Organizational entity within client
c_invoice	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoiceline	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
m_inventory	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
m_movement	ad_orgtrx_id	numeric	10	√		null	Performing or initiating organization
c_invoice	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
m_movement	ad_user_id	numeric	10	√		null	User within the system - Internal or Business Partner Contact
c_invoiceline	c_1099box_id	numeric	10	√		NULL::numeric	1099 Box
c_invoice	c_activity_id	numeric	10	√		null	Business Activity
c_invoiceline	c_activity_id	numeric	10	√		null	Business Activity
m_inout	c_activity_id	numeric	10	√		null	Business Activity
m_inoutline	c_activity_id	numeric	10	√		null	Business Activity
m_inventory	c_activity_id	numeric	10	√		null	Business Activity
m_movement	c_activity_id	numeric	10	√		null	Business Activity
c_invoice	c_bpartner_id	numeric	10				Identifies a Business Partner
m_inout	c_bpartner_id	numeric	10				Identifies a Business Partner
m_movement	c_bpartner_id	numeric	10	√		null	Identifies a Business Partner
c_invoice	c_bpartner_location_id	numeric	10				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
m_movement	c_bpartner_location_id	numeric	10	√		null	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
m_inout	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inoutline	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_inventory	c_campaign_id	numeric	10	√		null	Marketing Campaign
m_movement	c_campaign_id	numeric	10	√		null	Marketing Campaign
c_invoice	c_cashline_id	numeric	10	√		null	Cash Journal Line
c_invoice	c_cashplanline_id	numeric	10	√		NULL::numeric	Cash Plan Line
c_invoice	c_charge_id	numeric	10	√		null	Additional document charges
c_invoiceline	c_charge_id	numeric	10	√		null	Additional document charges
m_inout	c_charge_id	numeric	10	√		null	Additional document charges
m_inoutline	c_charge_id	numeric	10	√		null	Additional document charges
m_inventoryline	c_charge_id	numeric	10	√		null	Additional document charges
m_movement	c_charge_id	numeric	10	√		null	Additional document charges
c_invoice	c_conversiontype_id	numeric	10	√		null	Currency Conversion Rate Type
m_inventory	c_conversiontype_id	numeric	10	√		NULL::numeric	Currency Conversion Rate Type
c_invoice	c_currency_id	numeric	10				The Currency for this record
m_inventory	c_currency_id	numeric	10	√		NULL::numeric	The Currency for this record
c_invoice	c_doctype_id	numeric	10				Document type or rules
m_inout	c_doctype_id	numeric	10				Document type or rules
m_inventory	c_doctype_id	numeric	10				Document type or rules
m_movement	c_doctype_id	numeric	10				Document type or rules
c_invoice	c_doctypetarget_id	numeric	10				Target document type for conversing documents
c_invoice	c_dunninglevel_id	numeric	10	√		null	Dunning Level
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
m_inoutconfirm	c_invoice_id	numeric	10	√		null	Invoice Identifier
c_invoiceline	c_invoiceline_id	numeric	10				Invoice Detail Line
m_inoutlineconfirm	c_invoiceline_id	numeric	10	√		null	Invoice Detail Line
c_invoice	c_order_id	numeric	10	√		null	Order
m_inout	c_order_id	numeric	10	√		null	Order
c_invoiceline	c_orderline_id	numeric	10	√		null	Sales Order Line
m_inoutline	c_orderline_id	numeric	10	√		null	Sales Order Line
c_invoice	c_payment_id	numeric	10	√		null	Payment identifier
c_invoice	c_paymentterm_id	numeric	10				The terms of Payment (timing, discount)
c_invoice	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	c_project_id	numeric	10	√		null	Financial Project
m_inout	c_project_id	numeric	10	√		null	Financial Project
m_inoutline	c_project_id	numeric	10	√		null	Financial Project
m_inventory	c_project_id	numeric	10	√		null	Financial Project
m_movement	c_project_id	numeric	10	√		null	Financial Project
c_invoiceline	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
m_inoutline	c_projecttask_id	numeric	10	√		null	Actual Project Task in a Phase
c_invoiceline	c_tax_id	numeric	10	√		null	Tax identifier
c_invoiceline	c_uom_id	numeric	10	√		null	Unit of Measure
m_inoutline	c_uom_id	numeric	10				Unit of Measure
c_invoice	createdby	numeric	10				User who created this records
c_invoiceline	createdby	numeric	10				User who created this records
m_inout	createdby	numeric	10				User who created this records
m_inoutconfirm	createdby	numeric	10				User who created this records
m_inoutline	createdby	numeric	10				User who created this records
m_inoutlineconfirm	createdby	numeric	10				User who created this records
m_inventory	createdby	numeric	10				User who created this records
m_inventoryline	createdby	numeric	10				User who created this records
m_movement	createdby	numeric	10				User who created this records
m_movementconfirm	createdby	numeric	10				User who created this records
m_movementline	createdby	numeric	10				User who created this records
m_movementlineconfirm	createdby	numeric	10				User who created this records
m_movement	dd_order_id	numeric	10	√		null	Distribution Order
m_movementline	dd_orderline_id	numeric	10	√		null	Distribution Order Line
m_inout	dropship_bpartner_id	numeric	10	√		null	Business Partner to ship to
m_inout	dropship_location_id	numeric	10	√		null	Business Partner Location for shipping to
m_inout	dropship_user_id	numeric	10	√		null	Business Partner Contact for drop shipment
m_inout	fob	varchar	10	√		NULL::character varying	Freight Terms
m_inout	freightcharges	varchar	10	√		NULL::character varying	Freight Charges
c_invoiceline	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
c_invoiceline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inoutline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_inventoryline	m_attributesetinstance_id	numeric	10	√		0	Product Attribute Set Instance
m_movementline	m_attributesetinstance_id	numeric	10	√		null	Product Attribute Set Instance
m_movementline	m_attributesetinstanceto_id	numeric	10	√		null	Target Product Attribute Set Instance
m_inout	m_inout_id	numeric	10				Material Shipment Document
m_inoutconfirm	m_inout_id	numeric	10				Material Shipment Document
m_inoutline	m_inout_id	numeric	10				Material Shipment Document
m_inoutconfirm	m_inoutconfirm_id	numeric	10				Material Shipment or Receipt Confirmation
m_inoutlineconfirm	m_inoutconfirm_id	numeric	10				Material Shipment or Receipt Confirmation
c_invoiceline	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_inoutlineconfirm	m_inoutline_id	numeric	10				Line on Shipment or Receipt document
m_inoutlineconfirm	m_inoutlineconfirm_id	numeric	10				Material Shipment or Receipt Confirmation Line
m_inoutconfirm	m_inventory_id	numeric	10	√		null	Parameters for a Physical Inventory
m_inventory	m_inventory_id	numeric	10				Parameters for a Physical Inventory
m_inventoryline	m_inventory_id	numeric	10				Parameters for a Physical Inventory
m_movementconfirm	m_inventory_id	numeric	10	√		null	Parameters for a Physical Inventory
m_inoutlineconfirm	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_movementlineconfirm	m_inventoryline_id	numeric	10	√		null	Unique line in an Inventory document
m_inoutline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_inventoryline	m_locator_id	numeric	10	√		null	Warehouse Locator
m_movementline	m_locator_id	numeric	10				Warehouse Locator
m_movementline	m_locatorto_id	numeric	10				Location inventory is moved to
m_movement	m_movement_id	numeric	10				Movement of Inventory
m_movementconfirm	m_movement_id	numeric	10				Movement of Inventory
m_movementline	m_movement_id	numeric	10				Movement of Inventory
m_movementconfirm	m_movementconfirm_id	numeric	10				Inventory Move Confirmation
m_movementlineconfirm	m_movementconfirm_id	numeric	10				Inventory Move Confirmation
m_movementline	m_movementline_id	numeric	10				Inventory Move document Line
m_movementlineconfirm	m_movementline_id	numeric	10				Inventory Move document Line
m_movementlineconfirm	m_movementlineconfirm_id	numeric	10				Inventory Move Line Confirmation
m_inventory	m_perpetualinv_id	numeric	10	√		null	Rules for generating physical inventory
c_invoice	m_pricelist_id	numeric	10				Unique identifier of a Price List
c_invoiceline	m_product_id	numeric	10	√		null	Product, Service, Item
m_inoutline	m_product_id	numeric	10	√		null	Product, Service, Item
m_inventoryline	m_product_id	numeric	10				Product, Service, Item
m_movementline	m_product_id	numeric	10				Product, Service, Item
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
m_inout	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_movement	m_shipper_id	numeric	10	√		null	Method or manner of product delivery
m_inout	m_warehouse_id	numeric	10				Storage Warehouse and Service Point
m_inventory	m_warehouse_id	numeric	10	√		null	Storage Warehouse and Service Point
m_movement	m_warehouse_id	numeric	10	√		NULL::numeric	Storage Warehouse and Service Point
m_movement	m_warehouseto_id	numeric	10	√		NULL::numeric	To Storage Warehouse and Service Point
m_inout	nopackages	numeric	10	√		(1)::numeric	Number of packages shipped
m_inout	ref_inout_id	numeric	10	√		null	Referenced Shipment
m_inoutline	ref_inoutline_id	numeric	10	√		null	Referenced Shipment Line
c_invoice	ref_invoice_id	numeric	10	√		null	Referenced Invoice
c_invoiceline	ref_invoiceline_id	numeric	10	√		null	Referenced Invoice Line
c_invoice	relatedinvoice_id	numeric	10	√		NULL::numeric	Related Invoice
m_inout	returnbpartner_id	numeric	10	√		NULL::numeric	Return Partner
m_inout	returnlocation_id	numeric	10	√		NULL::numeric	Return Location
m_inout	returnuser_id	numeric	10	√		NULL::numeric	Return User/Contact
c_invoice	reversal_id	numeric	10	√		null	ID of document reversal
m_inout	reversal_id	numeric	10	√		null	ID of document reversal
m_inventory	reversal_id	numeric	10	√		null	ID of document reversal
m_movement	reversal_id	numeric	10	√		null	ID of document reversal
m_inoutline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
m_inventoryline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
m_movementline	reversalline_id	numeric	10	√		null	Use to keep the reversal line ID for reversing costing purpose
c_invoiceline	s_resourceassignment_id	numeric	10	√		null	Resource Assignment
c_invoice	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_inout	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
m_movement	salesrep_id	numeric	10	√		null	Sales Representative or Company Agent
c_invoice	updatedby	numeric	10				User who updated this records
c_invoiceline	updatedby	numeric	10				User who updated this records
m_inout	updatedby	numeric	10				User who updated this records
m_inoutconfirm	updatedby	numeric	10				User who updated this records
m_inoutline	updatedby	numeric	10				User who updated this records
m_inoutlineconfirm	updatedby	numeric	10				User who updated this records
m_inventory	updatedby	numeric	10				User who updated this records
m_inventoryline	updatedby	numeric	10				User who updated this records
m_movement	updatedby	numeric	10				User who updated this records
m_movementconfirm	updatedby	numeric	10				User who updated this records
m_movementline	updatedby	numeric	10				User who updated this records
m_movementlineconfirm	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
m_inout	user1_id	numeric	10	√		null	User defined list element #1
m_inoutline	user1_id	numeric	10	√		null	User defined list element #1
m_inventory	user1_id	numeric	10	√		null	User defined list element #1
m_movement	user1_id	numeric	10	√		null	User defined list element #1
c_invoice	user2_id	numeric	10	√		null	User defined list element #2
c_invoiceline	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_inventory	user2_id	numeric	10	√		null	User defined list element #2
m_movement	user2_id	numeric	10	√		null	User defined list element #2
m_inoutconfirm	confirmationno	varchar	20	√		null	Confirmation Number
m_inoutlineconfirm	confirmationno	varchar	20	√		null	Confirmation Number
c_invoice	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
m_movement	poreference	varchar	20	√		null	Transaction Reference Number (Sales Order, Purchase Order) of your Business Partner
c_invoice	created	timestamp	29,6			now()	Date this record was created
c_invoiceline	created	timestamp	29,6			now()	Date this record was created
m_inout	created	timestamp	29,6			now()	Date this record was created
m_inoutconfirm	created	timestamp	29,6			now()	Date this record was created
m_inoutline	created	timestamp	29,6			now()	Date this record was created
m_inoutlineconfirm	created	timestamp	29,6			now()	Date this record was created
m_inventory	created	timestamp	29,6			now()	Date this record was created
m_inventoryline	created	timestamp	29,6			now()	Date this record was created
m_movement	created	timestamp	29,6			now()	Date this record was created
m_movementconfirm	created	timestamp	29,6			now()	Date this record was created
m_movementline	created	timestamp	29,6			now()	Date this record was created
m_movementlineconfirm	created	timestamp	29,6			now()	Date this record was created
c_invoice	dateacct	timestamp	29,6				Accounting Date
m_inout	dateacct	timestamp	29,6				Accounting Date
c_invoice	dateinvoiced	timestamp	29,6				Date printed on Invoice
c_invoice	dateordered	timestamp	29,6	√		null	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.
m_inout	dateprinted	timestamp	29,6	√		null	Date the document was printed.
m_inout	datereceived	timestamp	29,6	√		null	Date a product was received
m_movement	datereceived	timestamp	29,6	√		null	Date a product was received
c_invoice	dunninggrace	timestamp	29,6	√		null	Dunning Grace Date
m_inout	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inventory	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_movement	movementdate	timestamp	29,6				Date a product was moved in or out of inventory
m_inout	pickdate	timestamp	29,6	√		null	Date/Time when picked for Shipment
c_invoiceline	rrstartdate	timestamp	29,6	√		null	Revenue Recognition Start Date
m_inout	shipdate	timestamp	29,6	√		null	Shipment Date/Time
c_invoice	updated	timestamp	29,6			now()	Date this record was updated
c_invoiceline	updated	timestamp	29,6			now()	Date this record was updated
m_inout	updated	timestamp	29,6			now()	Date this record was updated
m_inoutconfirm	updated	timestamp	29,6			now()	Date this record was updated
m_inoutline	updated	timestamp	29,6			now()	Date this record was updated
m_inoutlineconfirm	updated	timestamp	29,6			now()	Date this record was updated
m_inventory	updated	timestamp	29,6			now()	Date this record was updated
m_inventoryline	updated	timestamp	29,6			now()	Date this record was updated
m_movement	updated	timestamp	29,6			now()	Date this record was updated
m_movementconfirm	updated	timestamp	29,6			now()	Date this record was updated
m_movementline	updated	timestamp	29,6			now()	Date this record was updated
m_movementlineconfirm	updated	timestamp	29,6			now()	Date this record was updated
c_invoice	documentno	varchar	30				Document sequence number of the document
m_inout	documentno	varchar	30				Document sequence number of the document
m_inoutconfirm	documentno	varchar	30				Document sequence number of the document
m_inventory	documentno	varchar	30				Document sequence number of the document
m_movement	documentno	varchar	30				Document sequence number of the document
m_movementconfirm	documentno	varchar	30				Document sequence number of the document
c_invoice	c_invoice_uu	varchar	36	√		NULL::character varying	C_Invoice_UU
c_invoiceline	c_invoiceline_uu	varchar	36	√		NULL::character varying	C_InvoiceLine_UU
m_inout	m_inout_uu	varchar	36	√		NULL::character varying	M_InOut_UU
m_inoutconfirm	m_inoutconfirm_uu	varchar	36	√		NULL::character varying	M_InOutConfirm_UU
m_inoutline	m_inoutline_uu	varchar	36	√		NULL::character varying	M_InOutLine_UU
m_inoutlineconfirm	m_inoutlineconfirm_uu	varchar	36	√		NULL::character varying	M_InOutLineConfirm_UU
m_inventory	m_inventory_uu	varchar	36	√		NULL::character varying	M_Inventory_UU
m_inventoryline	m_inventoryline_uu	varchar	36	√		NULL::character varying	M_InventoryLine_UU
m_movement	m_movement_uu	varchar	36	√		NULL::character varying	M_Movement_UU
m_movementconfirm	m_movementconfirm_uu	varchar	36	√		NULL::character varying	M_MovementConfirm_UU
m_movementline	m_movementline_uu	varchar	36	√		NULL::character varying	M_MovementLine_UU
m_movementlineconfirm	m_movementlineconfirm_uu	varchar	36	√		NULL::character varying	M_MovementLineConfirm_UU
m_inout	shipperaccount	varchar	40	√		NULL::character varying	Shipper Account Number
m_inout	trackingno	varchar	60	√		null	Number to track the shipment
c_invoice	description	varchar	255	√		null	Optional short description of the record
c_invoiceline	description	varchar	255	√		null	Optional short description of the record
m_inout	description	varchar	255	√		null	Optional short description of the record
m_inoutconfirm	description	varchar	255	√		null	Optional short description of the record
m_inoutline	description	varchar	255	√		null	Optional short description of the record
m_inoutlineconfirm	description	varchar	255	√		null	Optional short description of the record
m_inventory	description	varchar	255	√		null	Optional short description of the record
m_inventoryline	description	varchar	255	√		null	Optional short description of the record
m_movement	description	varchar	255	√		null	Optional short description of the record
m_movementconfirm	description	varchar	255	√		null	Optional short description of the record
m_movementline	description	varchar	255	√		null	Optional short description of the record
m_movementlineconfirm	description	varchar	255	√		null	Optional short description of the record