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 |
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. |