ID |
Detail |
Description |
Field Type |
Max (lenght) |
Mandatory |
Default D365FO - HSO field (remarks) |
1 |
Record Type |
This is the type of the document. The stock file always has the value “3” in this field. |
Integer |
1 |
Y |
Fixed Number: 3 |
2 |
Year |
The stock file always has the current date. This is thus the current year. |
Integer |
4 |
Y |
Current Year |
3 |
Month |
The stock file always has the current date. This is thus the current month. |
Integer |
2 |
Y |
Current Month |
4 |
Week |
The stock file always has the current date. This is thus the current ISO week. |
Integer |
2 |
Y |
Current ISO Weeknr |
5 |
Warehouse Code |
In Slim4 you are able to control the stock anonymously or by warehouse. Controlling stock by warehouse adds an additional code to your custom article code. |
Alpha |
10 |
Y when multiple warehouses exist |
Warehouse with underscore suffix |
6 |
Article Code |
This field must be filled with your custom article code. |
Alpha |
25 |
Y |
Standard items: Item number Product master: product number |
7 |
Stock On Hand |
This is the number of units of stock that is freely available for use. Decimals are not permitted. |
Integer |
11 |
Y |
Physical inventory NB: incl. reserved inventory! |
8 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
Remaining sales physical (inventory unit). Aggregation can be skipped (parameter) |
9 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
10 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
11 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
12 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
13 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
14 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
15 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
16 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
17 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
18 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
19 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
20 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
21 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
22 |
Criterium 1 |
The Criteria are used as multipliers in Slim4. The entry needs to match the unit of measure in which stock is held in Slim4. Typically used criteria are: weight, volume, share in pallet, share per container etc. This field is decimal, limited to 38 positions (including the decimal separator and decimals), maximum 14 decimals are permitted, e.g. 99999999999999999999999.99999999999999 |
Numeric |
38 |
N |
(In previous version: purchase price. Now moved to field 80) |
23 |
Criterium 2 |
The Criteria are used as multipliers in Slim4. The entry needs to match the unit of measure in which stock is held in Slim4. Typically used criteria are: weight, volume, share in pallet, share per container etc. This field is decimal, limited to 38 positions (including the decimal separator and decimals), maximum 14 decimals are permitted, e.g. 99999999999999999999999.99999999999999 |
Numeric |
38 |
N |
Gross volume |
24 |
Criterium 3 |
The Criteria are used as multipliers in Slim4. The entry needs to match the unit of measure in which stock is held in Slim4. Typically used criteria are: weight, volume, share in pallet, share per container etc. This field is decimal, limited to 38 positions (including the decimal separator and decimals), maximum 14 decimals are permitted, e.g. 99999999999999999999999.99999999999999 |
Numeric |
38 |
N |
Gross weight |
25 |
Criterium 4 |
The Criteria are used as multipliers in Slim4. The entry needs to match the unit of measure in which stock is held in Slim4. Typically used criteria are: weight, volume, share in pallet, share per container etc. This field is decimal, limited to 38 positions (including the decimal separator and decimals), maximum 14 decimals are permitted, e.g. 99999999999999999999999.99999999999999 |
Numeric |
38 |
N |
|
26 |
ABC Class |
This is the ABC classification from your ERP system. If no ABC classification is present or used in your ERP, leave this field blank. |
Alpha |
2 |
N |
ABC code based on Revenue (if filled) |
27 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
28 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
29 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
30 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
Sold quantity this month. Aggregation can be skipped (parameter) |
31 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
32 |
Article Description |
The description related to the unique article code should be entered here. |
Alpha |
60 |
Y |
Short Description Standard item: Item name Product master: variant name |
33 |
Lead Time |
This is the time that expires between the point of order and when an item is available for use. This includes the manufacturing time as agreed with the supplier, as well as goods processing, shipping, etc. This field is decimal, limited to 6 positions including the decimal point and decimals, maximum 2 decimals are permitted, e.g. 999.99. |
Number |
6 |
Y |
Vendor lead time If expressed in working days, the number of days is multiplied by 7/5 NB Receipt margin and order margin are not taken into account |
34 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
Review time. Prio 1: coverage group Prio 2: vendor |
35 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
36 |
Run Code |
This is an indicator for which week in a month has been reached. If this number does not correspond with the week number in Slim4 no order suggestions will be calculated. This field is an integer, limited to 1 position, ranging from 1 - 5. |
Integer |
1 |
Y |
real2int(round((dayofmth(systemdateget())/7)+0.5,1) |
37 |
Supplier Number |
This is the code associated with your supplier. If more than one supplier exists for an article, the preferred supplier code should be given. |
Alpha |
20 |
Y |
Primary vendor |
38 |
Supplier Name |
This is the name of the supplier associated with the code above. |
Alpha |
60 |
Y |
Primary vendor name |
39 |
MOQ |
This is the minimum purchase order quantity permitted, as agreed with your supplier. If an entry is given in this field, any order suggestion in Slim4 will be rounded up to at least this value. Note: If there is no MOQ data available, this field must be left blank. Slim4 will then use a default value. |
Integer |
11 |
Y |
Minimum purchase order quantity Prio 1: Site specific order settings Prio 2: Default order settings |
40 |
IOQ |
This is the incremental order quantity, to be used once the minimum order quantity has been reached. For any order suggestion in Slim4 that exceeds the MOQ, the order suggestion will be rounded up to multiples of this field, e.g. the MOQ is equal to a pallet quantity, the IOQ can be a pallet layer or the smallest amount permissible on a pallet. Note: If there is no IOQ data available, this field must be left blank. Slim4 will then use a default value of 1. |
Integer |
11 |
Y |
Multiple purchase order quantity Prio 1: Site specific order settings Prio 2: Default order settings
|
41 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
42 |
Unit Price |
This is the price (commonly per unit, see below in Price Per) that is used to determine stock value, e.g. average landed cost, average weighted cost, etc. This field is decimal, limited to 15 positions including the decimal point and decimals, maximum 4 decimals are permitted, e.g. 9999999999.9999. |
Number |
15 |
Y |
Cost price Prio 1: cost price per site and product dimension Prio 2: cost price released item |
43 |
Sales Price |
This is the price the sales price for an item. This field is decimal, limited to 15 positions including the decimal point and decimals, maximum 4 decimals are permitted, e.g. 9999999999.9999. |
Number |
15 |
N |
Sales price Prio 1: valid trade agreement for all customers (not for a specific price group) Prio 2: basic sales price |
44 |
Product Group Number 1 |
|
Alpha |
20 |
N |
Item group |
45 |
Product Group Name 1 |
|
Alpha |
20 |
N |
Item buyer group |
46 |
Product Group Number 2 |
|
Alpha |
20 |
N |
Coverage group |
47 |
Product Group Name 2 |
|
Alpha |
20 |
N |
Sales blocked Y / N |
48 |
Product Group Number 3 |
|
Alpha |
20 |
N |
Inventory blocked Y / N |
49 |
Product Group Name 3 |
|
Alpha |
20 |
N |
Purchase blocked Y / N |
50 |
Price Per |
Conversion Factor when Unit Price is not in the same unit of measure as Inventory data is. |
Integer |
11 |
N |
Conversion factor NB: Assumption: purchase price unit = purchase quantity unit |
51 |
Stocked Item |
This field can be used to separate the Slim4 database into stocked items, non- stocked items and promotion items. Slim4 will calculate forecasts and generate exceptions for all items. Slim4 will only calculate a buffer stock, order level and order suggestions, automatically and continuously, for stocked items. Non-Stocked items will have a buffer stock and order level of zero; order suggestions will only be made if there is insufficient stock (including outstanding purchase orders) to meet customer requirements (back/confirmed future orders). Stocked items are identified as “Y”. Non-stocked items are identified as “N”. |
Alpha |
1 |
Y |
Stocked item Y / N according to item coverage field ‘Stock keeping item’ Y/N. See paragraph 2.3 in this document. |
52 |
Free Field 1 |
|
|
255 |
N |
|
53 |
Free Field 2 |
|
|
255 |
N |
|
54 |
Free Field 3 |
|
|
255 |
N |
|
55 |
Free Field 4 |
|
|
255 |
N |
|
56 |
Free Field 5 |
|
|
255 |
N |
|
57 |
Free Field 6 |
|
|
255 |
N |
|
58 |
Free Field 7 |
|
|
255 |
N |
|
59 |
Free Field 8 |
|
|
255 |
N |
|
60 |
Free Field 9 |
|
|
255 |
N |
|
61 |
Free Field 10 |
|
|
255 |
N |
|
62 |
Free Field 11 |
|
|
255 |
N |
|
63 |
Free Field 12 |
|
|
255 |
N |
|
64 |
Free Field 13 |
|
|
255 |
N |
|
65 |
Free Field 14 |
|
|
255 |
N |
|
66 |
Free Field 15 |
|
|
255 |
N |
|
67 |
Predecessor / Successor |
This is either always the predecessor item (warehouse code + item code) or the successor item (warehouse code + item code). This field is alphanumeric, limited to 35 characters. Note: Either the predecessor or successor code can be interfaced. However, this has to be consistent throughout the range, rather than vary from one item to another. |
Alpha |
35 |
N |
Alternative item. Here the successor can be filled. |
68 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
69 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
70 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
71 |
Blank |
This field needs to be kept empty (blank). |
|
|
Blank |
|
72 |
EOQ Logistic Unit 1 |
Number of articles per logistic unit. Smallest till largest. i.e. Consumer Unit, Box, Pallet Layer, Palet |
Integer |
10 |
N |
Smallest multiple based on existing unit of measure conversions for this item |
73 |
EOQ Logistic Unit 2 |
Number of articles per logistic unit |
Integer |
10 |
N |
Second smallest multiple based on existing unit of measure conversions for this item |
74 |
EOQ Logistic Unit 3 |
Number of articles per logistic unit |
Integer |
10 |
N |
Third smallest multiple based on existing unit of measure conversions for this item |
75 |
EOQ Logistic Unit 4 |
Number of articles per logistic unit |
Integer |
10 |
N |
Fourth smallest multiple based on existing unit of measure conversions for this item |
76 |
EOQ Logistic Unit 5 |
Number of articles per logistic unit |
Integer |
10 |
N |
Fifth smallest multiple based on existing unit of measure conversions for this item |
77 |
EOQ Logistic Unit 6 |
Number of articles per logistic unit |
Integer |
10 |
N |
Sixth smallest multiple based on existing unit of measure conversions for this item |
78 |
Min. selling qty |
This is the Minimum Selling Quantity for this item which is used in calculating an order level that is minimized with this value. |
Integer |
10 |
N |
Default order setting for min sales qty. Prio 1: Site specific order settings Prio 2: Default order settings |
79 |
Incremental selling qty |
This is the Incremental Selling Quantity for this item which is used in calculating an order level that is rounded with this value. |
Integer |
10 |
N |
Default order settings for sales multiples. Prio 1: Site specific order settings Prio 2: Default order settings
|
80 |
Buying price |
This is the buying price per unit. |
Real |
15 |
N |
Purchase price Prio 1: valid purchase price trade agreement for primary vendor (no discounts)
Prio 2: basic purchase price (in previous version, this information was exported in field 22) |