MYOB Endpoint: GeneralJournalsTable
Overview
The MYOB GeneralJournals endpoint allows you to get access to general journal transactions posted within MYOB.
Note this endpoint is an alternate format of the GeneralJournals endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.
Fields
The following fields are available for the GeneralJournals endpoint.
- DataFileID
- A guid field that provides the id of the data file as setup in OdataLink.
- DataFileName
- A text field provides the name of the data file as setup in OdataLink.
- DataFileCode
- A text field provides the code of the data file as setup in OdataLink.
- UID
- A GUID field representing the internal id of this record. This field can be used to link to other endpoints.
- DisplayID
- A text field that provides the transaction number.
- DateOccurred
- A date field that indicates the date of the transaction.
- IsTaxInclusive
- A true/false field that indicates if the amounts are tax inclusive or not.
- Memo
- A text field that provides the memo for the transaction.
- GSTReportingMethod
- A text field that indicates whether this transaction is considered a sale or purchase with regards to GST and BAS.
- Possible values are:
- Sale
- Purchase
- IsYearEndAdjustment
- A true/false field that indicates if the transaction is an end of year adjustment or not.
- CategoryUID
- A GUID field representing the internal id of a category. This field can be used to link to other endpoints.
- CategoryName
- A text field used as the category name.
- CategoryDisplayID
- A text field used as the category number.
- LineRowID
- A integer field representing the internal id of this line.
- LineAccountUID
- A GUID field provides the internal id of the account assigned to this line. This field can be used to link to other endpoints.
- LineAccountName
- A text field provides the account name assigned to this line.
- LineAccountDisplayID
- A text field provides the account number assigned to this line.
- LineJobUID
- A GUID field provides the internal id of a job assigned to this line. This field can be used to link to other endpoints.
- LineJobName
- A text field provides the job name assigned to this line.
- LineJobDisplayID
- A text field provides the job number assigned to this line.
- LineMemo
- A text field that provides the line memo for the transaction.
- LineTaxCodeUID
- A guid field that provides the id of the tax code for this line.
- LineTaxCode
- A text field that provides the tax code for this line (e.g. GST or FRE).
- LineAmount
- A decimal field that provides the amount.
- LineAmountForeign
- A decimal field that provides the amount in foreign currency if applicable.
- LineIsCredit
- A true/false field that indicates if the amount is a credit or debit.
- LineTaxAmount
- A decimal field that provides the tax amount.
- LineTaxAmountForeign
- A decimal field that provides the tax amount in foreign currency if applicable.
- LineIsOverridenTaxAmount
- A true/false field that indicates if the tax amount was edited and not automically calculated based on the tax code rate.
- LineUnitCount
- A decimal field that provides the quantity for this line.
- Only applicable to MYOB Essentials.
- LineRowVersion
- A row version field.
- ForeignCurrencyUID
- A GUID field representing the internal id of the currency linked to this transaction. This field can be used to link to other endpoints.
- ForeignCurrencyCode
- A text field used as the currency ISO code.
- ForeignCurrencyName
- A text field used as the currency name.
- CurrencyExchangeRate
- A decimal field that provides the exchange rate for foreign currency transactions.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Endpoints