rv_m_requisition

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_requisition_id numeric 10 √ null
m_requisition.m_requisition_id Implied Constraint R
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
documentno varchar 30 √ null
description varchar 255 √ null
help varchar 2000 √ null
ad_user_id numeric 10 √ null
m_pricelist_id numeric 10 √ null
m_pricelist.m_pricelist_id Implied Constraint R
m_warehouse_id numeric 10 √ null
m_warehouse.m_warehouse_id Implied Constraint R
isapproved bpchar 1 √ null
priorityrule bpchar 1 √ null
daterequired timestamp 29,6 √ null
totallines numeric 0 √ null
docaction bpchar 2 √ null
docstatus bpchar 2 √ null
processed bpchar 1 √ null
m_requisitionline_id numeric 10 √ null
m_requisitionline.m_requisitionline_id Implied Constraint R
line numeric 10 √ null
qty numeric 0 √ null
qtyordered numeric 0 √ null
m_product_id numeric 10 √ null
m_product.m_product_id Implied Constraint R
linedescription varchar 255 √ null
priceactual numeric 0 √ null
linenetamt numeric 0 √ null
c_charge_id numeric 10 √ null
c_charge.c_charge_id Implied Constraint R

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views