Locations In Each Location Group
In ScopeTechnical: ALC_LOC_GROUP_DETAIL | ID: OR-ALLOC-ALC_LOC_GROUP_DETAIL-ACTUAL_LANDED_COST_LOCATION_GROUP_DETAIL
Stores the locations in each location group.
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_LOC_GROUP_DETAIL
Field Definitions(5)
Rules & Considerations(17)
constraint
validation
Sample Load Data(4)
| _scenario | GROUP_TYPER | LOC_GROUP_IDR | LOC_GROUP_DETAIL_IDRPK | GROUP_ID | CREATED_BY | GROUP_DESC | SUBGROUP_ID | CREATION_DATE | SUBGROUP_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 | SA | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 12:00:00.000000 | SAMPLE | SAMPLE | 2026-01-01 12:00:00.000000 | 1 | SAMPLE |
| default | Al | 1000000003 | 1000000003 | ALT-ALC_LOC-002 | Alc Loc Group Detail-002-ALT | Alc Loc Group Detail-002-ALT | ALT-ALC_LOC-002 | — | Alc Loc Group Detail-002-ALT | — | — | 3 | 2026-01-02-ALT |
| default | Al | 1000000005 | 1000000005 | EDGE-ALC_LOC-003 | Alc Loc Group Detail-003-EDGE | Alc Loc Group Detail-003-EDGE | EDGE-ALC_LOC-003 | — | Alc Loc Group Detail-003-EDGE | — | — | 5 | 2026-01-03-EDGE |
Example values from field definitions
- GROUP_TYPER
- SA
- LOC_GROUP_IDR
- 1
- LOC_GROUP_DETAIL_IDRPK
- 1
- GROUP_ID
- SAMPLE
- CREATED_BY
- SAMPLE
- GROUP_DESC
- SAMPLE
- SUBGROUP_ID
- SAMPLE
- CREATION_DATE
- 2026-01-01 12:00:00.000000
- SUBGROUP_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
default
- GROUP_TYPER
- Al
- LOC_GROUP_IDR
- 1000000003
- LOC_GROUP_DETAIL_IDRPK
- 1000000003
- GROUP_ID
- ALT-ALC_LOC-002
- CREATED_BY
- Alc Loc Group Detail-002-ALT
- GROUP_DESC
- Alc Loc Group Detail-002-ALT
- SUBGROUP_ID
- ALT-ALC_LOC-002
- CREATION_DATE
- —
- SUBGROUP_DESC
- Alc Loc Group Detail-002-ALT
- LAST_UPDATED_BY
- —
- LAST_UPDATED_DATE
- —
- OBJECT_VERSION_NUMBER
- 3
- CREATION_DATENTIMESTAMP(6)1110LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY
- 2026-01-02-ALT
default
- GROUP_TYPER
- Al
- LOC_GROUP_IDR
- 1000000005
- LOC_GROUP_DETAIL_IDRPK
- 1000000005
- GROUP_ID
- EDGE-ALC_LOC-003
- CREATED_BY
- Alc Loc Group Detail-003-EDGE
- GROUP_DESC
- Alc Loc Group Detail-003-EDGE
- SUBGROUP_ID
- EDGE-ALC_LOC-003
- CREATION_DATE
- —
- SUBGROUP_DESC
- Alc Loc Group Detail-003-EDGE
- LAST_UPDATED_BY
- —
- LAST_UPDATED_DATE
- —
- OBJECT_VERSION_NUMBER
- 5
- CREATION_DATENTIMESTAMP(6)1110LAST_UPDATED_DATENTIMESTAMP(6)1111LAST_UPDATED_BY
- 2026-01-03-EDGE
Rule Validation Summary
- Source Rule Count
- 27
- Governed Rule Count
- 17