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(26)
Rules & Considerations(7)
Row Count
Field Mapping
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
- 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