MYOB Endpoint: JournalTransactionsTable: Difference between revisions
No edit summary |
No edit summary |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
It does not give you complete details of each transaction. Instead, it provides information as to how the transaction affected the General Ledger. | It does not give you complete details of each transaction. Instead, it provides information as to how the transaction affected the General Ledger. | ||
Note this endpoint is an alternate format of the [[MYOB Endpoint: JournalTransactions|JournalTransactions]]. 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: JournalTransactions|JournalTransactions]] endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory. | ||
== Fields == | == Fields == | ||
The following fields are available for the | The following fields are available for the JournalTransactionsTable 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. | |||
;JournalUID | ;JournalUID | ||
| Line 55: | Line 64: | ||
;Description | ;Description | ||
:A [[Field Type: Text|text field]] that provides the memo for the transaction. | :A [[Field Type: Text|text field]] that provides the memo for the transaction. | ||
;LineIndex | |||
:A [[Field Type: Integer|integer field]] that provides a index (1,2,3...) for each line of a journal transaction. | |||
;LineDescription | ;LineDescription | ||
:A [[Field Type: Text|text field]] that provides the line memo for the transaction. | :A [[Field Type: Text|text field]] that provides the line memo for the transaction. | ||
; | ;AccountUID | ||
:A [[Field Type: | :A [[Field Type: GUID|GUID field]] representing the internal id of an account. This field can be used to link to other endpoints. | ||
;AccountNumber | |||
:A [[Field Type: Text|text field]] used as the account number. | |||
;AccountName | |||
:A [[Field Type: Text|text field]] used as the account name. | |||
;JobUID | |||
:A [[Field Type: GUID|GUID field]] representing the internal id of a job. This field can be used to link to other endpoints. | |||
;JobNumber | |||
:A [[Field Type: Text|text field]] used as the job number. | |||
; | ;JobName | ||
:A [[Field Type: | :A [[Field Type: Text|text field]] used as the job name. | ||
;Amount | ;Amount | ||
| Line 99: | Line 123: | ||
:[[MYOB Endpoint: GeneralJournals|GeneralJournals]] | :[[MYOB Endpoint: GeneralJournals|GeneralJournals]] | ||
:[[MYOB Endpoint: InventoryAdjustments|InventoryAdjustments]] | :[[MYOB Endpoint: InventoryAdjustments|InventoryAdjustments]] | ||
:[[MYOB Endpoint: | :[[MYOB Endpoint: InventoryBuildTransactions|InventoryBuildTransactions]] | ||
:[[MYOB Endpoint: JournalTransactions|JournalTransactions]] | |||
:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]] | |||
:[[MYOB Endpoint: PurchasesAllInvoices|PurchasesAllInvoices]] | :[[MYOB Endpoint: PurchasesAllInvoices|PurchasesAllInvoices]] | ||
:[[MYOB Endpoint: PurchasesItemInvoices|PurchasesItemInvoices]] | :[[MYOB Endpoint: PurchasesItemInvoices|PurchasesItemInvoices]] | ||
| Line 119: | Line 145: | ||
== Related Topics == | == Related Topics == | ||
:[[MYOB Endpoint: | :[[MYOB Endpoint: JournalTransactions|JournalTransactions]] | ||
:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]] | |||
:[[MYOB Models]] | :[[MYOB Models]] | ||
:[[MYOB Endpoints]] | :[[MYOB Endpoints]] | ||