m_requisitionline

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_requisitionline_id numeric 10 null
m_demanddetail.m_requisitionline_id mreqline_mdemanddetail C
pp_mrp.m_requisitionline_id mrequisitionline_ppmrp R
rv_m_requisition.m_requisitionline_id Implied Constraint R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
line numeric 10 null
m_requisition_id numeric 10 null
m_requisition.m_requisition_id mrequisition_mrequisitionline C
qty numeric 0 0
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_mrequisitionline R
description varchar 255 √ null
priceactual numeric 0 0
linenetamt numeric 0 0
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_mrequisitionline R
m_attributesetinstance_id numeric 0 √ null
m_attributesetinstance.m_attributesetinstance_id mattributesetinstance_mrequisi R
c_charge_id numeric 10 √ null
c_charge.c_charge_id ccharge_mrequisitionline R
c_bpartner_id numeric 10 √ NULL::numeric
c_bpartner.c_bpartner_id cbpartner_mrequisitionline R
c_uom_id numeric 10 √ NULL::numeric
c_uom.c_uom_id cuom_mrequisitionline R
m_requisitionline_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_requisitionline_pkey Primary key Asc m_requisitionline_id
m_requisitionline_uu_idx Must be unique Asc m_requisitionline_uu

Check Constraints

Constraint Name Constraint
m_requisitionline_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation