Description |
A snapshot of the stock by location 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
- The StockOvernightLocation is generated on SupplyStream at 00:00 local time to the DC.
Available formats
Entity Relationships
This diagram shows the high level relationship between the entities detailed in the Field Level Details section of this page.
Note: Entity 'Stock Overnight Location' only sent when using REST API.
Field level details
StockOvernightLocation | ||
Field | Description | Data Type |
MessageGroupId | Placeholder | 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 | This is determined by SupplyStream. Every push message will increment by 1 for each service selected | int |
Stock Overnight Location Line Item | ||
Field | Description | Data Type |
AtEndOfDate | The date and time in which the file was generated | DateTime |
ProductCode | Unique SKU identifier code from the product master | nvarchar(100) |
ProductDescription | Short description of SKU from the product master | nvarchar(200) |
LotNo | LotNo of SKU, if the SKU is lot controlled. | nvarchar(100) |
Location | The location of the stock in the DC, for example: "LM-01-A1" | nvarchar(100) |
LocationType | The location type is the type of location the stock is in, i.e. Available Stock, Quarantine, Query, QC | nvarchar(100) |
LPN | The Licence Plate Number of the stock, for example: "126321" | int |
UOM | Placeholder | nvarchar(50) |
Quantity | Total quantity within the specified location (LPN) | int |
BestBeforeDate | Best Before Date of SKU, if the SKU is date controlled | DateTime |
CustomerCode | SupplyStream internal value. Code associated to the customer account Example: IND032 | nvarchar(100) |
CustomerName | Name of the customer account on SupplyStream | nvarchar(200) |
DCCode | SEKO created code that uniquely identifies the DC from other SEKO DC's. This code is supplied by SEKO | nvarchar(100) |
DCName | Name of the SEKO DC | nvarchar(200) |