System operation
StockSAVER manual - Software version 2.1
57
−
If a Location is deleted or the bus configuration is amended, an entry is exported with the
quantity 0 and without stock limits.
Formatting rules
−
UTF-8 is used as a character set for the CSV file.
−
Fields are separated by semicolons (;).
−
A double quotation mark " is used as an escape character. A semicolon or double
quotation marks indicate an escape in a character string.
−
Double quotation marks " are displayed twice in an escape sequence.
Example:
Character string: Large T-shirt; long-sleeved and "colourful"
Output in CSV file: Large T-shirt; "long-sleeved and ""colourful"""
Field descriptions
−
The CSV file is always generated with all fields.
−
The specified data types correspond to the SQL server data types for the corresponding
columns.
−
For optimum compatibility we recommend using data types with the same or larger value
ranges in interfaces.
−
The quantity, sequence and definition of the fields may change in future updates of
WERMA StockSAVER.
Field ID
Data type
Description
Id
[bigint]
Internal database ID of the MaterialLog data
set.
Timestamp
[datetime2]
Timestamp, of when the data set was created
in the database. Corresponds to the local time
(and time zone) on the server. The timestamp is
formatted in line with ISO 8601.
MaterialId
[int]
Internal database ID for the assigned material.
MaterialName
[nvarchar] (32) Assigned Part Number
The Part Number allocated to the material with
the ID from the MaterialId field at the time of
export.
MaterialDescription1
[nvarchar] (60) Description of the assigned material.
The material description saved for the material
with the ID from the MaterialId field at the time
of export.
ShelfFieldId
[int]
Internal database ID of the Location.
ShelfFieldName
[nvarchar] (40) Name of the assigned Location.
The name of the Location at the time of
posting is used.
BoxCount
[int]
The detected/new quantity of bins at the time.
PiecesPerBox
[int]
Bin quantity (pcs per bin).
Amount
[int]
Stock in this Location in pieces
Current BoxCount * PiecesPerBox
(The definition may be changed in future
updates, e.g. counted quantities)
