MYOB Endpoint: ReceiveMoneyTransactionsTable
Jump to navigation
Jump to search
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.
- 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.
- ReceiptNumber
- A text field that provides the transaction number.
- Date
- A date field that indicates the date of the transaction.
- 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.
- DepositAccountUID
- 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.
- DepositAccountNumber
- A text field that provides the account number assigned to this line.
- DepositAccountName
- 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.
- 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.
- 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).
- LineMemo
- A text field that provides the line memo for the transaction.
- LineAmount
- A decimal field that provides the amount.
- LineUnitCount
- A decimal field that provides the unit count.
- Only applicable to MYOB Essentials.
- LineRowVersion
- A row version field.
- 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