Description

A snapshot of the stock 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

StockOvernightSummary

Field

Description

Data Type

MessageGroupId

Example: "DCCL01-4/8/2020 11:59:59 PM"

This will remain the same for all message parts.

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

Will increment by 1 for every entity pushed. Example: 2300

StockOvernightSummaryLineItem

Field

Description

Data Type

SummaryStockHeaderId

SupplyStream internal value. Example: d1a0f521-2560-4129-8282-020709a6d723

nvarchar(100)

AtEndOfDate

Date the message was generated

datetime

QuantityOnHand

QtyOnHand / Free: Total stock in a confirmed "Available Stock" location. Does not include stock already allocated to orders.

int

QuantityInCrossDock

QtyInCrossDock / Cross Dock: Total stock in a "Cross Dock" location. Cross Dock stock does not require the GRN to be confirmed.

int

QuantityInQuarantine

QtyInQuarantine / Quarantine: Total stock in a "Quarantine" location. Quarantine does not require the GRN to be confirmed.

int

QuantityInReturns

QtyInReturns / Returns: Total stock in a "Returns" location. Returns do not require the GRN to be confirmed.

int

QuantityInPutAway

QtyInPutAway / To Put Away: Total stock that has been received into a bin box but not put away into a location.

int

QuantityInPick

QtyInPick / Pick: Total dispatch quantity currently being picked.

int

QuantityInAllocated

QtyInAllocated / Free Allocated: Total stock for confirmed dispatch requests in an "Available Stock" location ready to be picked.

int

QuantityToDispatch

QtyToDispatch / To Dispatch: Total dispatch quantity packed and ready to be dispatched.

int

QuantityGrnPendingConfirmed

QtyGRNPendingConfirmed / Free Pending: Total stock that has been received into an "Available Stock" location but the GRN has not been confirmed yet.

int

QuantityInCrossDockAllocated

QtyInCrossDockAllocated / Cross Dock Allocated: Total stock for confirmed dispatch requests in a "Cross Dock" location ready to be picked.

int

CustomerName

Name of the customer account on SupplyStream 

nvarchar(200)

QuantityInWebStock

QtyInWebStock / Web Stock: Total stock in a confirmed "Web Stock" location.

int

QuantityInWebStockPendingConfirmed

QtyInWebStockPendingConfirmed / Web Stock Pending: Total stock that has been received into a "Web Stock" location but the GRN has not been confirmed yet.

int

QuantityInWebStockAllocated

QtyInWebStockAllocated / Web Stock Allocated: Total stock for confirmed dispatch requests in a "Web Stock" location ready to be picked.

int

QuantityInBulkStock

QtyInBulkStock/ Bulk Stock: Total stock in a "Bulk Stock" location. Bulk Stock does not require the GRN to be confirmed.

int

QuantityInReserved

Placeholder field. Not used

int

TotalInDc

Combination of all stock totals throughout the DC including pick totals. This is NOT an available stock total. It is all stock still within the DC (including picked stock).

int

DCCode

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

nvarchar(100)

QuantityInOnHold

QtyInOnHold / Free on Hold: Total stock for confirmed dispatch requests in an "Available Stock" location marked as "On Hold".

int

QuantityInWebStockOnHold

QtyInWebStockOnHold / Web Stock on Hold: Total stock for confirmed dispatch requests in a "Web Stock" location marked as "On Hold".

int

QuantityInCrossDockOnHold

QtyInCrossDockOnHold / Cross Dock on Hold: Total stock for confirmed dispatch requests in a "Cross Dock" location marked as "On Hold".

int

CustomerCode

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

nvarchar(100)

QuantityInQc

QtyInQC / QC: Total stock in a confirmed "QC" location

int

QuantityInQcPendingConfirmed

QtyInQCPendingConfirmed / QC Pending: Total stock that has been received into a "QC" location but the GRN has not been confirmed yet.

int

QuantityInQuery

QtyInQuery / Query: Total stock in a confirmed "Query" location.

int

QuantityInQueryOnHold

QtyInQueryOnHold / Query on Hold: Total stock for confirmed dispatch requests in a "Query" location marked as "On Hold".

int

QuantityInQueryPendingConfirmed

QtyInQueryPendingConfirmed / Query Pending: Total stock that has been received into a "Query" location but the GRN has not been confirmed yet.

int

QuantityInQueryAllocated

QtyInQueryAllocated / Query Allocated: Total stock for confirmed dispatch requests in a "Query" location ready to be picked.

int

DcCompanyName

SupplyStream internal value.

nvarchar(200)

DcCompanyCode

SupplyStream internal value.

nvarchar(100)

DcName

Name of the SEKO DC

nvarchar(100)

ProductCode

Unique SKU identifier code from the product master

nvarchar(100)

ProductDescription

Short description of SKU from the product master

nvarchar(200)

Attributes

Placeholder

nvarchar(1000)

EAN

The EAN of the SKU, set on the product master.

nvarchar(50)