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. | |
| CompanyFileId | String |
CompanyFiles.ID | ID of the company file. Takes precedence over the CompanyFileId property. |