JDBC Driver for MYOB

Build 22.0.8462

PurchaseBillItems

Return all purchase bill types for an AccountRight company file.

Table Specific Information

Select

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

Columns

Name Type Description
PurchaseBillId Uuid Unique identifier in the form of a guid.
Date Datetime Transaction date entry.
Description String Description text for the line.
Total Decimal Total amount for the line item only.
Type String Bill 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.
BillQuantity Decimal The quantity of goods shipped.
ReceivedQuantity Decimal The quantity of goods received.
BackorderQuantity Decimal Please note: To be implemented when Purchase Order functionality is available.
UnitPrice Decimal Price per unit.
DiscountPercent Double Discount rate applicable to the line item.
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.
JobID Uuid Unique job identifier in the form of a guid.
JobName String Name assigned to the job.
JobNumber String Number assigned to the job.
JobURI String Uniform resource identifier associated with the job object.
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.
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.
RowID Integer Sequence of the entry within the item.
RowVersion String Number value that changes upon a record update, can be used for change control but does does not preserve a date or a time.
BillType String Type of the bill. 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