ODBC Driver for Sage 200

Build 23.0.8839


This resource returns a view of sales pro formas, sales pro forma lines, customers, products, warehouses, tax codes and currencies that can be queried on any field. The default sort (orderby) field are by 'sop_proforma_id' and 'sop_proforma_line_id' descending.

Table Specific Information


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 SalesOrderProformaLines WHERE SalesOrderProformaId = 346345654564565
SELECT * FROM SalesOrderProformaLines WHERE SalesOrderProformaDocumentStatus = 'Sample'


Name Type References Description
SalesOrderProformaId [KEY] Long Unique Id of the sales pro forma
SalesOrderProformaDocumentNo String Sales pro forma document number.
SalesOrderProformaDocumentDate Date Sales pro forma date.
SalesOrderProformaDocumentStatus String Sales pro forma status. See sop_document_status_types
SalesOrderProformaCustomerDocumentNo String Customer sales pro forma document number.
SalesOrderProformaCurrencyId Long The Id for the currency used for the sales pro forma. See currencies
SalesOrderProformaCurrencyName String The name for the currency used for the sales pro forma.
SalesOrderProformaCurrencySymbol String The symbol of the currency used for the sales pro forma.
SalesOrderProformaExchangeRate Decimal Exchange rate for the sales pro forma.
SalesOrderProformaRequestedDeliveryDate Date Requested delivery date.
SalesOrderProformaPromisedDeliveryDate Date Promised delivery date.
SalesOrderProformaAnalysisCode1 String Analysis code 1.
SalesOrderProformaAnalysisCode2 String Analysis code 2.
SalesOrderProformaAnalysisCode3 String Analysis code 3.
SalesOrderProformaAnalysisCode4 String Analysis code 4.
SalesOrderProformaAnalysisCode5 String Analysis code 5.
SalesOrderProformaDateTimeUpdated Datetime The date and time the sales pro forma was last updated (UTC).
SalesOrderProformaLineId Long Associated sales pro forma line Id
SalesOrderProformaLineNumber Short Sales pro forma line number.
SalesOrderProformaLineType String Sales pro forma line type. See order_return_line_types
SalesOrderProformaLineProductCode String Sales pro forma line product code.
SalesOrderProformaLineProductDescription String Sales pro forma line product description. This could be stock item description, free text, additional charge or comment.
SalesOrderProformaLineQuantity Decimal The line quantity.
SalesOrderProformaLineSellingUnitDescription String The selling unit description.
SalesOrderProformaLineSellingUnitPrice Decimal The selling price per item.
SalesOrderProformaLineUnitDiscountPercent Decimal The percentage discount per item.
SalesOrderProformaLineUnitDiscountValue Decimal The discount value per item.
SalesOrderProformaLineCostPrice Decimal The cost price.
SalesOrderProformaLineTotalValue Decimal The total value of the line.
SalesOrderProformaLineLineTaxValue Decimal The tax value of the line.
SalesOrderProformaLineDiscountedUnitPrice Decimal The discounted unit price of the line. This is calculated by subtracting the sop_proforma_line_unit_discount_value from the sop_proforma_line_selling_unit_price.
SalesOrderProformaLineRequestedDeliveryDate Date Requested delivery date.
SalesOrderProformaLinePromisedDeliveryDate Date Promised delivery date.
SalesOrderProformaLineAnalysisCode1 String Analysis code 1.
SalesOrderProformaLineAnalysisCode2 String Analysis code 2.
SalesOrderProformaLineAnalysisCode3 String Analysis code 3.
SalesOrderProformaLineAnalysisCode4 String Analysis code 4.
SalesOrderProformaLineAnalysisCode5 String Analysis code 5.
SalesOrderProformaLineAnalysisCode6 String Analysis code 6.
SalesOrderProformaLineAnalysisCode7 String Analysis code 7.
SalesOrderProformaLineAnalysisCode8 String Analysis code 8.
SalesOrderProformaLineAnalysisCode9 String Analysis code 9.
SalesOrderProformaLineAnalysisCode10 String Analysis code 10.
SalesOrderProformaLineAnalysisCode11 String Analysis code 11.
SalesOrderProformaLineAnalysisCode12 String Analysis code 12.
SalesOrderProformaLineAnalysisCode13 String Analysis code 13.
SalesOrderProformaLineAnalysisCode14 String Analysis code 14.
SalesOrderProformaLineAnalysisCode15 String Analysis code 15.
SalesOrderProformaLineAnalysisCode16 String Analysis code 16.
SalesOrderProformaLineAnalysisCode17 String Analysis code 17.
SalesOrderProformaLineAnalysisCode18 String Analysis code 18.
SalesOrderProformaLineAnalysisCode19 String Analysis code 19.
SalesOrderProformaLineAnalysisCode20 String Analysis code 20.
SalesOrderProformaLineDateTimeUpdated Datetime The date and time the sop pro forma 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_proforma_line_type = EnumLineTypeStandard. See products
ProductCode String The code of the product ordered. Only returned where sop_proforma_line_type = EnumLineTypeStandard
ProductName String The name of the product ordered. Only returned where sop_proforma_line_type = EnumLineTypeStandard
ProductDescription String The associated product description. Only returned where sop_proforma_line_type = EnumLineTypeStandard
WarehouseId Long The id of the warehouse the product is stored in. Only returned where sop_proforma_line_type = EnumLineTypeStandard. See warehouses
WarehouseName String The name of the warehouse. Only returned where sop_proforma_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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839