MYOB Endpoint: GeneralJournalsTable - Revision history

Nic at 22:41, 2 April 2025

2025-04-02T22:41:46Z

← Older revision		Revision as of 17:41, 2 April 2025
Line 14:		Line 14:

	;DataFileName		;DataFileName
	:A [[Field Type: Text\|text field]] provides the name of the data file as setup in OdataLink.		:A [[Field Type: Text\|text field]] that provides the name of the data file as setup in OdataLink.

	;DataFileCode		;DataFileCode
	:A [[Field Type: Text\|text field]] provides the code of the data file as setup in OdataLink.		:A [[Field Type: Text\|text field]] that provides the code of the data file as setup in OdataLink.

	;UID		;UID
Line 44:		Line 44:

	;CategoryUID		;CategoryUID
	:A [[Field Type: GUID\|GUID field]] provides the internal id of a [[MYOB Endpoint: Categories\|category]]. This field can be used to link to other endpoints.		:A [[Field Type: GUID\|GUID field]] that provides the internal id of a [[MYOB Endpoint: Categories\|category]]. This field can be used to link to other endpoints.

	;CategoryName		;CategoryName
Line 56:		Line 56:

	;LineAccountUID		;LineAccountUID
	:A [[Field Type: GUID\|GUID field]] provides the internal id of the [[MYOB Endpoint: Accounts\|account]] assigned to this line. This field can be used to link to other endpoints.		:A [[Field Type: GUID\|GUID field]] that provides the internal id of the [[MYOB Endpoint: Accounts\|account]] assigned to this line. This field can be used to link to other endpoints.

	;LineAccountNumber		;LineAccountNumber
	:A [[Field Type: Text\|text field]] provides the account number assigned to this line.		:A [[Field Type: Text\|text field]] that provides the account number assigned to this line.

	;LineAccountName		;LineAccountName
	:A [[Field Type: Text\|text field]] provides the account name assigned to this line.		:A [[Field Type: Text\|text field]] that provides the account name assigned to this line.

	;LineJobUID		;LineJobUID
	:A [[Field Type: GUID\|GUID field]] provides the internal id of a [[MYOB Endpoint: Jobs\|job]] assigned to this line. This field can be used to link to other endpoints.		:A [[Field Type: GUID\|GUID field]] that provides the internal id of a [[MYOB Endpoint: Jobs\|job]] assigned to this line. This field can be used to link to other endpoints.

	;LineJobNumber		;LineJobNumber
	:A [[Field Type: Text\|text field]] provides the job number assigned to this line.		:A [[Field Type: Text\|text field]] that provides the job number assigned to this line.

	;LineJobName		;LineJobName
	:A [[Field Type: Text\|text field]] provides the job name assigned to this line.		:A [[Field Type: Text\|text field]] that provides the job name assigned to this line.

	;LineMemo		;LineMemo
Line 108:		Line 108:

	;ForeignCurrencyUID		;ForeignCurrencyUID
	:A [[Field Type: GUID\|GUID field]] provides the internal id of the [[MYOB Endpoint: Currencies\|currency]] linked to this transaction. This field can be used to link to other endpoints.		:A [[Field Type: GUID\|GUID field]] that provides the internal id of the [[MYOB Endpoint: Currencies\|currency]] linked to this transaction. This field can be used to link to other endpoints.

	;ForeignCurrencyCode		;ForeignCurrencyCode
	:A [[Field Type: Text\|text field]] provides the currency ISO code.		:A [[Field Type: Text\|text field]] that provides the currency ISO code.

	;ForeignCurrencyName		;ForeignCurrencyName
	:A [[Field Type: Text\|text field]] provides the currency name.		:A [[Field Type: Text\|text field]] that provides the currency name.

	;CurrencyExchangeRate		;CurrencyExchangeRate

Nic at 22:40, 2 April 2025

2025-04-02T22:40:04Z

← Older revision		Revision as of 17:40, 2 April 2025
Line 108:		Line 108:

	;ForeignCurrencyUID		;ForeignCurrencyUID
	:A [[Field Type: GUID\|GUID field]] ~~representing~~ the internal id of the currency linked to this transaction. This field can be used to link to other endpoints.		:A [[Field Type: GUID\|GUID field]] provides the internal id of the [[MYOB Endpoint: Currencies\|currency]] linked to this transaction. This field can be used to link to other endpoints.

	;ForeignCurrencyCode		;ForeignCurrencyCode
	:A [[Field Type: Text\|text field]] ~~used as~~ the currency ISO code.		:A [[Field Type: Text\|text field]] provides the currency ISO code.

	;ForeignCurrencyName		;ForeignCurrencyName
	:A [[Field Type: Text\|text field]] ~~used as~~ the currency name.		:A [[Field Type: Text\|text field]] provides the currency name.

	;CurrencyExchangeRate		;CurrencyExchangeRate

