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 |
| SalesOrderQuoteId [KEY] | Long | Unique Id of the sales quote | |
| SalesOrderQuoteDocumentNo | String | Sales quote document number. | |
| SalesOrderQuoteDocumentDate | Date | Sales quote date. | |
| SalesOrderQuoteDocumentStatus | String | Sales quote status. See sop_document_status_types | |
| SalesOrderQuoteCustomerDocumentNo | String | Customer sales quote document number. | |
| SalesOrderQuoteCurrencyId | Long | The Id for the currency used for the sales quote. See currencies | |
| SalesOrderQuoteCurrencyName | String | The name for the currency used for the sales quote. | |
| SalesOrderQuoteCurrencySymbol | String | The symbol of the currency used for the sales quote. | |
| SalesOrderQuoteExchangeRate | Decimal | Exchange rate for the sales quote. | |
| SalesOrderQuoteRequestedDeliveryDate | Date | Requested delivery date. | |
| SalesOrderQuotePromisedDeliveryDate | Date | Promised delivery date. | |
| SalesOrderQuoteAnalysisCode1 | String | Analysis code 1. | |
| SalesOrderQuoteAnalysisCode2 | String | Analysis code 2. | |
| SalesOrderQuoteAnalysisCode3 | String | Analysis code 3. | |
| SalesOrderQuoteAnalysisCode4 | String | Analysis code 4. | |
| SalesOrderQuoteAnalysisCode5 | String | Analysis code 5. | |
| SalesOrderQuoteAnalysisCode6 | String | Analysis code 6. | |
| SalesOrderQuoteAnalysisCode7 | String | Analysis code 7. | |
| SalesOrderQuoteAnalysisCode8 | String | Analysis code 8. | |
| SalesOrderQuoteAnalysisCode9 | String | Analysis code 9. | |
| SalesOrderQuoteAnalysisCode10 | String | Analysis code 10. | |
| SalesOrderQuoteAnalysisCode11 | String | Analysis code 11. | |
| SalesOrderQuoteAnalysisCode12 | String | Analysis code 12. | |
| SalesOrderQuoteAnalysisCode13 | String | Analysis code 13. | |
| SalesOrderQuoteAnalysisCode14 | String | Analysis code 14. | |
| SalesOrderQuoteAnalysisCode15 | String | Analysis code 15. | |
| SalesOrderQuoteAnalysisCode16 | String | Analysis code 16. | |
| SalesOrderQuoteAnalysisCode17 | String | Analysis code 17. | |
| SalesOrderQuoteAnalysisCode18 | String | Analysis code 18. | |
| SalesOrderQuoteAnalysisCode19 | String | Analysis code 19. | |
| SalesOrderQuoteAnalysisCode20 | String | Analysis code 20. | |
| SalesOrderQuoteDateTimeUpdated | Datetime | The date and time the sales quote was last updated (UTC). | |
| SalesOrderQuoteLineId | Long | Associated sales quote line Id | |
| SalesOrderQuoteLineNumber | Short | Sales quote line number. | |
| SalesOrderQuoteLineType | String | Sales quote line type. See order_return_line_types | |
| SalesOrderQuoteLineProductCode | String | Sales quote line product code. | |
| SalesOrderQuoteLineProductDescription | String | Sales quote line product description. This could be stock item description, free text, additional charge or comment. | |
| SalesOrderQuoteLineQuantity | Decimal | The line quantity. | |
| SalesOrderQuoteLineSellingUnitDescription | String | The selling unit description. | |
| SalesOrderQuoteLineSellingUnitPrice | Decimal | The selling price per item. | |
| SalesOrderQuoteLineUnitDiscountPercent | Decimal | The percentage discount per item. | |
| SalesOrderQuoteLineUnitDiscountValue | Decimal | The discount value per item. | |
| SalesOrderQuoteLineCostPrice | Decimal | The cost price. | |
| SalesOrderQuoteLineTotalValue | Decimal | The total value of the line. | |
| SalesOrderQuoteLineLineTaxValue | Decimal | The tax value of the line. | |
| SalesOrderQuoteLineDiscountedUnitPrice | 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. | |
| SalesOrderQuoteLineRequestedDeliveryDate | Date | Requested delivery date. | |
| SalesOrderQuoteLinePromisedDeliveryDate | Date | Promised delivery date. | |
| SalesOrderQuoteLineAnalysisCode1 | String | Analysis code 1. | |
| SalesOrderQuoteLineAnalysisCode2 | String | Analysis code 2. | |
| SalesOrderQuoteLineAnalysisCode3 | String | Analysis code 3. | |
| SalesOrderQuoteLineAnalysisCode4 | String | Analysis code 4. | |
| SalesOrderQuoteLineAnalysisCode5 | String | Analysis code 5. | |
| SalesOrderQuoteLineAnalysisCode6 | String | Analysis code 6. | |
| SalesOrderQuoteLineAnalysisCode7 | String | Analysis code 7. | |
| SalesOrderQuoteLineAnalysisCode8 | String | Analysis code 8. | |
| SalesOrderQuoteLineAnalysisCode9 | String | Analysis code 9. | |
| SalesOrderQuoteLineAnalysisCode10 | String | Analysis code 10. | |
| SalesOrderQuoteLineAnalysisCode11 | String | Analysis code 11. | |
| SalesOrderQuoteLineAnalysisCode12 | String | Analysis code 12. | |
| SalesOrderQuoteLineAnalysisCode13 | String | Analysis code 13. | |
| SalesOrderQuoteLineAnalysisCode14 | String | Analysis code 14. | |
| SalesOrderQuoteLineAnalysisCode15 | String | Analysis code 15. | |
| SalesOrderQuoteLineAnalysisCode16 | String | Analysis code 16. | |
| SalesOrderQuoteLineAnalysisCode17 | String | Analysis code 17. | |
| SalesOrderQuoteLineAnalysisCode18 | String | Analysis code 18. | |
| SalesOrderQuoteLineAnalysisCode19 | String | Analysis code 19. | |
| SalesOrderQuoteLineAnalysisCode20 | String | Analysis code 20. | |
| SalesOrderQuoteLineDateTimeUpdated | 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. |