Alc Rule
In ScopeTechnical: ALC_RULE | ID: OR-RACS-ALC_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
Target Structure
- Load Approach
- Table
- Target Objects
- ALC_RULE
Field Definitions(46)
Rules & Considerations(118)
Sample Load Data(4)
| _scenario | RULE_IDRPK | ALLOC_IDPK | EXACT_INDR | RULE_TYPER | TEMPLATE_IDPK | NET_NEED_INDR | PROMO_SALES_INDR | REGULAR_SALES_INDR | CLEARANCE_SALES_INDR | INCLUDE_INV_IN_MAX_INDR | INCLUDE_INV_IN_MIN_INDR | USE_RULE_LEVEL_ON_HAND_INDR | INCLUDE_CLEARANCE_STOCK_INDR | END_DATE1 | END_DATE2 | RULE_MODE | IWOS_WEEKS | RULE_LEVEL | ON_HAND_IND | START_DATE1 | START_DATE2 | ON_ORDER_IND | SIZE_PROFILE | WEEKS_FUTURE | BACK_ORDER_IND | IN_TRANSIT_IND | PACK_THRESHOLD | CONVERT_TO_PACK | WEEKS_LAST_YEAR | WEEKS_THIS_YEAR | CORPORATE_RULE_ID | SIZE_PROFILE_TYPE | LEAD_TIME_NEED_IND | ENFORCE_PRES_MIN_IND | ON_ORDER_COMMIT_DATE | ON_ORDER_COMMIT_WEEKS | INBOUND_ALLOCATION_IND | LEAD_TIME_NEED_END_DATE | OUTBOUND_ALLOCATION_IND | LEAD_TIME_NEED_RULE_TYPE | LEAD_TIME_NEED_START_DATE | ON_ORDER_COMMIT_RANGE_END | ON_ORDER_COMMIT_RANGE_START | INCLUDE_MID_TIER_ON_HAND_IND | SIZE_PROFILE_DEFAULT_HIER_IND | SIZE_PROFILE_WH_AVAIL_PCT_IND |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 1000000001 | 1000000001 | yes | Alc Rule-001 | 1000000001 | yes | yes | yes | yes | yes | yes | yes | yes | 2026-01-01 | 2026-01-01 | Alc Rule-001 | 11.0000 | Alc Rule-001 | Alc Rule-001 | 2026-01-01 | 2026-01-01 | Alc Rule-001 | Alc Rule-001 | 0001 | Alc Rule-001 | Alc Rule-001 | 001 | Alc Rule-001 | 01 | 01 | 1000000001 | Alc Rule-001 | Alc Rule-001 | Alc Rule-001 | 2026-01-01 | 11.0000 | Alc Rule-001 | 2026-01-01 | Alc Rule-001 | Alc Rule-001 | 2026-01-01 | 2026-01-06 | 2026-01-06 | Alc Rule-001 | Alc Rule-001 | Alc Rule-001 |
default
- RULE_IDRPK
- 1000000001
- ALLOC_IDPK
- 1000000001
- EXACT_INDR
- yes
- RULE_TYPER
- Alc Rule-001
- TEMPLATE_IDPK
- 1000000001
- NET_NEED_INDR
- yes
- PROMO_SALES_INDR
- yes
- REGULAR_SALES_INDR
- yes
- CLEARANCE_SALES_INDR
- yes
- INCLUDE_INV_IN_MAX_INDR
- yes
- INCLUDE_INV_IN_MIN_INDR
- yes
- USE_RULE_LEVEL_ON_HAND_INDR
- yes
- INCLUDE_CLEARANCE_STOCK_INDR
- yes
- END_DATE1
- 2026-01-01
- END_DATE2
- 2026-01-01
- RULE_MODE
- Alc Rule-001
- IWOS_WEEKS
- 11.0000
- RULE_LEVEL
- Alc Rule-001
- ON_HAND_IND
- Alc Rule-001
- START_DATE1
- 2026-01-01
- START_DATE2
- 2026-01-01
- ON_ORDER_IND
- Alc Rule-001
- SIZE_PROFILE
- Alc Rule-001
- WEEKS_FUTURE
- 0001
- BACK_ORDER_IND
- Alc Rule-001
- IN_TRANSIT_IND
- Alc Rule-001
- PACK_THRESHOLD
- 001
- CONVERT_TO_PACK
- Alc Rule-001
- WEEKS_LAST_YEAR
- 01
- WEEKS_THIS_YEAR
- 01
- CORPORATE_RULE_ID
- 1000000001
- SIZE_PROFILE_TYPE
- Alc Rule-001
- LEAD_TIME_NEED_IND
- Alc Rule-001
- ENFORCE_PRES_MIN_IND
- Alc Rule-001
- ON_ORDER_COMMIT_DATE
- 2026-01-01
- ON_ORDER_COMMIT_WEEKS
- 11.0000
- INBOUND_ALLOCATION_IND
- Alc Rule-001
- LEAD_TIME_NEED_END_DATE
- 2026-01-01
- OUTBOUND_ALLOCATION_IND
- Alc Rule-001
- LEAD_TIME_NEED_RULE_TYPE
- Alc Rule-001
- LEAD_TIME_NEED_START_DATE
- 2026-01-01
- ON_ORDER_COMMIT_RANGE_END
- 2026-01-06
- ON_ORDER_COMMIT_RANGE_START
- 2026-01-06
- INCLUDE_MID_TIER_ON_HAND_IND
- Alc Rule-001
- SIZE_PROFILE_DEFAULT_HIER_IND
- Alc Rule-001
- SIZE_PROFILE_WH_AVAIL_PCT_IND
- Alc Rule-001