cof_rv_detalhesestoqueprevisto

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_org_id numeric 10 √ null
ad_client_id numeric 10 √ null
cof_identificadortransacao varchar 2 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
cof_producttype_id numeric 10 √ null
cof_producttype.cof_producttype_id Implied Constraint R
cof_productclass_id numeric 10 √ null
cof_productclass.cof_productclass_id Implied Constraint R
cof_productgroup_id numeric 10 √ null
cof_productgroup.cof_productgroup_id Implied Constraint R
movementdate timestamp 29,6 √ null
quantidade_antiga numeric 0 √ null
qty numeric 0 √ null
quantidade_atual numeric 0 √ null
lbr_docfiscal_line_id numeric 10 √ null
lbr_docfiscal_line.lbr_docfiscal_line_id Implied Constraint R
m_productionline_id numeric 10 √ null
m_productionline.m_productionline_id Implied Constraint R
cof_ajusteestoqueprvstline_id numeric 10 √ null
cof_ajusteestoqueprvstline.cof_ajusteestoqueprvstline_id Implied Constraint R
cof_cumulatedcostamt numeric 0 √ null
currentcostprice numeric 0 √ null
amt numeric 0 √ null
cumulatedamt numeric 0 √ null
documentno varchar 30 √ null
ide_dhemi timestamp 29,6 √ null
dateacct timestamp 29,6 √ null
det_prod_cfop varchar 4 √ null
lbr_cfop_id numeric 10 √ null
lbr_cfop.lbr_cfop_id Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views