Nic at 22:39, 2 April 2025

2025-04-02T22:39:05Z

← Older revision		Revision as of 17:39, 2 April 2025
Line 44:		Line 44:

	;CategoryUID		;CategoryUID
	:A [[Field Type: GUID\|GUID field]] ~~representing~~ the internal id of a category. This field can be used to link to other endpoints.		:A [[Field Type: GUID\|GUID field]] provides the internal id of a [[MYOB Endpoint: Categories\|category]]. This field can be used to link to other endpoints.

	;CategoryName		;CategoryName

Nic at 22:35, 2 April 2025

2025-04-02T22:35:17Z

← Older revision		Revision as of 17:35, 2 April 2025
Line 66:		Line 66:
	;LineJobUID		;LineJobUID
	:A [[Field Type: GUID\|GUID field]] provides the internal id of a [[MYOB Endpoint: Jobs\|job]] assigned to this line. This field can be used to link to other endpoints.		:A [[Field Type: GUID\|GUID field]] provides the internal id of a [[MYOB Endpoint: Jobs\|job]] assigned to this line. This field can be used to link to other endpoints.

			;LineJobNumber
			:A [[Field Type: Text\|text field]] provides the job number assigned to this line.

	;LineJobName		;LineJobName
	:A [[Field Type: Text\|text field]] provides the job name assigned to this line.		:A [[Field Type: Text\|text field]] provides the job name assigned to this line.

	~~;LineJobDisplayID~~
	~~:A [[Field Type: Text\|text field]] provides the job number assigned to this line.~~

	;LineMemo		;LineMemo

Nic at 22:34, 2 April 2025

2025-04-02T22:34:57Z

← Older revision		Revision as of 17:34, 2 April 2025
Line 57:		Line 57:
	;LineAccountUID		;LineAccountUID
	:A [[Field Type: GUID\|GUID field]] provides the internal id of the [[MYOB Endpoint: Accounts\|account]] assigned to this line. This field can be used to link to other endpoints.		:A [[Field Type: GUID\|GUID field]] provides the internal id of the [[MYOB Endpoint: Accounts\|account]] assigned to this line. This field can be used to link to other endpoints.

			;LineAccountNumber
			:A [[Field Type: Text\|text field]] provides the account number assigned to this line.

	;LineAccountName		;LineAccountName
	:A [[Field Type: Text\|text field]] provides the account name assigned to this line.		:A [[Field Type: Text\|text field]] provides the account name assigned to this line.

	~~;LineAccountDisplayID~~
	~~:A [[Field Type: Text\|text field]] provides the account number assigned to this line.~~

	;LineJobUID		;LineJobUID

Nic at 22:31, 2 April 2025

2025-04-02T22:31:26Z

← Older revision		Revision as of 17:31, 2 April 2025
Line 1:		Line 1:
	== Overview ==		== Overview ==

	The MYOB '''~~GeneralJournals~~''' [[MYOB Endpoints\|endpoint]] allows you to get access to general journal transactions posted within MYOB.		The MYOB '''GeneralJournalsTable''' [[MYOB Endpoints\|endpoint]] allows you to get access to general journal transactions posted within MYOB.

	Note this endpoint is an alternate format of the [[MYOB Endpoint: GeneralJournals\|GeneralJournals]] endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.		Note this endpoint is an alternate format of the [[MYOB Endpoint: GeneralJournals\|GeneralJournals]] endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.

Nic: Created page with "== Overview == The MYOB '''GeneralJournals''' endpoint allows you to get access to general journal transactions posted within MYOB. Note this endpoint is..."

2025-03-27T23:25:41Z

Created page with "== Overview == The MYOB '''GeneralJournals''' endpoint allows you to get access to general journal transactions posted within MYOB. Note this endpoint is..."

New page

== Overview ==

The MYOB '''GeneralJournals''' [[MYOB Endpoints|endpoint]] allows you to get access to general journal transactions posted within MYOB.

