Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...


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

System behaviours

  • Some of the StockOvernightSummary fields have a different naming convention to the 'Stock Report' available on SupplyStream. In the field level descriptions of this service, the value on the left is used in the Stock Overnight Summary and the value on the right is for the SupplyStream stock report i.e. QtyGRNPendingConfirmed / Free Pending.

  • The StockOvernighySummary is generated on SupplyStream at 00:00 local time to the DC. Stock files will be split by DC.

  • This service will only return a SKU if there is at least one value in the Stock Overnight Summary that is more than 0. If a SKU has stock, and then has 0, the SKU will be removed from the next scheduled service run.

  • Negative quantities are not shown.

  • Each MessagePart will have a max of 100 records. The messages are sent one after the other. MessagePart 1 then MessagePart 2 then MessagePart 3 etc. 

Available formats

API

FTP

Manual

XML

x

x

JSON

x

CSV

x

Entity Relationships

This diagram shows the high level relationship between the entities detailed in the the Field Level Details section  section of this page.

"StockOvernightSummary" entity sent for API

Field level details

StockOvernightSummary

Field

Description

Data Type

MessageGroupId

Placeholder

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)

Anchor
_Toc470183172
_Toc470183172
Anchor
_Toc473117627
_Toc473117627