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).