Push Stock Adjustment
- James Seabrook
- Sara Aslam
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
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
API adjustment messages are separated by Increase and Decrease. You will not see both in a single message/file.
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. API only. | int |
MessageTotal | This is the total number of messages. API only. | 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. This is the DC's main reference point | int |
InternalId | SEKO 360 internal value. Unique. 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) |
LocationType | The the type of location the stock is in, i.e. Available Stock, Query | nvarchar(100) |
StockAdjustmentLineItem | ||
Field | Description | Data Type |
LineInternalId | SEKO 360 internal value. Unique. 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 |