Product-location-suppliers
In ScopeTechnical: product_location_suppliers | ID: RELEX-RA-PRODUCT_LOCATION_SUPPLIERS
To have multiple suppliers per product-location.
See how this object fits into Suppliers
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_location_suppliers
Field Definitions(29)
Rules & Considerations(12)
Sample Load Data(4)
| _scenario | productRPK | locationRPK | supplierRPK | volume | weight | box_size | currency | preferred | batch_size | space_size | space_unit | pallet_size | volume_unit | weight_unit | delivery_all | manufacturer | max_lot_size | deletion_flag | erp_reference | purchase_price | availability_end | pallet_layer_size | availability_start | coordination_group | purchase_batch_unit | supplier_subcategory | minimum_delivery_batch | standard_delivery_batch | alternative_product_code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 5789 | DC001 | S1400 | 0 | 0 | 12 | EUR | True | 50 | 1 | M3 | 500 | M3 | KG | 3 | Coca Cola | 10 | False | 20004567 | 5 | 2025-09-09 | 1000 | 2025-01-01 | CG100001 | BOX | Cold cuts | 150 | 5 | STD-PRODUCT_LO-001 |
default
- productRPK
- 5789
- locationRPK
- DC001
- supplierRPK
- S1400
- volume
- 0
- weight
- 0
- box_size
- 12
- currency
- EUR
- preferred
- True
- batch_size
- 50
- space_size
- 1
- space_unit
- M3
- pallet_size
- 500
- volume_unit
- M3
- weight_unit
- KG
- delivery_all
- 3
- manufacturer
- Coca Cola
- max_lot_size
- 10
- deletion_flag
- False
- erp_reference
- 20004567
- purchase_price
- 5
- availability_end
- 2025-09-09
- pallet_layer_size
- 1000
- availability_start
- 2025-01-01
- coordination_group
- CG100001
- purchase_batch_unit
- BOX
- supplier_subcategory
- Cold cuts
- minimum_delivery_batch
- 150
- standard_delivery_batch
- 5
- alternative_product_code
- STD-PRODUCT_LO-001