Purchase Order Line Item
In ScopeTechnical: PURCHASE_ORDER_LINE_ITEM | ID: OR-STO-PURCHASE_ORDER_LINE_ITEM-PURCHASE_ORDER_LINE_ITEM
Stores one line for each unique item that is included on a purchase order.
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_LINE_ITEM
Field Definitions(5)
Rules & Considerations(18)
constraint
validation
Sample Load Data(4)
| _scenario | IDRPK | ITEM_IDR | PURCHASE_ORDER_IDRPK | SUPPLIER_COUNTRY_IDR | CASE_SIZE | PUBLISHED | PREFERRED_UOM | UNIT_COST_VALUE | QUANTITY_EXPECTED | QUANTITY_RECEIVED | UNIT_COST_CURRENCY |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | SAM | 1.00 | S | SAMP | 1.0000 | 1.0000 | 1.0000 | SAM |
| default | 3 | ALT-PURCHASE_O-002 | 1000000003 | ALT | 12.50 | N | Purc | 12.5000 | 12.5000 | 12.5000 | Pur |
| default | 5 | EDGE-PURCHASE_O-003 | 1000000005 | EDG | 14.00 | N | Purc | 14.0000 | 14.0000 | 14.0000 | Pur |
Example values from field definitions
- IDRPK
- 1
- ITEM_IDR
- SAMPLE
- PURCHASE_ORDER_IDRPK
- 1
- SUPPLIER_COUNTRY_IDR
- SAM
- CASE_SIZE
- 1.00
- PUBLISHED
- S
- PREFERRED_UOM
- SAMP
- UNIT_COST_VALUE
- 1.0000
- QUANTITY_EXPECTED
- 1.0000
- QUANTITY_RECEIVED
- 1.0000
- UNIT_COST_CURRENCY
- SAM
default
- IDRPK
- 3
- ITEM_IDR
- ALT-PURCHASE_O-002
- PURCHASE_ORDER_IDRPK
- 1000000003
- SUPPLIER_COUNTRY_IDR
- ALT
- CASE_SIZE
- 12.50
- PUBLISHED
- N
- PREFERRED_UOM
- Purc
- UNIT_COST_VALUE
- 12.5000
- QUANTITY_EXPECTED
- 12.5000
- QUANTITY_RECEIVED
- 12.5000
- UNIT_COST_CURRENCY
- Pur
default
- IDRPK
- 5
- ITEM_IDR
- EDGE-PURCHASE_O-003
- PURCHASE_ORDER_IDRPK
- 1000000005
- SUPPLIER_COUNTRY_IDR
- EDG
- CASE_SIZE
- 14.00
- PUBLISHED
- N
- PREFERRED_UOM
- Purc
- UNIT_COST_VALUE
- 14.0000
- QUANTITY_EXPECTED
- 14.0000
- QUANTITY_RECEIVED
- 14.0000
- UNIT_COST_CURRENCY
- Pur
Rule Validation Summary
- Source Rule Count
- 27
- Governed Rule Count
- 18