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.This is needed because of binary backward compatibility, but it's also referenceable from Groovy!Deprecated.This is needed because of binary backward compatibility, but it's also referenceable from Groovy!Deprecated.This is needed because of binary backward compatibility, but it's also referenceable from Groovy!