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

Interface QapiCustomer

All Superinterfaces:
Map<String,SelectableExpression>, PersistedObjectColumns, Tables.Columns, Tables.Table
public interface QapiCustomer extends Tables.Table, PersistedObjectColumns
Table of the Customer master data. Each row is one customer, which can be a sold-to party or a higher level of the customer hierarchy.

Example: 


 def q = api.queryApi()
 def c = q.tables().customers()

 def customer = q.source(c, [c.customerId(), c.name(), c.Country], c.customerId().equal("CD-0001"))
         .stream { it.find() }
Since:
14.0 - Caribou Lou
See Also:

  • Method Details

    • customerId

      SelectableExpression customerId()
      Returns the customer ID, the unique key of the customer.
      Returns:
      the customerId column as a String expression

    • name

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

    • parentId

      SelectableExpression parentId()
      Returns the ID of the parent customer in the customer hierarchy, or null when the customer has no parent.

      The value is the internal ID of the parent row, as returned by PersistedObjectColumns.id(), not its customer ID.

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

    • isParent

      SelectableExpression isParent()
      Returns whether the customer is a parent, that is a higher level of the customer hierarchy.
      Returns:
      the isParent column as a Boolean expression
      See Also:

    • userGroupEdit

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