Data Dictionary
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 Name | Text | The name of the Connection. Typically the name of the Unleashed Organisation. |
Created | Datetime | API: Sales Shipment.CreatedOn |
Created By | Text | API: Sales Shipment.CreatedBy |
Customer GUID | Text | Unique ID for a Customer, API: Customer.Guid |
Customer Name | Text | API: Customer.CustomerName |
Customer Ref | Text | API: Sales Shipment.CustomerRef |
Data current as of | Datetime | Gives the date and time that this record was taken from Unleashed. |
Delivery City | Text | API: Sales Shipment.DeliveryCity |
Delivery Country | Text | API: Sales Shipment.DeliveryCountry |
Delivery Instruction | Text | API: Sales Shipment.DeliveryInstruction |
Delivery Name | Text | API: Sales Shipment.DeliveryName |
Delivery Post Code | Text | API: Sales Shipment.DeliveryPostCode |
Delivery Region | Text | API: Sales Shipment.DeliveryRegion |
Delivery Street Address | Text | API: Sales Shipment.DeliveryStreetAddress |
Delivery Street Address2 | Text | API: Sales Shipment.DeliveryStreetAddress2 |
Delivery Suburb | Text | API: Sales Shipment.DeliverySuburb |
Dispatch Date | Date | API: Sales Shipment.DispatchDate |
Incoterm | Text | API: Sales Shipment.Incoterm |
Line Created | Datetime | Created, API: Sales Shipment Lines.CreatedOn |
Line Created By | Text | Created By, API: Sales Shipment Lines.CreatedBy |
Line Number | Integer | API: Sales Shipment Lines.LineNumber |
Line Updated | Datetime | Updated, API: Sales Shipment Lines.LastModifiedOn |
Line Updated By | Text | Updated By, 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 Number | Text | API: Sales Shipment.OrderNumber |
Product Description | Text | |
Product GUID | Text | The Unique ID of a Product |
Receiver Eori | Text | API: Sales Shipment.ReceiverEORI |
Sales Order Line ID | Integer | API: Sales Shipment Lines.SalesOrderLineId |
Sales Order Line Number | Integer | API: Sales Shipment Lines.SalesOrderLineNumber |
Sales Shipment GUID | Text | API: Sales Shipment.Guid |
Sales Shipment Line GUID | Text | API: Sales Shipment Lines.Guid |
Serial Numbers | Text | API: Sales Shipment Lines.SerialNumbers |
Shipment Number | Text | API: Sales Shipment.ShipmentNumber |
Shipment Qty | Number | API: Sales Shipment Lines.ShipmentQty |
Shipment Status | Text | API: Sales Shipment.ShipmentStatus |
Shipment Weight | Text | API: Sales Shipment.ShipmentWeight |
Shipper Eori | Text | API: Sales Shipment.ShipperEORI |
Shipping Company GUID | Text | The Unique ID of a Shipping Company, API: Shipping Company.Guid |
Total Commercial Value | Number | API: Sales Shipment.TotalCommercialValue |
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 | API: Sales Shipment.LastModifiedOn |
Updated By | Text | API: Sales Shipment.LastModifiedBy |
Warehouse GUID | Text | Warehouse.Guid, API: Warehouse.Guid |
Warehouse Name | Text | Warehouse.Name, API: Warehouse.WarehouseName |
