Product-locations
In ScopeTechnical: product_locations | ID: RELEX-RA-PRODUCT_LOCATIONS
Automated maintenance of product-location master data.
See how this object fits into Products
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 1 - Foundation Data
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- product_locations
Field Definitions(5)
Rules & Considerations(7)
Row Count
Field Mapping
Data Accuracy
Referential Integrity
Sample Load Data(4)
| _scenario | productRPK | locationRPK | supplierR | purchase_priceR | box_size | book_value | pallet_size | sales_price | shelf_space | max_lot_size | order_quantity | reference_code | sales_tax_rate | shelving_delay | termination_date | ugly_shelf_point | assortment_status | introduction_date | production_lead_time | minimum_delivery_batch | legal_for_merchandising | reference_location_code | reference_spoiling_time | illegal_for_merchandising | required_remaining_shelf_life | inventory_unit_in_consumer_units |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 57896 | 550 | S110 | 1 | 12 | 01:02:00 | 500 | 2 | 30 | 10 | 10 | STD-PRODUCT_LO-001 | 0 | 2 | 2022-10-01 | 20 | Live assortment | 2020-10-01 | 7 | 5 | False | STD-PRODUCT_LO-001 | 7 | False | 10 | 10 |
| default | 57896-ALT | 550-ALT | S110-ALT | 2 | 13 | 01:02:00-ALT | 501 | 3 | 31 | 11 | 11 | ALT-PRODUCT_LO-002 | 1 | 3 | 2022-10-02 | 21 | Live assortment-ALT | 2020-10-02 | 8 | 6 | True | ALT-PRODUCT_LO-002 | 8 | True | 11 | 11 |
| default | 57896-EDGE | 550-EDGE | S110-EDGE | 3 | 14 | 01:02:00-EDGE | 502 | 4 | 32 | 12 | 12 | — | 2 | 4 | 2022-10-03 | 22 | Live assortment-EDGE | 2020-10-03 | 9 | 7 | False | — | — | False | 12 | 12 |
default
- productRPK
- 57896
- locationRPK
- 550
- supplierR
- S110
- purchase_priceR
- 1
- box_size
- 12
- book_value
- 01:02:00
- pallet_size
- 500
- sales_price
- 2
- shelf_space
- 30
- max_lot_size
- 10
- order_quantity
- 10
- reference_code
- STD-PRODUCT_LO-001
- sales_tax_rate
- 0
- shelving_delay
- 2
- termination_date
- 2022-10-01
- ugly_shelf_point
- 20
- assortment_status
- Live assortment
- introduction_date
- 2020-10-01
- production_lead_time
- 7
- minimum_delivery_batch
- 5
- legal_for_merchandising
- False
- reference_location_code
- STD-PRODUCT_LO-001
- reference_spoiling_time
- 7
- illegal_for_merchandising
- False
- required_remaining_shelf_life
- 10
- inventory_unit_in_consumer_units
- 10
default
- productRPK
- 57896-ALT
- locationRPK
- 550-ALT
- supplierR
- S110-ALT
- purchase_priceR
- 2
- box_size
- 13
- book_value
- 01:02:00-ALT
- pallet_size
- 501
- sales_price
- 3
- shelf_space
- 31
- max_lot_size
- 11
- order_quantity
- 11
- reference_code
- ALT-PRODUCT_LO-002
- sales_tax_rate
- 1
- shelving_delay
- 3
- termination_date
- 2022-10-02
- ugly_shelf_point
- 21
- assortment_status
- Live assortment-ALT
- introduction_date
- 2020-10-02
- production_lead_time
- 8
- minimum_delivery_batch
- 6
- legal_for_merchandising
- True
- reference_location_code
- ALT-PRODUCT_LO-002
- reference_spoiling_time
- 8
- illegal_for_merchandising
- True
- required_remaining_shelf_life
- 11
- inventory_unit_in_consumer_units
- 11
default
- productRPK
- 57896-EDGE
- locationRPK
- 550-EDGE
- supplierR
- S110-EDGE
- purchase_priceR
- 3
- box_size
- 14
- book_value
- 01:02:00-EDGE
- pallet_size
- 502
- sales_price
- 4
- shelf_space
- 32
- max_lot_size
- 12
- order_quantity
- 12
- reference_code
- —
- sales_tax_rate
- 2
- shelving_delay
- 4
- termination_date
- 2022-10-03
- ugly_shelf_point
- 22
- assortment_status
- Live assortment-EDGE
- introduction_date
- 2020-10-03
- production_lead_time
- 9
- minimum_delivery_batch
- 7
- legal_for_merchandising
- False
- reference_location_code
- —
- reference_spoiling_time
- —
- illegal_for_merchandising
- False
- required_remaining_shelf_life
- 12
- inventory_unit_in_consumer_units
- 12