JDBC Driver for MYOB

Build 22.0.8462

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 criterias 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 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

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

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

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

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

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

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

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.

CompanyFileId String True

The ID of the company file. Takes precedence over the CompanyFileId connection property.

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