Output data
During a plan regeneration, the Planner populates the following SQL Server tables:
Table | Contents |
---|---|
ALTPLAN | The date and time the Planner was last run. |
DOWNPLAN | A record for each period of time any resource was idle, and the reason for the idleness. |
INVPLAN | A record for each supply and demand that affects material inventory. |
JOBPLAN | Information about each operation in the plan (such as the actual duration of each operation). |
MATLPLAN | Information about each item occurrence in the plan (such as the start and end date of the item's manufacture and the order that caused the manufacture or purchase). |
MSLPLAN | Information about the starting inventory level and safety stock replenishment date for each item. |
ORDPLAN | The projected order completion date the Planner calculated for each order. |
POEXCEPT | Exception messages for orders that need to be moved in or out. |
RESPLAN | Information about every resource used in the plan (such as the start and end date of the resource usage). |
TODEMAND | A record for every order transferred from a remote site (after a multi-site global plan regeneration). |
TOSUPPLY | A record for every order transferred to a remote site (after a multi-site global plan regeneration). |