Alc Rule

this column contains the rule identifier.

indicates the Allocation Id and the foriegn key to the primary key of ALC_ALLOC table

this column would contain a unique template identifier, if a template is used for this allocation.

this column contains the rule type for this allocation. valid values are:history = 1forecast = 2plan = 3history_and_plan = 4plan_reproject = 5corporate_rules = 6manual = 7 RECIEPT_AND_PLAN=8

this column contains the level for the rule chosen for this allocation. valid values are: dept = 1 class = 2 subclass = 3 style= 4 sku = 5 STYLELEVEL =6 UDA=8 UDA_VALUE=9 ITEMLIST =10

this column contains the exact indicator. valid values are:yes = yno = n

this column contains the identifier to determine if net need is used in the calculation process. valid values are:yes = y, no = n

this column contains the use rule level on hand indicator. valid values are:yes = yno = n

this column contains the include clearance stock indicator. valid values are:yes = yno = n

this column contains the regular sales indicator. valid values are:yes = yno = n

this column contains the promotion sales indicator valid values are:yes = yno = n

this column contains the clearance sales indicator valid values are:yes = yno = n

this column contains the include inventory in minimum indicator valid values are:yes = yno = n

this column contains the include inventory in maximum indicator valid values are:yes = yno = n

this column would contain the on-order commit date, if populated.

this column would contain the on order commit weeks, if populated.

this column would contain the ideal-weeks-of-supply weeks value, if populated.

this column would contain the weeks this year quantity. this value will only be populated if the start_date1, end_date1 are null.

this column would contain the number of weeks for last year to be used in the calculation. this value will only be populated if the start_date1, end_date1 are null.

this column would contain the number of future weeks to be used in the calculation.

this column would contain the start date for the date range used in this rule. this value will be null if weeks_this_year is not null.

this column would contain the end date for the date range used in this rule. this value will be null if weeks_this_year is not null.

this column would contain the start date for the date range used in this rule. this value will not be populated for the following rules: corporate rules, plan re-project and history and plan.

this column would contain the end date for the date range used in this rule. this value will not be populated for the following rules: corporate rules, plan re-project and history and plan.

this column contains a unique corporate rule head identifier. this is associated to the corresponding records in the alc_corporate_rule_head table.

holds the flag whether to include mid-tier onhand or not for an mld allocation

when this indicator is y, values from alc_auto_quantity_limits are defaulted into the quantity limits for the allocation.

when this indicator is y, include the need generated during the lead time in the total need.

indicates the rule type (e.g. history) used to predict the sales that are used to extrapolate the lead time need

the start date of the period used to get the sales that are used to extrapolate the lead time need

the end date of the period used to get the sales that are used to extrapolate the lead time need

column details whether the sellable staple pack has to be allocated in terms of packs or not.

Allowed Values - PR, PO and SO PR - Profile Ratio Logic : PO - Profile Ratio Optimal Logic SO - Selling Curve Optimal Logic

Allowed values - Y, N Oracle Retail target column ON_HAND_IND on ALC_RULE.

Allowed values - Y, N Oracle Retail target column ON_ORDER_IND on ALC_RULE.

Allowed values - Y, N Oracle Retail target column IN_TRANSIT_IND on ALC_RULE.

Allowed values - Y, N Oracle Retail target column INBOUND_ALLOCATION_IND on ALC_RULE.

Indicates if out bound allocation quantities will be used in the inventory calculations on this allocation.

This column holds Back Order Indicator value

Adding Column to meet CR-36 requirement. This column will hold Pack Variance Acceptance Threshold value that is populated from the Policy Maintenance screen.

Represents the size profile details

Column Holding Mode 1- Simple 2-Cascade 3-Pack Distribution 4-Spread Demand

The start of the date range when the date range options is being used for the include inventory dates section.

The end of the date range when the date range options is being used for the include inventory dates section.

Use available inventory for wh location size profile population when normal size profile values are not available.

Indicates if Hierarchy size profile information should be used when SIZE_PROFILE is set to a GID but no GID data is available.