...
...
...
...
...
...
...
...
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 the Field Level Details section 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 |