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