Description |
As soon as a quantity increase/decrease has been made to stock by the DC on SEKO360, this method will push the stock adjustment information to the Hub. |
System behaviours
- Messages sent for adjustments created in location types: Available Stock, Web Stock, Cross Dock or Query.
- Reason Codes: This page shows the adjustment codes that can occur in a stock adjustment. These values are provided in Stock Adjustment service fields StockAdjustmentLineItemď ReasonCode and StockAdjustmentLineItemď ReasonDescription
Available formats
Entity Relationships
This diagram shows the high level relationship between the entities detailed in the Field Level Details section of this page.
Field level details
StockAdjustment |
|
|
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 |
IntegrationId | This is determined by SEKO360 and is the client unique identifier. This will be a consistent unique value per client. Example: CCIND | nvarchar(100) |
SequenceNumber | This is determined by SEKO360. Every push message will increment by 1 for each service selected | int |
InternalId | SEKO 360 internal value. Example: 2dfd50ff-eb0c-4eff-bd10-5814d0b0b9f9 | varchar(100) |
StockAdjustmentType | This value will be either: | StockAdjustmentType |
StockAdjustmentDate | The date/time the stock adjustment was made. For example: 2017-01-09T16:04:12Z | datetime |
DCCode | SEKO created code that uniquely identifies the DC from other SEKO DC's. This code is supplied by SEKO. | nvarchar(100) |
StockAdjustmentLineItem |
|
|
Field | Description | Data Type |
LineInternalId | SEKO 360 internal value. Example: 0ef15339-73ad-4b26-9e3d-8c50716d3088 | varchar(100) |
LineNumber | Integer that uniquely identifies a line of a stock adjustment. The line number will increment by 1 for every line on a single stock adjustment. | int |
ProductCode | The SKU that has been adjusted | nvarchar(100) |
EAN | The EAN of the SKU that has been adjusted. Data must exist in the product master on SEKO360 to be returned. | nvarchar(50) |
Quantity | The quantity that has been adjusted. Example: 4 | int |
ReasonCode | The reason code for the adjustment. Example: 2 | nvarchar(100) |
ReasonDescription | The reason for the adjustment (linked to the ReasonCode). Example: 'Damaged in Transit'. | nvarchar(100) |
LotNumber | The lot number of the SKU that has been adjusted | nvarchar(100) |
UOM | The system currently supports single units and the UOM will return 1 | nvarchar(50) |
SignedQuantity | The same value as the 'Quantity' field, but based on the StockAdjustmentType, this field will show a negative or positive value (i.e -1 or 1) | int |