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(18)
Rules & Considerations(22)
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | S | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE | 2026-01-01 | 2026-01-01 | SAMPLE |
Example values from field definitions
- IDRPK
- 1
- SOURCER
- SAMPLE
- STATUSR
- 1
- IMPORTEDR
- S
- STORE_IDRPK
- 1
- SUPPLIER_IDR
- 1
- EXTERNAL_STATUSR
- 1
- USER_ID
- SAMPLE
- COMMENTS
- SAMPLE
- IMPORT_ID
- SAMPLE
- CREATE_DATE
- 2026-01-01
- EXTERNAL_ID
- SAMPLE
- UPDATE_DATE
- 2026-01-01
- COMPLETE_DATE
- 2026-01-01
- CUST_ORDER_ID
- SAMPLE
- NOT_AFTER_DATE
- 2026-01-01
- NOT_BEFORE_DATE
- 2026-01-01
- FUL_ORD_EXTERNAL_ID
- SAMPLE
Rule Validation Summary
- Source Rule Count
- 35
- Governed Rule Count
- 22