Items
Return, update, create and delete inventory items for an AccountRight company file.
Table Specific Information
Select
MYOB allows a subset of columns to be used in the WHERE clause of a SELECT query. These columns may be used with the following operators: =, !=, >, <, >=, <=. In addition, queries with multiple criteria can be executed by combining the criteria with AND and OR operators.
These columns support the above comparison types for server side filtering: ID, AverageCost, BaseSellingPrice, IsActive, IsBought, IsInventoried, IsSold, Name, Number, CurrentValue, Description, UseDescription, AssetAccountID, AssetAccountDisplayID, AssetAccountName, BuyingUnitOfMeasure, BuyingItemsPerBuyingUnit, BuyingLastPurchasePrice, BuyingStandardCost, RestockingSupplierID, RestockingSupplierDisplayID, RestockingSupplierItemNumber, RestockingSupplierName, RestockingDefaultOrderQuantity, RestockingMinimumLevelForRestockingAlert, BuyingTaxCodeID, BuyingTaxCodeCode, CostOfSalesAccountID, CostOfSalesAccountDisplayID, CostOfSalesAccountName, IncomeAccountID, IncomeAccountDisplayID, IncomeAccountName, ExpenseAccountID, ExpenseAccountDisplayID, ExpenseAccountName, QuantityAvailable, QuantityCommitted, QuantityOnHand, QuantityOnOrder, SellingBaseSellingPrice, SellingCalculateSalesTaxOn, SellingIsTaxInclusive, SellingItemsPerSellingUnit, SellingUnitOfMeasure, SellingTaxCodeID, SellingTaxCodeCode. All the other columns and operators are processed client side.
SELECT * FROM Items WHERE ID = "d5ab0fd1-3bf4-4230-bbaf-90b26ea9afda" OR ID = "59aa54c8-6793-4a63-bda9-55451fa3976e" SELECT * FROM Items WHERE AverageCost = 21.38 OR BaseSellingPrice = 11.95 SELECT * FROM Items WHERE IsActive = true
Insert
The following attribute is required when performing an insert: Number.
INSERT INTO Items (Number) VALUES ("429")
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. | |
AverageCost | Decimal | True |
Item's average cost when the quantity on hand is equal to or greater than zero. | |
BaseSellingPrice | Decimal | True |
Item's base selling price inclusive of tax. | |
IsActive | Boolean | False |
Please note: Defaults to true if left blank on POST. True indicates the item is active. False indicates the item is inactive. | |
IsBought | Boolean | False |
True indicates the item is bought. False indicates the item is not bought. | |
IsInventoried | Boolean | False |
True indicates the item is inventoried. False indicates the item is not inventoried. | |
IsSold | Boolean | False |
True indicates the item is sold. False indicates the item is not sold. | |
Name | String | False |
Name of the object. | |
Number | String | False |
Item number. | |
PhotoURI | String | False |
Uniform resource identifier associated with a photo image. | |
PriceMatrixURI | String | False |
Please note: Only available if Item IsSold = true. | |
CurrentValue | Decimal | True |
Dollar value of units held in inventory. | |
Description | String | False |
Description of the object. | |
UseDescription | Boolean | False |
True indicates to use the description text instead of item name on sale invoices and purchase orders. False indicates not to use the item description on sales and purchases. | |
AssetAccountID | Uuid | False |
Accounts.ID |
Unique identifier for the account in the form of a guid. |
AssetAccountDisplayID | String | True |
Account code. Format includes separator ie 4-1100 | |
AssetAccountName | String | True |
Name of the account. | |
AssetAccountURI | String | True |
Uniform resource identifier associated with the account object. | |
BuyingUnitOfMeasure | String | False |
Description of the unit type the item is purchased with, ie: kg, hour. | |
BuyingItemsPerBuyingUnit | Decimal | False |
Number of items per buying unit. Note: if is IsInventoried = false null is returned. | |
BuyingLastPurchasePrice | Decimal | True |
The item's tax inclusive price per unit when last purchased. | |
BuyingStandardCost | Decimal | False |
Standard purchase price for one buying unit of this item. | |
RestockingSupplierID | Uuid | False |
Contacts.ID |
Unique guid identifier belonging to the assigned supplier contact. |
RestockingSupplierDisplayID | String | True |
Customer contact Card ID, can also be used as a unique supplier contact identifier. | |
RestockingSupplierItemNumber | String | False |
Number or code supplier has assigned to the item. | |
RestockingSupplierName | String | True |
Name of the supplier contact. | |
RestockingSupplierURI | String | True |
Uniform resource identifier associated with the supplier contact object. | |
RestockingDefaultOrderQuantity | Integer | True |
Default number of units to buy on auto reorder. | |
RestockingMinimumLevelForRestockingAlert | Integer | True |
The minimum number of items on hand before needing to reorder. | |
BuyingTaxCodeID | Uuid | False |
TaxCodes.ID |
Unique guid identifier belonging to the assigned tax code. |
BuyingTaxCodeCode | String | True |
3 digit tax code. | |
BuyingTaxCodeURI | String | True |
Uniform resource identifier associated with the tax code object. | |
CostOfSalesAccountID | Uuid | False |
Accounts.ID |
Unique identifier for the account in the form of a guid. |
CostOfSalesAccountDisplayID | String | True |
Account code. Format includes separator ie 4-1100 | |
CostOfSalesAccountName | String | True |
Name of the account. | |
CostOfSalesAccountURI | String | True |
Uniform resource identifier associated with the account object. | |
IncomeAccountID | Uuid | False |
Accounts.ID |
Unique identifier for the account in the form of a guid. |
IncomeAccountDisplayID | String | True |
Account code. Format includes separator ie 4-1100 | |
IncomeAccountName | String | True |
Name of the account. | |
IncomeAccountURI | String | True |
Uniform resource identifier associated with the account object. | |
ExpenseAccountID | Uuid | False |
Accounts.ID |
Unique identifier for the account in the form of a guid. |
ExpenseAccountDisplayID | String | True |
Account code. Format includes separator ie 4-1100 | |
ExpenseAccountName | String | True |
Name of the account. | |
ExpenseAccountURI | String | True |
Uniform resource identifier associated with the account object. | |
QuantityAvailable | Decimal | True |
Calculated quantity of the item available for sale. | |
QuantityCommitted | Decimal | True |
Quantity of the item held in pending sale invoices. | |
QuantityOnHand | Decimal | True |
Quantity of units held in inventory. | |
QuantityOnOrder | Decimal | True |
Quantity of the item held in pending purchase orders. | |
SellingBaseSellingPrice | Decimal | True |
Standard selling price for one selling unit of this item. | |
SellingCalculateSalesTaxOn | String | True |
ONLY APPLICABLE FOR AU REGION. Sales tax can be calculated on any of the following Enum values: ActualSellingPrice, BaseSellingPrice, LevelA, LevelB, LevelC, LevelD, LevelE, LevelF. | |
SellingIsTaxInclusive | Boolean | True |
True indicates the selling prices are inclusive of tax. False indicates the selling prices are exclusive of tax. | |
SellingItemsPerSellingUnit | Integer | True |
Number of items per selling unit. Note: if is IsInventoried = false null is returned. | |
SellingUnitOfMeasure | String | True |
Description of the unit type the item is sold as, ie: kg, hour. | |
SellingTaxCodeID | Uuid | False |
TaxCodes.ID |
Unique guid identifier belonging to the assigned tax code. |
SellingTaxCodeCode | String | True |
3 digit tax code. | |
SellingTaxCodeURI | String | True |
Uniform resource identifier associated with the tax code object. | |
CustomField1Label | String | True |
Custom Field 1 label. | |
CustomField1Value | String | True |
Custom Field 1 value. | |
CustomField2Label | String | True |
Custom Field 2 label. | |
CustomField2Value | String | True |
Custom Field 2 value. | |
CustomField3Label | String | True |
Custom Field 3 label. | |
CustomField3Value | String | True |
Custom Field 3 value. | |
CustomList1Label | String | True |
Custom List 1 label. | |
CustomList1Value | String | True |
Custom List 1 value. | |
CustomList2Label | String | True |
Custom List 2 label. | |
CustomList2Value | String | True |
Custom List 2 value. | |
CustomList3Label | String | True |
Custom List 3 label. | |
CustomList3Value | String | True |
Custom List 3 value. | |
URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. | |
RowVersion | String | True |
Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time. |