ItemPriceMatrices
Return and update 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: ID, ItemID, ItemName, ItemNumber. All the other columns and operators are processed client side.
SELECT * FROM ItemPriceMatrices WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9" SELECT * FROM ItemPriceMatrices WHERE ItemName = "item name"
Update
To update an existing item price matrix, along with its SellingPrices, we can either pass a JSON string to the SellingPrices value or use a temporary table like below.
Note: this will replace all the current SellingPrices with the ones below.
INSERT INTO ItemSellingPrices#TEMP(quantityover, levelA, LevelB) VALUES (10, 11.5, 12.7) UPDATE ItemPriceMatrices SET SellingPrices = "ItemSellingPrices#TEMP" WHERE ID = "1bed306d-2da4-49b3-9023-153c3dc5b2e9"
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | Uuid | True |
Unique identifier in the form of a guid. |
| ItemID | Uuid | True |
Unique identifier in the form of a guid. |
| ItemName | String | True |
Name of the item. |
| ItemNumber | String | True |
The number assigned to the item. |
| ItemURI | String | True |
Uniform resource identifier associated with the item. |
| 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. |
| URI | String | True |
Uniform resource identifier encompasses all types of names and addresses that refer to objects on the web. |
| SellingPrices | String | False |
An array of selling price information. |
| CompanyFileId | String | True |
The ID of the company file. Takes precedence over the CompanyFileId connection property. |