Uses of Interface
net.pricefx.formulaengine.scripting.queryapi.SelectableExpression

Packages that use SelectableExpression

Package	Description
net.pricefx.formulaengine.scripting.queryapi	The Query API, the unified Groovy API for reading data from Pricefx.
net.pricefx.formulaengine.scripting.queryapi.tables	Typed table descriptors of the Query API.

Uses of SelectableExpression in net.pricefx.formulaengine.scripting.queryapi

Methods in net.pricefx.formulaengine.scripting.queryapi that return SelectableExpression

Modifier and Type	Method	Description
SelectableExpression	Expression.as(String alias)	Builds a SelectableExpression having the same value as this expression and named after the given alias.

Uses of SelectableExpression in net.pricefx.formulaengine.scripting.queryapi.tables

Methods in net.pricefx.formulaengine.scripting.queryapi.tables that return SelectableExpression

Modifier and Type	Method	Description
SelectableExpression	QapiActionItem.actionItemTypeUniqueName()	Returns the unique name of the Action Item Type.
SelectableExpression	QapiUser.activated()
SelectableExpression	QapiPriceGridLineItem.activeCalculationResult(String elementName)	Returns the result of the given logic element at the last approval of the item, read from QapiPriceGridLineItem.activeCalculationResults(), or null if there is no such result.
SelectableExpression	QapiPriceGridLineItem.activeCalculationResults()	Returns all logic element results of the item at its last approval.
SelectableExpression	QapiPriceGridLineItem.activePrice()	Returns the approved price of the item, that is the result price at its last approval.
SelectableExpression	QapiPriceGridLineItem.activePriceDate()	Returns the date and time when the active price was approved.
SelectableExpression	QapiProductBillOfMaterial.additionalInfo1()	Returns the first additional numeric information of the component.
SelectableExpression	QapiProductCompetition.additionalInfo1()	Returns the first additional numeric information of the record.
SelectableExpression	QapiProductReference.additionalInfo1()	Returns the first additional numeric information of the reference.
SelectableExpression	QapiUser.additionalInfo1()
SelectableExpression	QapiProductBillOfMaterial.additionalInfo2()	Returns the second additional numeric information of the component.
SelectableExpression	QapiProductCompetition.additionalInfo2()	Returns the second additional numeric information of the record.
SelectableExpression	QapiProductReference.additionalInfo2()	Returns the second additional numeric information of the reference.
SelectableExpression	QapiUser.additionalInfo2()
SelectableExpression	QapiProductBillOfMaterial.additionalInfo3()	Returns the first additional text information of the component.
SelectableExpression	QapiProductCompetition.additionalInfo3()	Returns the first additional text information of the record.
SelectableExpression	QapiProductReference.additionalInfo3()	Returns the first additional text information of the reference.
SelectableExpression	QapiUser.additionalInfo3()
SelectableExpression	QapiProductBillOfMaterial.additionalInfo4()	Returns the second additional text information of the component.
SelectableExpression	QapiProductCompetition.additionalInfo4()	Returns the second additional text information of the record.
SelectableExpression	QapiProductReference.additionalInfo4()	Returns the second additional text information of the reference.
SelectableExpression	QapiUser.additionalInfo4()
SelectableExpression	QapiRebateRecord.agreementStatus()	When a revision of the agreement is created, this value is set to SUPERSEDED or INVALIDATED on the records of the previous revision.
SelectableExpression	QapiCompensationRecord.agreementTermsJson()
SelectableExpression	QapiRebateRecord.agreementTermsJson()
SelectableExpression	CalculableObjectLineItemColumns.alerts()	Returns the alerts triggered for the item by the last calculation, for all fields.
SelectableExpression	CalculableObjectLineItemColumns.allowedOverrides()	Returns the item fields that users are allowed to override manually.
SelectableExpression	QapiCalculationGridLineItem.approvalDate()	Returns the date and time when the item was approved.
SelectableExpression	QapiCompensationRecord.approvalDate()
SelectableExpression	QapiPriceGridLineItem.approvalDate()	Returns the date and time when the item was last approved.
SelectableExpression	QapiPriceList.approvalDate()	Returns the date and time when the Price List was approved.
SelectableExpression	QapiRebateRecord.approvalDate()
SelectableExpression	QapiCompensationRecord.approvalState()	Typical values are APPROVED, AUTO_APPROVED and DENIED.
SelectableExpression	QapiPriceGrid.approvalState()	Returns the approval state of the Live Price Grid, derived from the approval of its items: NOT_APPROVED, PARTIALLY_APPROVED (some items are approved) or APPROVED.
SelectableExpression	QapiPriceGridLineItem.approvalState()	Returns the approval state of the item: NOT_APPROVED, APPROVED, AUTO_APPROVED or DENIED.
SelectableExpression	QapiPriceList.approvalState()	Returns the approval state of the Price List, for example NOT_APPROVED or APPROVED.
SelectableExpression	QapiRebateRecord.approvalState()	Typical values are APPROVED, AUTO_APPROVED and DENIED.
SelectableExpression	ApprovableColumns.approvedByName()	Returns the name of the user who approved the row.
SelectableExpression	QapiActionItem.assignedTo()	Returns the ID of the user the Action Item is assigned to.
SelectableExpression	QapiActionItem.assignedToGroup()	Returns the user group the Action Item is assigned to.
SelectableExpression	QapiActionItem.assignedToName()	Returns the name of the user the Action Item is assigned to.
SelectableExpression	PriceCalculableObjectLineItemColumns.calculatedResultPrice()	Returns the price calculated by the logic for the item.
SelectableExpression	QapiCompensationLineItem.calculationBaseJson()	Returns the Datamart data slice that defines the calculation base of the line item.
SelectableExpression	QapiCompensationRecord.calculationBaseJson()
SelectableExpression	QapiContractLineItem.calculationBaseJson()	Returns the Datamart data slice that defines the calculation base of the line item.
SelectableExpression	QapiRebateLineItem.calculationBaseJson()	Returns the Datamart data slice that defines the calculation base of the line item.
SelectableExpression	QapiRebateRecord.calculationBaseJson()
SelectableExpression	CalculableObjectColumns.calculationDate()	Returns the date and time when the last calculation of the object ended.
SelectableExpression	QapiClaim.calculationDate()
SelectableExpression	QapiCompensationRecord.calculationDate()
SelectableExpression	QapiRebateRecord.calculationDate()
SelectableExpression	QapiCalculationGridLineItem.calculationGridId()	Returns the ID of the Calculation Grid that the item belongs to.
SelectableExpression	CalculableObjectColumns.calculationMessages()	Returns the messages, such as errors, produced by the last calculation of the object.
SelectableExpression	QapiClaim.calculationMessages()	The value is a JSON array of message strings.
SelectableExpression	CalculableObjectLineItemColumns.calculationResult(String elementName)	Returns the result of the given logic element from the last calculation of the item.
SelectableExpression	CalculableObjectColumns.calculationStartDate()	Returns the date and time when the last calculation of the object started.
SelectableExpression	QapiClaim.calculationStartDate()
SelectableExpression	CalculableLineItemColumns.calculationStatus()	Returns the result of the last calculation of the line item.
SelectableExpression	QapiClaimLineItem.calculationStatus()	Returns the result of the last calculation of the Claim line.
SelectableExpression	QapiCompensationRecord.calculationStatus()
SelectableExpression	QapiRebateRecord.calculationStatus()
SelectableExpression	QapiJobStatusTracker.cancelRequested()	Returns whether a user requested the cancellation of the job.
SelectableExpression	QapiProductBillOfMaterial.category()	Returns the category of the component.
SelectableExpression	QapiClaim.claimRecordUniqueName()
SelectableExpression	QapiClaim.claimStatus()	To filter on the status, pass the enum constant, as in the example of this class: t.claimStatus().equal(net.pricefx.common.api.ClaimStatus.APPROVED).
SelectableExpression	QapiClaim.claimTypeUniqueName()
SelectableExpression	CalculableObjectLineItemColumns.comments()	Returns the comments of the item.
SelectableExpression	QapiProductBillOfMaterial.comments()	Returns the comments on the component.
SelectableExpression	QapiProductCompetition.comments()	Returns the comments on the record.
SelectableExpression	QapiProductReference.comments()	Returns the comments on the reference.
SelectableExpression	QapiCompensationLineItem.compensationConditionTypeLabel()	Returns the label of the Compensation Condition Type of the line item.
SelectableExpression	QapiCompensationLineItem.compensationConditionTypeUniqueName()	Returns the unique name of the Compensation Condition Type that the line item represents and calculates.
SelectableExpression	QapiCompensationRecord.compensationConditionTypeUniqueName()
SelectableExpression	QapiCompensationRecord.compensationHeaderTypeUniqueName()
SelectableExpression	QapiCompensationRecord.compensationRecordSetLabel()
SelectableExpression	QapiCompensationRecord.compensationStatus()	When a revision of the plan is created, this value is set to SUPERSEDED or INVALIDATED on the records of the previous revision.
SelectableExpression	QapiProductCompetition.competitionType()	Returns the type of the competition.
SelectableExpression	QapiProductCompetition.competitor()	Returns the name of the competitor.
SelectableExpression	QapiProductCompetition.competitorSku()	Returns the identifier of the competitor's product.
SelectableExpression	CalculableObjectLineItemColumns.completeCalculationResults()	Returns all logic element results of the last calculation of the item, except internal ones.
SelectableExpression	QapiActionItem.completedBy()	Returns the ID of the user who set the Action Item to DONE.
SelectableExpression	QapiActionItem.completedByName()	Returns the login name of the user who set the Action Item to DONE.
SelectableExpression	QapiActionItem.completedDate()	Returns the date and time when the Action Item was set to DONE.
SelectableExpression	CalculableObjectLineItemColumns.completeResultsAvailable()	Returns whether the complete calculation results of the item are stored.
SelectableExpression	QapiJobStatusTracker.concurrencyKey()	Returns the concurrency key of the job, for example 2148068499.JST.
SelectableExpression	QapiConditionRecord.conditionValue()
SelectableExpression	QapiHistoricalConditionRecord.conditionValue()
SelectableExpression	QapiContractLineItem.contractTermTypeLabel()	Returns the label of the Condition Type of the line item.
SelectableExpression	QapiContractLineItem.contractTermTypeUniqueName()	Returns the unique name of the Condition Type (formerly Contract Term Type) of the line item.
SelectableExpression	QapiClaimLineItem.contractUniqueName()	Returns the unique name of the Agreement or Promotion that the Claim line is validated against.
SelectableExpression	QapiProductCompetition.country()	Returns the country where the competitor price was obtained.
SelectableExpression	PersistedObjectColumns.createDate()	Returns the date and time when the row was created.
SelectableExpression	PersistedObjectColumns.createdBy()	Returns the ID of the user who created the row.
SelectableExpression	QapiActionItem.createdByName()	Returns the name of the user who created the Action Item.
SelectableExpression	QapiCalculationGrid.createdByName()	Returns the name of the user who created the Calculation Grid.
SelectableExpression	QapiCompanyParameterRow.createdByName()	Returns the name of the user who created the row.
SelectableExpression	QapiCompensationRecord.createdByName()
SelectableExpression	QapiPriceGrid.createdByName()	Returns the name of the user who created the Live Price Grid.
SelectableExpression	QapiPriceList.createdByName()	Returns the name of the user who created the Price List.
SelectableExpression	QapiRebateRecord.createdByName()
SelectableExpression	QapiConditionRecord.createdByObj()
SelectableExpression	QapiHistoricalConditionRecord.createdByObj()	The value is usually a typed ID, for example 2147491032.PL for a Price List.
SelectableExpression	PriceCalculableObjectLineItemColumns.currency()	Returns the currency of the price.
SelectableExpression	QapiConditionRecord.currency()
SelectableExpression	QapiHistoricalConditionRecord.currency()
SelectableExpression	QapiProduct.currency()	Returns the default currency in which the price of the product is calculated.
SelectableExpression	QapiProductCompetition.currency()	Returns the currency of the competitor price.
SelectableExpression	QapiCompensationLineItem.customerGroup()	Returns the group of customers for whom the compensation conditions on the line item are negotiated.
SelectableExpression	QapiCompensationRecord.customerGroup()	The value is a customer group object, not a String.
SelectableExpression	QapiContractLineItem.customerGroup()	Returns the group of customers for whom the conditions on the line item are negotiated.
SelectableExpression	QapiRebateLineItem.customerGroup()	Returns the group of customers for whom the rebate conditions on the line item are negotiated.
SelectableExpression	QapiRebateRecord.customerGroup()	The value is a customer group object, not a String.
SelectableExpression	QapiClaim.customerId()
SelectableExpression	QapiCustomer.customerId()	Returns the customer ID, the unique key of the customer.
SelectableExpression	QapiCustomerExtensionRow.customerId()	Returns the ID of the customer that the row holds data for.
SelectableExpression	QapiClaim.customerName()
SelectableExpression	QapiUser.defaultUserGroupEdit()
SelectableExpression	QapiUser.defaultUserGroupViewDetails()
SelectableExpression	QapiCalculationGridLineItem.denialDate()	Returns the date and time when the item was denied.
SelectableExpression	QapiPriceGridLineItem.denialDate()	Returns the date and time when the item was denied.
SelectableExpression	QapiCalculationGridLineItem.denialReason()	Returns the reason given when the item was denied.
SelectableExpression	QapiPriceGridLineItem.denialReason()	Returns the reason given when the item was denied, combined with the denial comment.
SelectableExpression	ApprovableColumns.deniedByName()	Returns the name of the user who denied the row.
SelectableExpression	QapiActionItem.description()	Returns the long description of the action.
SelectableExpression	QapiCompensationRecord.description()
SelectableExpression	QapiPriceGrid.description()	Returns the description of the Live Price Grid.
SelectableExpression	QapiPriceList.description()	Returns the description of the Price List.
SelectableExpression	QapiRebateRecord.description()
SelectableExpression	CalculableLineItemColumns.dirty()	Returns the flag that marks a line item as needing recalculation.
SelectableExpression	CalculableObjectLineItemColumns.dirty()	Returns the flag that marks the item for another round of recalculation by the logic.
SelectableExpression	QapiActionItem.dueDate()	Returns the date and time by which the action should be done.
SelectableExpression	QapiActionItem.dueDatePassedNotificationSent()	Returns the date and time when the notification that the due date passed was sent.
SelectableExpression	CalculableLineItemColumns.editabilityStatus()	Returns the editing restriction of the line item.
SelectableExpression	QapiUser.email()
SelectableExpression	QapiUser.emailLocale()
SelectableExpression	QapiClaimLineItem.endCustomerId()	Returns the ID of the end customer to whom the distributor sold the product.
SelectableExpression	QapiCompensationLineItem.endDate()	Returns the last day of validity of the conditions on the line item.
SelectableExpression	QapiCompensationRecord.endDate()
SelectableExpression	QapiContractLineItem.endDate()	Returns the last day of validity of the conditions on the line item.
SelectableExpression	QapiRebateLineItem.endDate()	Returns the last day of validity of the conditions on the line item.
SelectableExpression	QapiRebateRecord.endDate()
SelectableExpression	QapiPriceList.expiryDate()	Returns the last day of validity of the prices in the Price List.
SelectableExpression	QapiPriceList.exportDate()	Returns the date and time when the Price List was exported.
SelectableExpression	QapiClaim.externalRef()
SelectableExpression	QapiRebateRecord.externalRef()
SelectableExpression	QapiConditionRecord.extraData()
SelectableExpression	QapiHistoricalConditionRecord.extraData()	Unlike in QapiConditionRecord.extraData(), this is not the data of the original record.
SelectableExpression	QapiClaim.fileName()
SelectableExpression	QapiUser.firstName()
SelectableExpression	QapiCustomForm.formStatus()	To filter on the status, pass the enum constant, as in the example of this class: cf.formStatus().equal(CustomFormStatus.APPROVED).
SelectableExpression	QapiCompensationRecord.formulaName()
SelectableExpression	QapiProduct.formulaName()	Returns the name of the logic that calculates the line items of this product, or null when none is set.
SelectableExpression	QapiRebateRecord.formulaName()
SelectableExpression	QapiPriceListLineItem.hasCriticalAlert()	Returns whether the logic raised a critical alert when it calculated the item.
SelectableExpression	QapiJobStatusTracker.hasWarning()	Returns whether the job ended with a warning, for example a warning or an alert in its calculation results.
SelectableExpression	QapiRebateRecord.headerRebateTypeUniqueName()
SelectableExpression	QapiPriceGrid.headerTypeUniqueName()	Returns the unique name of the Live Price Grid type that the grid was created from.
SelectableExpression	PersistedObjectColumns.id()	Returns the ID of the row.
SelectableExpression	QapiProduct.image()	Returns whether an image is stored for the product.
SelectableExpression	QapiProductCompetition.infoDate()	Returns the date and time when the competitor price was obtained.
SelectableExpression	QapiProductReference.infoDate()	Returns the information date of the reference.
SelectableExpression	QapiCompensationRecord.inputsJson()
SelectableExpression	QapiRebateRecord.inputsJson()
SelectableExpression	QapiConditionRecord.integrationStatus()
SelectableExpression	QapiHistoricalConditionRecord.integrationStatus()
SelectableExpression	QapiPriceGrid.integrationStatus()	Returns the integration status of the Live Price Grid.
SelectableExpression	QapiPriceList.integrationStatus()	Returns the integration status of the Price List.
SelectableExpression	QapiProductCompetition.integrationToken()	Returns the key that identifies the integration the record comes from.
SelectableExpression	QapiProductReference.internalReference()	Returns the internal reference flag.
SelectableExpression	QapiCompensationRecord.intgStatus()
SelectableExpression	QapiRebateRecord.intgStatus()
SelectableExpression	QapiCompensationRecord.intgStatusDetails()
SelectableExpression	QapiRebateRecord.intgStatusDetails()
SelectableExpression	QapiCompensationRecord.intgStatusErpReference()
SelectableExpression	QapiRebateRecord.intgStatusErpReference()
SelectableExpression	QapiCalculationGridLineItem.isCompleted()	Returns the flag that marks an item as successfully calculated.
SelectableExpression	QapiDataFeed.isDeleted()	Returns whether the row is flagged as deleted.
SelectableExpression	QapiDatamart.isDeleted()	Returns whether the row is flagged as deleted.
SelectableExpression	QapiDataSource.isDeleted()	Returns whether the row is flagged as deleted.
SelectableExpression	QapiCompensationRecord.isManual()
SelectableExpression	QapiRebateRecord.isManual()
SelectableExpression	OutputsColumns.OutputColumns.isOverridden()	Returns whether a user overrode the result of the logic element manually.
SelectableExpression	QapiCustomer.isParent()	Returns whether the customer is a parent, that is a higher level of the customer hierarchy.
SelectableExpression	CalculableObjectLineItemColumns.itemExtensions()	Returns the mapping of item fields to logic element result suffixes.
SelectableExpression	QapiJobStatusTracker.jobName()	Returns the name of the job.
SelectableExpression	QapiCalculationGridLineItem.key1()	Returns the first key of the item.
SelectableExpression	QapiCompanyParameterRow.key1()	Returns the first key of the row.
SelectableExpression	QapiConditionRecord.key1()	The keys identify what the condition applies to, for example a product and a customer.
SelectableExpression	QapiHistoricalConditionRecord.key1()	The keys identify what the condition applies to, for example a product and a customer.
SelectableExpression	QapiConditionRecord.key10()	Only available when the set has at least 10 keys.
SelectableExpression	QapiHistoricalConditionRecord.key10()	Only available when the set has at least 10 keys.
SelectableExpression	QapiConditionRecord.key11()	Only available when the set has at least 11 keys.
SelectableExpression	QapiHistoricalConditionRecord.key11()	Only available when the set has at least 11 keys.
SelectableExpression	QapiConditionRecord.key12()	Only available when the set has 12 keys.
SelectableExpression	QapiHistoricalConditionRecord.key12()	Only available when the set has 12 keys.
SelectableExpression	QapiCalculationGridLineItem.key2()	Returns the second key of the item.
SelectableExpression	QapiCompanyParameterRow.key2()	Returns the second key of the row.
SelectableExpression	QapiConditionRecord.key2()	Only available when the set has at least 2 keys.
SelectableExpression	QapiHistoricalConditionRecord.key2()	Only available when the set has at least 2 keys.
SelectableExpression	QapiPriceGridLineItem.key2()	Returns the value of the second dimension of the item, in addition to the product.
SelectableExpression	QapiPriceListLineItem.key2()	Returns the value of the second dimension of the item, in addition to the product.
SelectableExpression	QapiCalculationGridLineItem.key3()	Returns the third key of the item.
SelectableExpression	QapiCompanyParameterRow.key3()	Returns the third key of the row.
SelectableExpression	QapiConditionRecord.key3()	Only available when the set has at least 3 keys.
SelectableExpression	QapiHistoricalConditionRecord.key3()	Only available when the set has at least 3 keys.
SelectableExpression	QapiCalculationGridLineItem.key4()	Returns the fourth key of the item.
SelectableExpression	QapiCompanyParameterRow.key4()	Returns the fourth key of the row.
SelectableExpression	QapiConditionRecord.key4()	Only available when the set has at least 4 keys.
SelectableExpression	QapiHistoricalConditionRecord.key4()	Only available when the set has at least 4 keys.
SelectableExpression	QapiCalculationGridLineItem.key5()	Returns the fifth key of the item.
SelectableExpression	QapiCompanyParameterRow.key5()	Returns the fifth key of the row.
SelectableExpression	QapiConditionRecord.key5()	Only available when the set has at least 5 keys.
SelectableExpression	QapiHistoricalConditionRecord.key5()	Only available when the set has at least 5 keys.
SelectableExpression	QapiCalculationGridLineItem.key6()	Returns the sixth key of the item.
SelectableExpression	QapiCompanyParameterRow.key6()	Returns the sixth key of the row.
SelectableExpression	QapiConditionRecord.key6()	Only available when the set has at least 6 keys.
SelectableExpression	QapiHistoricalConditionRecord.key6()	Only available when the set has at least 6 keys.
SelectableExpression	QapiConditionRecord.key7()	Only available when the set has at least 7 keys.
SelectableExpression	QapiHistoricalConditionRecord.key7()	Only available when the set has at least 7 keys.
SelectableExpression	QapiConditionRecord.key8()	Only available when the set has at least 8 keys.
SelectableExpression	QapiHistoricalConditionRecord.key8()	Only available when the set has at least 8 keys.
SelectableExpression	QapiConditionRecord.key9()	Only available when the set has at least 9 keys.
SelectableExpression	QapiHistoricalConditionRecord.key9()	Only available when the set has at least 9 keys.
SelectableExpression	QapiCalculationGrid.keySize()	Returns the number of key fields of the items of the Calculation Grid, from 1 to 6.
SelectableExpression	CalculableLineItemColumns.label()	Returns the label of the line item, as displayed in the line item list of the document.
SelectableExpression	CalculableObjectColumns.label()	Returns the label of the object.
SelectableExpression	CalculableObjectLineItemColumns.label()	Returns the label of the item.
SelectableExpression	QapiClaim.label()
SelectableExpression	QapiCompanyParameterTable.label()	Returns the name of the Company Parameter table as displayed to users.
SelectableExpression	QapiCustomForm.label()	A revision keeps the label of the form it revises.
SelectableExpression	QapiProduct.label()	Returns the description of the product.
SelectableExpression	QapiProductCompetition.label()	Returns the label of the record.
SelectableExpression	QapiUser.lastLogin()
SelectableExpression	QapiUser.lastName()
SelectableExpression	PersistedObjectColumns.lastUpdateBy()	Returns the ID of the user who last updated the row.
SelectableExpression	QapiActionItem.lastUpdateByName()	Returns the name of the user who last updated the Action Item.
SelectableExpression	QapiCalculationGrid.lastUpdateByName()	Returns the name of the user who last updated the Calculation Grid.
SelectableExpression	QapiCompanyParameterRow.lastUpdateByName()	Returns the name of the user who last updated the row.
SelectableExpression	QapiCompensationRecord.lastUpdateByName()
SelectableExpression	QapiPriceGrid.lastUpdateByName()	Returns the name of the user who last updated the Live Price Grid.
SelectableExpression	QapiPriceList.lastUpdateByName()	Returns the name of the user who last updated the Price List.
SelectableExpression	QapiRebateRecord.lastUpdateByName()
SelectableExpression	PersistedObjectColumns.lastUpdateDate()	Returns the date and time when the row was last updated.
SelectableExpression	QapiDataFeed.lastUpdateDate()	Returns the date and time when the row was last updated.
SelectableExpression	QapiDatamart.lastUpdateDate()	Returns the date and time when the row was last updated.
SelectableExpression	QapiDataSource.lastUpdateDate()	Returns the date and time when the row was last loaded or updated.
SelectableExpression	QapiConditionRecord.lastUpdatedByObj()
SelectableExpression	QapiHistoricalConditionRecord.lastUpdatedByObj()	The value is not copied from the original record and is usually empty.
SelectableExpression	QapiJobStatusTracker.lightweight()	Returns whether the job is lightweight.
SelectableExpression	CalculableLineItemColumns.lineId()	Returns the identifier of the line item within its document.
SelectableExpression	QapiCompensationRecord.lineId()
SelectableExpression	QapiRebateRecord.lineId()
SelectableExpression	QapiClaim.locale()
SelectableExpression	QapiCompensationRecord.locked()
SelectableExpression	QapiRebateRecord.locked()
SelectableExpression	QapiUser.loginName()
SelectableExpression	QapiCompanyParameterRow.lowerBound()	Returns the lower bound of the range of the row.
SelectableExpression	QapiCalculationGridLineItem.manualEditUser()	Returns the ID of the user who last edited the item manually.
SelectableExpression	QapiPriceGridLineItem.manualEditUser()	Returns the ID of the user who last edited the item manually.
SelectableExpression	QapiCalculationGridLineItem.manualEditVersion()	Returns the number of times a user edited the item manually.
SelectableExpression	QapiPriceGridLineItem.manualEditVersion()	Returns the number of times a user edited the item manually.
SelectableExpression	CalculableObjectLineItemColumns.manualOverrides()	Returns the logic elements whose result was actually overridden manually on the item.
SelectableExpression	QapiPriceGridLineItem.manualPriceDate()	Returns the date and time when the manual price of the item was set, or null when it has none.
SelectableExpression	QapiPriceGridLineItem.manualPriceExpired()	Returns whether the manual price of the item is expired.
SelectableExpression	PriceCalculableObjectLineItemColumns.manualResultPrice()	Returns the price that a user set manually on the item, which overrides the calculated price.
SelectableExpression	QapiCompensationRecord.name()
SelectableExpression	QapiCustomer.name()	Returns the name of the customer, usually printed on documents.
SelectableExpression	QapiRebateRecord.name()
SelectableExpression	QapiSeller.name()	Returns the full name of the seller, usually printed on documents.
SelectableExpression	QapiCalculationGrid.nodeId()	Returns the node ID of the Calculation Grid.
SelectableExpression	QapiPriceGrid.nodeId()	Returns the node ID of the Live Price Grid.
SelectableExpression	QapiPriceList.nodeId()	Returns the node ID of the Price List.
SelectableExpression	QapiCalculationGrid.numberOfApprovedItems()	Returns the number of approved items of the Calculation Grid.
SelectableExpression	QapiPriceGrid.numberOfApprovedItems()	Returns the number of approved items of the Live Price Grid.
SelectableExpression	QapiCalculationGrid.numberOfAutoApprovedItems()	Returns the number of automatically approved items of the Calculation Grid.
SelectableExpression	QapiPriceGrid.numberOfAutoApprovedItems()	Returns the number of automatically approved items of the Live Price Grid.
SelectableExpression	QapiCalculationGrid.numberOfDeniedItems()	Returns the number of denied items of the Calculation Grid.
SelectableExpression	QapiPriceGrid.numberOfDeniedItems()	Returns the number of denied items of the Live Price Grid.
SelectableExpression	CalculableObjectColumns.numberOfItems()	Returns the number of items of the object.
SelectableExpression	QapiCalculationGrid.numberOfOpenItems()	Returns the number of open items of the Calculation Grid.
SelectableExpression	QapiPriceGrid.numberOfOpenItems()	Returns the number of open items of the Live Price Grid.
SelectableExpression	QapiCalculationGrid.numberOfSubmittedItems()	Returns the number of items of the Calculation Grid that are submitted for approval.
SelectableExpression	QapiPriceGrid.numberOfSubmittedItems()	Returns the number of items of the Live Price Grid that are submitted for approval.
SelectableExpression	QapiActionItem.originatorLabel()	Returns the label of the object that caused the creation of the Action Item.
SelectableExpression	QapiActionItem.originatorTypedId()	Returns the typed ID of the object that caused the creation of the Action Item.
SelectableExpression	QapiHistoricalConditionRecord.originToken()
SelectableExpression	CalculableLineItemColumns.parentId()	Returns the line ID of the folder that contains the line item.
SelectableExpression	QapiCustomer.parentId()	Returns the ID of the parent customer in the customer hierarchy, or null when the customer has no parent.
SelectableExpression	QapiActionItem.parentLabel()	Returns the label of the parent object.
SelectableExpression	QapiActionItem.parentTabName()	Returns the name of the tab of the parent object on which the Action Item is shown.
SelectableExpression	QapiActionItem.parentTypedId()	Returns the typed ID of the object the Action Item belongs to.
SelectableExpression	QapiCalculationGrid.partialCalculationDate()	Returns the date and time when only part of the items of the Calculation Grid were last recalculated.
SelectableExpression	QapiPriceGrid.partialCalculationDate()	Returns the date and time when only part of the items of the Live Price Grid were last recalculated.
SelectableExpression	QapiCompensationLineItem.payoutDate()	Returns the date on which the compensation is expected to be paid out.
SelectableExpression	QapiCompensationRecord.payoutDate()
SelectableExpression	QapiRebateLineItem.payoutDate()	Returns the date on which the customer expects to receive the rebate.
SelectableExpression	QapiRebateRecord.payoutDate()
SelectableExpression	QapiConditionRecord.preciseConditionValue()	This field is independent of QapiConditionRecord.conditionValue(): the two values are not synchronized, and the logic or integration that writes the record decides which one to fill.
SelectableExpression	QapiHistoricalConditionRecord.preciseConditionValue()	This field is independent of QapiHistoricalConditionRecord.conditionValue(): the two values are not synchronized.
SelectableExpression	QapiPriceGridLineItem.previousCalculationResult(String elementName)	Returns the result of the given logic element as it was before the last approval, read from QapiPriceGridLineItem.previousCalculationResults(), or null if there is no such result.
SelectableExpression	QapiPriceGridLineItem.previousCalculationResults()	Returns all logic element results as they were before the last approval, that is the active results that the last approval replaced.
SelectableExpression	PriceCalculableObjectLineItemColumns.previousPrice()	Returns the price that the price change is measured against.
SelectableExpression	QapiPriceGridLineItem.previousPriceDate()	Returns the date and time when the previous price was approved, that is the active price date that the last approval replaced.
SelectableExpression	QapiPriceList.previousPricelistId()	Returns the ID of the previous version of the Price List, when the Price List is a revision.
SelectableExpression	QapiProductCompetition.price()	Returns the price of the competitor.
SelectableExpression	QapiProductCompetition.priceAPIRecord()	Returns the content of the priceAPIRecord field of the record, stored as text.
SelectableExpression	PriceCalculableObjectLineItemColumns.priceChange()	Returns the absolute change of the result price.
SelectableExpression	QapiPriceGridLineItem.priceChange_ActivePrev()	Returns the absolute change between the active price and the previous price, as recorded at the last approval.
SelectableExpression	PriceCalculableObjectLineItemColumns.priceChangePct()	Returns the relative change of the result price.
SelectableExpression	QapiPriceGridLineItem.priceChangePct_ActivePrev()	Returns the relative change between the active price and the previous price, as recorded at the last approval.
SelectableExpression	QapiPriceGrid.priceGridType()	Returns whether the items of the Live Price Grid have one key, the Stock Keeping Unit (SKU), or two keys, the SKU and key2: SIMPLE or MATRIX.
SelectableExpression	QapiPriceList.pricelistPricegridTypeUniqueName()	Returns the unique name of the Price List type that the Price List was created from.
SelectableExpression	QapiPriceList.pricelistType()	Returns whether the items of the Price List have one key, the Stock Keeping Unit (SKU), or two keys, the SKU and key2: SIMPLE or MATRIX.
SelectableExpression	QapiContractLineItem.priceRecordId()	Returns the ID of the Price Record generated from the line item.
SelectableExpression	QapiQuoteLineItem.priceRecordId()	Returns the ID of the Price Record generated from the line item, or null when none was generated.
SelectableExpression	QapiProductCompetition.priceType()	Returns the type of the competitor price.
SelectableExpression	QapiConditionRecord.priceUnit()
SelectableExpression	QapiHistoricalConditionRecord.priceUnit()
SelectableExpression	QapiProductCompetition.priceUnit()	Returns the price unit of the competitor price.
SelectableExpression	QapiProductCompetition.priority()	Returns the priority of the record.
SelectableExpression	QapiJobStatusTracker.processingEnd()	Returns the date and time when the processing of the job ended.
SelectableExpression	QapiJobStatusTracker.processingNode()	Returns the name of the node that processes the job.
SelectableExpression	QapiJobStatusTracker.processingStart()	Returns the date and time when the processing of the job started.
SelectableExpression	QapiCompensationLineItem.productGroup()	Returns the group of products for which the compensation conditions on the line item are negotiated.
SelectableExpression	QapiCompensationRecord.productGroup()	The value is a product group object, not a String.
SelectableExpression	QapiContractLineItem.productGroup()	Returns the group of products for which the conditions on the line item are negotiated.
SelectableExpression	QapiRebateLineItem.productGroup()	Returns the group of products for which the rebate conditions on the line item are negotiated.
SelectableExpression	QapiRebateRecord.productGroup()	The value is a product group object, not a String.
SelectableExpression	QapiClaim.progress()	The value is the number of processed lines over all lines, for example 40/100.
SelectableExpression	QapiJobStatusTracker.progress()	Returns the progress of the job as text, for example 100%.
SelectableExpression	QapiClaimLineItem.quantity()	Returns the claimed quantity of the product.
SelectableExpression	QapiProductBillOfMaterial.quantity()	Returns how many units of the raw material or sub-component the product needs.
SelectableExpression	QapiClaimLineItem.quoteUniqueName()	Returns the unique name of the Quote that the Claim line is validated against.
SelectableExpression	QapiCompensationRecord.rank()
SelectableExpression	QapiRebateRecord.rank()
SelectableExpression	QapiProductBillOfMaterial.rawMaterial()	Returns the name of the raw material, when the component is a raw material, or null when the component is a sub-component.
SelectableExpression	QapiRebateRecord.rebateRecordGroupUniqueName()	Records of one group can be approved together instead of one by one.
SelectableExpression	QapiRebateRecord.rebateRecordSetLabel()
SelectableExpression	QapiRebateLineItem.rebateTypeLabel()	Returns the label of the Rebate Type of the line item.
SelectableExpression	QapiRebateRecord.rebateTypeUN()	The column is also accessible as the property rebateTypeUniqueName.
SelectableExpression	QapiRebateLineItem.rebateTypeUniqueName()	Returns the unique name of the Rebate Type that the line item represents and calculates.
SelectableExpression	QapiUser.receiveAdminEmail()
SelectableExpression	QapiProductReference.referenceType()	Returns how the two products relate, for example a parent or a cross-sell product.
SelectableExpression	QapiCalculationGrid.relativeTargetDateDays()	Returns the relative target date of the Calculation Grid, as a number of days from the current date.
SelectableExpression	QapiPriceGrid.relativeTargetDateDays()	Returns the relative target date of the Live Price Grid, as a number of days from the current date.
SelectableExpression	QapiSeller.reportsTo()	Returns the seller ID of the seller that this seller reports to.
SelectableExpression	OutputsColumns.OutputColumns.result()	Returns the result of the logic element.
SelectableExpression	PriceCalculableObjectLineItemColumns.resultPrice()	Returns the final price of the item.
SelectableExpression	QapiCustomForm.rootUniqueName()	All revisions of the same form share this value.
SelectableExpression	QapiCompensationRecord.seller()	The value is a seller reference object, not a String.
SelectableExpression	QapiRebateRecord.seller()	The value is a seller reference object, not a String.
SelectableExpression	QapiSeller.sellerId()	Returns the seller ID, the unique key of the seller.
SelectableExpression	QapiSellerExtensionRow.sellerId()	Returns the ID of the seller that the row holds data for.
SelectableExpression	QapiCompensationLineItem.simulationType()	Returns the simulation type of the line item, copied from the Compensation Plan when the line item is calculated.
SelectableExpression	QapiRebateLineItem.simulationType()	Returns the simulation type of the line item.
SelectableExpression	PriceCalculableObjectLineItemColumns.sku()	Returns the Stock Keeping Unit (SKU) of the product the item is calculated for.
SelectableExpression	QapiClaimLineItem.sku()	Returns the Stock Keeping Unit (SKU) of the product claimed by the distributor.
SelectableExpression	QapiProduct.sku()	Returns the Stock Keeping Unit (SKU), the unique key of the product.
SelectableExpression	QapiProductBillOfMaterial.sku()	Returns the Stock Keeping Unit (SKU) of the product that the component belongs to.
SelectableExpression	QapiProductCompetition.sku()	Returns the Stock Keeping Unit (SKU) of your product that the competitor price is for.
SelectableExpression	QapiProductExtensionRow.sku()	Returns the Stock Keeping Unit (SKU) of the product that the row holds data for.
SelectableExpression	QapiProductReference.sku()	Returns the Stock Keeping Unit (SKU) of the product that the reference is created for.
SelectableExpression	QapiQuoteLineItem.sku()	Returns the Stock Keeping Unit (SKU) of the product negotiated on the line item.
SelectableExpression	QapiProductCompetition.source()	Returns the source from which the record was retrieved.
SelectableExpression	QapiClaim.sourceContractUniqueName()
SelectableExpression	QapiCompensationRecord.sourceId()
SelectableExpression	QapiRebateRecord.sourceId()
SelectableExpression	QapiCompensationRecord.sourceIdNoRev()
SelectableExpression	QapiRebateRecord.sourceIdNoRev()
SelectableExpression	QapiClaim.sourceQuoteUniqueName()
SelectableExpression	QapiCompensationLineItem.startDate()	Returns the first day of validity of the conditions on the line item.
SelectableExpression	QapiCompensationRecord.startDate()
SelectableExpression	QapiContractLineItem.startDate()	Returns the first day of validity of the conditions on the line item.
SelectableExpression	QapiRebateLineItem.startDate()	Returns the first day of validity of the conditions on the line item.
SelectableExpression	QapiRebateRecord.startDate()
SelectableExpression	CalculableObjectColumns.status()	Returns the status of the calculation job of the object.
SelectableExpression	QapiActionItem.status()	Returns the status of the Action Item.
SelectableExpression	QapiClaim.status()	The value is the name of one of the CalculationStatus values.
SelectableExpression	QapiCompensationRecord.status()	The value is the name of one of the CompensationRecordStatus values.
SelectableExpression	QapiHistoricalConditionRecord.status()	The possible values are SUPERSEDED (replaced or cut short by a new record), INVALIDATED (invalidated with conditionRecordHelper.invalidate()) and SHORTENED (its validity was shortened with conditionRecordHelper.shortenValidTo()).
SelectableExpression	QapiJobStatusTracker.status()	Returns the status of the job.
SelectableExpression	QapiRebateRecord.status()	The value is the name of one of the RebateRecordStatus values.
SelectableExpression	QapiProductBillOfMaterial.subComponentSku()	Returns the Stock Keeping Unit (SKU) of the product used as a sub-component, when the component is another product, or null when the component is a raw material.
SelectableExpression	QapiCalculationGridLineItem.submitDate()	Returns the date and time when the item was submitted for approval.
SelectableExpression	QapiClaim.submitDate()
SelectableExpression	QapiCustomForm.submitDate()	The value is null until the Custom Form is submitted for approval, or approved directly when no approval is required.
SelectableExpression	QapiPriceGridLineItem.submitDate()	Returns the date and time when the item was submitted for approval.
SelectableExpression	QapiPriceList.submitDate()	Returns the date and time when the Price List was submitted for approval.
SelectableExpression	ApprovableColumns.submittedByName()	Returns the name of the user who submitted the row for approval.
SelectableExpression	QapiActionItem.summary()	Returns the short description of the required action.
SelectableExpression	CalculableObjectLineItemColumns.tainted()	Returns the flag that marks an item that was changed or updated externally and needs recalculation.
SelectableExpression	CalculableObjectColumns.targetDate()	Returns the target date of the object.
SelectableExpression	QapiClaim.targetDate()
SelectableExpression	QapiJobStatusTracker.targetObject()	Returns the typed ID of the object that the job runs for, for example 2147485082.DMDL for a Data Load.
SelectableExpression	QapiProductReference.targetSku()	Returns the Stock Keeping Unit (SKU) of the referenced product.
SelectableExpression	QapiJobStatusTracker.threadUUID()	Returns the universally unique identifier (UUID) of the thread that processes the job.
SelectableExpression	QapiClaimLineItem.totalAmount()	Returns the amount of money claimed by the distributor on the line.
SelectableExpression	QapiJobStatusTracker.trackerType()	Returns the type of the job, for example PRICELIST, PRICEGRID, CFS, PADATALOAD or CALCULATIONFLOW.
SelectableExpression	QapiProductBillOfMaterial.type()	Returns the type of the component: RAWMATERIAL or SUBCOMPONENT.
SelectableExpression	QapiActionItem.uniqueName()	Returns the unique name of the Action Item.
SelectableExpression	QapiClaim.uniqueName()
SelectableExpression	QapiCompanyParameterTable.uniqueName()	Returns the unique name of the Company Parameter table.
SelectableExpression	QapiCompensationRecord.uniqueName()
SelectableExpression	QapiCustomForm.uniqueName()	A revision gets a new unique name derived from the unique name of the original Custom Form, by default in the format <original unique name>-REV-<revision number>.
SelectableExpression	QapiRebateRecord.uniqueName()
SelectableExpression	PriceCalculableObjectLineItemColumns.unitOfMeasure()	Returns the unit of measure of the price.
SelectableExpression	QapiConditionRecord.unitOfMeasure()
SelectableExpression	QapiHistoricalConditionRecord.unitOfMeasure()
SelectableExpression	QapiProduct.unitOfMeasure()	Returns the default unit of measure of the product, for example KG or PCS.
SelectableExpression	QapiProductCompetition.unitOfMeasure()	Returns the unit of measure of the competitor price.
SelectableExpression	QapiCompanyParameterRow.upperBound()	Returns the upper bound of the range of the row.
SelectableExpression	OutputsColumns.OutputColumns.userGroup()	Returns the user group set on the logic element, which restricts which users can see its result.
SelectableExpression	QapiCalculationGrid.userGroupEdit()	Returns the user group whose members can edit the Calculation Grid.
SelectableExpression	QapiCompanyParameterTable.userGroupEdit()	Returns the user group whose members can edit the Company Parameter table.
SelectableExpression	QapiCompensationRecord.userGroupEdit()
SelectableExpression	QapiCustomer.userGroupEdit()	Returns the user group whose members can edit the customer.
SelectableExpression	QapiCustomForm.userGroupEdit()
SelectableExpression	QapiPriceGrid.userGroupEdit()	Returns the user group whose members can edit the Live Price Grid.
SelectableExpression	QapiPriceList.userGroupEdit()	Returns the user group whose members can edit the Price List.
SelectableExpression	QapiProduct.userGroupEdit()	Returns the user group whose members can edit the product.
SelectableExpression	QapiRebateRecord.userGroupEdit()
SelectableExpression	QapiSeller.userGroupEdit()	Returns the user group whose members can edit the seller.
SelectableExpression	QapiCalculationGrid.userGroupViewDetails()	Returns the user group whose members can view the details of the Calculation Grid.
SelectableExpression	QapiCompanyParameterTable.userGroupViewDetails()	Returns the user group whose members can view the details of the Company Parameter table.
SelectableExpression	QapiCompensationRecord.userGroupViewDetails()
SelectableExpression	QapiCustomer.userGroupViewDetails()	Returns the user group whose members can view the details of the customer.
SelectableExpression	QapiCustomForm.userGroupViewDetails()
SelectableExpression	QapiPriceGrid.userGroupViewDetails()	Returns the user group whose members can view the details of the Live Price Grid.
SelectableExpression	QapiPriceList.userGroupViewDetails()	Returns the user group whose members can view the details of the Price List.
SelectableExpression	QapiProduct.userGroupViewDetails()	Returns the user group whose members can view the details of the product.
SelectableExpression	QapiRebateRecord.userGroupViewDetails()
SelectableExpression	QapiSeller.userGroupViewDetails()	Returns the user group whose members can view the details of the seller.
SelectableExpression	QapiCompanyParameterTable.validAfter()	Returns the date after which the Company Parameter table can be used.
SelectableExpression	QapiClaimLineItem.validationState()	Returns whether the Claim line is validated or rejected.
SelectableExpression	QapiConditionRecord.validFrom()
SelectableExpression	QapiHistoricalConditionRecord.validFrom()
SelectableExpression	QapiConditionRecord.validTo()
SelectableExpression	QapiHistoricalConditionRecord.validTo()
SelectableExpression	InputsColumns.InputColumns.value()	Returns the value of the input.
SelectableExpression	QapiCompanyParameterRow.value()	Returns the value of the row.
SelectableExpression	PersistedObjectColumns.version()	Returns the version of the row.
SelectableExpression	CalculableObjectLineItemColumns.warnings()	Returns the warnings triggered for the item by the last calculation, for all fields.
SelectableExpression	QapiUser.wizardDashboardName()
SelectableExpression	QapiUser.workflowEmailingActivated()
SelectableExpression	ApprovableColumns.workflowStatus()	Returns the status of the approval workflow attached to the row.
SelectableExpression	CalculableObjectLineItemColumns.workStatus()	Returns the work status of the item.