Package net.pricefx.formulaengine.scripting.queryapi

Interface Tables

public interface Tables
Collection of accessor to Pricefx domain tables as Tables.Table objects.
Since:
14.0 - Caribou Lou

  • Method Details

    • products

      QapiProduct products()
      Builds a representation of the product master table from the configured attributes meta.
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • customers

      QapiCustomer customers()
      Builds a representation of the customer master table from the configured attributes meta.
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • sellers

      QapiSeller sellers()
      Builds a representation of the sellers master table from the configured attributes meta.
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • productExtensionRows

      QapiProductExtensionRow productExtensionRows(String productExtensionName)
      Builds a representation of a product extension table from the configured attributes meta.
      Parameters:
      productExtensionName - the name of the product extension
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • customerExtensionRows

      QapiCustomerExtensionRow customerExtensionRows(String customerExtensionName)
      Builds a representation of a customer extension table from the configured attributes meta.
      Parameters:
      customerExtensionName - the name of the customer extension
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • sellerExtensionRows

      QapiSellerExtensionRow sellerExtensionRows(String sellerExtensionName)
      Builds a representation of a seller extension table from the configured attributes meta.
      Parameters:
      sellerExtensionName - the name of the seller extension
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • companyParameterRows

      QapiCompanyParameterRow companyParameterRows(String companyParameterUniqueName)
      Builds a representation of a company parameter table from the configured attributes meta.
      Parameters:
      companyParameterUniqueName - the name of the company parameter
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • conditionRecords

      QapiConditionRecord conditionRecords(String conditionRecordSetUniqueName)
      Builds a representation of a condition record set table from the configured attributes meta.
      Parameters:
      conditionRecordSetUniqueName - the name of the condition record set
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • quoteLineItems

      QapiQuoteLineItem quoteLineItems(String quoteUniqueName)
      Builds a representation of the table containing the lines items of a given quote.
      Parameters:
      quoteUniqueName - the line items quote name
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • rebateLineItems

      QapiRebateLineItem rebateLineItems(String rebateUniqueName)
      Builds a representation of the table containing the lines items of a given rebate.
      Parameters:
      rebateUniqueName - the line items rebate name
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • contractLineItems

      QapiContractLineItem contractLineItems(String contractUniqueName)
      Builds a representation of the table containing the lines items of a given contract.
      Parameters:
      contractUniqueName - the line items contract name
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • compensationLineItems

      QapiCompensationLineItem compensationLineItems(String compensationUniqueName)
      Builds a representation of the table containing the lines items of a given compensation.
      Parameters:
      compensationUniqueName - the line items compensation name
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • calculationGrids

      QapiCalculationGrid calculationGrids()
      Builds a representation of the table containing all the calculation grids (header).
      Returns:
      the built table
      Since:
      14.3 - Caribou Lou

    • calculationGridLineItems

      QapiCalculationGridLineItem calculationGridLineItems(long calculationGridId)
      Builds a representation of the table containing the lines items of a given calculation grid.
      Parameters:
      calculationGridId - the line items calculation grid id
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • priceLists

      QapiPriceList priceLists()
      Builds a representation of the table containing all the price lists (header).
      Returns:
      the built table
      Since:
      14.3 - Caribou Lou

    • priceListLineItems

      QapiPriceListLineItem priceListLineItems(long priceListId)
      Builds a representation of the table containing the lines items of a given price list.
      Parameters:
      priceListId - the line items price list id
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • priceGrids

      QapiPriceGrid priceGrids()
      Builds a representation of the table containing all the price grids (header).
      Returns:
      the built table
      Since:
      14.3 - Caribou Lou

    • priceGridLineItems

      QapiPriceGridLineItem priceGridLineItems(long priceGridId)
      Builds a representation of the table containing the lines items of a given price grid.
      Parameters:
      priceGridId - the line items price grid id
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • rebateRecords

      QapiRebateRecord rebateRecords(long rebateRecordSetId)
      Builds a representation of the table containing the rebate records of a given rebate record set.
      Parameters:
      rebateRecordSetId - the rebate record set id
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • compensationRecords

      QapiCompensationRecord compensationRecords(long compensationRecordSetId)
      Builds a representation of the table containing the compensation records of a given compensation record set.
      Parameters:
      compensationRecordSetId - the compensation record set id
      Returns:
      the built table
      Since:
      14.0 - Caribou Lou

    • actionItems

      QapiActionItem actionItems()
      Builds a representation of the table containing all the action items.
      Returns:
      the built table
      Since:
      15.0 - Southside

    • productCompetitions

      QapiProductCompetition productCompetitions()
      Builds a representation of the table containing all the product competition.
      Returns:
      the built table
      Since:
      15.2 - Southside

    • dataFeed

      QapiDataFeed dataFeed(String dataFeedUniqueName)
      Builds a representation of the given PA DataFeed table name.
      Parameters:
      dataFeedUniqueName - the name of the DataFeed
      Returns:
      the built table
      Since:
      15.0 - Southside

    • dataSource

      QapiDataSource dataSource(String dataSourceUniqueName)
      Builds a representation of the given PA DataSource table name.
      Parameters:
      dataSourceUniqueName - the name of the DataSource
      Returns:
      the built table
      Since:
      15.0 - Southside

    • datamart

      QapiDatamart datamart(String datamartUniqueName)
      Builds a representation of the given PA Datamart table name.
      Parameters:
      datamartUniqueName - the name of the Datamart
      Returns:
      the built table
      Since:
      15.0 - Southside

    • datamart

      QapiDatamart datamart(String datamartUniqueName, Map<QapiDatamart.Options,Object> options)
      Builds a representation of the given PA Datamart table name with a set of options.
      Parameters:
      datamartUniqueName - the name of the Datamart
      options - a map of QapiDatamart.Options
      Returns:
      the built table
      Since:
      15.0 - Southside

    • modelTable

      QapiModelTable modelTable(String modelUniqueName, String tableName)
      Builds a representation of a table owned by a ModelObject.
      Parameters:
      modelUniqueName - the name of the model owning the table
      tableName - the name of the table
      Returns:
      the built table
      Since:
      15.0 - Southside

    • rollup

      QapiRollup rollup(String rollupLabel)
      Builds a representation of a PA rollup.
      Parameters:
      rollupLabel - the label of the rollup
      Returns:
      the built table
      Since:
      15.0 - Southside