m_costmovement_v

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
c_acctschema_id numeric 10 √ null
m_costhistory_id numeric 10 √ null
m_costhistory.m_costhistory_id Implied Constraint R
m_costtype_id numeric 10 √ null
m_costtype.m_costtype_id Implied Constraint R
m_costelement_id numeric 10 √ null
m_costelement.m_costelement_id Implied Constraint R
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
oldqty numeric 0 √ null
newqty numeric 0 √ null
oldcostprice numeric 0 √ null
newcostprice numeric 0 √ null
oldcqty numeric 0 √ null
newcqty numeric 0 √ null
oldcamt numeric 0 √ null
newcamt numeric 0 √ null
qty numeric 0 √ null
amt numeric 0 √ null
deltaqty numeric 0 √ null
deltaamt numeric 0 √ null
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id Implied Constraint R
m_inoutline_id numeric 10 √ null
m_inoutline.m_inoutline_id Implied Constraint R
c_invoiceline_id numeric 10 √ null
c_invoiceline.c_invoiceline_id Implied Constraint R
m_movementline_id numeric 10 √ null
m_movementline.m_movementline_id Implied Constraint R
m_inventoryline_id numeric 10 √ null
m_inventoryline.m_inventoryline_id Implied Constraint R
m_productionline_id numeric 10 √ null
m_productionline.m_productionline_id Implied Constraint R
c_projectissue_id numeric 10 √ null
c_projectissue.c_projectissue_id Implied Constraint R
m_matchinv_id numeric 10 √ null
m_matchinv.m_matchinv_id Implied Constraint R
m_costdetail_id numeric 10 √ null
m_costdetail.m_costdetail_id Implied Constraint R
description varchar 255 √ null
created timestamp 29,6 √ null
createdby numeric 10 √ null
updated timestamp 29,6 √ null
updatedby numeric 10 √ null
isactive bpchar 1 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views