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)