Purchase Order
In ScopeTechnical: PURCHASE_ORDER | ID: OR-STO-PURCHASE_ORDER-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
Classification
- Object Type
- dictionary
Target Structure
- Load Approach
- Table
- Target Objects
- PURCHASE_ORDER
Field Definitions(5)
Rules & Considerations(23)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | STATUSR | STORE_IDR | SOURCE | USER_ID | COMMENTS | IMPORTED | IMPORT_ID | CREATE_DATE | EXTERNAL_ID | SUPPLIER_ID | UPDATE_DATE | COMPLETE_DATE | CUST_ORDER_ID | NOT_AFTER_DATE | EXTERNAL_STATUS | NOT_BEFORE_DATE | FUL_ORD_EXTERNAL_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | S | SAMPLE | 2026-01-01 | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | SAMPLE | 2026-01-01 | 1 | 2026-01-01 | SAMPLE |
| default | 3 | 2 | 1000000003 | Purchase Order-002-ALT | ALT-PURCHASE_O-002 | Purchase Order-002-ALT | P | ALT-PURCHASE_O-002 | 2026-01-03 | ALT-PURCHASE_O-002 | 1000000003 | 2026-01-03 | 2026-01-03 | ALT-PURCHASE_O-002 | 2026-01-03 | 2 | 2026-01-03 | ALT-PURCHASE_O-002 |
| default | 5 | 3 | 1000000005 | Purchase Order-003-EDGE | EDGE-PURCHASE_O-003 | Purchase Order-003-EDGE | P | EDGE-PURCHASE_O-003 | 2026-01-05 | EDGE-PURCHASE_O-003 | 1000000005 | 2026-01-05 | 2026-01-05 | EDGE-PURCHASE_O-003 | 2026-01-05 | 3 | 2026-01-05 | EDGE-PURCHASE_O-003 |
Example values from field definitions
- IDRPK
- 1
- STATUSR
- 1
- STORE_IDR
- 1
- SOURCE
- SAMPLE
- USER_ID
- SAMPLE
- COMMENTS
- SAMPLE
- IMPORTED
- S
- IMPORT_ID
- SAMPLE
- CREATE_DATE
- 2026-01-01
- EXTERNAL_ID
- SAMPLE
- SUPPLIER_ID
- 1
- UPDATE_DATE
- 2026-01-01
- COMPLETE_DATE
- 2026-01-01
- CUST_ORDER_ID
- SAMPLE
- NOT_AFTER_DATE
- 2026-01-01
- EXTERNAL_STATUS
- 1
- NOT_BEFORE_DATE
- 2026-01-01
- FUL_ORD_EXTERNAL_ID
- SAMPLE
default
- IDRPK
- 3
- STATUSR
- 2
- STORE_IDR
- 1000000003
- SOURCE
- Purchase Order-002-ALT
- USER_ID
- ALT-PURCHASE_O-002
- COMMENTS
- Purchase Order-002-ALT
- IMPORTED
- P
- IMPORT_ID
- ALT-PURCHASE_O-002
- CREATE_DATE
- 2026-01-03
- EXTERNAL_ID
- ALT-PURCHASE_O-002
- SUPPLIER_ID
- 1000000003
- UPDATE_DATE
- 2026-01-03
- COMPLETE_DATE
- 2026-01-03
- CUST_ORDER_ID
- ALT-PURCHASE_O-002
- NOT_AFTER_DATE
- 2026-01-03
- EXTERNAL_STATUS
- 2
- NOT_BEFORE_DATE
- 2026-01-03
- FUL_ORD_EXTERNAL_ID
- ALT-PURCHASE_O-002
default
- IDRPK
- 5
- STATUSR
- 3
- STORE_IDR
- 1000000005
- SOURCE
- Purchase Order-003-EDGE
- USER_ID
- EDGE-PURCHASE_O-003
- COMMENTS
- Purchase Order-003-EDGE
- IMPORTED
- P
- IMPORT_ID
- EDGE-PURCHASE_O-003
- CREATE_DATE
- 2026-01-05
- EXTERNAL_ID
- EDGE-PURCHASE_O-003
- SUPPLIER_ID
- 1000000005
- UPDATE_DATE
- 2026-01-05
- COMPLETE_DATE
- 2026-01-05
- CUST_ORDER_ID
- EDGE-PURCHASE_O-003
- NOT_AFTER_DATE
- 2026-01-05
- EXTERNAL_STATUS
- 3
- NOT_BEFORE_DATE
- 2026-01-05
- FUL_ORD_EXTERNAL_ID
- EDGE-PURCHASE_O-003
Rule Validation Summary
- Source Rule Count
- 36
- Governed Rule Count
- 23