JDBC Driver for MYOB

Build 24.0.9060

SpendingTransactionItems

Spend money transaction items for an AccountRight company file.

Table Specific Information

Select

The driver will process all filters client side.

Columns

Name Type References Description
TransactionID Uuid

SpendingTransactions.ID

Unique identifier in the form of a guid.
Amount Double Amount to be allocated to the account.
Memo String Memo text describing the transaction line.
RowID Integer Sequence of the entry within the spend money set.
RowVersion String RowVersion. Required during update to identify the line item.
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.
JobID Uuid

Jobs.ID

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

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.

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