View idempiere9.adempiere.rv_pp_mrp
View Material Requirement Planning

 Generated by
Quality Systems & Solutions
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
pp_mrp_id numeric 0  √  null MRP ID
ad_client_id numeric 10  √  null Client/Tenant for this installation.
ad_org_id numeric 10  √  null Organizational entity within client
created timestamp 29,6  √  null Date this record was created
createdby numeric 10  √  null User who created this records
isactive bpchar 1  √  null The record is active in the system
isavailable bpchar 2147483647  √  null
updated timestamp 29,6  √  null Date this record was updated
updatedby numeric 10  √  null User who updated this records
ismps bpchar 1  √  null Is MPS
name varchar 2147483647  √  null Alphanumeric identifier of the entity
description varchar 2147483647  √  null
c_order_id numeric 0  √  null Order
c_orderline_id numeric 0  √  null Sales Order Line
dateordered timestamptz 35,6  √  null Date of Order
dateconfirm timestamptz 35,6  √  null Date Confirm of this Order
datepromised timestamptz 35,6  √  null Date Order was promised
datestartschedule timestamptz 35,6  √  null Scheduled start date for this Order
datefinishschedule timestamptz 35,6  √  null Scheduled Finish date for this Order
datestart timestamptz 35,6  √  null Date Start for this Order
datesimulation timestamptz 35,6  √  null Simulation date for this Material Plan
docstatus varchar 2147483647  √  null The current status of the document
m_forecast_id numeric 0  √  null Material Forecast
m_forecastline_id numeric 0  √  null Forecast Line
value varchar 2147483647  √  null Search key for the record in the format required - must be unique
m_product_id numeric 10  √  null Product, Service, Item
m_requisition_id numeric 0  √  null Material Requisition
m_requisitionline_id numeric 0  √  null Material Requisition Line
m_warehouse_id numeric 10  √  null Storage Warehouse and Service Point
pp_order_id numeric 0  √  null Manufacturing Order
pp_order_bomline_id numeric 0  √  null
dd_order_id numeric 0  √  null
dd_orderline_id numeric 0  √  null
qty numeric 0  √  null Quantity
s_resource_id numeric 10  √  null Resource
planner_id numeric 0  √  null
priority varchar 2147483647  √  null Indicates if this request is of a high, medium or low priority.
ordertype varchar 2147483647  √  null Type of Order: MRP records grouped by source (Sales Order, Purchase Order, Distribution Order, Requisition)
typemrp bpchar 2147483647  √  null MRP Type determines whether a record is demand or supply
lowlevel numeric 10  √  null The Low Level is used to calculate the material plan and determines if a net requirement should be exploited
c_bpartner_id numeric 0  √  null Identifies a Business Partner
version numeric 0  √  null
documentno varchar 2147483647  √  null Document sequence number of the document

Analyzed at 2021-12-25 14:43 +0100