Allocation Oi PO Arrival Details
In ScopeTechnical: ALC_OI_PO_ARRIVAL_DETAILS | ID: OR-ALLOC-ALC_OI_PO_ARRIVAL_DETAILS-ACTUAL_LANDED_COST_OI_PO_ARRIVAL_DETAILS
This table will contain the incoming POs and the order quantities that are expected to be received based on their delivery date.
See how this object fits into Allocations
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
- ALC_OI_PO_ARRIVAL_DETAILS
Field Definitions(5)
Rules & Considerations(14)
constraint
validation
Sample Load Data(4)
| _scenario | WEEK_NOR | ORDER_NOR | SESSION_IDRPK | ALLOC_ID | PROMO_IND | WH_ORDER_QTY | ALLOCATED_QTY | ALLOC_PERCENT | SUPPLIER_SITE | NEXT_SHIP_DATE | NOT_AFTER_DATE | NOT_BEFORE_DATE | SUPPLIER_SITE_NAME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 1 | 1 | S | 1.0000 | 1.0000 | 1.0000000000 | 1 | 2026-01-01 | 2026-01-01 | 2026-01-01 | SAMPLE |
| default | 0 | 4 | 1000000003 | 1000000003 | A | 12.5000 | 12.5000 | 12.5000000000 | 3 | 2026-01-03 | 2026-01-03 | 2026-01-03 | Alc Oi PO Arrival Details Secondary |
| default | 0 | 6 | 1000000005 | 1000000005 | A | 14.0000 | 14.0000 | 14.0000000000 | 5 | 2026-01-05 | 2026-01-05 | 2026-01-05 | Alc Oi PO Arrival Details Core |
Example values from field definitions
- WEEK_NOR
- 1
- ORDER_NOR
- 1
- SESSION_IDRPK
- 1
- ALLOC_ID
- 1
- PROMO_IND
- S
- WH_ORDER_QTY
- 1.0000
- ALLOCATED_QTY
- 1.0000
- ALLOC_PERCENT
- 1.0000000000
- SUPPLIER_SITE
- 1
- NEXT_SHIP_DATE
- 2026-01-01
- NOT_AFTER_DATE
- 2026-01-01
- NOT_BEFORE_DATE
- 2026-01-01
- SUPPLIER_SITE_NAME
- SAMPLE
default
- WEEK_NOR
- 0
- ORDER_NOR
- 4
- SESSION_IDRPK
- 1000000003
- ALLOC_ID
- 1000000003
- PROMO_IND
- A
- WH_ORDER_QTY
- 12.5000
- ALLOCATED_QTY
- 12.5000
- ALLOC_PERCENT
- 12.5000000000
- SUPPLIER_SITE
- 3
- NEXT_SHIP_DATE
- 2026-01-03
- NOT_AFTER_DATE
- 2026-01-03
- NOT_BEFORE_DATE
- 2026-01-03
- SUPPLIER_SITE_NAME
- Alc Oi PO Arrival Details Secondary
default
- WEEK_NOR
- 0
- ORDER_NOR
- 6
- SESSION_IDRPK
- 1000000005
- ALLOC_ID
- 1000000005
- PROMO_IND
- A
- WH_ORDER_QTY
- 14.0000
- ALLOCATED_QTY
- 14.0000
- ALLOC_PERCENT
- 14.0000000000
- SUPPLIER_SITE
- 5
- NEXT_SHIP_DATE
- 2026-01-05
- NOT_AFTER_DATE
- 2026-01-05
- NOT_BEFORE_DATE
- 2026-01-05
- SUPPLIER_SITE_NAME
- Alc Oi PO Arrival Details Core
Rule Validation Summary
- Source Rule Count
- 22
- Governed Rule Count
- 14