Alc Load Size Profile

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

Oracle Retail target column GID on ALC_LOAD_SIZE_PROFILE.

this column contains the size1 group identifier. (diff group of diff1 in rms).

this column would contain the size2 group identifier. (diff group of diff2 in rms).

If a GID profile (Season numerical code) was assigned to the size profile when interfaced from SPO, it will be captured here. GID is not required.

The size profile level is calulated using the merch level.

this column contains the plan quantity for this entry.

this column is for internal validation check

this column would contain the thread value identifier.