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.

This diagram shows the high level relationship between the entities detailed in the the Field Level Details section section of this page.

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

SupplyStream 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

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

SupplyStream internal value. Unique. Example: 2dfd50ff-eb0c-4eff-bd10-5814d0b0b9f9	varchar(100)
StockAdjustmentType	This value will be either: 'Increase' : an increase to the Available Stock quantity 'Decrease': a decrease to the Available Stock quantity	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 type of location the stock is in, i.e. Available Stock, Query.	nvarchar(100)

SEKO 360

SupplyStream 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

SupplyStream 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