Product documentation
In This Topic
    Stock file export definition
    In This Topic

    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)

    See Also