Product-location-suppliers

In Scope

Technical: 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(5)

Rules & Considerations(12)

Validation

Referential Integrity

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	5789-ALT	DC001-ALT	S1400-ALT	1	1	13	EUR-ALT	False	51	2	M3-ALT	501	M3-ALT	KG-ALT	4	Coca Cola-ALT	11	True	20004567-ALT	6	2025-09-10	1001	2025-01-02	CG100001-ALT	BOX-ALT	Cold cuts-ALT	151	6	ALT-PRODUCT_LO-002
default	5789-EDGE	DC001-EDGE	S1400-EDGE	2	2	14	EUR-EDGE	True	52	3	M3-EDGE	502	M3-EDGE	KG-EDGE	5	Coca Cola-EDGE	12	False	—	7	2025-09-11	1002	2025-01-03	CG100001-EDGE	BOX-EDGE	Cold cuts-EDGE	152	7	EDGE-PRODUCT_LO-003

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

default

productRPK: 5789-ALT
locationRPK: DC001-ALT
supplierRPK: S1400-ALT
volume: 1
weight: 1
box_size: 13
currency: EUR-ALT
preferred: False
batch_size: 51
space_size: 2
space_unit: M3-ALT
pallet_size: 501
volume_unit: M3-ALT
weight_unit: KG-ALT
delivery_all: 4
manufacturer: Coca Cola-ALT
max_lot_size: 11
deletion_flag: True
erp_reference: 20004567-ALT
purchase_price: 6
availability_end: 2025-09-10
pallet_layer_size: 1001
availability_start: 2025-01-02
coordination_group: CG100001-ALT
purchase_batch_unit: BOX-ALT
supplier_subcategory: Cold cuts-ALT
minimum_delivery_batch: 151
standard_delivery_batch: 6
alternative_product_code: ALT-PRODUCT_LO-002

default

productRPK: 5789-EDGE
locationRPK: DC001-EDGE
supplierRPK: S1400-EDGE
volume: 2
weight: 2
box_size: 14
currency: EUR-EDGE
preferred: True
batch_size: 52
space_size: 3
space_unit: M3-EDGE
pallet_size: 502
volume_unit: M3-EDGE
weight_unit: KG-EDGE
delivery_all: 5
manufacturer: Coca Cola-EDGE
max_lot_size: 12
deletion_flag: False
erp_reference: —
purchase_price: 7
availability_end: 2025-09-11
pallet_layer_size: 1002
availability_start: 2025-01-03
coordination_group: CG100001-EDGE
purchase_batch_unit: BOX-EDGE
supplier_subcategory: Cold cuts-EDGE
minimum_delivery_batch: 152
standard_delivery_batch: 7
alternative_product_code: EDGE-PRODUCT_LO-003