The way items are classified in Allocation Cloud Service is different from Merchandising Foundation Cloud Service and most of the enterprise. The ALC_ITEM_TYPE is best explained with examples. This is not the exhaustive list of possible combinations, but is instead an illustration of possibilities. When examples of the data in the item_master table are presented, please be aware that the example only shows a small subset of the columns on the table. Not all items in the ITEM_MASTER table will be considered by Allocation Cloud Service. Thus, not all items in ITEM_MASTER will have the ALC_ITEM_TYPE column populated.
Allocation has the following item types:
Staple Item (ST)
Sellable Pack (SELLPACK)
Style (STYLE)
Fashion Item (FA)
Fashion SKU (FASHIONSKU)
Pack Component (PACKCOMP)
Non-sellable Fashion Simple Pack (NSFSP)
Non-sellable Staple Simple Pack (NSSSP)
Non-sellable Staple Complex Pack (NSSCP)
Non-sellable Fashion Multi-color Pack (NSFMCP)
Non-sellable Fashion Single Color Pack (NSFSCP)
A one level item is not related to any other items.
| Item(ID, not null) | Item_parent(nullable) | Item_grandparent(nullable) | Item_level(not null) | Tran_level(not null) | Diff_1 | Diff_2 | ITEM_AGGREGATE_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|---|---|
| 182920285 | Null | Null | 1 | 1 | Null | Null | N | ST |
Transaction level items of multiple level item families that have their aggregation indicator marked as N.
| Item(ID, not null) | Item_parent(nullable) | Item_grandparent(nullable) | Item_level(not null) | Tran_level(not null) | Diff_1 | Diff_2 | ITEM_AGGREGATE_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|---|---|
| 100001393 | Null | Null | 1 | 2 | COLOR | SIZE | N | |
| 100001828 | 100001393 | Null | 2 | 2 | RED | SMALL | N | ST |
| 100001561 | 100001393 | Null | 2 | 2 | BLUE | SMALL | N | ST |
| 100075018 | Null | Null | 1 | 3 | null | null | N | |
| 100075026 | 100075018 | Null | 2 | 3 | null | null | N | |
| 100075034 | 100075026 | 100075018 | 3 | 3 | null | null | N | ST |
All pack items that have ITEM_MASTER.sellable_ind = Y are classified as Sellable Packs in Allocation Cloud Service.
| Item(ID, not null) | Item_level(not null) | Tran_level(not null) | PACK_IND | SELLABLE_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|
| 110919650 | 1 | 1 | Y | Y | SELLPACK |
| 110919649 | 1 | 1 | Y | Y | SELLPACK |
| 111394648 | 1 | 1 | Y | Y | SELLPACK |
These are item families where the transaction level is 2 and the aggregation indicator at level 1 is Y. Allocation Cloud Service introduces a new level between the level 1 item and the level 2 items. These intermediate level items (1.5) do not exist on the ITEM_MASTER table.
Level 1 items hold diff groups and level 2 items hold diffs in fashion item families
| Item(ID, not null) | Item_parent(nullable) | Item_grandparent(nullable) | Item_level(not null) | Tran_level(not null) | Diff_1 | Diff_2 | ITEM_AGGREGATE_IND | DIFF_1_AGGREGATE_IND | DIFF_2_AGGREGATE_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|
| 100001393 | Null | Null | 1 | 2 | COLOR | SIZE | Y | Y | N | STYLE |
| 100001828 | 100001393 | Null | 2 | 2 | RED | SMALL | N | N | N | FASHIONSKU |
| 100001561 | 100001393 | Null | 2 | 2 | RED | LARGE | N | N | N | FASHIONSKU |
| 100001465 | 100001393 | Null | 2 | 2 | BLUE | SMALL | N | N | N | FASHIONSKU |
| 100001721 | 100001393 | Null | 2 | 2 | BLUE | LARGE | N | N | N | FASHIONSKU |
The Allocation Cloud Service constructed items (FA) between the STYLE items and the FASHIONSKU items are a combination of the STYLE and the unique aggregation diffs of the FASHIONSKU items. In our example the STYLE is 100001393. The unique aggregation diffs (where the DIFF_X_AGGREGATION_IND is Y at the STYLE level): RED, BLUE. They are concatenated in this format {STYLE agg position~aggregation diff}
| ITEM | ALC_ITEM_TYPE |
|---|---|
| 100001393 1~RED | FA |
| 100001393 1~BLUE | FA |
The same example if DIFF_2_AGGREGATE_IND is Y instead of DIFF_1_AGGREGATE_IND
| Item(ID, not null) | Item_parent(nullable) | Item_grandparent(nullable) | Item_level(not null) | Tran_level(not null) | Diff_1 | Diff_2 | ITEM_AGGREGATE_IND | DIFF_1_AGGREGATE_IND | DIFF_2_AGGREGATE_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|
| 100001393 | Null | Null | 1 | 2 | COLOR | SIZE | Y | N | Y | STYLE |
| 100001828 | 100001393 | Null | 2 | 2 | RED | SMALL | N | N | N | FASHIONSKU |
| 100001561 | 100001393 | Null | 2 | 2 | RED | LARGE | N | N | N | FASHIONSKU |
| 100001465 | 100001393 | Null | 2 | 2 | BLUE | SMALL | N | N | N | FASHIONSKU |
| 100001721 | 100001393 | Null | 2 | 2 | BLUE | LARGE | N | N | N | FASHIONSKU |
| ITEM | ALC_ITEM_TYPE |
|---|---|
| 100001393 2~SMALL | FA |
| 100001393 2~LARGE | FA |
These are non-sellable simple packs that contain only 1 component item. The component item must be classified as a Staple item by Allocation Cloud Service.
In this example pack item 110919650 is a simple pack with 1 component item 110919649 which is a ST item.
| Item(ID, not null) | Item_level(not null) | Tran_level(not null) | PACK_IND | SELLABLE_IND | SIMPLE_PACK_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|
| 110919650 | 1 | 1 | Y | N | N | NSSSP |
| 110919649 | 1 | 1 | N | Y | N | ST |
These are non-sellable simple packs that contain only 1 component item. The component item must be classified as a Fashion sku item by Allocation Cloud Service.
In this example pack item 110919650 is a simple pack with 1 component item (110919649) which is a FASHIONSKU item.
| Item(ID, not null) | Item_level(not null) | Tran_level(not null) | PACK_IND | SELLABLE_IND | SIMPLE_PACK_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|
| 110919650 | 1 | 1 | Y | N | N | NSSSP |
| 110919649 | 1 | 1 | N | Y | N | FASHIONSKU |
These are non-sellable complex packs that only contain staple items as components.
In this example pack item 110919650 is a simple pack with 3 component items which are ST items.
| Item(ID, not null) | Item_level(not null) | Tran_level(not null) | PACK_IND | SELLABLE_IND | SIMPLE_PACK_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|
| 110919650 | 1 | 1 | Y | N | N | NSSSP |
| 110919649 | 1 | 1 | N | Y | N | ST |
| 110919648 | 1 | 1 | N | Y | N | ST |
| 110919647 | 1 | 1 | N | Y | N | ST |
These are non-sellable complex packs that only contain FASHIONSKU components. The component items must all share the same item_parent. The component items must all share the same aggregate diff values.
In this example, let's say pack item 110919650 has two components: 100001828 and 100001561. The two components share a common parent item (100001393). The two components are classified as FASHIONSKU in ALC_ITEM_TYPE. The aggregation diff for the STYLE the components both belong to is position 1 and both components have the same value for DIFF_1.
| Item(ID, not null) | Item_parent(nullable) | Item_grandparent(nullable) | Item_level(not null) | Tran_level(not null) | Diff_1 | Diff_2 | ITEM_AGGREGATE_IND | DIFF_1_AGGREGATE_IND | DIFF_2_AGGREGATE_IND | PACK_IND | SELLABLE_IND | SIMPLE_PACK_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100001393 | Null | Null | 1 | 2 | COLOR | SIZE | Y | Y | N | N | Y | N | STYLE |
| 100001828 | 100001393 | Null | 2 | 2 | RED | SMALL | N | N | N | N | Y | N | FASHIONSKU |
| 100001561 | 100001393 | Null | 2 | 2 | RED | LARGE | N | N | N | N | Y | N | FASHIONSKU |
| 100001465 | 100001393 | Null | 2 | 2 | BLUE | SMALL | N | N | N | N | Y | N | FASHIONSKU |
| 100001721 | 100001393 | Null | 2 | 2 | BLUE | LARGE | N | N | N | N | Y | N | FASHIONSKU |
| 110919650 | Null | Null | 1 | 1 | Null | Null | N | N | N | Y | N | N | NSFSCP |
These are non-sellable complex packs that only contain FASHIONSKU components. The component items must all share the same item_parent. The component items can have varying aggregate diff values.
In this example, let's say pack item 110919655 has two components: 100001828 and 100001721. The two components share a common parent item (100001393). The two components are classified as FASHIONSKU in ALC_ITEM_TYPE. The aggregation diff for the STYLE the components both belong to is position 1 and both components have different values for DIFF_1.
| Item(ID, not null) | Item_parent(nullable) | Item_grandparent(nullable) | Item_level(not null) | Tran_level(not null) | Diff_1 | Diff_2 | ITEM_AGGREGATE_IND | DIFF_1_AGGREGATE_IND | DIFF_2_AGGREGATE_IND | PACK_IND | SELLABLE_IND | SIMPLE_PACK_IND | ALC_ITEM_TYPE |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100001393 | Null | Null | 1 | 2 | COLOR | SIZE | Y | Y | N | N | Y | N | STYLE |
| 100001828 | 100001393 | Null | 2 | 2 | RED | SMALL | N | N | N | N | Y | N | FASHIONSKU |
| 100001561 | 100001393 | Null | 2 | 2 | RED | LARGE | N | N | N | N | Y | N | FASHIONSKU |
| 100001465 | 100001393 | Null | 2 | 2 | BLUE | SMALL | N | N | N | N | Y | N | FASHIONSKU |
| 100001721 | 100001393 | Null | 2 | 2 | BLUE | LARGE | N | N | N | N | Y | N | FASHIONSKU |
| 110919655 | Null | Null | 1 | 1 | Null | Null | N | N | N | Y | N | N | NSFMCP |
The following items are not supported by Allocation Cloud Service
Allocation Cloud Service does not support Items where the item_level is greater than the tran_level.