JDBC Driver for MYOB

Build 24.0.9062

JournalTransactionHistoryLineItems

Journal Transaction History Items

Columns

Name Type References Description
ID [KEY] Integer LineId which represents the index of the line.
JournalTransactionID [KEY] Uuid Unique identifier in the form of a guid.
AccountID Uuid Unique identifier for the account in the form of a guid
AccountDisplayID String Account code format includes separator ie 1-1100
AccountName String Account name belonging to the account record.
AccountURI String Uniform resource identifier associated with the account object.
Amount Decimal Dollar amount posted to the Account object for each line of the transaction.
IsCredit Boolean Indicates whether the amount posted a credit to the Account object.
JobID Uuid Unique guid identifier belonging to the job for the line of the service sale.
JobName String Name assigned to the job
JobNumber String Number assigned to the job
JobUri String Uniform resource identifier associated with the job object
LineDescription String Line description for each line of the transaction if one has been entered.

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