Power BI Connector for Sage 200

Build 24.0.9062

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

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