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
Entity Relationships
This diagram shows the high level relationship between the entities detailed in the Field Level Details section of this page.
"StockOvernightSummary" entity sent for API
Field level details
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 | int |
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. 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 | 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. | 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 | 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) |