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 Name | Text | The name of the Connection. Typically the name of the Unleashed Organisation. |
Currency | Text | The ISO Currency Code, API: Currency.CurrencyCode |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Exchange Rate | Number | API: Supplier Return.ExchangeRate |
Line Comment | Text | Comments, API: Supplier Return Lines.Comments |
Line Number | Integer | API: Supplier Return Lines.LineNumber |
Line Tax | Number | API: Supplier Return Lines.LineTax |
Line Tax Rate | Number | Tax Rate, API: Supplier Return Lines.TaxRate |
Line Xero Tax Code | Text | Xero Tax Code, API: Supplier Return Lines.XeroTaxCode |
Order Price | Number | API: Supplier Return Lines.OrderPrice |
Order Quantity | Number | API: Supplier Return Lines.OrderQuantity |
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: Supplier Return Lines.RequiredDate |
Return Cost | Number | API: Supplier Return Lines.ReturnCost |
Return Date | Date | API: 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 Ref | Text | API: Supplier Return.SupplierRef |
Supplier Return Costs | JSON | API: Array of Supplier Return.SupplierReturnCosts |
Supplier Return GUID | Text | API: Supplier Return.Guid |
Supplier Return Line GUID | Text | API: Supplier Return Lines.Guid |
Supplier Return Number | Text | API: Supplier Return.SupplierReturnNumber |
Tax Rate | Number | API: Supplier Return.TaxRate |
Tax Total | Number | API: Supplier Return.TaxTotal |
Total | Number | API: Supplier Return.Total |
Updated | Datetime | API: Supplier Return.LastModifiedOn |
Warehouse GUID | Text | Warehouse.Guid, API: Warehouse.Guid |
Warehouse Name | Text | Warehouse.Name, 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 |
