Allocation Session Size Profile
In ScopeTechnical: ALC_SESSION_SIZE_PROFILE | ID: OR-ALLOC-ALC_SESSION_SIZE_PROFILE-ACTUAL_LANDED_COST_SESSION_SIZE_PROFILE
This temporary table, holds the list of size profiles (child rows of gid headers) derived from the user search criteria.
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_SESSION_SIZE_PROFILE
Field Definitions(5)
Rules & Considerations(28)
Sample Load Data(4)
| _scenario | SEQ_IDR | SESSION_IDRPK | RESULT_TYPER | SIZE_PROFILE_IDR | QTY | DEPT | CLASS | STORE | STYLE | SUBCLASS | STYLEDESC | CHILD_DIFF1 | CHILD_DIFF2 | CHILD_DIFF3 | CHILD_DIFF4 | DISPLAY_SEQ | SIZE_PROFILE | DIFF_GROUP_ID1 | DIFF_GROUP_ID2 | DIFF_GROUP_ID3 | DIFF_GROUP_ID4 | GID_PROFILE_ID | NEW_SIZE_PROFILE_ID |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | 1 | 1 | 1.0000 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 1 | 1 |
| default | 100003 | ALT-ALC_SESSIO-002 | 3 | 1000000003 | 12.5000 | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile- | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | 3 | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | Alc Session Size Profile-002-ALT | 1000000003 | 1000000003 |
| default | 100005 | EDGE-ALC_SESSIO-003 | 5 | 1000000005 | 14.0000 | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile- | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | 5 | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | Alc Session Size Profile-003-EDGE | 1000000005 | 1000000005 |
Example values from field definitions
- SEQ_IDR
- 1
- SESSION_IDRPK
- SAMPLE
- RESULT_TYPER
- 1
- SIZE_PROFILE_IDR
- 1
- QTY
- 1.0000
- DEPT
- SAMPLE
- CLASS
- SAMPLE
- STORE
- SAMPLE
- STYLE
- SAMPLE
- SUBCLASS
- SAMPLE
- STYLEDESC
- SAMPLE
- CHILD_DIFF1
- SAMPLE
- CHILD_DIFF2
- SAMPLE
- CHILD_DIFF3
- SAMPLE
- CHILD_DIFF4
- SAMPLE
- DISPLAY_SEQ
- 1
- SIZE_PROFILE
- SAMPLE
- DIFF_GROUP_ID1
- SAMPLE
- DIFF_GROUP_ID2
- SAMPLE
- DIFF_GROUP_ID3
- SAMPLE
- DIFF_GROUP_ID4
- SAMPLE
- GID_PROFILE_ID
- 1
- NEW_SIZE_PROFILE_ID
- 1
default
- SEQ_IDR
- 100003
- SESSION_IDRPK
- ALT-ALC_SESSIO-002
- RESULT_TYPER
- 3
- SIZE_PROFILE_IDR
- 1000000003
- QTY
- 12.5000
- DEPT
- Alc Session Size Profile-002-ALT
- CLASS
- Alc Session Size Profile-002-ALT
- STORE
- Alc Session Size Profile-002-ALT
- STYLE
- Alc Session Size Profile-
- SUBCLASS
- Alc Session Size Profile-002-ALT
- STYLEDESC
- Alc Session Size Profile-002-ALT
- CHILD_DIFF1
- Alc Session Size Profile-002-ALT
- CHILD_DIFF2
- Alc Session Size Profile-002-ALT
- CHILD_DIFF3
- Alc Session Size Profile-002-ALT
- CHILD_DIFF4
- Alc Session Size Profile-002-ALT
- DISPLAY_SEQ
- 3
- SIZE_PROFILE
- Alc Session Size Profile-002-ALT
- DIFF_GROUP_ID1
- Alc Session Size Profile-002-ALT
- DIFF_GROUP_ID2
- Alc Session Size Profile-002-ALT
- DIFF_GROUP_ID3
- Alc Session Size Profile-002-ALT
- DIFF_GROUP_ID4
- Alc Session Size Profile-002-ALT
- GID_PROFILE_ID
- 1000000003
- NEW_SIZE_PROFILE_ID
- 1000000003
default
- SEQ_IDR
- 100005
- SESSION_IDRPK
- EDGE-ALC_SESSIO-003
- RESULT_TYPER
- 5
- SIZE_PROFILE_IDR
- 1000000005
- QTY
- 14.0000
- DEPT
- Alc Session Size Profile-003-EDGE
- CLASS
- Alc Session Size Profile-003-EDGE
- STORE
- Alc Session Size Profile-003-EDGE
- STYLE
- Alc Session Size Profile-
- SUBCLASS
- Alc Session Size Profile-003-EDGE
- STYLEDESC
- Alc Session Size Profile-003-EDGE
- CHILD_DIFF1
- Alc Session Size Profile-003-EDGE
- CHILD_DIFF2
- Alc Session Size Profile-003-EDGE
- CHILD_DIFF3
- Alc Session Size Profile-003-EDGE
- CHILD_DIFF4
- Alc Session Size Profile-003-EDGE
- DISPLAY_SEQ
- 5
- SIZE_PROFILE
- Alc Session Size Profile-003-EDGE
- DIFF_GROUP_ID1
- Alc Session Size Profile-003-EDGE
- DIFF_GROUP_ID2
- Alc Session Size Profile-003-EDGE
- DIFF_GROUP_ID3
- Alc Session Size Profile-003-EDGE
- DIFF_GROUP_ID4
- Alc Session Size Profile-003-EDGE
- GID_PROFILE_ID
- 1000000005
- NEW_SIZE_PROFILE_ID
- 1000000005
Rule Validation Summary
- Source Rule Count
- 44
- Governed Rule Count
- 28