detail display information for mrp

[Chris Kelleher]

In the MRP detail display below, if I wanted to recreate a report with that
information, what table does that data reside in. I can get the PLN and PO's
from the rcpts, the CO from the citem however I cannot find where the PMPS,
PPS, and MPS would be. What table does that data exist in?

MRP detail display for an item.
02/03/00 206.000 120.000 120.000 PLN 368164
02/03/00 126.000 80.000 80.000 PPS WUASTD
02/11/00 102.000 24.000 24.000 PMPS 12094
02/23/00 101.000 1.000 1.000 CO w000058 1
02/25/00 94.000 7.000 7.000 PMPS 12162
03/17/00 134.000 40.000 40.000 PLN 370566
03/17/00 111.000 23.000 23.000 PMPS 12163
03/31/00 101.000 10.000 10.000 PMPS 12164

============================================================================
====================================
Davi-Ann Boodram
Information Systems Manager
mailto : daviann@wow.net url : http://www.peakeind.com
Peake Industries Limited. 177 Western Main Road. Cocorite.
Trinidad. West Indies.

 

[Chris Kelleher]

I think demand side records are kept in the "mrp" table and the supply side
records are kept in the "rcpts" table.

 

[Chris Kelleher]

The MRP detail display pulls records from job, poitem, coitem, mrp, and
rcpts. The MPS records are in the rcpts table with a type of "M".

HTH,
Mary S. Martin