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

Interface QapiQuoteLineItem

All Superinterfaces:

CalculableLineItemColumns, ClicColumns, InputsColumns, Map<String,SelectableExpression>, OutputsColumns, PersistedObjectColumns, Tables.Columns, Tables.Table

public interface QapiQuoteLineItem
extends Tables.Table, PersistedObjectColumns, ClicColumns

Table of the line items of one Quote. Each row is one line item, which negotiates one product, or one folder.

Example:

 def q = api.queryApi()
 def t = q.tables().quoteLineItems("P-1234")

 return q.source(t, [t.lineId(), t.sku(), t.label(), t.priceRecordId()], t.sku().isNotNull())
         .stream { it.collect { it } }
 

Since:

14.0 - Caribou Lou

See Also:

• Tables
• Quote Line Item (QLI)

Nested Class Summary

Nested classes/interfaces inherited from interface ClicColumns

ClicColumns.InputColumns, ClicColumns.OutputColumns

Nested classes/interfaces inherited from interface Map

Map.Entry<K,V>

Method Summary

Modifier and Type	Method	Description
SelectableExpression	priceRecordId()	Returns the ID of the Price Record generated from the line item, or null when none was generated.
SelectableExpression	sku()	Returns the Stock Keeping Unit (SKU) of the product negotiated on the line item.

Methods inherited from interface CalculableLineItemColumns

calculationStatus, dirty, editabilityStatus, label, lineId, parentId

Methods inherited from interface ClicColumns

input, output

Methods inherited from interface Map

clear, compute, computeIfAbsent, computeIfPresent, containsKey, containsValue, entrySet, equals, forEach, get, getOrDefault, hashCode, isEmpty, keySet, merge, put, putAll, putIfAbsent, remove, remove, replace, replace, replaceAll, size, values

Methods inherited from interface PersistedObjectColumns

createDate, createdBy, id, lastUpdateBy, lastUpdateDate, version

Method Details

sku

SelectableExpression sku()

Returns the Stock Keeping Unit (SKU) of the product negotiated on the line item.

Folders have no SKU.

Returns:

the sku column as a String expression

priceRecordId

SelectableExpression priceRecordId()

Returns the ID of the Price Record generated from the line item, or null when none was generated.

Price Records are generated from the line items when an approved Quote is converted to Price Records.

Returns:

the priceRecordId column as an Integer expression