Stage Data For Allocation Rules
In ScopeTechnical: ALC_SVC_RULE | ID: OR-ALLOC-ALC_SVC_RULE-ACTUAL_LANDED_COST_SERVICE_RULE
Stores stage data for allocation rules.
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_SVC_RULE
Field Definitions(5)
Rules & Considerations(42)
Sample Load Data(4)
| _scenario | ACTION | ROW_ID | RULE_ID | ALLOC_ID | END_DATE1 | END_DATE2 | ERROR_MSG | EXACT_IND | RULE_MODE | RULE_TYPE | IWOS_WEEKS | RULE_LEVEL | ON_HAND_IND | START_DATE1 | START_DATE2 | TEMPLATE_ID | NET_NEED_IND | ON_ORDER_IND | SIZE_PROFILE | WEEKS_FUTURE | WORKSPACE_ID | BACK_ORDER_IND | IN_TRANSIT_IND | PACK_THRESHOLD | PROCESS$STATUS | 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 | SAMPLE | 1 | 1 | 1 | 2026-01-01 | 2026-01-01 | SAMPLE | S | S | S | 1.0000 | SA | S | 2026-01-01 | 2026-01-01 | 1 | S | S | SAMPLE | 1 | 1 | S | S | 1 | SAMPLE | 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 | Alc Svc Ru | 100003 | 1000000003 | 1000000003 | 2026-01-03 | 2026-01-03 | Alc Svc Rule-002-ALT | A | A | A | 12.5000 | Al | A | 2026-01-03 | 2026-01-03 | 1000000003 | A | A | Alc Svc Rule-002-ALT | 3 | 1000000003 | A | A | 3 | PENDING-AL | A | A | 3 | 3 | 1000000003 | A | Al | A | A | A | 2026-01-03 | 12.5000 | A | A | A | 2026-01-03 | A | A | 2026-01-03 | 2026-02-09 | A | A | 2026-02-09 | A | A | A |
| default | Alc Svc Ru | 100005 | 1000000005 | 1000000005 | 2026-01-05 | 2026-01-05 | Alc Svc Rule-003-EDGE | A | A | A | 14.0000 | Al | A | 2026-01-05 | 2026-01-05 | 1000000005 | A | A | Alc Svc Rule-003-EDG | 5 | 1000000005 | A | A | 5 | ACTIVE-EDG | A | A | 5 | 5 | 1000000005 | A | Al | A | A | A | 2026-01-05 | 14.0000 | A | A | A | 2026-01-05 | A | A | 2026-01-05 | 2026-03-12 | A | A | 2026-03-12 | A | A | A |
Example values from field definitions
- ACTION
- SAMPLE
- ROW_ID
- 1
- RULE_ID
- 1
- ALLOC_ID
- 1
- END_DATE1
- 2026-01-01
- END_DATE2
- 2026-01-01
- ERROR_MSG
- SAMPLE
- EXACT_IND
- S
- RULE_MODE
- S
- RULE_TYPE
- 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
- WORKSPACE_ID
- 1
- BACK_ORDER_IND
- S
- IN_TRANSIT_IND
- S
- PACK_THRESHOLD
- 1
- PROCESS$STATUS
- SAMPLE
- 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
- ACTION
- Alc Svc Ru
- ROW_ID
- 100003
- RULE_ID
- 1000000003
- ALLOC_ID
- 1000000003
- END_DATE1
- 2026-01-03
- END_DATE2
- 2026-01-03
- ERROR_MSG
- Alc Svc Rule-002-ALT
- EXACT_IND
- A
- RULE_MODE
- A
- RULE_TYPE
- 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
- A
- ON_ORDER_IND
- A
- SIZE_PROFILE
- Alc Svc Rule-002-ALT
- WEEKS_FUTURE
- 3
- WORKSPACE_ID
- 1000000003
- BACK_ORDER_IND
- A
- IN_TRANSIT_IND
- A
- PACK_THRESHOLD
- 3
- PROCESS$STATUS
- PENDING-AL
- CONVERT_TO_PACK
- A
- PROMO_SALES_IND
- A
- WEEKS_LAST_YEAR
- 3
- WEEKS_THIS_YEAR
- 3
- CORPORATE_RULE_ID
- 1000000003
- REGULAR_SALES_IND
- A
- SIZE_PROFILE_TYPE
- Al
- LEAD_TIME_NEED_IND
- A
- CLEARANCE_SALES_IND
- A
- 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
- A
- INCLUDE_INV_IN_MIN_IND
- A
- 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
- A
- INCLUDE_CLEARANCE_STOCK_IND
- A
- 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
- ACTION
- Alc Svc Ru
- ROW_ID
- 100005
- RULE_ID
- 1000000005
- ALLOC_ID
- 1000000005
- END_DATE1
- 2026-01-05
- END_DATE2
- 2026-01-05
- ERROR_MSG
- Alc Svc Rule-003-EDGE
- EXACT_IND
- A
- RULE_MODE
- A
- RULE_TYPE
- 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
- A
- ON_ORDER_IND
- A
- SIZE_PROFILE
- Alc Svc Rule-003-EDG
- WEEKS_FUTURE
- 5
- WORKSPACE_ID
- 1000000005
- BACK_ORDER_IND
- A
- IN_TRANSIT_IND
- A
- PACK_THRESHOLD
- 5
- PROCESS$STATUS
- ACTIVE-EDG
- CONVERT_TO_PACK
- A
- PROMO_SALES_IND
- A
- WEEKS_LAST_YEAR
- 5
- WEEKS_THIS_YEAR
- 5
- CORPORATE_RULE_ID
- 1000000005
- REGULAR_SALES_IND
- A
- SIZE_PROFILE_TYPE
- Al
- LEAD_TIME_NEED_IND
- A
- CLEARANCE_SALES_IND
- A
- 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
- A
- INCLUDE_INV_IN_MIN_IND
- A
- 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
- A
- INCLUDE_CLEARANCE_STOCK_IND
- A
- 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
- 48
- Governed Rule Count
- 42