SSIS Components for Sage 200

Build 20.0.7587

SalesOrderProformaLines

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

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

Columns

Name Type References Description
ProformaId [KEY] Long Unique Id of the sales pro forma
ProformaDocumentNo String Sales pro forma document number.
ProformaDocumentDate Date Sales pro forma date.
ProformaDocumentStatus String Sales pro forma status. See sop_document_status_types
ProformaCustomerDocumentNo String Customer sales pro forma document number.
ProformaCurrencyId Long The Id for the currency used for the sales pro forma. See currencies
ProformaCurrencyName String The name for the currency used for the sales pro forma.
ProformaCurrencySymbol String The symbol of the currency used for the sales pro forma.
ProformaExchangeRate Decimal Exchange rate for the sales pro forma.
ProformaRequestedDeliveryDate Date Requested delivery date.
ProformaPromisedDeliveryDate Date Promised delivery date.
ProformaAnalysisCode1 String Analysis code 1.
ProformaAnalysisCode2 String Analysis code 2.
ProformaAnalysisCode3 String Analysis code 3.
ProformaAnalysisCode4 String Analysis code 4.
ProformaAnalysisCode5 String Analysis code 5.
ProformaDateTimeUpdated Datetime The date and time the sales pro forma was last updated (UTC).
ProformaLineId Long Associated sales pro forma line Id
ProformaLineNumber Short Sales pro forma line number.
ProformaLineType String Sales pro forma line type. See order_return_line_types
ProformaLineProductCode String Sales pro forma line product code.
ProformaLineProductDescription String Sales pro forma line product description. This could be stock item description, free text, additional charge or comment.
ProformaLineQuantity Decimal The line quantity.
ProformaLineSellingUnitDescription String The selling unit description.
ProformaLineSellingUnitPrice Decimal The selling price per item.
ProformaLineUnitDiscountPercent Decimal The percentage discount per item.
ProformaLineUnitDiscountValue Decimal The discount value per item.
ProformaLineCostPrice Decimal The cost price.
ProformaLineTotalValue Decimal The total value of the line.
ProformaLineLineTaxValue Decimal The tax value of the line.
ProformaLineDiscountedUnitPrice 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.
ProformaLineRequestedDeliveryDate Date Requested delivery date.
ProformaLinePromisedDeliveryDate Date Promised delivery date.
ProformaLineAnalysisCode1 String Analysis code 1.
ProformaLineAnalysisCode2 String Analysis code 2.
ProformaLineAnalysisCode3 String Analysis code 3.
ProformaLineAnalysisCode4 String Analysis code 4.
ProformaLineAnalysisCode5 String Analysis code 5.
ProformaLineDateTimeUpdated 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587