rv_dd_orderdetail

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 √ null
ad_org_id numeric 10 √ null
isactive bpchar 1 √ null
created timestamp 29,6 √ null
createdby numeric 10 √ null
updated timestamp 29,6 √ null
updatedby numeric 10 √ null
dd_order_id numeric 10 √ null
dd_order.dd_order_id Implied Constraint R
c_order_id numeric 10 √ null
c_order.c_order_id Implied Constraint R
docstatus bpchar 2 √ null
docaction bpchar 2 √ null
c_doctype_id numeric 10 √ null
c_doctype.c_doctype_id Implied Constraint R
isapproved bpchar 1 √ null
salesrep_id numeric 10 √ null
isdropship bpchar 1 √ null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id Implied Constraint R
c_bp_group_id numeric 10 √ null
c_bp_group.c_bp_group_id Implied Constraint R
ad_user_id numeric 10 √ null
poreference varchar 20 √ null
issotrx bpchar 1 √ null
c_campaign_id numeric 10 √ null
c_campaign.c_campaign_id Implied Constraint R
c_project_id numeric 10 √ null
c_project.c_project_id Implied Constraint R
c_activity_id numeric 10 √ null
c_activity.c_activity_id Implied Constraint R
dd_orderline_id numeric 10 √ null
dd_orderline.dd_orderline_id Implied Constraint R
dateordered timestamp 29,6 √ null
datepromised timestamp 29,6 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
m_locator_id numeric 10 √ null
m_locator.m_locator_id Implied Constraint R
m_locatorto_id numeric 10 √ null
m_attributesetinstance_id numeric 10 √ null
m_attributesetinstance.m_attributesetinstance_id Implied Constraint R
productattribute varchar 2147483647 √ null
m_attributesetinstanceto_id numeric 10 √ null
productattributeto varchar 2147483647 √ null
m_attributeset_id numeric 10 √ null
m_attributeset.m_attributeset_id Implied Constraint R
m_lot_id numeric 10 √ null
m_lot.m_lot_id Implied Constraint R
guaranteedate timestamp 29,6 √ null
lot varchar 40 √ null
serno varchar 40 √ null
c_uom_id numeric 10 √ null
c_uom.c_uom_id Implied Constraint R
qtyentered numeric 0 √ null
qtyordered numeric 0 √ null
qtyreserved numeric 0 √ null
qtydelivered numeric 0 √ null
confirmedqty numeric 0 √ null
qtyintransit numeric 0 √ null
targetqty numeric 0 √ null
qtytodeliver numeric 0 √ null
description varchar 255 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views