Nwp

In Scope

Technical: NWP | ID: OR-ITM-NWP-NWP

This table will be added to the system to record all activity for the NWP process. This table will hold a record for every active Item/Location combination for each year.

See how this object fits into Item Management

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity: Medium
Sequencing: Stage 2
Typical Sources: ERPLegacy

Classification

Object Type: dictionary

Target Structure

Load Approach: Table
Target Objects: NWP

Field Definitions(5)

Rules & Considerations(21)

constraint

validation

Sample Load Data(4)

_scenario	ITEMRPK	LOCATIONRPK	FISCAL_YEARRPK	WAC	ORDER_NO	SHIPMENT	ON_HAND_QTY	COST_ADJ_AMT	QTY_RECEIVED	RECEIVE_DATE	UNIT_ADJ_QTY	VARIANCE_QTY	CURRENCY_CODE	EXCHANGE_RATE	REC_UNIT_COST	IN_TRANSIT_QTY	ADJUSTMENT_DATE
Example values from field definitions	SAMPLE	1	1	1.0000	SAMPLE	1	1.0000	1.0000	1.0000	2026-01-01	1.0000	1.0000	SAM	1.0000000000	1.0000	1.0000	2026-01-01
default	Nwp-002-ALT	3	3	12.5000	Nwp-002-ALT	3	12.5000	12.5000	12.5000	2026-01-03	12.5000	12.5000	ALT	12.5000000000	12.5000	12.5000	2026-01-03
default	Nwp-003-EDGE	5	5	14.0000	Nwp-003-EDGE	5	14.0000	14.0000	14.0000	2026-01-05	14.0000	14.0000	EDG	14.0000000000	14.0000	14.0000	2026-01-05

Example values from field definitions

ITEMRPK: SAMPLE
LOCATIONRPK: 1
FISCAL_YEARRPK: 1
WAC: 1.0000
ORDER_NO: SAMPLE
SHIPMENT: 1
ON_HAND_QTY: 1.0000
COST_ADJ_AMT: 1.0000
QTY_RECEIVED: 1.0000
RECEIVE_DATE: 2026-01-01
UNIT_ADJ_QTY: 1.0000
VARIANCE_QTY: 1.0000
CURRENCY_CODE: SAM
EXCHANGE_RATE: 1.0000000000
REC_UNIT_COST: 1.0000
IN_TRANSIT_QTY: 1.0000
ADJUSTMENT_DATE: 2026-01-01

default

ITEMRPK: Nwp-002-ALT
LOCATIONRPK: 3
FISCAL_YEARRPK: 3
WAC: 12.5000
ORDER_NO: Nwp-002-ALT
SHIPMENT: 3
ON_HAND_QTY: 12.5000
COST_ADJ_AMT: 12.5000
QTY_RECEIVED: 12.5000
RECEIVE_DATE: 2026-01-03
UNIT_ADJ_QTY: 12.5000
VARIANCE_QTY: 12.5000
CURRENCY_CODE: ALT
EXCHANGE_RATE: 12.5000000000
REC_UNIT_COST: 12.5000
IN_TRANSIT_QTY: 12.5000
ADJUSTMENT_DATE: 2026-01-03