JDBC Driver for MYOB

Build 22.0.8462

JournalItems

Journal line items.

Table Specific Information

Select

The driver will process all filters client side.

Columns

Name Type Description
JournalID [KEY] Uuid Unique identifier in the form of a guid.
Amount Double Dollar amount posted to the line of the transaction.
IsCredit Boolean True indicates the amount posted to the account as a credit. False indicates the amount posted to the account as a debit.
IsOverriddenTaxAmount Boolean True indicates the tax amount has been altered. False indicates the tax amount has not been altered.
Memo String Memo text applied to the line of the transaction.
RowID Integer Sequence of the entry within the general journal set.
TaxAmount Double Tax amount for the line of the journal if using an applicable TaxCode.
RowVersion String Row version for the item. Required to udpate an existing line.
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.
JobNumber String Number assigned to the job.
JobName String Name 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.
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