Package net.pricefx.formulaengine.scripting.queryapi.tables

Interface QapiProduct

All Superinterfaces:
Map<String,SelectableExpression>, PersistedObjectColumns, Tables.Columns, Tables.Table
public interface QapiProduct extends Tables.Table, PersistedObjectColumns
Table of the Product master data. Each row is one product, identified by its Stock Keeping Unit (SKU).

Example: 


 def q = api.queryApi()
 def p = q.tables().products()

 def product = q.source(p, [p.sku(), p.label(), p.ProductGroup, p.unitOfMeasure()], p.sku().equal("10000001"))
         .stream { it.find() }
Since:
14.0 - Caribou Lou
See Also:

  • Method Details

    • sku

      SelectableExpression sku()
      Returns the Stock Keeping Unit (SKU), the unique key of the product.
      Returns:
      the sku column as a String expression

    • label

      SelectableExpression label()
      Returns the description of the product.
      Returns:
      the label column as a String expression

    • unitOfMeasure

      SelectableExpression unitOfMeasure()
      Returns the default unit of measure of the product, for example KG or PCS.
      Returns:
      the unitOfMeasure column as a String expression
      See Also:

    • userGroupEdit

      SelectableExpression userGroupEdit()
      Returns the user group whose members can edit the product.
      Returns:
      the userGroupEdit column as a String expression
      See Also:

    • userGroupViewDetails

      SelectableExpression userGroupViewDetails()
      Returns the user group whose members can view the details of the product.
      Returns:
      the userGroupViewDetails column as a String expression
      See Also:

    • currency

      SelectableExpression currency()
      Returns the default currency in which the price of the product is calculated.
      Returns:
      the currency column as a String expression
      See Also:

    • formulaName

      SelectableExpression formulaName()
      Returns the name of the logic that calculates the line items of this product, or null when none is set.

      When set, this logic overrides the logic configured elsewhere, for example in the Price List or the Quote.

      Returns:
      the formulaName column as a String expression

    • image

      SelectableExpression image()
      Returns whether an image is stored for the product.
      Returns:
      the image column as a Boolean expression