MYOB Endpoint: GeneralJournalsTable: Difference between revisions

(5 intermediate revisions by the same user not shown)

Line 1:

== 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.

Line 14:

;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

: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

Line 44:

;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]] that provides the internal id of a [[MYOB Endpoint: Categories|category]]. This field can be used to link to other endpoints.

;CategoryName

Line 56:

;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

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

;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.

;~~LineAccountDisplayID~~

;LineJobUID

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

: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.

;~~LineJobUID~~

;LineJobNumber

: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: Text|text field]] that provides the job number assigned to this line.

;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.

~~;LineJobDisplayID~~

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

;LineMemo

Line 108:

;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]] 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

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

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

;ForeignCurrencyName

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

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

;CurrencyExchangeRate

@@ Line 1: / Line 1: @@
 == 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.
@@ Line 14: / Line 14: @@
 ;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
-: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
@@ Line 44: / Line 44: @@
 ;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]] that provides the internal id of a [[MYOB Endpoint: Categories|category]]. This field can be used to link to other endpoints.
 ;CategoryName
@@ Line 56: / Line 56: @@
 ;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
+:A [[Field Type: Text|text field]] that provides the account number assigned to this line.
 ;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.
-;LineAccountDisplayID
+;LineJobUID
-:A [[Field Type: Text|text field]] provides the account number assigned to this line.
+: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.
-;LineJobUID
+;LineJobNumber
-: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: Text|text field]] that provides the job number assigned to this line.
 ;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.
-;LineJobDisplayID
-:A [[Field Type: Text|text field]] provides the job number assigned to this line.
 ;LineMemo
@@ Line 108: / Line 108: @@
 ;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]] 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
-:A [[Field Type: Text|text field]] used as the currency ISO code.
+:A [[Field Type: Text|text field]] that provides the currency ISO code.
 ;ForeignCurrencyName
-:A [[Field Type: Text|text field]] used as the currency name.
+:A [[Field Type: Text|text field]] that provides the currency name.
 ;CurrencyExchangeRate