ODBC Driver for Sage 200

Build 20.0.7587

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.
AnalysisCode6 String Analysis code 6.
AnalysisCode7 String Analysis code 7.
AnalysisCode8 String Analysis code 8.
AnalysisCode9 String Analysis code 9.
AnalysisCode10 String Analysis code 10.
AnalysisCode11 String Analysis code 11.
AnalysisCode12 String Analysis code 12.
AnalysisCode13 String Analysis code 13.
AnalysisCode14 String Analysis code 14.
AnalysisCode15 String Analysis code 15.
AnalysisCode16 String Analysis code 16.
AnalysisCode17 String Analysis code 17.
AnalysisCode18 String Analysis code 18.
AnalysisCode19 String Analysis code 19.
AnalysisCode20 String Analysis code 20.
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).

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587