column-reference developer end-user mrp reference shortage

MRP Core Column Reference¶

Overview¶

The MRP Core table (mrp_details) is the final output of the MRP regeneration and the source of data for all Pulse shortage reports. This reference defines the key columns that drive shortage analysis. For a conceptual description of how these columns are calculated, see How Shortages Are Calculated and MRP Core Table.

Transaction Identity Columns¶

These columns identify what each row represents.

Column	Description
MRP - Ord Type (mrp_ord_type)	A descriptive label for the transaction type. Examples: `'Purchase (Replenishment)'`, `'Production (Demand)'`, `'Customer Kit (Demand)'`.
MRP Ord # (mrp_ord_no)	The originating order number from the source system.
MRP - Ord Dt (mrp_ord_dt)	The date the originating order was entered.
MRP - Demand/Replenish Date (mrp_trx_dt)	The transaction date — determines the chronological position of this record in the netting sequence. Sourced from the date field configured in MRP Setup for each order type.
MRP - Qty Demand/Replenish (mrp_trx_qty)	The quantity impact of this transaction. Demand quantities are negative; replenishment quantities are positive.
`mrp_demand_or_replenish_cd`	`'D'` = demand (consumes inventory); `'R'` = replenishment (adds inventory). Internal code, not exposed in reports.
`mrp_ord_source`	The order type that generated this row: `'Customer'`, `'PO'`, `'POP'`, `'SF'`, `'TRN'`, or `'Forecast'`. Internal code, not exposed in reports.

Projected On-Hand Quantity Columns¶

The most important columns for shortage analysis. Each exists in three variants for three aggregation levels.

Column	Aggregation Scope	Description
MRP - New Qty On-Hand (All Loc) (mrp_new_qty_i)	Item — all locations	Running projected on-hand balance across all locations. Negative = shortage at item level.
MRP - New Qty On-Hand (Loc) (mrp_new_qty_il)	Item + Location	Running projected on-hand balance for this specific location. The level most commonly used by Pulse shortage reports. Negative = location-specific shortage.
MRP - New Qty On-Hand (Group) (mrp_new_qty_ilg)	Item + MRP Group	Running projected on-hand balance within the item's MRP Group. Relevant only when MRP Groups are configured.

On-Hand Ignoring Replenishments¶

Same running balance as above, but excluding all replenishment transactions. Shows the projected inventory position based on demand only.

Column	Aggregation Scope
MRP - New Qty On-Hand (All Loc) - Ignore Replenish (mrp_new_nr_qty_i)	Item — all locations
MRP - New Qty On-Hand (Loc) - Ignore Replenish (mrp_new_nr_qty_il)	Item + Location
MRP - New Qty On-Hand (Group) - Ignore Replenish (mrp_new_nr_qty_ilg)	Item + MRP Group

Starting Available Quantity¶

The on-hand quantity available to MRP at the start of regeneration, before any transactions are applied.

Column	Aggregation Scope
MRP Qty Avail (All Loc) (mrp_qty_avail_i)	Item — all locations
MRP Qty Avail (Loc) (mrp_qty_avail_il)	Item + Location
MRP Qty Avail (Group) (mrp_qty_avail_ilg)	Item + MRP Group

Availability Flag¶

Column	Description
MRP - Avail? (mrp_rec_avail)	`'Y'` = the order is projected to be fully fulfillable; `'N'` = a shortage exists at some point in the order's planning horizon. Back-updated after all rows are inserted, based on the minimum `mrp_new_qty_il` across all demand rows for the order.

Earliest Shortage Date Columns¶

Written to the Inventory Status table after regeneration. Indicate the first date a shortage is projected for each item.

Column	Aggregation Scope
Earliest Shortage Dt (All Loc) (min_short_dt_i)	Item — all locations
Earliest Shortage Dt (Loc) (min_short_dt_il)	Item + Location
Earliest Shortage Dt (Group) (min_short_dt_ilg)	Item + MRP Group
Earliest Shortage Dt (All Loc) - Ignore Replenish (nr_min_short_dt_i)	Item — all locations (demand-only)
Earliest Shortage Dt (Loc) - Ignore Replenish (nr_min_short_dt_il)	Item + Location (demand-only)
Earliest Shortage Dt (Group) - Ignore Replenish (nr_min_short_dt_ilg)	Item + MRP Group (demand-only)

Item and Location Columns¶

Column	Description
Item # (item_no)	The item this row applies to.
Loc (item_loc)	The stocking location for this row.
MRP Loc Group (mrp_loc_group)	The MRP Group this item/location belongs to.
Item Pur or MFG (pur_or_mfg)	Whether the item is purchased (`'P'`) or manufactured (`'M'`).
Reorder Lvl (reorder_lvl)	The item/location reorder level, carried from Inventory Status into the MRP Core row.
Safety Stk (safety_stk)	The item/location safety stock quantity, carried from Inventory Status.

Order Reference Columns¶

Column	Description
OE Ord # (oe_ord_no)	The customer order number associated with this row.
POP Ord # (pp_ord_no)	The production order number associated with this row.
PO Ord # (po_ord_no)	The purchase order number associated with this row.
SF Ord # (sf_ord_no)	The shop floor order number associated with this row.
Par Item # (par_item_no)	The parent item that generated this demand through the BOM structure. Populated for POP demand and Forecast demand entries.
Org Ord # (org_ord_no)	The original order number when this row traces back to a source order.
Org Item # (org_item_no)	The original item number when the row traces back to a source item.
Job # (job_no)	The job number associated with this row, when applicable.

Customer and Vendor Columns¶

Column	Description
Cust # (cus_no)	Customer number — populated for customer order demand rows.
Cust Name (cus_name)	Customer name.
Ship to Name (oehdr_ship_to_name)	Ship-to name from the order header.
Bill to Name (bill_to_name)	Bill-to name from the order header.
Slspsn # (slspsn_no)	Salesperson number associated with the order.
Vend # (ap_vend_no)	Vendor number — populated for purchase order replenishment rows.
Vend Name (vend_name)	Vendor name.
POP Byr Plnr (pp_byr_plnr)	Buyer/planner code from the production or purchase order.
Request Dt (request_dt)	Requested date from the originating order.
Promise Dt (promise_dt)	Promise date from the originating order.