Description

A snapshot of the stock by location in the DC generated at the end of day. The time in which this is generated is based on the time zone of the DC

API

FTP

Manual

XML

x

x

JSON

x

CSV

x

StockOvernightLocation

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

SequenceNumber

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

int

Stock Overnight Location Line Item

Field

Description

Data Type

AtEndOfDate

The date and time in which the file was generated

DateTime

ProductCode

Unique SKU identifier code from the product master

nvarchar(100) 

ProductDescription

Short description of SKU from the product master

nvarchar(200) 

LotNo

LotNo of SKU, if the SKU is lot controlled.

nvarchar(100) 

Location

The location of the stock in the DC, for example: "LM-01-A1"

nvarchar(100) 

LocationType

The location type is the type of location the stock is in, i.e. Available Stock, Quarantine, Query, QC

nvarchar(100) 

LPN

The Licence Plate Number of the stock, for example: "126321"

int

UOM

Placeholder

nvarchar(50) 

Quantity

Total quantity within the specified location (LPN)

int

BestBeforeDate

Best Before Date of SKU, if the SKU is date controlled

DateTime

CustomerCode

SupplyStream internal value. Code associated to the customer account Example: IND032

nvarchar(100) 

CustomerName

Name of the customer account on SupplyStream

nvarchar(200) 

DCCode

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

nvarchar(100)

DCName

Name of the SEKO DC

nvarchar(200)