Description

As soon as a dispatch is confirmed by the DC on SEKO360SupplyStream, this method will push the dispatch information to the Hub.

Dispatch

Field

Description

Data Type

MessageGroupId

Placeholder

nvarchar(100)

MessagePart

This is the message part of the total number of messages.

int

MessageTotal

This is the total number of messages.

int

IntegrationId

This is determined by SEKO360 SupplyStream and is the client unique identifier. This will be a consistent unique value per client. Example: CCIND

nvarchar(100)

SequenceNumber

This is determined by SEKO360SupplyStream . Every push message will increment by 1 for each service selected

int

ToBePackedDate

Date the sales order reached the status of 'To be Packed'. Example: 2016-07-07T16:15:38Z

datetime

ToDispatchDate

Date the sales order reached the status of 'To Dispatch'. Example: 2016-07-07T16:15:50Z

datetime

DispatchDate

Date the sales order was systematically dispatched from SEKO360SupplyStream . Example: 2016-07-07T16:16:01Z

datetime

TrackingUrl

The courier specific URL for tracking the dispatch

nvarchar(4000)

DispatchId

SEKO 360 SupplyStream internal value. Example: 2dfd50ff-eb0c-4eff-bd10-5814d0b0b9f9

nvarchar(100)

CourierService

The courier service the sales order was dispatched on

nvarchar(50)

Weight

The weight of the dispatched goods. Example: 4.25

decimal(18, 4)

WeightUOM

The WeightUOM of the dispatched goods. This is either KG of LB.

nvarchar(2)

ShipToAttention

Delivery address contacts name

nvarchar(200)

DeliveryAddressLine1

Delivery address Line 1

nvarchar(100)

InterfaceRecordId

This is the SEKO360 SupplyStream Globally Unique Identifier. If the GUID is not provided in the Load message, this will be automatically generated by the system. System generated example: a99645dc-5b45-4917-890c-4b02c68ac342.

varchar(100)

DeliveryAddressLine2

Delivery address Line 2

nvarchar(100)

DeliveryAddressLine3

Delivery address Line 3

nvarchar(100)

DeliveryAddressCity

Delivery address city

nvarchar(50)

DeliveryAddressCounty

Delivery address county

nvarchar(50)

DeliveryAddressPostCode

Delivery address postcode

nvarchar(20)

DeliveryAddressCountry

Delivery address country in ISO-2

nvarchar(2)

DeliveryPhoneNumber

Delivery address contacts phone number

nvarchar(20)

DeliveryEmailAddress

Delivery contacts email address

nvarchar(150)

SalesInvoiceNumber

Placeholder

nvarchar(100)

TrackingUrlReturn

Placeholder

nvarchar(200)

SalesOrderNumber

Sales Order Number

nvarchar(50)

SalesOrderReference

Sales Order reference

nvarchar(50)

DispatchNumber

Client specific counter for sales orders. This is the 'Dispatch No' shown in SEKO360in SupplyStream

nvarchar(100)

CourierName

Name of the courier the sales order was dispatched with

nvarchar(100)

CourierRef

Reference code as supplied by the courier service

nvarchar(50)

DCCode

SEKO created code that uniquely identifies the DC from other SEKO DC's. This code is supplied by SEKO.

nvarchar(100)

BeingPickedDate

Date the sales order reached the status of 'Being picked'. Example: 2016-07-07T16:15:35Z

datetime