Alc Load Plan

Department ID, this is not a mandatory field but atleast one of the below has to be provided (Dept, Dept/Class, Dept / Class/ Subclass, Item)

Class ID, this is not a mandatory field but atleast one of the below has to be provided (Dept, Dept/Class, Dept / Class/ Subclass, Item)

Subclass ID, this is not a mandatory field but atleast one of the below has to be provided (Dept, Dept/Class, Dept / Class/ Subclass, Item)

Item ID, this is not a mandatory field but atleast one of the below has to be provided (Dept, Dept/Class, Dept / Class/ Subclass, Item). For fashion items, Diff ID has to be provided.

The location the plan applies to.

this column would contain the diff1 identifier, if populated

this column would contain the diff2 identifier, if populated.

this column would contain the diff3 identifier, if populated.

this column would contain the diff4 identifier, if populated

End of week date. The end of week date provided should fall on the weekday specificed in ALC_SYSTEM_OPTIONS.TP_END_OF_WEEK_DAY.

this column contains the plan quantity for this entry.

Oracle Retail target column DELETE_IND on ALC_LOAD_PLAN.