MYOB Endpoint: JournalTransactionsTable: Difference between revisions
No edit summary |
No edit summary |
||
| (6 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 | ||
| Line 111: | 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 131: | Line 145: | ||
== Related Topics == | == Related Topics == | ||
:[[MYOB Endpoint: | :[[MYOB Endpoint: JournalTransactions|JournalTransactions]] | ||
:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]] | |||
:[[MYOB Models]] | :[[MYOB Models]] | ||
:[[MYOB Endpoints]] | :[[MYOB Endpoints]] | ||