VariationWarehouse
The data format VariationWarehouse is used to export and edit your warehouse configuration. Create and export the data format in the Data » Dynamic export menu. The Exporting data page of the manual describes how you export the data format.
Pay close attention to the exact spelling of the data fields. The data cannot be processed if the data fields are spelled incorrectly.
1. Overview of the data fields
Table 1 explains the data fields for the VariationWarehouse data format in alphabetical order as well as filter options that you set in the Filter tab of the data format.
Field name | Explanation | Filter |
---|---|---|
Flag |
Flag |
Activate the filter, select the operator and the flag from the drop-down list. |
Flag2 |
Additional flag |
Activate the filter, select the operator and the flag from the drop-down list. |
MaximumStock |
Maximum stock |
|
ProducerID |
Manufacturer ID |
Activate the filter and select the manufacturer from the drop-down list. |
ReorderLevel |
Reorder level |
|
StockBuffer |
Stock buffer |
|
StockTurnoverInDays |
Stock turnover in days |
|
StorageLocationID |
Storage location ID for the suggested storage location |
|
StorageLocationType |
Storage location type |
|
VariationCustomNumber |
Variation number |
|
VariationID |
Variation ID |
Activate the filter, select the operator and enter the value. |
WarehouseID |
Warehouse ID |
Activate the filter and select the warehouse from the drop-down list. |
WarehouseZone |
Zone in the warehouse |
|
Barcode_xxx |
Barcode |
Activate the filter, select the operator and enter the value. |
Export for customer class |
Note: filter setting only |
Activate the filter and select the customer class. In order to export data for all customer classes, do not activate the filter. Go to Setup » CRM » Classes to set up customer classes. |
2. Overview of the mandatory fields
The following mandatory fields must be available for the data format VariationWarehouse and need to have a valid value saved for them:
-
WarehouseID
-
VariationID
-
VariationCustomNumber, if needed
3. Overview of the synchronisation fields
The data fields that are listed in table 2 are available for data synchronisation. For mandatory synchronisation fields, select the option Synchronisation as Import procedure. Mandatory synchronisation fields are marked with an M. Optional fields are marked with an O. The mandatory synchronisation field WarehouseID must be combined with at least one of the optional fields.
Field name | Explanation | Synchronisation fields |
---|---|---|
VariationCustomNumber |
Variation number |
O |
VariationID |
Variation ID |
O |
WarehouseID |
Warehouse ID |
M |