JDBC Driver for MYOB

Build 24.0.9060

SupplierPaymentItems

Supplier payment items for an AccountRight company file.

Table Specific Information

Select

The driver will process all filters client side.

Columns

Name Type References Description
SupplierPaymentID [KEY] Uuid Unique identifier in the form of a guid.
AmountApplied Double Amount applied to the purchase bill or order.
Type String Purchase type, can consist of the following: Bill, Order.
PurchaseID Uuid Unique guid identifier belonging to the supplier purchase bill or order.
PurchaseNumber String Purchase bill/order number.
PurchaseURI String Uniform resource identifier associated with the purchase bill/order object.
RowID Integer Sequence of the entry within the supplier payment set.
RowVersion String Incrementing number that can be used for change control but does does not preserve a date or a time.

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