PurchaseOrders

Purchase orders are used to represent the purchase of goods or services from a supplier. They are central to a business and define the terms (price, quantity and times) by which the products or services will be received.

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 PurchaseOrders WHERE Id = 42101
SELECT * FROM PurchaseOrders WHERE DocumentNo = '0000000001'
SELECT * FROM PurchaseOrders WHERE ExchangeRate = 'Sample'

Columns


Name	Type	References	Description
Id [KEY]	Long		Purchase order record Id.
DocumentNo	String		Purchase order document number. Note: If the POP setting in Sage 200c Professional, then this property MUST be set.
DocumentDate	Date		Purchase order document date.
DocumentStatus	String		Document status. See pop_document_status_types
AuthorisationStatus	String		Authorisation status. See pop_authorisation_status_types
SupplierId	Long	Suppliers.Id	Supplier record Id. See suppliers
ExchangeRate	Decimal		Exchange rate.
SubtotalGoodsValue	Decimal		Goods value (sum of stock items and free text).
SubtotalChargesNetValue	Decimal		Charges net value.
SubtotalDiscountValue	Decimal		Discount value.
SubtotalLandedCostsValue	Decimal		Landed costs value.
TotalNetValue	Decimal		Net value (sum of all line types).
TotalTaxValue	Decimal		Tax value.
TotalGrossValue	Decimal		Gross value.
SupplierDocumentNo	String		Supplier document number.
SettlementDiscountDays	Short		Settlement discount days.
SettlementDiscountPercent	Decimal		Settlement discount percent.
DocumentDiscountPercent	Decimal		Document discount percent.
DocumentOriginatorId	Long		Document originator id. See users
DocumentOriginatorName	String		Document originator name.
DocumentCreatedById	Long		Document created by id. See users
DocumentCreatedBy	String		Document created by.
RequestedDeliveryDate	Date		Requested delivery date.
AnalysisCode1	String		Analysis code 1.
AnalysisCode2	String		Analysis code 2.
AnalysisCode3	String		Analysis code 3.
AnalysisCode4	String		Analysis code 4.
AnalysisCode5	String		Analysis code 5.
Lines	String		The purchase order lines collection. See pop_order_lines
DeliveryAddress_1	String		The delivery address line 1.
DeliveryAddress_2	String		The delivery address line 2.
DeliveryAddress_3	String		The delivery address line 3.
DeliveryAddress_4	String		The delivery address line 4.
DeliveryAddressCity	String		The delivery address city.
DeliveryAddressCounty	String		The delivery address county.
DeliveryAddressPostcode	String		The delivery address postcode.
DeliveryAddressContact	String		The delivery address contact.
DateTimeUpdated	Datetime		The date and time this entity was last updated (UTC).

ADO.NET Provider for Sage 200

PurchaseOrders

Table Specific Information

Select

Columns