Data Dictionary
Records of goods dispatched to customers, including line items shipped, dispatch dates, quantities, shipping methods, and fulfillment status.Useful for tracking order fulfillment progress, analyzing warehouse throughput by date, or comparing expected shipment timelines against actual dispatch dates to identify delivery bottlenecks.
Field | Type | Notes |
Batch Numbers | Text | API: Sales Shipment Lines.BatchNumbers |
Comment | Text | API: Sales Shipment.Comments |
Commercial Monetary Value | Number | API: Sales Shipment Lines.CommercialMonetaryValue |
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 | Derived from datetime with timezone conversion of Created |
Created By | Text | API: Sales Shipment.CreatedBy |
Customer GUID | Text | Unique ID for a Customer, API: Customer.Guid |
Customer Name | Text | Derived from cleaning Customer.CustomerName |
Customer Reference | Text | API: Sales Shipment.CustomerRef |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Delivery Address City | Text | API: Sales Shipment.DeliveryCity |
Delivery Address Country | Text | API: Sales Shipment.DeliveryCountry |
Delivery Address Name | Text | API: Sales Shipment.DeliveryName |
Delivery Address Post Code | Text | API: Sales Shipment.DeliveryPostCode |
Delivery Address Region | Text | API: Sales Shipment.DeliveryRegion |
Delivery Address Suburb | Text | API: Sales Shipment.DeliverySuburb |
Delivery Instruction | Text | API: Sales Shipment.DeliveryInstruction |
Delivery Street Address | Text | API: Sales Shipment.DeliveryStreetAddress |
Delivery Street Address 2 | Text | API: Sales Shipment.DeliveryStreetAddress2 |
Dispatch Date | Date | Derived from date conversion of Dispatch Date |
International Commercial Term | Text | Includes terms like EXW (Ex Works), FOB (Free on Board), and DDP (Delivered Duty Paid), which outline the obligations of both parties in a transaction. See https://en.wikipedia.org/wiki/Incoterms for more details, API: Sales Shipment.Incoterm |
Line Created | Datetime | Derived from datetime with timezone conversion of Line Created |
Line Created By | Text | API: Sales Shipment Lines.CreatedBy |
Line Number | Integer | API: Sales Shipment Lines.LineNumber |
Line Updated | Datetime | Derived from datetime with timezone conversion of Line Updated |
Line Updated By | Text | API: Sales Shipment Lines.LastModifiedBy |
Nature Of Transaction Code | Text | API: Sales Shipment.NatureOfTransactionCode |
Number Of Packages | Integer | API: Sales Shipment.NumberOfPackages |
Order GUID | Text | API: Sales Shipment.OrderGuid |
Order Line Number | Integer | API: Sales Shipment Lines.SalesOrderLineNumber |
Order Number | Text | API: Sales Shipment.OrderNumber |
Product Description | Text | Derived from cleaning Product Description |
Product GUID | Text | The Unique ID of a Product, API: Product.Guid |
Receiver EORI | Text | Receiver EORI (Economic Operators Registration and Identification number), API: Sales Shipment.ReceiverEORI |
Sales Shipment GUID | Text | API: Sales Shipment.Guid |
Serial Numbers | Text | API: Sales Shipment Lines.SerialNumbers |
Shipment Number | Text | API: Sales Shipment.ShipmentNumber |
Shipment Quantity | Number | API: Sales Shipment Lines.ShipmentQty |
Shipment Status | Text | API: Sales Shipment.ShipmentStatus |
Shipment Weight | Text | API: Sales Shipment.ShipmentWeight |
Shipper EORI | Text | Shipper EORI (Economic Operators Registration and Identification number), API: Sales Shipment.ShipperEORI |
Shipping Company Name | Text | API: Shipping Company.Name |
Total Commercial Value | Number | API: Sales Shipment.TotalCommercialValue |
Total Shipment Cost | Number | Derived from multiplying Shipment Quantity and Unit Cost |
Total Shipment Cost At Time Of Dispatch | Number | Derived from multiplying Shipment Quantity and Unit Cost At Time Of Dispatch |
Tracking Number | Text | API: Sales Shipment.TrackingNumber |
Unit Cost | Number | API: Sales Shipment Lines.UnitCost |
Unit Cost At Time Of Dispatch | Number | API: Sales Shipment Lines.UnitCostAtTimeOfDispatch |
Updated | Datetime | Derived from datetime with timezone conversion of Updated |
Updated By | Text | API: Sales Shipment.LastModifiedBy |
Warehouse GUID | Text | The Unique ID of the Warehouse, API: Warehouse.Guid |
Warehouse Name | Text | API: Warehouse.WarehouseName |