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

Interface QapiSeller

All Superinterfaces:
Map<String,SelectableExpression>, PersistedObjectColumns, Tables.Columns, Tables.Table
public interface QapiSeller extends Tables.Table, PersistedObjectColumns
Table of the Seller master data. Each row is one seller, a person who sells products, for example a person who receives a sales compensation without having a user account.

Example, the sellers who report to one seller: 


 def q = api.queryApi()
 def s = q.tables().sellers()

 return q.source(s, [s.sellerId(), s.name()], s.reportsTo().equal("S-0001"))
         .stream { it.collect { it } }
Since:
14.0 - Caribou Lou
See Also:

  • Method Details

    • sellerId

      SelectableExpression sellerId()
      Returns the seller ID, the unique key of the seller.
      Returns:
      the sellerId column as a String expression
      See Also:

    • name

      SelectableExpression name()
      Returns the full name of the seller, usually printed on documents.
      Returns:
      the name column as a String expression

    • userGroupEdit

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

    • reportsTo

      SelectableExpression reportsTo()
      Returns the seller ID of the seller that this seller reports to. It keeps a hierarchy between the sellers; the logic decides how to use it.
      Returns:
      the reportsTo column as a String expression
      See Also: