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 criteria 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 | References | Description |
ID [KEY] | Integer | LineId which represents the index of the line. | |
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. |