Nwp
In ScopeTechnical: 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(17)
Rules & Considerations(19)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Example values from field definitions
- ITEMRPK
- SAMPLE
- LOCATIONR
- 1
- FISCAL_YEARR
- 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
Rule Validation Summary
- Source Rule Count
- 25
- Governed Rule Count
- 19