Allocation Rule Many To One
In ScopeTechnical: ALC_RULE_MANY_TO_ONE | ID: OR-ALLOC-ALC_RULE_MANY_TO_ONE-ACTUAL_LANDED_COST_RULE_MANY_TO_ONE
Stores the data used to determine the need of an allocation when a user has defined specific points of data relevant to this allocation. this data can only use a...
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_RULE_MANY_TO_ONE
Field Definitions(5)
Rules & Considerations(25)
constraint
validation
Sample Load Data(4)
| _scenario | MANY_TO_ONE_IDRPK | DEPT | TYPE | CLASS | UDA_ID | ITEM_ID | RULE_ID | ALLOC_ID | DIFF1_ID | SUBCLASS | WEIGHT_PCT | ITEMLIST_ID | TEMPLATE_ID | UDA_VALUE_ID | ALT_HIER_RULE_LEVEL | END_DATE_PERIOD_ONE | END_DATE_PERIOD_TWO | START_DATE_PERIOD_ONE | START_DATE_PERIOD_TWO | WK_FROM_TODAY_LAST_YR | WK_FROM_TODAY_THIS_YR |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | SAMPLE | SA | SAMPLE | SAMPLE | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | 1.0000 | SAMPLE | 1 | SAMPLE | 1 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 1 | 1 |
| default | 1000000003 | Alc Rule Many To One-002-ALT | Al | Alc Rule Many To One-002-ALT | ALT-ALC_RULE-002 | ALT-ALC_RULE-002 | 1000000003 | 1000000003 | ALT-ALC_RULE-002 | Alc Rule Many To One-002-ALT | 12.5000 | ALT-ALC_RULE-002 | 1000000003 | ALT-ALC_RULE-002 | 3 | 2026-01-03 | 2026-01-03 | 2026-01-03 | 2026-01-03 | 3 | 3 |
| default | 1000000005 | Alc Rule Many To One-003-EDGE | Al | Alc Rule Many To One-003-EDGE | EDGE-ALC_RULE-003 | EDGE-ALC_RULE-003 | 1000000005 | 1000000005 | EDGE-ALC_RULE-003 | Alc Rule Many To One-003-EDGE | 14.0000 | EDGE-ALC_RULE-003 | 1000000005 | EDGE-ALC_RULE-003 | 5 | 2026-01-05 | 2026-01-05 | 2026-01-05 | 2026-01-05 | 5 | 5 |
Example values from field definitions
- MANY_TO_ONE_IDRPK
- 1
- DEPT
- SAMPLE
- TYPE
- SA
- CLASS
- SAMPLE
- UDA_ID
- SAMPLE
- ITEM_ID
- SAMPLE
- RULE_ID
- 1
- ALLOC_ID
- 1
- DIFF1_ID
- SAMPLE
- SUBCLASS
- SAMPLE
- WEIGHT_PCT
- 1.0000
- ITEMLIST_ID
- SAMPLE
- TEMPLATE_ID
- 1
- UDA_VALUE_ID
- SAMPLE
- ALT_HIER_RULE_LEVEL
- 1
- END_DATE_PERIOD_ONE
- 2026-01-01
- END_DATE_PERIOD_TWO
- 2026-01-01
- START_DATE_PERIOD_ONE
- 2026-01-01
- START_DATE_PERIOD_TWO
- 2026-01-01
- WK_FROM_TODAY_LAST_YR
- 1
- WK_FROM_TODAY_THIS_YR
- 1
default
- MANY_TO_ONE_IDRPK
- 1000000003
- DEPT
- Alc Rule Many To One-002-ALT
- TYPE
- Al
- CLASS
- Alc Rule Many To One-002-ALT
- UDA_ID
- ALT-ALC_RULE-002
- ITEM_ID
- ALT-ALC_RULE-002
- RULE_ID
- 1000000003
- ALLOC_ID
- 1000000003
- DIFF1_ID
- ALT-ALC_RULE-002
- SUBCLASS
- Alc Rule Many To One-002-ALT
- WEIGHT_PCT
- 12.5000
- ITEMLIST_ID
- ALT-ALC_RULE-002
- TEMPLATE_ID
- 1000000003
- UDA_VALUE_ID
- ALT-ALC_RULE-002
- ALT_HIER_RULE_LEVEL
- 3
- END_DATE_PERIOD_ONE
- 2026-01-03
- END_DATE_PERIOD_TWO
- 2026-01-03
- START_DATE_PERIOD_ONE
- 2026-01-03
- START_DATE_PERIOD_TWO
- 2026-01-03
- WK_FROM_TODAY_LAST_YR
- 3
- WK_FROM_TODAY_THIS_YR
- 3
default
- MANY_TO_ONE_IDRPK
- 1000000005
- DEPT
- Alc Rule Many To One-003-EDGE
- TYPE
- Al
- CLASS
- Alc Rule Many To One-003-EDGE
- UDA_ID
- EDGE-ALC_RULE-003
- ITEM_ID
- EDGE-ALC_RULE-003
- RULE_ID
- 1000000005
- ALLOC_ID
- 1000000005
- DIFF1_ID
- EDGE-ALC_RULE-003
- SUBCLASS
- Alc Rule Many To One-003-EDGE
- WEIGHT_PCT
- 14.0000
- ITEMLIST_ID
- EDGE-ALC_RULE-003
- TEMPLATE_ID
- 1000000005
- UDA_VALUE_ID
- EDGE-ALC_RULE-003
- ALT_HIER_RULE_LEVEL
- 5
- END_DATE_PERIOD_ONE
- 2026-01-05
- END_DATE_PERIOD_TWO
- 2026-01-05
- START_DATE_PERIOD_ONE
- 2026-01-05
- START_DATE_PERIOD_TWO
- 2026-01-05
- WK_FROM_TODAY_LAST_YR
- 5
- WK_FROM_TODAY_THIS_YR
- 5
Rule Validation Summary
- Source Rule Count
- 31
- Governed Rule Count
- 25
