MYOB Endpoint: ReceiveMoneyTransactionsTable
Overview
The MYOB ReceiveMoneyTransactionsTable endpoint allows you to get access to receive money transactions recorded within MYOB.
Note this endpoint is an alternate format of the ReceiveMoneyTransactions 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 ReceiveMoneyTransactionsTable endpoint.
- UID
- A GUID field representing the internal id of this record. This field can be used to link to other endpoints.
- DepositTo
- A text field used to indicate the destination of the payment.
- Possible values are:
- Account: Indicates the money was paid from the nominated account.
- UndepositedFunds: Indicates the money was paid from the undeposited funds clearing account.
- Account
- A record field that provides the account to which payment was made.
- Contact
- A record field that provides the card associated with this transaction.
- ReceiptNumber
- A text field that provides the transaction number.
- Date
- A date field that indicates the date of the transaction.
- AmountReceived
- A decimal field that provides the total amount received.
- 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.
- PaymentMethod
- A text field that provides the payment method used to receive the money.
- Memo
- A text field that provides the memo for the transaction.
- Category
- A record field that provides the category associated with this transaction.
- Lines
- A table field that provides the lines of this transaction.
- See Lines Fields for more information.
- ForeignCurrency
- A record field that provides the currency associated with this transaction.
- RowVersion
- A row version field.
Lines Fields
The Lines field contains the following sub-fields.
- RowID
- A integer field representing the internal id of this row.
- Account
- A record field that provides the account for this line.
- Job
- A record field that provides the job for this line.
- TaxCode
- A record field that provides the tax code for this line.
- Memo
- A text field that provides the line memo for the transaction.
- Amount
- A decimal field that provides the amount.
- UnitCount
- A decimal field that provides the unit count.
- Only applicable to MYOB Essentials.
- RowVersion
- A row version field.
MYOB API
For a detailed run through of the endpoint, you can see the MYOB API.
Related Fields
Related Endpoints