Costs
Return a list of all costs
Select
The 本製品 will use the Xero WorkflowMax API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client-side within the driver. Specifically, the following are processed server-side:
- UUID supports the '=' operator.
All filterable columns allow multiple values to be specified by using the IN operator.
Response time from the server can be improved by identifying only the rows you want to retrieve.
SELECT * FROM Costs WHERE UUID = '9d382fcf-7013-4d97-8dd8-c08e8b26a0b2' SELECT * FROM Costs WHERE UUID IN ('9d382fcf-7013-4d97-8dd8-c08e8b26a0b2', '9d382fcf-7013-4d97-8dd8-c08e8b26av43')
Insert
Description, UnitPrice, UnitCost are required to insert. The following query creates a new Cost:
INSERT INTO Costs (Description, UnitPrice, UnitCost) VALUES ('decr', 100, 200)
Update
You can update a Cost by specifying the Cost UUID:
UPDATE Costs SET UnitPrice = '101' WHERE UUID = '9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'
Delete
Delete a Cost by specifying the Cost UUID:
DELETE FROM Costs WHERE UUID = '9d382fcf-7013-4d97-8dd8-c08e8b26a0b2'
Columns
Name | Type | ReadOnly | Description |
UUID [KEY] | String | True |
The Id of the Cost. |
Description | String | False |
The description related to the cost. |
Code | String | False |
The code of the unit. |
Note | String | False |
The note related to the cost. |
UnitCost | Float | False |
Cost per unit. |
UnitPrice | Float | False |
Price per unit. |
SupplierUUID | String | False |
Determines the supplier identifier. |
SupplierName | String | True |
Determines the supplier name. |