Push Stock Overnight Summary
- James Seabrook
- Sara Aslam
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 SEKO 360. 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 SEKO 360 stock report i.e. QtyGRNPendingConfirmed / Free Pending.
- The StockOvernighySummary is generated on SEKO 360 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..png?version=1&modificationDate=1694423140470&cacheVersion=1&api=v2)
"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 available 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. | 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 |
CustomerName | Name of the customer account on SEKO 360. | nvarchar(200) |
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 |
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 |
QuantityInQueryPendingConfirmed | QtyInQueryPendingConfirmed / Query Pending: Total stock that has been received into a "Query" location but the GRN has not been confirmed yet. | 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) |
EAN | The EAN of the SKU, set on the product master. | nvarchar(50) |