StockOvernightSummaryLineItem

Field

Description

Data Type

SummaryStockHeaderId

SEKO 360 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

int

QuantityInCrossDock

QtyInCrossDock / Cross Dock: Total stock in a "Cross Dock" location. Cross Dock stock does not require the GRN to be confirmedavailable for new orders. This accounts for orders that have been raised, but have not been picked yet. For example, if SKU ABC had 100 QtyOnHand, and a new order comes through for a quantity of 1, the QtyOnHand would reduce to 99. The QuantityInAllocated would increase by 1.

int

QuantityInQuarantine

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

intQuantityInReturns

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

SEKO 360 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.

intQuantityInQueryOnHold

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

SEKO 360 internal value.

nvarchar(200)

DcCompanyCode

SEKO 360 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)