Skip to main content

Supplier Returns

Written by Nick Maxwell

Data Dictionary

Field

Type

Notes

Average Landed Price After Return

Text

API: Supplier Return Lines.AverageLandedPriceAfterReturn

Average Landed Price Before Return

Text

API: Supplier Return Lines.AverageLandedPriceBeforeReturn

Base Return Cost Tax Total

Number

API: Supplier Return.BaseReturnCostTaxTotal

Base Return Cost Total

Number

API: Supplier Return.BaseReturnCostTotal

Base Sub Total

Number

API: Supplier Return.BaseSubTotal

Base Tax Total

Number

API: Supplier Return.BaseTaxTotal

Base Total

Number

API: Supplier Return.BaseTotal

Comment

Text

API: Supplier Return.Comments

Connection ID

Integer

The Connectorly Connection ID. If you group Connectorly's together, then you will see a Connection ID for each one. Organisations has the corresponding Connection Name for each Connection ID.

Currency

Text

The ISO Currency Code, API: Currency.CurrencyCode

Currency Rate

Number

API: Supplier Return.ExchangeRate

Data current as of

Datetime

Gives the date and time that this record was taken from Unleashed.

Line Comment

Text

API: Supplier Return Lines.Comments

Line Number

Integer

API: Supplier Return Lines.LineNumber

Line Tax Rate

Number

API: Supplier Return Lines.TaxRate

Line Xero Tax Code

Text

API: Supplier Return Lines.XeroTaxCode

Order Price

Number

API: Supplier Return Lines.OrderPrice

Product Description

Text

Product GUID

Text

The Unique ID of a Product

Purchase Order GUID

Text

The Unique ID of a Purchase Order, API: Purchase Order.Guid

Purchase Unit Order Quantity

Number

API: Supplier Return Lines.PurchaseUnitOrderQuantity

Purchase Unit Return Quantity

Number

API: Supplier Return Lines.PurchaseUnitReturnQuantity

Required Date

Datetime

API: Derived from Supplier Return Lines.RequiredDate

Return Cost

Number

API: Supplier Return Lines.ReturnCost

Return Date

Date

API: Derived from Supplier Return.ReturnDate

Return Price

Number

API: Supplier Return Lines.ReturnPrice

Return Quantity

Number

API: Supplier Return Lines.ReturnQuantity

Return Reason

Text

API: Supplier Return Lines.ReturnReason

Return To Supplier

Boolean

API: Supplier Return Lines.ReturnToSupplier

Status

Text

API: Supplier Return.Status

Stock On Hand Before Return

Number

API: Supplier Return Lines.StockOnHandBeforeReturn

Sub Total

Number

API: Supplier Return.SubTotal

Supplier GUID

Text

The Unique ID of a Supplier, API: Supplier.Guid

Supplier Name

Text

Supplier.Name, API: Supplier.SupplierName

Supplier Reference

Text

Supplier Reference erence, API: Supplier Return.SupplierRef

Supplier Return Costs

JSON

API: Array of Supplier Return.SupplierReturnCosts

Supplier Return GUID

Text

API: Supplier Return.Guid

Supplier Return Number

Text

API: Supplier Return.SupplierReturnNumber

Tax Amount

Number

API: Supplier Return Lines.LineTax

Tax Rate

Number

API: Supplier Return.TaxRate

Tax Total

Number

API: Supplier Return.TaxTotal

Total

Number

API: Supplier Return.Total

Updated

Datetime

API: Derived from Supplier Return.LastModifiedOn

Warehouse GUID

Text

The Unique ID of the Warehouse, API: Warehouse.Guid

Warehouse Name

Text

API: Warehouse.WarehouseName

Xero Cost Of Goods Account

Text

API: Supplier Return Lines.XeroCostOfGoodsAccount

Xero Sales Account

Text

API: Supplier Return Lines.XeroSalesAccount

Xero Tax Code

Text

API: Supplier Return.XeroTaxCode

Did this answer your question?