Nwp
In ScopeTechnical: NWP | ID: OR-MFCS-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
Target Structure
- Load Approach
- Table
- Target Objects
- NWP
Field Definitions(17)
Rules & Considerations(14)
Sample Load Data(4)
| _scenario | ITEMRPK | LOCATIONR | FISCAL_YEARR | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | Nwp-001 | 1 | 0001 | 11.0000 | Nwp-001 | 1 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 | 11.0000 | 11.0000 | STD-NWP-001 | 11.0000 | 11.0000 | 11.0000 | 2026-01-01 |
default
- ITEMRPK
- Nwp-001
- LOCATIONR
- 1
- FISCAL_YEARR
- 0001
- WAC
- 11.0000
- ORDER_NO
- Nwp-001
- SHIPMENT
- 1
- ON_HAND_QTY
- 11.0000
- COST_ADJ_AMT
- 11.0000
- QTY_RECEIVED
- 11.0000
- RECEIVE_DATE
- 2026-01-01
- UNIT_ADJ_QTY
- 11.0000
- VARIANCE_QTY
- 11.0000
- CURRENCY_CODE
- STD-NWP-001
- EXCHANGE_RATE
- 11.0000
- REC_UNIT_COST
- 11.0000
- IN_TRANSIT_QTY
- 11.0000
- ADJUSTMENT_DATE
- 2026-01-01