Tableau Connector for MYOB

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062