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 |
...
- The StockOvernightLocation is generated on SEKO360 on SupplyStream at 00:00 local time to the DC.
...
Manual | |||
XML | x | x | |
JSON | x | ||
CSV | x |
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.
...
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 SEKO360SupplyStream. 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 | SEKO 360 SupplyStream internal value. Code associated to the customer account Example: IND032 | nvarchar(100) |
CustomerName | Name of the customer account on SEKO360on 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) |
...