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 |
...
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
...
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 | IntegrationId | Defines the client uniquely in the system | nvarchar
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 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) |
...