JDBC Driver for MYOB

Build 22.0.8462

SaleInvoiceItems

Return all sale invoice types for an AccountRight company file.

Table Specific Information

Select

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

Columns

Name Type Description
SaleInvoiceId Uuid Unique identifier in the form of a guid.
DiscountPercent Double Discount rate applicable to the line of the sale invoice.
Description String Description text for the sale line.
CostOfGoodsSold Decimal Cost Of the Goods Sold
RowID Integer Sequence of the entry within the item sale invoice set.
RowVersion String The RowVersion or the line item.
ShipQuantity Decimal The quantity of goods shipped.
Total Decimal Invoice 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.
Type String The type of the invoice.
UnitPrice Decimal Price per unit.
AccountID Uuid 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 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 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.
JobID Uuid Unique guid identifier belonging to the job for the line of the item sale.
JobNumber String Number assigned to the job.
JobName String Name assigned to the job.
JobURI String Uniform resource identifier associated with the job object.
LocationID Uuid Unique identifier for location in the form of a guid.
LocationIdentifier String Identifier assigned to the location.
LocationName String Name assigned to the location.
LocationURI String Uniform resource identifier associated with the location object.
InvoiceType String The type of the invoice. One of: Item,Service,Professional,Miscellaneous.
CompanyFileId String The ID of the company file. Takes precedence over the CompanyFileId connection property.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462