View idempiere9.adempiere.m_costmovement_v
Cost movement for M_Cost

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
c_acctschema_id numeric 10  √  null Rules for accounting
m_costhistory_id numeric 10  √  null Movement history for M_Cost
m_costtype_id numeric 10  √  null Type of Cost (e.g. Current, Plan, Future)
m_costelement_id numeric 10  √  null Product Cost Element
m_attributesetinstance_id numeric 10  √  null Product Attribute Set Instance
m_product_id numeric 10  √  null Product, Service, Item
oldqty numeric 0  √  null Old current quantity before the processing of M_CostDetail
newqty numeric 0  √  null New current quantity after processing of M_CostDetail
oldcostprice numeric 0  √  null Old current cost price before the processing of M_CostDetail
newcostprice numeric 0  √  null New current cost price after processing of M_CostDetail
oldcqty numeric 0  √  null Old accumulated qty before the processing of M_CostDetail
newcqty numeric 0  √  null New Accumulated Qty after processing of M_CostDetail
oldcamt numeric 0  √  null Old accumulated amt before the processing of M_CostDetail
newcamt numeric 0  √  null Accumulated Amt after processing of M_CostDetail
qty numeric 0  √  null Quantity
amt numeric 0  √  null Amount
deltaqty numeric 0  √  null Quantity Difference
deltaamt numeric 0  √  null Difference Amount
c_orderline_id numeric 10  √  null Sales Order Line
m_inoutline_id numeric 10  √  null Line on Shipment or Receipt document
c_invoiceline_id numeric 10  √  null Invoice Detail Line
m_movementline_id numeric 10  √  null Inventory Move document Line
m_inventoryline_id numeric 10  √  null Unique line in an Inventory document
m_productionline_id numeric 10  √  null Document Line representing a production
c_projectissue_id numeric 10  √  null Project Issues (Material, Labor)
m_matchinv_id numeric 10  √  null Match Shipment/Receipt to Invoice
m_costdetail_id numeric 10  √  null Cost Detail Information
description varchar 255  √  null Optional short description of the record
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
isactive bpchar 1  √  null The record is active in the system

Analyzed at 2021-12-25 14:46 +0100