Allocation Location

In Scope

Technical: ALC_LOCATION | ID: OR-ALLOC-ALC_LOCATION-ACTUAL_LANDED_COST_LOCATION

Stores all of the locations that are present on each allocation. each location will appear on this table a unique allocation/location combination no matter how the location was added to...

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_LOCATION

Field Definitions(5)

Rules & Considerations(20)

validation

constraint

Sample Load Data(4)

_scenario	GROUP_IDR	LOCATION_IDR	LOC_GROUP_IDR	ALC_LOCATION_IDRPK	CREATED_BY	STORE_TYPE	SUBGROUP_ID	CREATION_DATE	IN_STORE_DATE	LOCATION_DESC	LOCATION_TYPE	LAST_UPDATED_BY	LAST_UPDATED_DATE	OBJECT_VERSION_NUMBER	CREATION_DATENTIMESTAMP(6)1110LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY
Example values from field definitions	SAMPLE	SAMPLE	1	1	SAMPLE	S	SAMPLE	2026-01-01 12:00:00.000000	2026-01-01	SAMPLE	S	SAMPLE	2026-01-01 12:00:00.000000	1	SAMPLE
default	ALT-ALC_LOCATI-002	ALT-ALC_LOCATI-002	1000000003	1000000003	Alc Location-002-ALT	A	ALT-ALC_LOCATI-002	—	2026-01-03	Alc Location-002-ALT	A	—	—	3	2026-01-02-ALT
default	EDGE-ALC_LOCATI-003	EDGE-ALC_LOCATI-003	1000000005	1000000005	Alc Location-003-EDGE	A	EDGE-ALC_LOCATI-003	—	2026-01-05	Alc Location-003-EDGE	A	—	—	5	2026-01-03-EDGE

Example values from field definitions

GROUP_IDR: SAMPLE
LOCATION_IDR: SAMPLE
LOC_GROUP_IDR: 1
ALC_LOCATION_IDRPK: 1
CREATED_BY: SAMPLE
STORE_TYPE: S
SUBGROUP_ID: SAMPLE
CREATION_DATE: 2026-01-01 12:00:00.000000
IN_STORE_DATE: 2026-01-01
LOCATION_DESC: SAMPLE
LOCATION_TYPE: S
LAST_UPDATED_BY: SAMPLE
LAST_UPDATED_DATE: 2026-01-01 12:00:00.000000
OBJECT_VERSION_NUMBER: 1
CREATION_DATENTIMESTAMP(6)1110LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY: SAMPLE

default

GROUP_IDR: ALT-ALC_LOCATI-002
LOCATION_IDR: ALT-ALC_LOCATI-002
LOC_GROUP_IDR: 1000000003
ALC_LOCATION_IDRPK: 1000000003
CREATED_BY: Alc Location-002-ALT
STORE_TYPE: A
SUBGROUP_ID: ALT-ALC_LOCATI-002
CREATION_DATE: —
IN_STORE_DATE: 2026-01-03
LOCATION_DESC: Alc Location-002-ALT
LOCATION_TYPE: A
LAST_UPDATED_BY: —
LAST_UPDATED_DATE: —
OBJECT_VERSION_NUMBER: 3
CREATION_DATENTIMESTAMP(6)1110LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY: 2026-01-02-ALT