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: Derived from Sales Shipment Lines.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 Reference | Text | Customer Reference erence, 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 | API: Derived from Sales Shipment.DispatchDate |
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 | API: Derived from Sales Shipment Lines.CreatedOn |
Line Created By | Text | API: Sales Shipment Lines.CreatedBy |
Line Number | Integer | API: Sales Shipment Lines.LineNumber |
Line Updated | Datetime | API: Derived from Sales Shipment Lines.LastModifiedOn |
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 | |
Product GUID | Text | The Unique ID of a Product |
Receiver EORI | Text | Receiver EORI (Economic Operators Registration and Identification number), API: Sales Shipment.ReceiverEORI |
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 |
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: Derived from Sales Shipment Lines.LastModifiedOn |
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 |
