pp_mrp

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
name varchar 120 √ null
ad_org_id numeric 10 null
c_bpartner_id numeric 10 √ null
c_bpartner.c_bpartner_id cbpartner_ppmrp R
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_ppmrp R
c_order_id numeric 10 √ null
c_order.c_order_id corder_ppmrp R
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
dateconfirm timestamp 29,6 √ null
datefinishschedule timestamp 29,6 √ null
dateordered timestamp 29,6 null
datepromised timestamp 29,6 null
datesimulation timestamp 29,6 √ null
datestart timestamp 29,6 √ null
datestartschedule timestamp 29,6 √ null
description varchar 1020 √ null
docstatus varchar 2 √ null
isactive bpchar 1 null
isavailable bpchar 1 √ null
m_forecastline_id numeric 10 √ null
m_forecastline.m_forecastline_id mforecastline_ppmrp R
m_forecast_id numeric 10 √ null
m_forecast.m_forecast_id mforecast_ppmrp R
m_product_id numeric 10 √ null
m_product.m_product_id mproduct_ppmrp R
m_requisitionline_id numeric 10 √ null
m_requisitionline.m_requisitionline_id mrequisitionline_ppmrp R
m_requisition_id numeric 10 √ null
m_requisition.m_requisition_id mrequisition_ppmrp R
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id mwarehouse_ppmrp R
pp_mrp_id numeric 10 null
pp_order_bomline_id numeric 10 √ null
pp_order_bomline.pp_order_bomline_id pporderbomline_ppmrp R
pp_order_id numeric 10 √ null
pp_order.pp_order_id pporder_ppmrp R
planner_id numeric 10 √ null
ad_user.ad_user_id planner_ppmrp R
priority varchar 10 √ null
qty numeric 0 √ null
s_resource_id numeric 10 √ null
s_resource.s_resource_id sresource_ppmrp R
ordertype varchar 3 √ null
typemrp bpchar 1 √ null
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
value varchar 80 null
ad_client_id numeric 10 null
version numeric 0 √ null
dd_order_id numeric 10 √ null
dd_order.dd_order_id ddorder_ppmrp R
dd_orderline_id numeric 10 √ null
dd_orderline.dd_orderline_id ddorderline_ppmrp R
pp_mrp_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
pp_mrp_key Primary key Asc pp_mrp_id
pp_mrp_c_order_id_idx Performance Asc c_order_id
pp_mrp_c_orderline_id_idx Performance Asc c_orderline_id
pp_mrp_uu_idx Must be unique Asc pp_mrp_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation