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. |
...
- 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 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 |
...