Package net.pricefx.formulaengine.scripting.queryapi.tables
Each Qapi interface describes one queryable Pricefx table. Every column is an
accessor method that returns a selectable expression. The expression carries a Query API
type: String, Integer, Real, DateOnly, DateTime, Boolean or Pojo.
Entry point: the accessors of the Tables collection, obtained with
api.queryApi().tables(). Examples are products(), customers() and
datamart(name). The query pipeline itself lives in the
net.pricefx.formulaengine.scripting.queryapi package.
The tables group as follows.
Analytics:
Transactional data:
- Master data:
QapiProduct,QapiProductExtensionRow,QapiProductCompetition,QapiProductBillOfMaterial,QapiProductReference,QapiCustomer,QapiCustomerExtensionRow,QapiSeller,QapiSellerExtensionRow,QapiUser. - Company Parameters and Condition Records:
QapiCompanyParameterTable,QapiCompanyParameterRow,QapiConditionRecord,QapiHistoricalConditionRecord. - Pricing documents:
QapiPriceList,QapiPriceListLineItem,QapiPriceGrid,QapiPriceGridLineItem,QapiCalculationGrid,QapiCalculationGridLineItem,QapiQuoteLineItem,QapiContractLineItem,QapiCustomForm. - Rebates, claims and compensation:
QapiRebateRecord,QapiRebateLineItem,QapiClaim,QapiClaimLineItem,QapiCompensationRecord,QapiCompensationLineItem. - Jobs and tasks:
QapiActionItem,QapiJobStatusTracker.
The *Columns interfaces are shared column mixins. They carry the columns common
to several tables: PersistedObjectColumns, CalculableObjectColumns,
CalculableObjectLineItemColumns, PriceCalculableObjectLineItemColumns,
CalculableLineItemColumns, InputsColumns, OutputsColumns and
ApprovableColumns. ClicColumns is deprecated.
-
ClassDescriptionDeprecated.Deprecated.Use
InputsColumns.InputColumnsinstead.Deprecated.UseOutputsColumns.OutputColumnsinstead.
CalculableLineItemColumnsinstead.