JDBC Driver for MYOB

Build 22.0.8462

ItemSellingPrices

Return the item price matrix for multiple customer selling prices.

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: ItemPriceMatrixID. All the other columns and operators are processed client side.

SELECT * FROM ItemSellingPrices WHERE ItemPriceMatrixID = "3a35e83a-5070-432d-b6ec-f4791f353352"

Columns

Name Type Description
ItemPriceMatrixID [KEY] Uuid Unique identifier in the form of a guid.
QuantityOver Integer The first QuantityOver must always be 0, for each additional quantity break specify the item quantity.
LevelA Double Item price Level a, defaults to items Base Selling Price.
LevelB Double Item price Level b, defaults to items Base Selling Price.
LevelC Double Item price Level c, defaults to items Base Selling Price.
LevelD Double Item price Level d, defaults to items Base Selling Price.
LevelE Double Item price Level e, defaults to items Base Selling Price.
LevelF Double Item price Level f, defaults to items Base Selling Price.
CompanyFileId String 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