MYOB Endpoint: JournalTransactionsTable: Difference between revisions
Jump to navigation
Jump to search
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]] | ||
Latest revision as of 19:32, 29 July 2025
Overview
The MYOB JournalTransactionsTable endpoint allows you to access all transactions that affect your General Ledger (sales, purchases, payments, etc.).
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 JournalTransactions 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 JournalTransactionsTable endpoint.
- DataFileID
- A guid field that provides the id of the data file as setup in OdataLink.
- DataFileName
- A text field provides the name of the data file as setup in OdataLink.
- DataFileCode
- A text field provides the code of the data file as setup in OdataLink.
- JournalUID
- A GUID field representing the internal id of this record. This field can be used to link to other endpoints.
- JournalNumber
- A text field used as the default transaction number (invoice number, purchase number, etc.)
- JournalType
- A text field that indicates the type of journal.
- Possible values are:
- General
- Sale
- Purchase
- CashPayment
- CashReceipt
- Inventory
- SourceTransactionUID
- A GUID field that provides the ID of the source transaction.
- SourceTransactionType
- A text field that indicates the type of transaction that originated this entry.
- Possible values are:
- Bill
- Invoice
- SupplierPayment
- CustomerPayment
- SpendMoneyTxn
- ReceiveMoneyTxn
- TransferMoneyTxn
- GeneralJournal
- InventoryAdjustment
- CreditRefund
- CreditSettlement
- DebitRefund
- DebitSettlement
- DateOccurred
- A date field that indicates the date of the transaction.
- DatePosted
- A date field that indicates the date the transaction was entered into MYOB.
- Description
- A text field that provides the memo for the transaction.
- LineIndex
- A integer field that provides a index (1,2,3...) for each line of a journal transaction.
- LineDescription
- A text field that provides the line memo for the transaction.
- AccountUID
- A GUID field representing the internal id of an account. This field can be used to link to other endpoints.
- AccountNumber
- A text field used as the account number.
- AccountName
- A text field used as the account name.
- JobUID
- A GUID field representing the internal id of a job. This field can be used to link to other endpoints.
- JobNumber
- A text field used as the job number.
- JobName
- A text field used as the job name.
- Amount
- A decimal field that provides the amount.
- IsCredit
- A true/false field that indicates if the amount is a credit or debit.
- UnitCount
- A decimal field that provides the unit count for this entry..
- ReconciledDate
- A date field that indicates the date the transaction was reconciled.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Fields
- N/A
Related Endpoints
- CreditRefunds
- CreditSettlements
- DebitRefunds
- DebitSettlements
- CustomerPayments
- GeneralJournals
- InventoryAdjustments
- InventoryBuildTransactions
- JournalTransactions
- JournalTransactionsHistory
- PurchasesAllInvoices
- PurchasesItemInvoices
- PurchasesMiscellaneousInvoices
- PurchasesProfessionalInvoices
- PurchasesServiceInvoices
- ReceiveMoneyTransactions
- SalesAllInvoices
- SalesItemInvoices
- SalesMiscellaneousInvoices
- SalesProfessionalInvoices
- SalesServiceInvoices
- SalesTimeBillingInvoices
- SpendMoneyTransactions
- SupplierPayments
- TransferMoneyTransactions