MYOB Endpoint: SpendMoneyTransactionsTable
Overview
The MYOB SpendMoneyTransactionsTable endpoint allows you to get access to spend money transactions recorded within MYOB.
Note this endpoint is an alternate format of the SpendMoneyTransactions 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 SpendMoneyTransactionsTable endpoint.
- DataFileID
- A guid field that provides the id of the data file as setup in OdataLink.
- DataFileName
- A text field that provides the name of the data file as setup in OdataLink.
- DataFileCode
- A text field that provides the code of the data file as setup in OdataLink.
- UID
- A GUID field representing the internal id of this record. This field can be used to link to other endpoints.
- PaymentNumber
- A text field that provides the transaction number.
- Date
- A date field that indicates the date of the transaction.
- PayFrom
- A text field used to indicate the source of the payment.
- Possible values are:
- Account: Indicates the money was paid from the nominated account.
- ElectronicPayments: Indicates the money was paid from the electronic payments clearing account.
- PayFromAccountUID
- A GUID field that provides the internal id of the account assigned to this line. This field can be used to link to other endpoints.
- PayFromAccountNumber
- A text field that provides the account number assigned to this line.
- PayFromAccountName
- A text field that provides the account name assigned to this line.
- CardUID
- A GUID field that provides the internal id of the card. This field can be used to link to other endpoints.
- CardName
- A text field that provides the full name of the card.
- CardType
- A text field that indicates the type of card used on the transaction (Customer, Supplier, Employee or Personal).
- CardDisplayID
- A text field that provides the Card ID of the card.
- PayeeAddress
- A text field that provides the complete address of the payee.
- StatementParticulars
- A text field that provides the statement particular if it is an electronic payments transaction.
- StatementCode
- A text field that provides the statement code if it is an electronic payments transaction.
- StatementReference
- A text field that provides the statement reference if it is an electronic payments transaction.
- AmountPaid
- A decimal field that provides the total amount paid.
- IsTaxInclusive
- A true/false field that indicates if the amounts are tax inclusive or not.
- TotalTax
- A decimal field that provides the total tax amount.
- Memo
- A text field that provides the memo for the transaction.
- LineRowID
- A integer field representing the internal id of this row.
- LineAccountUID
- A GUID field that provides the internal id of the account assigned to this line. This field can be used to link to other endpoints.
- LineAccountNumber
- A text field that provides the account number assigned to this line.
- LineAccountName
- A text field that provides the account name assigned to this line.
- LineJobUID
- A GUID field that provides the internal id of a job assigned to this line. This field can be used to link to other endpoints.
- LineJobNumber
- A text field that provides the job number assigned to this line.
- LineJobName
- A text field that provides the job name assigned to this line.
- LineTaxCodeUID
- A guid field that provides the id of the tax code for this line.
- LineTaxCode
- A text field that provides the tax code for this line (e.g. GST or FRE).
- LineAmount
- A decimal field that provides the amount.
- LineMemo
- A text field that provides the line memo for the transaction.
- LineUnitCount
- A decimal field that provides the unit count.
- Only applicable to MYOB Essentials.
- LineRowVersion
- A row version field.
- ChequePrinted
- A true/false field that indicates if the cheque was printed or not.
- DeliveryStatus
- A text field that provides the delivery status of this transaction.
- Possible values are:
- PrintAndEmail
- Nothing
- CategoryUID
- A GUID field that provides the internal id of a category. This field can be used to link to other endpoints.
- CategoryName
- A text field that provides the category name.
- CategoryDisplayID
- A text field that provides the category number.
- ForeignCurrencyUID
- A GUID field that provides the internal id of the currency linked to this transaction. This field can be used to link to other endpoints.
- ForeignCurrencyCode
- A text field that provides the currency ISO code.
- ForeignCurrencyName
- A text field that provides the currency name.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Endpoints