Note this endpoint is an alternate format of the [[MYOB Endpoint: GeneralJournals|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 [[Field Type: GUID|guid field]] that provides the id of the data file as setup in OdataLink.

;DataFileName
:A [[Field Type: Text|text field]] provides the name of the data file as setup in OdataLink.

;DataFileCode
:A [[Field Type: Text|text field]] provides the code of the data file as setup in OdataLink.

;UID
:A [[Field Type: GUID|GUID field]] representing the internal id of this record. This field can be used to link to other endpoints.

;DisplayID
:A [[Field Type: Text|text field]] that provides the transaction number.

;DateOccurred
:A [[Field Type: Date|date field]] that indicates the date of the transaction.

;IsTaxInclusive
:A [[Field Type: Boolean|true/false field]] that indicates if the amounts are tax inclusive or not.

;Memo
:A [[Field Type: Text|text field]] that provides the memo for the transaction.

;GSTReportingMethod
:A [[Field Type: Text|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 [[Field Type: Boolean|true/false field]] that indicates if the transaction is an end of year adjustment or not.

;CategoryUID
:A [[Field Type: GUID|GUID field]] representing the internal id of a category. This field can be used to link to other endpoints.

;CategoryName
:A [[Field Type: Text|text field]] used as the category name.

;CategoryDisplayID
:A [[Field Type: Text|text field]] used as the category number.

;LineRowID
:A [[Field Type: Integer|integer field]] representing the internal id of this line.

;LineAccountUID
:A [[Field Type: GUID|GUID field]] provides the internal id of the [[MYOB Endpoint: Accounts|account]] assigned to this line. This field can be used to link to other endpoints.

;LineAccountName
:A [[Field Type: Text|text field]] provides the account name assigned to this line.

;LineAccountDisplayID
:A [[Field Type: Text|text field]] provides the account number assigned to this line.

;LineJobUID
:A [[Field Type: GUID|GUID field]] provides the internal id of a [[MYOB Endpoint: Jobs|job]] assigned to this line. This field can be used to link to other endpoints.

;LineJobName
:A [[Field Type: Text|text field]] provides the job name assigned to this line.

;LineJobDisplayID
:A [[Field Type: Text|text field]] provides the job number assigned to this line.

;LineMemo
:A [[Field Type: Text|text field]] that provides the line memo for the transaction.

;LineTaxCodeUID
:A [[Field Type: GUID|guid field]] that provides the id of the [[MYOB Field: TaxCodes|tax code]] for this line.

;LineTaxCode
:A [[Field Type: Text|text field]] that provides the [[MYOB Field: TaxCodes|tax code]] for this line (e.g. GST or FRE).

;LineAmount
:A [[Field Type: Decimal|decimal field]] that provides the amount.

;LineAmountForeign
:A [[Field Type: Decimal|decimal field]] that provides the amount in foreign currency if applicable.

;LineIsCredit
:A [[Field Type: Boolean|true/false field]] that indicates if the amount is a credit or debit.

;LineTaxAmount
:A [[Field Type: Decimal|decimal field]] that provides the tax amount.

;LineTaxAmountForeign
:A [[Field Type: Decimal|decimal field]] that provides the tax amount in foreign currency if applicable.

;LineIsOverridenTaxAmount
:A [[Field Type: Boolean|true/false field]] that indicates if the tax amount was edited and not automically calculated based on the [[MYOB Endpoint: TaxCodes|tax code]] rate.

;LineUnitCount
:A [[Field Type: Decimal|decimal field]] that provides the quantity for this line.
:Only applicable to MYOB Essentials.

;LineRowVersion
:A [[Field Type: Row Version|row version field]].

;ForeignCurrencyUID
:A [[Field Type: GUID|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 [[Field Type: Text|text field]] used as the currency ISO code.

;ForeignCurrencyName
:A [[Field Type: Text|text field]] used as the currency name.

;CurrencyExchangeRate
:A [[Field Type: Decimal|decimal field]] that provides the exchange rate for foreign currency transactions.

;RowVersion
:A [[Field Type: Row Version|row version field]].

== MYOB API ==

For a detailed run through of the endpoint, you can see the [https://developer.myob.com/api/accountright/v2/generalledger/generaljournal/ MYOB API].

== Related Endpoints==

:[[MYOB Endpoint: JournalTransactions|JournalTransactions]]

== Related Topics ==

:[[MYOB Models]]
:[[MYOB Endpoints]]