MYOB Endpoint: JournalTransactions: Difference between revisions
No edit summary |
No edit summary |
||
| (5 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 an alternate endpoint named [[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory . | Note an alternate endpoint named [[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]] is available which provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory. | ||
| Line 11: | Line 11: | ||
The following fields are available for the JournalTransactions endpoint. | The following fields are available for the JournalTransactions endpoint. | ||
;DataFile | |||
:A [[Field Type: Record|record field]] that provides the [[Field: DataFile|DataFile]] associated with the data. | |||
;UID | ;UID | ||
| Line 77: | Line 80: | ||
The [[#Fields|Lines]] field contains the following sub-fields. | The [[#Fields|Lines]] field contains the following sub-fields. | ||
;LineIndex | |||
:A [[Field Type: Integer|integer field]] that provides a index (1,2,3...) for each line of a journal transaction. | |||
;Account | ;Account | ||
| Line 120: | Line 126: | ||
:[[MYOB Endpoint: GeneralJournals|GeneralJournals]] | :[[MYOB Endpoint: GeneralJournals|GeneralJournals]] | ||
:[[MYOB Endpoint: InventoryAdjustments|InventoryAdjustments]] | :[[MYOB Endpoint: InventoryAdjustments|InventoryAdjustments]] | ||
:[[MYOB Endpoint: InventoryBuildTransactions|InventoryBuildTransactions]] | |||
:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]] | |||
:[[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]] | :[[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]] | ||
:[[MYOB Endpoint: PurchasesAllInvoices|PurchasesAllInvoices]] | :[[MYOB Endpoint: PurchasesAllInvoices|PurchasesAllInvoices]] | ||
| Line 140: | Line 148: | ||
== Related Topics == | == Related Topics == | ||
:[[MYOB Endpoint: JournalTransactionsHistory|JournalTransactionsHistory]] | |||
:[[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]] | :[[MYOB Endpoint: JournalTransactionsTable|JournalTransactionsTable]] | ||
:[[MYOB Models]] | :[[MYOB Models]] | ||
:[[MYOB Endpoints]] | :[[MYOB Endpoints]] | ||