MYOB Endpoint: PurchasesItemOrders
Jump to navigation
Jump to search
Overview
The MYOB PurchasesItemOrders endpoint allows you to get access to item purchase orders within MYOB.
Fields
The following fields are available for the PurchasesItemOrders endpoint.
- 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 order 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.
- ShipToAddress
- A text field that provides the complete address.
- Terms
- A record field that provides the terms of this transaction.
- 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.
- Lines
- A table field that provides the lines of this transaction.
- See Lines Fields for more information.
- 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.
- FreightTaxCode
- A record field that provides the tax code used for freight.
- 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.
- Category
- A record field that provides the category associated with this transaction.
- 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.
- OrderDeliveryStatus
- A text field that provides the delivery status of this transaction.
- Possible values are:
- 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 order has not been converted to a purchase bill.
- ConvertedToBill: Indicates the order has been converted to a purchase bill.
- LastPaymentDate
- A date field that provides the last payment date applied to the transaction.
- ForeignCurrency
- A record field that provides the currency associated with this transaction.
- CurrencyExchangeRate
- A decimal field that provides exchange rate for foreign currency transactions.
- 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.
- Type
- A text field that indicates the type of line.
- Possible values are:
- Header
- Transaction
- Subtotal
- Description
- A text field that provides the line memo for the transaction.
- BillQuantity
- A decimal field that provides the quantity billed for this line.
- ReceivedQuantity
- A decimal field that provides the quantity received for this line.
- UnitPrice
- A decimal field that provides the unit price for this line.
- UnitPriceForeign
- A decimal field that provides the unit price for this line for foreign currency transactions.
- DiscountPercent
- A decimal field that provides the percentage discount for this line.
- Total
- A decimal field that provides the total amount for this line.
- TotalForeign
- A decimal field that provides the total amount for this line for foreign currency transactions.
- Item
- A record field that provides the item 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.
- Location
- A record field that provides the location for this line.
- 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