Loc List Criteria

Contains the number that uniquely identifies a location list.

Indicates whether this criteria is being used to query stores for the location list or to query warehouses for the location list. Valid values are: S - Store W - Warehouse

Indicates the order in which the criteria should be applied. This number is unique within the location list for a given location type.

Puts an open parenthesis ( to the query where clause if this field contains a value.

Contains the code of location-related data element that can be used to create a list of locations. Together with the comparison field and the value field, it forms one criteria that is used to build the location list. The codes are on the code_detail table with code type LLST and LLWH. Valid values are: SN(Store Number) WN(WH Number) ST(State) CTY(Country ID) ZC(Zip Code) LT(Location Traits) DT(District) DW(Default WH) VR(Vat Region) PM(Promo Zone) TSF(Transfer Zone) CZG(Cost Zone Group) CZ(Cost Zone) PZG(Price Zone Group) PZ(Price Zone) SGG(Store Grade Group) SG(Store Grade) CUR(Currency) LNG(Language) SC(Store Class) SF(Store Format) TA(Total Area) SA(Selling Area) OD(Store Open Date) AD(Store Acquired Date) RD(Store Remodel Date) SL(Store Sales Level for Last Closed Week) FL(Store Forecast level for Last Closed Week)