SalesOrderQuoteLines
This resource returns a view of sales quotes, sales quote lines, customers, products, warehouses, tax codes and currencies that can be queried on any field. The default sort (orderby) field are by 'sop_quote_id' and 'sop_quote_line_id' descending.
Table Specific Information
Select
The driver uses the Sage 200c Standard Online API to process all search criteria.
Supported operators are: =, < , <= , > , >= , != , AND, LIKE , IS NULL , IS NOT NULL.
For example, the following queries are processed server side:
SELECT * FROM SalesOrderQuoteLines WHERE SalesOrderQuoteId = 3424324324324 SELECT * FROM SalesOrderQuoteLines WHERE SalesOrderQuoteDocumentNo = 'Sample' SELECT * FROM SalesOrderQuoteLines WHERE SalesOrderQuoteCustomerDocumentNo = 'Sample'
Columns
Name | Type | References | Description |
QuoteId [KEY] | Long | Unique Id of the sales quote | |
QuoteDocumentNo | String | Sales quote document number. | |
QuoteDocumentDate | Date | Sales quote date. | |
QuoteDocumentStatus | String | Sales quote status. See sop_document_status_types | |
QuoteCustomerDocumentNo | String | Customer sales quote document number. | |
QuoteCurrencyId | Long | The Id for the currency used for the sales quote. See currencies | |
QuoteCurrencyName | String | The name for the currency used for the sales quote. | |
QuoteCurrencySymbol | String | The symbol of the currency used for the sales quote. | |
QuoteExchangeRate | Decimal | Exchange rate for the sales quote. | |
QuoteRequestedDeliveryDate | Date | Requested delivery date. | |
QuotePromisedDeliveryDate | Date | Promised delivery date. | |
QuoteAnalysisCode1 | String | Analysis code 1. | |
QuoteAnalysisCode2 | String | Analysis code 2. | |
QuoteAnalysisCode3 | String | Analysis code 3. | |
QuoteAnalysisCode4 | String | Analysis code 4. | |
QuoteAnalysisCode5 | String | Analysis code 5. | |
QuoteDateTimeUpdated | Datetime | The date and time the sales quote was last updated (UTC). | |
QuoteLineId | Long | Associated sales quote line Id | |
QuoteLineNumber | Short | Sales quote line number. | |
QuoteLineType | String | Sales quote line type. See order_return_line_types | |
QuoteLineProductCode | String | Sales quote line product code. | |
QuoteLineProductDescription | String | Sales quote line product description. This could be stock item description, free text, additional charge or comment. | |
QuoteLineQuantity | Decimal | The line quantity. | |
QuoteLineSellingUnitDescription | String | The selling unit description. | |
QuoteLineSellingUnitPrice | Decimal | The selling price per item. | |
QuoteLineUnitDiscountPercent | Decimal | The percentage discount per item. | |
QuoteLineUnitDiscountValue | Decimal | The discount value per item. | |
QuoteLineCostPrice | Decimal | The cost price. | |
QuoteLineTotalValue | Decimal | The total value of the line. | |
QuoteLineLineTaxValue | Decimal | The tax value of the line. | |
QuoteLineDiscountedUnitPrice | Decimal | The discounted unit price of the line. This is calculated by subtracting the sop_quote_line_unit_discount_value from the sop_quote_line_selling_unit_price. | |
QuoteLineRequestedDeliveryDate | Date | Requested delivery date. | |
QuoteLinePromisedDeliveryDate | Date | Promised delivery date. | |
QuoteLineAnalysisCode1 | String | Analysis code 1. | |
QuoteLineAnalysisCode2 | String | Analysis code 2. | |
QuoteLineAnalysisCode3 | String | Analysis code 3. | |
QuoteLineAnalysisCode4 | String | Analysis code 4. | |
QuoteLineAnalysisCode5 | String | Analysis code 5. | |
QuoteLineDateTimeUpdated | Datetime | The date and time the sop quote line was last updated (UTC). | |
CustomerId | Long | The associated customer record Id. See customers | |
CustomerReference | String | The associated customer account reference. | |
CustomerName | String | The associated customer name. | |
ProductId | Long | The associated product record Id. Only returned where sop_quote_line_type = EnumLineTypeStandard. See products | |
ProductCode | String | The code of the product ordered. Only returned where sop_quote_line_type = EnumLineTypeStandard | |
ProductName | String | The name of the product ordered. Only returned where sop_quote_line_type = EnumLineTypeStandard | |
ProductDescription | String | The associated product description. Only returned where sop_quote_line_type = EnumLineTypeStandard | |
WarehouseId | Long | The id of the warehouse the product is stored in. Only returned where sop_quote_line_type = EnumLineTypeStandard. See warehouses | |
WarehouseName | String | The name of the warehouse. Only returned where sop_quote_line_type = EnumLineTypeStandard | |
TaxCodeId | Long | The id of the tax code set on the line. See tax_codes | |
TaxCodeCode | Short | The associated tax code. | |
TaxCodeName | String | The associated tax code name. | |
TaxCodeRate | Decimal | The associated tax rate. |