MYOB Endpoint: PurchasesAllInvoicesTable

Overview

The MYOB PurchasesAllInvoicesTable endpoint allows you to get access to all purchase invoices regardless of type (Item, Miscellaneous, Professional, Service) within MYOB.

Note this endpoint is an alternate format of the PurchasesAllInvoices 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 PurchasesAllInvoicesTableendpoint.

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.

Number: A text field that provides the invoice number.

Date: A date field that indicates the date of the transaction.

SupplierInvoiceNumber: A text field that provides the supplier invoice number.

Supplier: A record field that provides the supplier associated with this transaction.

SupplierUID: A GUID field that provides the internal id of the card. This field can be used to link to other endpoints.

SupplierName: A text field that provides the full name of the Supplier.

SupplierDisplayID: A text field that provides the Card ID of the Supplier.

ShipToAddress: A text field that provides the complete address.

TermsPaymentIsDue

A text field that represents the due date.

Possible values are:

CashOnDelivery
PrePaid
InAGivenNumberOfDays
OnADayOfTheMonth
NumberOfDaysAfterEOM
DayOfMonthAfterEOM

TermsDiscountDate: A integer field used to represent either a specific day or a specific number of days in order to receive a discount.

TermsBalanceDueDate: A integer field used to represent either a specific day or a specific number of days in order to pay on time.

TermsDiscountForEarlyPayment: A decimal field used to represent the percentage discount for early payment.

TermsDiscountExpiryDate: A datefield that provides the date when the discount expires.

TermsDiscount: A decimal field used to represent the dollar discount.

TermsDiscountForeign: A decimal field used to represent the dollar discount for foreign currency transactions.

TermsDueDate: A datefield that provides the date when payment is due.

IsTaxInclusive: A true/false field that indicates if the amounts are tax inclusive or not.

IsReportable: A true/false field that indicates if the transaction is a reportable taxable payment.; Note this applies to Australia only.

Subtotal: A decimal field that provides the total of all the lines.

SubtotalForeign: A decimal field that provides the total of all the lines for foreign currency transactions.

Freight: A decimal field that provides the freight amount for this transaction.

FreightForeign: A decimal field that provides the freight amount for this transaction for foreign currency transactions.

FreightTaxCodeUID: A guid field that provides the id of the tax code for freight.

FreightTaxCode: A text field that provides the tax code for freight (e.g. GST or FRE).

TotalTax: A decimal field that provides the total tax amount.

TotalTaxForeign: A decimal field that provides the total tax amount for foreign currency transactions.

TotalAmount: A decimal field that provides the total amount of this transaction.

TotalAmountForeign: A decimal field that provides the total amount of this transaction for foreign currency transactions.

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.

Comment: A text field that provides the comment for the transaction.

ShippingMethod: A text field that provides the shipping method for the transaction.

PromisedDate: A date field that provides the promised date of the transaction.

JournalMemo: A text field that provides the memo for the transaction.

BillDeliveryStatus

A text field that provides the delivery status of this transaction.

Possible values are:

Email
Print
PrintAndEmail
Nothing

AppliedToDate: A decimal field that provides the total amount paid on this transaction.

AppliedToDateForeign: A decimal field that provides the total amount paid on this transaction for foreign currency transactions.

BalanceDueAmount: A decimal field that provides the outstanding balance of this transaction.

BalanceDueAmountForeign: A decimal field that provides the outstanding balance of this transaction for foreign currency transactions.

Status

A text field that provides the status of this transaction.

Possible values are:

Open: Indicates the invoice has an outstanding amount owing.
Closed: Indicates the invoice is paid in full.
Credit: Indicates the invoice is negative or overpaid and not settled or refunded.

LastPaymentDate: A date field that provides the last payment date applied to the transaction.

BillType

A text field that provides the type of this transaction.

Possible values are:

Item
Miscellaneous
Professional
Service

OrderUID: A GUID field that provides the internal id of the order. This field can be used to link to other endpoints.

OrderNumber: A text field that provides the order number for the originating order (if applicable).

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.