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

Interface QapiPriceList

All Superinterfaces:
ApprovableColumns, CalculableObjectColumns, Map<String,SelectableExpression>, PersistedObjectColumns, Tables.Columns, Tables.Table
public interface QapiPriceList extends Tables.Table, PersistedObjectColumns, CalculableObjectColumns, ApprovableColumns
Table of Price List headers. Each row is one Price List, not one of its items.

Example, the validity of the Price Lists that were approved at least once: 


 def q = api.queryApi()
 def t = q.tables().priceLists()

 return q.source(t, [t.id(), t.label(), t.targetDate(), t.expiryDate(), t.previousPricelistId()],
         t.approvalDate().isNotNull())
         .stream { it.collect { it } }
Since:
14.3 - Caribou Lou
See Also:

  • Method Details

    • pricelistType

      SelectableExpression pricelistType()
      Returns whether the items of the Price List have one key, the Stock Keeping Unit (SKU), or two keys, the SKU and key2: SIMPLE or MATRIX.
      Returns:
      the pricelistType column as an Enum expression

    • nodeId

      SelectableExpression nodeId()
      Returns the node ID of the Price List.
      Returns:
      the nodeId column as an Integer expression

    • previousPricelistId

      SelectableExpression previousPricelistId()
      Returns the ID of the previous version of the Price List, when the Price List is a revision.

      The items of the previous version provide the previous prices that the price changes of the items are measured against.

      Returns:
      the previousPricelistId column as an Integer expression
      See Also:

    • expiryDate

      SelectableExpression expiryDate()
      Returns the last day of validity of the prices in the Price List. The first day is the target date.
      Returns:
      the expiryDate column as a DateOnly expression
      See Also:

    • approvalState

      SelectableExpression approvalState()
      Returns the approval state of the Price List, for example NOT_APPROVED or APPROVED.
      Returns:
      the approvalState column as an Enum expression
      See Also:

    • approvalDate

      SelectableExpression approvalDate()
      Returns the date and time when the Price List was approved.
      Returns:
      the approvalDate column as a DateTime expression
      See Also:

    • description

      SelectableExpression description()
      Returns the description of the Price List. It helps to tell apart Price Lists that have the same label.
      Returns:
      the description column as a String expression

    • userGroupEdit

      SelectableExpression userGroupEdit()
      Returns the user group whose members can edit the Price List.
      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 Price List.
      Returns:
      the userGroupViewDetails column as a String expression
      See Also:

    • pricelistPricegridTypeUniqueName

      SelectableExpression pricelistPricegridTypeUniqueName()
      Returns the unique name of the Price List type that the Price List was created from.
      Returns:
      the pricelistPricegridTypeUniqueName column as a String expression

    • submitDate

      SelectableExpression submitDate()
      Returns the date and time when the Price List was submitted for approval.
      Returns:
      the submitDate column as a DateTime expression
      See Also:

    • integrationStatus

      SelectableExpression integrationStatus()
      Returns the integration status of the Price List.
      Returns:
      the integrationStatus column as a String expression
      See Also:

    • exportDate

      SelectableExpression exportDate()
      Returns the date and time when the Price List was exported.
      Returns:
      the exportDate column as a DateTime expression
      See Also:

    • createdByName

      SelectableExpression createdByName()
      Returns the name of the user who created the Price List.
      Returns:
      the createdByName column as a String expression
      See Also:

    • lastUpdateByName

      SelectableExpression lastUpdateByName()
      Returns the name of the user who last updated the Price List.
      Returns:
      the lastUpdateByName column as a String expression
      See Also: