JDBC Driver for Xero WorkflowMax

Build 22.0.8462

PurchaseOrderCosts

Return all purchase order costs

Select

The driver will process all filters client side.

Insert

Description, Quantity, UnitCost, Code, Note are required to insert into the temporary table. The following query creates a new PurchaseOrderCost entry in memory:

INSERT INTO PurchaseOrderCosts#TEMP (Description, Quantity, UnitCost, Code, Note) VALUES ('hey descr', 4, 50, '123', 'note')

After inserting to PurchaseOrderCosts#TEMP, you have all the items you need to insert the PurchaseOrder. See PurchaseOrders for more details on inserting to Purchase Orders.

Columns

Name Type Description
PurchaseOrderID [KEY] String Since costs don't have an identifier this is the Purchase order identifier which references PurchaseOrders.ID
Description String The description related to teh cost
Code String The code of the unit.
Quantity Int Product quantity.
UnitCost Float Cost per unit.
Amount Float The amount to pay.
AmountTax Float The tax amount to pay.
AmountIncludingTax Float The total amount to pay including tax.
Note String The note related to the cost.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462