Nic at 04:22, 3 April 2025

2025-04-03T04:22:04Z

← Older revision		Revision as of 23:22, 2 April 2025
Line 30:		Line 30:
	;SupplierInvoiceNumber		;SupplierInvoiceNumber
	:A [[Field Type: Text\|text field]] that provides the supplier invoice number.		:A [[Field Type: Text\|text field]] that provides the supplier invoice number.

	~~;Supplier~~
	~~:A [[Field Type: Record\|record field]] that provides the [[MYOB Field: Cards\| supplier]] associated with this transaction.~~

	;SupplierUID		;SupplierUID

Nic: Created page with "== Overview == The MYOB '''PurchasesAllInvoicesTable''' endpoint allows you to get access to all purchase invoices regardless of type (Item, Miscellaneous,..."

2025-04-03T04:21:43Z

Created page with "== Overview == The MYOB '''PurchasesAllInvoicesTable''' endpoint allows you to get access to all purchase invoices regardless of type (Item, Miscellaneous,..."

New page

== Overview ==

The MYOB '''PurchasesAllInvoicesTable''' [[MYOB Endpoints|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 [[MYOB Endpoint: PurchasesAllInvoices|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 [[Field Type: GUID|guid field]] that provides the id of the data file as setup in OdataLink.

;DataFileName
:A [[Field Type: Text|text field]] that provides the name of the data file as setup in OdataLink.

;DataFileCode
:A [[Field Type: Text|text field]] that provides the code of the data file as setup in OdataLink.

;UID
:A [[Field Type: GUID|GUID field]] representing the internal id of this record. This field can be used to link to other endpoints.

;Number
:A [[Field Type: Text|text field]] that provides the invoice number.

;Date
:A [[Field Type: Date|date field]] that indicates the date of the transaction.

;SupplierInvoiceNumber
:A [[Field Type: Text|text field]] that provides the supplier invoice number.

;Supplier
:A [[Field Type: Record|record field]] that provides the [[MYOB Field: Cards| supplier]] associated with this transaction.

;SupplierUID
:A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: Suppliers|card]]. This field can be used to link to other endpoints.

;SupplierName
:A [[Field Type: Text|text field]] that provides the full name of the Supplier.

;SupplierDisplayID
:A [[Field Type: Text|text field]] that provides the Card ID of the Supplier.

;ShipToAddress
:A [[Field Type: Text|text field]] that provides the complete address.

;TermsPaymentIsDue
:A [[Field Type: Text|text field]] that represents the due date.
:Possible values are:
:* CashOnDelivery
:* PrePaid
:* InAGivenNumberOfDays
:* OnADayOfTheMonth
:* NumberOfDaysAfterEOM
:* DayOfMonthAfterEOM

;TermsDiscountDate
:A [[Field Type: Integer|integer field]] used to represent either a specific day or a specific number of days in order to receive a discount.

;TermsBalanceDueDate
:A [[Field Type: Integer|integer field]] used to represent either a specific day or a specific number of days in order to pay on time.

;TermsDiscountForEarlyPayment
:A [[Field Type: Decimal|decimal field]] used to represent the percentage discount for early payment.

;TermsDiscountExpiryDate
:A [[Field Type: Date|datefield]] that provides the date when the discount expires.

;TermsDiscount
:A [[Field Type: Decimal|decimal field]] used to represent the dollar discount.

;TermsDiscountForeign
:A [[Field Type: Decimal|decimal field]] used to represent the dollar discount for foreign currency transactions.

;TermsDueDate
:A [[Field Type: Date|datefield]] that provides the date when payment is due.

;IsTaxInclusive
:A [[Field Type: Boolean|true/false field]] that indicates if the amounts are tax inclusive or not.

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

;Subtotal
:A [[Field Type: Decimal|decimal field]] that provides the total of all the lines.

;SubtotalForeign
:A [[Field Type: Decimal|decimal field]] that provides the total of all the lines for foreign currency transactions.

;Freight
:A [[Field Type: Decimal|decimal field]] that provides the freight amount for this transaction.

;FreightForeign
:A [[Field Type: Decimal|decimal field]] that provides the freight amount for this transaction for foreign currency transactions.

;FreightTaxCodeUID
:A [[Field Type: GUID|guid field]] that provides the id of the [[MYOB Endpoint: TaxCodes|tax code]] for freight.

;FreightTaxCode
:A [[Field Type: Text|text field]] that provides the [[MYOB Endpoint: TaxCodes|tax code]] for freight (e.g. GST or FRE).

;TotalTax
:A [[Field Type: Decimal|decimal field]] that provides the total tax amount.

;TotalTaxForeign
:A [[Field Type: Decimal|decimal field]] that provides the total tax amount for foreign currency transactions.

;TotalAmount
:A [[Field Type: Decimal|decimal field]] that provides the total amount of this transaction.

;TotalAmountForeign
:A [[Field Type: Decimal|decimal field]] that provides the total amount of this transaction for foreign currency transactions.

;CategoryUID
: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.

;CategoryName
:A [[Field Type: Text|text field]] that provides the category name.

;CategoryDisplayID
:A [[Field Type: Text|text field]] that provides the category number.

;Comment
:A [[Field Type: Text|text field]] that provides the comment for the transaction.

;ShippingMethod
:A [[Field Type: Text|text field]] that provides the shipping method for the transaction.

;PromisedDate
:A [[Field Type: Date|date field]] that provides the promised date of the transaction.

;JournalMemo
:A [[Field Type: Text|text field]] that provides the memo for the transaction.

;BillDeliveryStatus
:A [[Field Type: Text|text field]] that provides the delivery status of this transaction.
:Possible values are:
:* Email
:* Print
:* PrintAndEmail
:* Nothing

;AppliedToDate
:A [[Field Type: Decimal|decimal field]] that provides the total amount paid on this transaction.

;AppliedToDateForeign
:A [[Field Type: Decimal|decimal field]] that provides the total amount paid on this transaction for foreign currency transactions.

;BalanceDueAmount
:A [[Field Type: Decimal|decimal field]] that provides the outstanding balance of this transaction.

;BalanceDueAmountForeign
:A [[Field Type: Decimal|decimal field]] that provides the outstanding balance of this transaction for foreign currency transactions.

;Status
:A [[Field Type: Text|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 [[Field Type: Date|date field]] that provides the last payment date applied to the transaction.

;BillType
:A [[Field Type: Text|text field]] that provides the type of this transaction.
:Possible values are:
:* '''Item'''
:* '''Miscellaneous'''
:* '''Professional'''
:* '''Service'''

;OrderUID
:A [[Field Type: GUID|GUID field]] that provides the internal id of the [[MYOB Endpoint: PurchasesAllOrders|order]]. This field can be used to link to other endpoints.

;OrderNumber
:A [[Field Type: Text|text field]] that provides the order number for the originating order (if applicable).

;ForeignCurrencyUID
: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.

;ForeignCurrencyCode
:A [[Field Type: Text|text field]] that provides the currency ISO code.

;ForeignCurrencyName
:A [[Field Type: Text|text field]] that provides the currency name.

;CurrencyExchangeRate
:A [[Field Type: Decimal|decimal field]] that provides exchange rate for foreign currency transactions.

;RowVersion
:A [[Field Type: Row Version|row version field]].

== MYOB API ==

For a detailed run through of the endpoint, you can see the [https://developer.myob.com/api/accountright/v2/purchase/bill/ MYOB API].

== Related Endpoints==

:[[MYOB Endpoint: JournalTransactions|JournalTransactions]]
:[[MYOB Endpoint: PurchasesAllInvoices|PurchasesAllInvoices]]
:[[MYOB Endpoint: PurchasesAllOrders|PurchasesAllOrders]]

== Related Topics ==

:[[MYOB Models]]
:[[MYOB Endpoints]]

MYOB Endpoint: PurchasesAllInvoicesTable - Revision history

Nic at 04:22, 3 April 2025

Nic: Created page with "== Overview == The MYOB '''PurchasesAllInvoicesTable''' endpoint allows you to get access to all purchase invoices regardless of type (Item, Miscellaneous,..."