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)

Defines the relation between the criteria element and the criteria value. Together with the element field and the value field, it forms one criteira that is used to build the location list. Valid values are: EQ (=) NE (!=) GT (>) LT (<) GE (>=) LE (<=)

Contains the value of the location data element. Together with the element field and the comparison field, it forms one criteira that is used to build the location list.

Puts an close parenthesis ) to the query where clause if this field contains a value.

Indicates the logical relation (AND/OR) between the current criteria and the next criteria. Valid values are: AND OR

This column may contain the cost zone group when the element is CZ, the price zone group when the element is PZ, or the store grade group when the element is SG.