Allocation Rule
In ScopeTechnical: ALC_RULE | ID: OR-ALLOC-ALC_RULE-ACTUAL_LANDED_COST_RULE
Stores a single record for each allocation created and is considered the header record for other rule information in the system. This is also meant to define the parameters by...
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
Field Definitions(5)
Rules & Considerations(55)
constraint
validation
Sample Load Data(4)
| _scenario | RULE_IDRPK | RULE_TYPER | ALLOC_ID | END_DATE1 | END_DATE2 | EXACT_IND | RULE_MODE | IWOS_WEEKS | RULE_LEVEL | ON_HAND_IND | START_DATE1 | START_DATE2 | TEMPLATE_ID | NET_NEED_IND | ON_ORDER_IND | SIZE_PROFILE | WEEKS_FUTURE | BACK_ORDER_IND | IN_TRANSIT_IND | PACK_THRESHOLD | CONVERT_TO_PACK | PROMO_SALES_IND | WEEKS_LAST_YEAR | WEEKS_THIS_YEAR | CORPORATE_RULE_ID | REGULAR_SALES_IND | SIZE_PROFILE_TYPE | LEAD_TIME_NEED_IND | CLEARANCE_SALES_IND | ENFORCE_PRES_MIN_IND | ON_ORDER_COMMIT_DATE | ON_ORDER_COMMIT_WEEKS | INBOUND_ALLOCATION_IND | INCLUDE_INV_IN_MAX_IND | INCLUDE_INV_IN_MIN_IND | LEAD_TIME_NEED_END_DATE | OUTBOUND_ALLOCATION_IND | LEAD_TIME_NEED_RULE_TYPE | LEAD_TIME_NEED_START_DATE | ON_ORDER_COMMIT_RANGE_END | USE_RULE_LEVEL_ON_HAND_IND | INCLUDE_CLEARANCE_STOCK_IND | ON_ORDER_COMMIT_RANGE_START | INCLUDE_MID_TIER_ON_HAND_IND | SIZE_PROFILE_DEFAULT_HIER_IND | SIZE_PROFILE_WH_AVAIL_PCT_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | S | 1 | 2026-01-01 | 2026-01-01 | S | S | 1.0000 | SA | S | 2026-01-01 | 2026-01-01 | 1 | S | S | SAMPLE | 1 | S | S | 1 | S | S | 1 | 1 | 1 | S | SA | S | S | S | 2026-01-01 | 1.0000 | S | S | S | 2026-01-01 | S | S | 2026-01-01 | 2026-01-01 | S | S | 2026-01-01 | S | S | S |
| default | 1000000003 | A | 1000000003 | 2026-01-03 | 2026-01-03 | y | A | 12.5000 | Al | A | 2026-01-03 | 2026-01-03 | 1000000003 | n | A | Alc Rule-002-ALT | 3 | A | A | 3 | A | y | 3 | 3 | 1000000003 | y | Al | A | y | A | 2026-01-03 | 12.5000 | A | y | y | 2026-01-03 | A | A | 2026-01-03 | 2026-02-09 | y | y | 2026-02-09 | A | A | A |
| default | 1000000005 | A | 1000000005 | 2026-01-05 | 2026-01-05 | y | A | 14.0000 | Al | A | 2026-01-05 | 2026-01-05 | 1000000005 | y | A | Alc Rule-003-EDGE | 5 | A | A | 5 | A | y | 5 | 5 | 1000000005 | y | Al | A | y | A | 2026-01-05 | 14.0000 | A | y | y | 2026-01-05 | A | A | 2026-01-05 | 2026-03-12 | y | y | 2026-03-12 | A | A | A |
Example values from field definitions
- RULE_IDRPK
- 1
- RULE_TYPER
- S
- ALLOC_ID
- 1
- END_DATE1
- 2026-01-01
- END_DATE2
- 2026-01-01
- EXACT_IND
- S
- RULE_MODE
- S
- IWOS_WEEKS
- 1.0000
- RULE_LEVEL
- SA
- ON_HAND_IND
- S
- START_DATE1
- 2026-01-01
- START_DATE2
- 2026-01-01
- TEMPLATE_ID
- 1
- NET_NEED_IND
- S
- ON_ORDER_IND
- S
- SIZE_PROFILE
- SAMPLE
- WEEKS_FUTURE
- 1
- BACK_ORDER_IND
- S
- IN_TRANSIT_IND
- S
- PACK_THRESHOLD
- 1
- CONVERT_TO_PACK
- S
- PROMO_SALES_IND
- S
- WEEKS_LAST_YEAR
- 1
- WEEKS_THIS_YEAR
- 1
- CORPORATE_RULE_ID
- 1
- REGULAR_SALES_IND
- S
- SIZE_PROFILE_TYPE
- SA
- LEAD_TIME_NEED_IND
- S
- CLEARANCE_SALES_IND
- S
- ENFORCE_PRES_MIN_IND
- S
- ON_ORDER_COMMIT_DATE
- 2026-01-01
- ON_ORDER_COMMIT_WEEKS
- 1.0000
- INBOUND_ALLOCATION_IND
- S
- INCLUDE_INV_IN_MAX_IND
- S
- INCLUDE_INV_IN_MIN_IND
- S
- LEAD_TIME_NEED_END_DATE
- 2026-01-01
- OUTBOUND_ALLOCATION_IND
- S
- LEAD_TIME_NEED_RULE_TYPE
- S
- LEAD_TIME_NEED_START_DATE
- 2026-01-01
- ON_ORDER_COMMIT_RANGE_END
- 2026-01-01
- USE_RULE_LEVEL_ON_HAND_IND
- S
- INCLUDE_CLEARANCE_STOCK_IND
- S
- ON_ORDER_COMMIT_RANGE_START
- 2026-01-01
- INCLUDE_MID_TIER_ON_HAND_IND
- S
- SIZE_PROFILE_DEFAULT_HIER_IND
- S
- SIZE_PROFILE_WH_AVAIL_PCT_IND
- S
default
- RULE_IDRPK
- 1000000003
- RULE_TYPER
- A
- ALLOC_ID
- 1000000003
- END_DATE1
- 2026-01-03
- END_DATE2
- 2026-01-03
- EXACT_IND
- y
- RULE_MODE
- A
- IWOS_WEEKS
- 12.5000
- RULE_LEVEL
- Al
- ON_HAND_IND
- A
- START_DATE1
- 2026-01-03
- START_DATE2
- 2026-01-03
- TEMPLATE_ID
- 1000000003
- NET_NEED_IND
- n
- ON_ORDER_IND
- A
- SIZE_PROFILE
- Alc Rule-002-ALT
- WEEKS_FUTURE
- 3
- BACK_ORDER_IND
- A
- IN_TRANSIT_IND
- A
- PACK_THRESHOLD
- 3
- CONVERT_TO_PACK
- A
- PROMO_SALES_IND
- y
- WEEKS_LAST_YEAR
- 3
- WEEKS_THIS_YEAR
- 3
- CORPORATE_RULE_ID
- 1000000003
- REGULAR_SALES_IND
- y
- SIZE_PROFILE_TYPE
- Al
- LEAD_TIME_NEED_IND
- A
- CLEARANCE_SALES_IND
- y
- ENFORCE_PRES_MIN_IND
- A
- ON_ORDER_COMMIT_DATE
- 2026-01-03
- ON_ORDER_COMMIT_WEEKS
- 12.5000
- INBOUND_ALLOCATION_IND
- A
- INCLUDE_INV_IN_MAX_IND
- y
- INCLUDE_INV_IN_MIN_IND
- y
- LEAD_TIME_NEED_END_DATE
- 2026-01-03
- OUTBOUND_ALLOCATION_IND
- A
- LEAD_TIME_NEED_RULE_TYPE
- A
- LEAD_TIME_NEED_START_DATE
- 2026-01-03
- ON_ORDER_COMMIT_RANGE_END
- 2026-02-09
- USE_RULE_LEVEL_ON_HAND_IND
- y
- INCLUDE_CLEARANCE_STOCK_IND
- y
- ON_ORDER_COMMIT_RANGE_START
- 2026-02-09
- INCLUDE_MID_TIER_ON_HAND_IND
- A
- SIZE_PROFILE_DEFAULT_HIER_IND
- A
- SIZE_PROFILE_WH_AVAIL_PCT_IND
- A
default
- RULE_IDRPK
- 1000000005
- RULE_TYPER
- A
- ALLOC_ID
- 1000000005
- END_DATE1
- 2026-01-05
- END_DATE2
- 2026-01-05
- EXACT_IND
- y
- RULE_MODE
- A
- IWOS_WEEKS
- 14.0000
- RULE_LEVEL
- Al
- ON_HAND_IND
- A
- START_DATE1
- 2026-01-05
- START_DATE2
- 2026-01-05
- TEMPLATE_ID
- 1000000005
- NET_NEED_IND
- y
- ON_ORDER_IND
- A
- SIZE_PROFILE
- Alc Rule-003-EDGE
- WEEKS_FUTURE
- 5
- BACK_ORDER_IND
- A
- IN_TRANSIT_IND
- A
- PACK_THRESHOLD
- 5
- CONVERT_TO_PACK
- A
- PROMO_SALES_IND
- y
- WEEKS_LAST_YEAR
- 5
- WEEKS_THIS_YEAR
- 5
- CORPORATE_RULE_ID
- 1000000005
- REGULAR_SALES_IND
- y
- SIZE_PROFILE_TYPE
- Al
- LEAD_TIME_NEED_IND
- A
- CLEARANCE_SALES_IND
- y
- ENFORCE_PRES_MIN_IND
- A
- ON_ORDER_COMMIT_DATE
- 2026-01-05
- ON_ORDER_COMMIT_WEEKS
- 14.0000
- INBOUND_ALLOCATION_IND
- A
- INCLUDE_INV_IN_MAX_IND
- y
- INCLUDE_INV_IN_MIN_IND
- y
- LEAD_TIME_NEED_END_DATE
- 2026-01-05
- OUTBOUND_ALLOCATION_IND
- A
- LEAD_TIME_NEED_RULE_TYPE
- A
- LEAD_TIME_NEED_START_DATE
- 2026-01-05
- ON_ORDER_COMMIT_RANGE_END
- 2026-03-12
- USE_RULE_LEVEL_ON_HAND_IND
- y
- INCLUDE_CLEARANCE_STOCK_IND
- y
- ON_ORDER_COMMIT_RANGE_START
- 2026-03-12
- INCLUDE_MID_TIER_ON_HAND_IND
- A
- SIZE_PROFILE_DEFAULT_HIER_IND
- A
- SIZE_PROFILE_WH_AVAIL_PCT_IND
- A
Rule Validation Summary
- Source Rule Count
- 73
- Governed Rule Count
- 55