https://help.odatalink.com/index.php?action=history&feed=atom&title=MYOB_Endpoint%3A_SpendMoneyTransactionsTable 2026-10-26T12:29:14Z Revision history for this page on the wiki MediaWiki 1.43.11 https://help.odatalink.com/index.php?title=MYOB_Endpoint:_SpendMoneyTransactionsTable&diff=4236&oldid=prev 2025-04-02T22:49:52Z

<p>Created page with &quot;== Overview == The MYOB &#039;&#039;&#039;SpendMoneyTransactionsTable&#039;&#039;&#039; <a href="/index.php?title=MYOB_Endpoints" title="MYOB Endpoints">endpoint</a> allows you to get access to spend money transactions recorded within MYOB. Note this en...&quot;</p> <p><b>New page</b></p><div>== Overview ==<br /> <br /> The MYOB &#039;&#039;&#039;SpendMoneyTransactionsTable&#039;&#039;&#039; [[MYOB Endpoints|endpoint]] allows you to get access to spend money transactions recorded within MYOB.<br /> <br /> Note this endpoint is an alternate format of the [[MYOB Endpoint: SpendMoneyTransactions|SpendMoneyTransactions]] endpoint. It provides a format that can more easily integrate with Tableau, SSIS and Azure Data Factory.<br /> <br /> <br /> == Fields ==<br /> <br /> The following fields are available for the SpendMoneyTransactionsTable endpoint.<br /> <br /> ;DataFileID<br /> :A [[Field Type: GUID|guid field]] that provides the id of the data file as setup in OdataLink.<br /> <br /> ;DataFileName<br /> :A [[Field Type: Text|text field]] that provides the name of the data file as setup in OdataLink.<br /> <br /> ;DataFileCode<br /> :A [[Field Type: Text|text field]] that provides the code of the data file as setup in OdataLink.<br /> <br /> ;UID<br /> :A [[Field Type: GUID|GUID field]] representing the internal id of this record. This field can be used to link to other endpoints.<br /> <br /> ;PaymentNumber<br /> :A [[Field Type: Text|text field]] that provides the transaction number.<br /> <br /> ;Date<br /> :A [[Field Type: Date|date field]] that indicates the date of the transaction.<br /> <br /> ;PayFrom<br /> :A [[Field Type: Text|text field]] used to indicate the source of the payment.<br /> :Possible values are:<br /> :* Account: Indicates the money was paid from the nominated account.<br /> :* ElectronicPayments: Indicates the money was paid from the electronic payments clearing account.<br /> <br /> ;PayFromAccountUID<br /> :A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Accounts|account]] assigned to this line. This field can be used to link to other endpoints.<br /> <br /> ;PayFromAccountNumber<br /> :A [[Field Type: Text|text field]] that provides the account number assigned to this line.<br /> <br /> ;PayFromAccountName<br /> :A [[Field Type: Text|text field]] that provides the account name assigned to this line.<br /> <br /> ;CardUID<br /> :A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Cards|card]]. This field can be used to link to other endpoints.<br /> <br /> ;CardName<br /> :A [[Field Type: Text|text field]] that provides the full name of the card.<br /> <br /> ;CardType<br /> :A [[Field Type: Text|text field]] that indicates the type of card used on the transaction (Customer, Supplier, Employee or Personal).<br /> <br /> ;CardDisplayID<br /> :A [[Field Type: Text|text field]] that provides the Card ID of the card.<br /> <br /> ;PayeeAddress<br /> :A [[Field Type: Text|text field]] that provides the complete address of the payee.<br /> <br /> ;StatementParticulars<br /> :A [[Field Type: Text|text field]] that provides the statement particular if it is an electronic payments transaction.<br /> <br /> ;StatementCode<br /> :A [[Field Type: Text|text field]] that provides the statement code if it is an electronic payments transaction.<br /> <br /> ;StatementReference<br /> :A [[Field Type: Text|text field]] that provides the statement reference if it is an electronic payments transaction.<br /> <br /> ;AmountPaid<br /> :A [[Field Type: Decimal|decimal field]] that provides the total amount paid.<br /> <br /> ;IsTaxInclusive<br /> :A [[Field Type: Boolean|true/false field]] that indicates if the amounts are tax inclusive or not.<br /> <br /> ;TotalTax<br /> :A [[Field Type: Decimal|decimal field]] that provides the total tax amount.<br /> <br /> ;Memo<br /> :A [[Field Type: Text|text field]] that provides the memo for the transaction.<br /> <br /> ;LineRowID<br /> :A [[Field Type: Integer|integer field]] representing the internal id of this row.<br /> <br /> ;LineAccountUID<br /> :A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Accounts|account]] assigned to this line. This field can be used to link to other endpoints.<br /> <br /> ;LineAccountNumber<br /> :A [[Field Type: Text|text field]] that provides the account number assigned to this line.<br /> <br /> ;LineAccountName<br /> :A [[Field Type: Text|text field]] that provides the account name assigned to this line.<br /> <br /> ;LineJobUID<br /> :A [[Field Type: GUID|GUID field]] that provides the internal id of a [[MYOB Endpoint: Jobs|job]] assigned to this line. This field can be used to link to other endpoints.<br /> <br /> ;LineJobNumber<br /> :A [[Field Type: Text|text field]] that provides the job number assigned to this line.<br /> <br /> ;LineJobName<br /> :A [[Field Type: Text|text field]] that provides the job name assigned to this line.<br /> <br /> ;LineTaxCodeUID<br /> :A [[Field Type: GUID|guid field]] that provides the id of the [[MYOB Endpoint: TaxCodes|tax code]] for this line.<br /> <br /> ;LineTaxCode<br /> :A [[Field Type: Text|text field]] that provides the [[MYOB Endpoint: TaxCodes|tax code]] for this line (e.g. GST or FRE).<br /> <br /> ;LineAmount<br /> :A [[Field Type: Decimal|decimal field]] that provides the amount.<br /> <br /> ;LineMemo<br /> :A [[Field Type: Text|text field]] that provides the line memo for the transaction.<br /> <br /> ;LineUnitCount<br /> :A [[Field Type: Decimal|decimal field]] that provides the unit count.<br /> :Only applicable to MYOB Essentials.<br /> <br /> ;LineRowVersion<br /> :A [[Field Type: Row Version|row version field]].<br /> <br /> ;ChequePrinted<br /> :A [[Field Type: Boolean|true/false field]] that indicates if the cheque was printed or not.<br /> <br /> ;DeliveryStatus<br /> :A [[Field Type: Text|text field]] that provides the delivery status of this transaction.<br /> :Possible values are:<br /> :* Email<br /> :* Print<br /> :* PrintAndEmail<br /> :* Nothing<br /> <br /> ;CategoryUID<br /> :A [[Field Type: GUID|GUID field]] that provides the internal id of a [[MYOB Endpoint: Categories|category]]. This field can be used to link to other endpoints.<br /> <br /> ;CategoryName<br /> :A [[Field Type: Text|text field]] that provides the category name.<br /> <br /> ;CategoryDisplayID<br /> :A [[Field Type: Text|text field]] that provides the category number.<br /> <br /> ;ForeignCurrencyUID<br /> :A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Currencies|currency]] linked to this transaction. This field can be used to link to other endpoints.<br /> <br /> ;ForeignCurrencyCode<br /> :A [[Field Type: Text|text field]] that provides the currency ISO code.<br /> <br /> ;ForeignCurrencyName<br /> :A [[Field Type: Text|text field]] that provides the currency name.<br /> <br /> ;RowVersion<br /> :A [[Field Type: Row Version|row version field]].<br /> <br /> <br /> == MYOB API ==<br /> <br /> For a detailed run through of the endpoint, you can see the [https://developer.myob.com/api/accountright/v2/banking/spend_money/ MYOB API].<br /> <br /> <br /> == Related Endpoints==<br /> <br /> :[[MYOB Endpoint: JournalTransactions|JournalTransactions]]<br /> <br /> <br /> == Related Topics ==<br /> <br /> :[[MYOB Models]]<br /> :[[MYOB Endpoints]]</div>

Nic