Allocation Location
In ScopeTechnical: ALC_LOCATION | ID: OR-ALLOC-ALC_LOCATION-ALLOCATION_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(15)
Rules & Considerations(19)
validation
constraint
Sample Load Data(4)
| _scenario | GROUP_IDR | LOCATION_IDR | LOC_GROUP_IDRPK | LOCATION_TYPER | ALC_LOCATION_IDRPK | CREATED_BY | STORE_TYPE | SUBGROUP_ID | CREATION_DATE | IN_STORE_DATE | LOCATION_DESC | 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 | S | 1 | SAMPLE | S | SAMPLE | 2026-01-01 12:00:00.000000 | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 12:00:00.000000 | 1 | SAMPLE |
Example values from field definitions
- GROUP_IDR
- SAMPLE
- LOCATION_IDR
- SAMPLE
- LOC_GROUP_IDRPK
- 1
- LOCATION_TYPER
- S
- 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
- 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
Rule Validation Summary
- Source Rule Count
- 33
- Governed Rule Count
- 19