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 |
