Condition builder attributes

Each query entity allows you to build statements based on attributes defined throughout the Applications Manager.

  • For the Item Condition Builder attributes, refer to Table 1 .
  • For the Alias Condition Builder attributes, refer to Table 2 .
  • For the Additional Attributes Condition Builder attributes, refer to Table 3 .
  • For the Category Condition Builder attributes, refer to Table 4 .
  • For the Exclusion Condition Builder attributes, refer to Table 5 .
    Table 1. Item condition builder attributes
    Attribute Description
    Primary Info
    Kit Code The kit code of the item, if applicable. Possible values are Physical Kit, Logical Kit, Bundle, and Dynamic Physical Kit.
    Item ID The ID of the item.
    Default Product Class The product class of the item.
    Item UOM Master The unit of measure of the item.
    Status The status of the item. Possible values are Held and Published.
    Used As Container For Packing The flag indicating whether or not the item is a container used for packing.
    Global Item ID The item's global identification number.
    Item Type The item's type.
    Can Be Added To Work Order As Service Tool The flag indicating whether or not the item can be added to a work order as a service tool.
    Description The detailed description of the item.
    Short Description The brief description of the item.
    Product Line The product line of the item.
    Manufacturer Name The name of the manufacturer who made the item.
    Manufacturer Item The identifier that the manufacturer uses to identify the item.
    Manufacturer Item Description The description that the manufacturer uses for the item.
    Country/Region of Origin The country or region of origin where the item was made.
    Taxable Flag The flag indicating whether or not the item is taxable.
    Tax Product Code The tax product code for this item.
    Master Catalog ID The identification number of the master catalog where the item is listed.
    Minimum Order Quantity The minimum quantity that an order can be placed for against the item.
    Maximum Order Quantity The maximum quantity that an order can be placed for against the item.
    Measurements
    Unit Length The length of the item.
    Unit Length UOM The unit of measure for the length of the item.
    Unit Weight The weight of the item.
    Unit Weight UOM The unit of measure for the weight of the item.
    Unit Height The height of the item.
    Unit Height UOM The unit of measure for the height of the item.
    Unit Width The width of the item.
    Unit Width UOM The unit of measure for the width of the item.
    Inventory Parameters
    Lead Time The amount of time (in days) needed to procure the item and make it available for shipping.
    Tag Control Flag The flag indicating to what extent the item is tag controlled. Possible values are Yes (always), No (never), and Sometimes.
    Time Sensitive The flag indicating whether or not the item is perishable with a specific ship-by date.
    Don't Perform Inventory Check on Schedule and release. The flag indicating whether or not an inventory check should be performed when scheduling or releasing this item. If this is set to 'Y', no inventory check occurs on schedule or release for this item. If this is set to 'N', inventory checks occur on schedule and release.
    ATP Rule The ATP rule that is used for this item.
    Inventory Monitor Rule The inventory monitor rule used to monitor this item's inventory level.
    Default Expiration Days The number of days that an item is available after it is received.
    Sourcing and Transportation Info
    Parcel Shipping Allowed The flag indicating whether parcel shipping is allowed for transfer of items.
    Requires Freezer The flag indicating whether items require freezer storage during transportation.
    Shipping By Air Allowed The flag indicating whether items can be shipped by air.
    Classification Codes
    Harmonized Code The Harmonized Code of the item.
    Schedule B Code The Schedule B Code of the item.
    ECCN No The Export Commodity Control Number of the item.
    NMFC Code The National Motor Freight Code of the item.
    NMFC Class The National Motor Freight Code Class of the item.
    UNSPSC The United Nations Standard Product and Services Code of the item.
    Hazmat Class The Hazardous Material Class of the item.
    Commodity Code The commodity code of the item.
    Table 2. Alias condition builder attributes
    Attribute Description
    Alias
    Alias Name The name of the item's alias.
    Alias Value The value of the item's alias.
    Table 3. Additional attributes condition builder attributes
    Attribute Description
    Additional Attributes
    Name The name of the item's additional attribute.
    Value The value of the item's additional attribute.
    Table 4. Category condition builder attributes
    Attribute Description
    Category
    Category ID The identification number of the item's category.
    Organization Code The organization that owns the item.
    Category Path The flattened path of the category tree for an item.
    Table 5. Exclusion condition builder attributes
    Attribute Description
    Exclusion
    Exclusion Code The item's exclusion code.