stockManagementStockMovements

Use the stockManagementStockMovements data format creator to export stock movements and save this data in the cloud. The raw data file is stored in the cloud for a maximum of 6 months. Therefore, the data must be processed before this date. The following tables contain further information about the format.

1. Technical specifications

See Table 1 for further information on the available properties and their corresponding values.

Table 1. Technical specifications of the format **stockManagementStockMovements**
Property	Meaning	Value	Explanation
dataName	Name	stockManagementStockMovements	Name of the creator process and prefix of the created file. File name: stockManagementStockMovements-xxx.csv.gz
fileFormat	File format	CSV, GZIP	The data is provided as a GZIP-compressed CSV file (RFC 1952).
limitPage	Lines per request	up to 10,000	The maximum number of data rows that is written into a single file.
limitDay	Lines per day	up to 200,000	The maximum number of data rows that is written on one day in total.
earliestPossibleDataDate	Earliest point in time	2020-01-01	Point in time as of which the raw data can be collected. The data is filtered by the date saved in the dataUpdatedAtColumnName column.
filterType	Filter type	lastUpdate	Data are filtered based on the last update.
dataUpdatedAtColumnName	Column header	smsm_created_at	Name of the column that contains the time stamp for when the data was created.
defaultActive	Activated by default	no	The data is only exported automatically in the background after you have activated the creator in the Setup » plentyBI » Raw data menu.
interval	Interval	daily	With this setting, all data that has been changed since the last run is exported once a day, usually during the night.
storableFromPlan	Storage starting from tariff	plentyBI XS	Minimum fee plan required for saving the data in cloud storage and making it available via REST.

2. Data columns

See Table 2 for further information on the stockManagementStockMovements data columns included in the CSV file during raw data export.

Table 2. Data columns of the format **stockManagementStockMovements**
Column name	Data type	Full name	Explanation
plenty_id	INTEGER NOT NULL	plenty id	ID of the plentymarkets system
smsm_id (Primary key)	VARCHAR NOT NULL	stock management stock movement ID	Contains the primary key of the data line.
i_id	VARCHAR NOT NULL	item id	The item’s ID
iv_id	VARCHAR NOT NULL	item variation id	ID of the variation
smw_id	VARCHAR NOT NULL	stock management warehouse ID	ID of the warehouse
smsm_quantity	NUMERIC(8,2)	stock management stock movement quantity	Quantity of items contained in the stock movement
smsm_reason_id	SMALLINT NOT NULL	stock management stock movement reason ID	ID of the reason of the stock movement Possible values: 101 = 101 = incoming items booked 102 = 102 = booked in by stocktaking 301 = 301 = stock correction 307 = 307 = stock correction because of damage 401 = 401 = Stock transfer Further possible values are listed in our documentation for developers .
sl_name	VARCHAR	storage location name	Name of the storage location
smsm_created_at	TIMESTAMPTZ NOT NULL	stock management stock movement created at	Time stamp of the creation Date format: MM/DD/YYYY HH:MI:SS TZ