Power BI Connector for MYOB

Build 24.0.9062

SaleQuoteItems

Return all sale quote types for an AccountRight company file.

Table Specific Information

Select

Only the SaleQuoteId and QuoteType columns, when using the equality comparison, are supported for server side filtering. If left unspecified, the QuoteType column will default to 'Item'.

Columns

Name Type References Description
SaleQuoteId Uuid Unique identifier in the form of a guid.
DiscountPercent Double Discount rate applicable to the line of the sale quote.
Description String Description text for the sale line.
RowID Integer Sequence of the entry within the item sale quote set.
RowVersion String The RowVersion or the line item.
ShipQuantity Decimal The quantity of goods shipped.
Total Decimal Total amount for the line item only.
Type String Quote line type, can consist of the following: Transaction - All fields detailed in Lines array are consumable. Header - Only allows you to POST to Description element. Subtotal - Calculated value that is read-only.
UnitPrice Decimal Price per unit.
AccountID Uuid

Accounts.ID

Unique identifier for the account in the form of a guid.
AccountDisplayID String Account code. Format includes separator ie 4-1100
AccountName String Name of the account.
AccountURI String Uniform resource identifier associated with the account object.
ItemID Uuid

Items.ID

Unique identifier in the form of a guid.
ItemName String Name of the item.
ItemNumber String The number assigned to the item.
ItemURI String Uniform resource identifier associated with the item.
TaxCodeID Uuid

TaxCodes.ID

Unique guid identifier belonging to the assigned tax code.
TaxCodeCode String 3 digit tax code.
TaxCodeURI String Uniform resource identifier associated with the tax code object.
QuoteType String The type of the quote. One of: Item,Service,Professional,TimeBilling,Miscellaneous.

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