Data Dictionary
Field | Type | Notes |
Actual Duration | Interval | API: Assemblies.ActualDuration |
Assemble By | Date | API: Derived from Assemblies.AssembleBy |
Assembly Date | Datetime | API: Derived from Assemblies.AssemblyDate |
Assembly Line Batch Numbers | JSON | API: Array of Assembly Lines.BatchNumbers |
Assembly Line Quantity | Number | API: Assembly Lines.Quantity |
Assembly Line Serial Numbers | Text | API: Assembly Lines.SerialNumbers |
Assembly Line Updated | Datetime | API: Derived from Assembly Lines.LastModifiedOn |
Assembly Number | Text | API: Assemblies.AssemblyNumber |
Assembly Status | Text | API: Assemblies.AssemblyStatus |
Assembly Type | Text | API: Assemblies.AssemblyType |
Auto Assembly | Boolean | API: Assemblies.AutoAssembly |
Batch Numbers | JSON | API: Array of Assemblies.BatchNumbers |
Can Assemble Quantity | Number | API: Assemblies.CanAssembleQuantity |
Comment | Text | API: Assemblies.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. |
Created | Datetime | API: Derived from Assemblies.CreatedOn |
Created By | Text | API: Assemblies.CreatedBy |
Custom Assembly Status | Text | API: Assemblies.CustomAssemblyStatus |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Destination Warehouse GUID | Text | The Unique ID of a Warehouse |
Destination Warehouse Name | Text | Warehouse.Name |
Disassemble Cost | Number | API: Assembly Lines.DisassembleCost |
Disassemble Cost Total | Number | API: Assemblies.DisassembleCostTotal |
Duration Comments | Text | API: Assemblies.DurationComments |
Text | ||
Estimated Start Date | Date | API: Derived from Assemblies.EstimatedStartDate |
Expected Duration | Interval | API: Assemblies.ExpectedDuration |
Full Name | Text | |
Product Description | Text | |
Product GUID | Text | The Unique ID of a Product |
Quantity | Number | API: Assemblies.Quantity |
Sales Order Number | Text | API: Assemblies.SalesOrderNumber |
Serial Numbers | Text | API: Assemblies.SerialNumbers |
Source Warehouse GUID | Text | The Unique ID of the Source Warehouse |
Source Warehouse Name | Text | Warehouse.Name |
Supplier Costs | JSON | API: Array of Assemblies.SupplierCosts |
Supplier Costs Sub Total | Number | API: Assemblies.SupplierCostsSubTotal |
Supplier Costs Tax | Number | API: Assemblies.SupplierCostsTax |
Total Cost | Number | API: Assembly Lines.TotalCost |
Unit Cost | Number | Unit Cost is calculated by Unleashed as Total Cost / (Assembly Line Quantity + Wastage Quantity), meaning it doesn't include the cost of the Wastage, API: Assembly Lines.UnitCost |
Updated | Datetime | API: Derived from Assembly Lines.LastModifiedOn |
Updated By | Text | API: Assemblies.LastModifiedBy |
Wastage Quantity | Number | API: Assembly Lines.WastageQuantity |
