Store Order Requests
In ScopeTechnical: STORE_ORDERS | ID: OR-REPL-STORE_ORDERS-STORE_ORDERS
This table is used to hold store order requests. These store order requests will be used during the replenishment process to determine what the recommended order quantity should be, depending...
See how this object fits into Replenishment
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
- STORE_ORDERS
Field Definitions(5)
Rules & Considerations(21)
validation
constraint
Sample Load Data(4)
| _scenario | ITEMRPK | STORER | NEED_QTYR | NEED_DATER | WF_ORDER_NO | PROCESSED_DATE | DELIVERY_SLOT_ID | WF_ORDER_LINE_NO | ROQ_EXTRACTED_IND |
|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | 1 | 1.0000 | 2026-01-01 | 1 | 2026-01-01 | SAMPLE | 1 | S |
| Closed historical record with successor reference | ITEM-20001 | 2 | 200.0000 | 2023-11-15 | 1002 | 2023-11-16 | SLOT-002 | 1 | Y |
| New record with minimal optional data | ITEM-30001 | 3 | 50.0000 | 2023-09-01 | 1003 | — | SLOT-003 | — | N |
Example values from field definitions
- ITEMRPK
- SAMPLE
- STORER
- 1
- NEED_QTYR
- 1.0000
- NEED_DATER
- 2026-01-01
- WF_ORDER_NO
- 1
- PROCESSED_DATE
- 2026-01-01
- DELIVERY_SLOT_ID
- SAMPLE
- WF_ORDER_LINE_NO
- 1
- ROQ_EXTRACTED_IND
- S
Closed historical record with successor reference
- ITEMRPK
- ITEM-20001
- STORER
- 2
- NEED_QTYR
- 200.0000
- NEED_DATER
- 2023-11-15
- WF_ORDER_NO
- 1002
- PROCESSED_DATE
- 2023-11-16
- DELIVERY_SLOT_ID
- SLOT-002
- WF_ORDER_LINE_NO
- 1
- ROQ_EXTRACTED_IND
- Y
New record with minimal optional data
- ITEMRPK
- ITEM-30001
- STORER
- 3
- NEED_QTYR
- 50.0000
- NEED_DATER
- 2023-09-01
- WF_ORDER_NO
- 1003
- PROCESSED_DATE
- —
- DELIVERY_SLOT_ID
- SLOT-003
- WF_ORDER_LINE_NO
- —
- ROQ_EXTRACTED_IND
- N
Rule Validation Summary
- Source Rule Count
- 43
- Governed Rule Count
- 21