Purchase Order
In ScopeTechnical: PURCHASE_ORDER | ID: OR-SIOCS-PURCHASE_ORDER
Stores one row for each purchase order per location that has been placed by the company.the purchase order may have been created via a merchandise system message or when a…
See how this object fits into Store Operations
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
- PURCHASE_ORDER
Field Definitions(18)
Rules & Considerations(50)
Sample Load Data(4)
| _scenario | IDRPK | SOURCER | STATUSR | IMPORTEDR | STORE_IDRPK | SUPPLIER_IDR | EXTERNAL_STATUSR | USER_ID | COMMENTS | IMPORT_ID | CREATE_DATE | EXTERNAL_ID | UPDATE_DATE | COMPLETE_DATE | CUST_ORDER_ID | NOT_AFTER_DATE | NOT_BEFORE_DATE | FUL_ORD_EXTERNAL_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1 | Purchase Order-001 | 1 | Purchase Order-001 | 1000000001 | 1000000001 | 1 | STD-PURCHASE_O-001 | Purchase Order-001 | STD-PURCHASE_O-001 | 2026-01-01 | STD-PURCHASE_O-001 | 2026-01-01 | 2026-01-01 | STD-PURCHASE_O-001 | 2026-01-01 | 2026-01-01 | STD-PURCHASE_O-001 |
default
- IDRPK
- 1
- SOURCER
- Purchase Order-001
- STATUSR
- 1
- IMPORTEDR
- Purchase Order-001
- STORE_IDRPK
- 1000000001
- SUPPLIER_IDR
- 1000000001
- EXTERNAL_STATUSR
- 1
- USER_ID
- STD-PURCHASE_O-001
- COMMENTS
- Purchase Order-001
- IMPORT_ID
- STD-PURCHASE_O-001
- CREATE_DATE
- 2026-01-01
- EXTERNAL_ID
- STD-PURCHASE_O-001
- UPDATE_DATE
- 2026-01-01
- COMPLETE_DATE
- 2026-01-01
- CUST_ORDER_ID
- STD-PURCHASE_O-001
- NOT_AFTER_DATE
- 2026-01-01
- NOT_BEFORE_DATE
- 2026-01-01
- FUL_ORD_EXTERNAL_ID
- STD-PURCHASE_O-001