Product documentation
In This Topic
    Confirmed demand export definition
    In This Topic

    Field ID

    Detail

    Description

    Field Type

    Max Length

    Mandatory

    Default D365FO - HSO field  (remarks)

    1

    Record Type

    This is the type of the document. The confirmed demand file always has the value “9” in this field.

    Integer

    1

    Y

    Fixed Number: 9

    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 locations exist

    Warehouse with underscore suffix

    6

    Article Code

    This field must be filled with your custom article code.

    Alpha

    25

    Y

    Standard item: item number

    Product master: product nr 

    7

    Confirmed Order Number

    This is the Confirmed Sales or Production Order number.

    Alpha

    100

    Y

    Sales order number 

    Transfer shipment order

    Production order

    8

    Confirmed Order Required Date

    This is the requested delivery date for the confirmed order number. The date profile must be the same as that used in all other date fields.

    Date

     

    Y

    Prio 1: Confirmed ship date

    Prio 2: Requested ship date

     

    Production BOM: raw material date

    9

    Confirmed Order Required Quantity

    This is the open required quantity associated with the confirmed order number.

    Int

     

    Y

    Remaining quantity (inventory unit). Does not include the quantity already picked

    10

    Blank

    This field needs to be kept empty (blank).

     

     

    Blank

     

    11

    Confirmed Order Type

    This field indicates what type of confirmed demand is associated with the confirmed order number, e.g. production order or customer order.

    Alpha

    60

    N

    Sales

    Transfer

    Production BOM

    12

    Customer Details

    These are the details of the customer requesting the quantity associated with the confirmed order number, e.g. the customer name and/or number.

    Alpha

    100

    N

    Customer number

    To warehouse and name

    Work center (cost) if applicable

    13

    Production Details

    These are the details of the production process requiring the quantity associated with the confirmed order number, e.g. the end product or production facility.

    Alpha

    100

    N

    Responsible sales worker name 

    14

    Confirmed Order Comments

    This is the comment line on the confirmed order header or line associated with the confirmed order number, e.g. text, shipping conditions, delivery address or other conditions related to the order.

    Alpha

    4000

    N

     Empty

    15

    Original Quantity

    This is the originally requested quantity associated with the confirmed order number. This field is numeric, limited to positions, maximum 2 decimals are permitted.

    Real

     

    N

    Ordered quantity

    (inventory unit) 

    16

    Supplied Quantity

    This is the already supplied/delivered quantity associated with the confirmed order number. The supplied quantity + open quantity should equal the original quantity.

    Real

     

    N

    Received quantity

    (inventory unit). Including the quantity already picked

    17

    Confirmed Order Free Text 1

    This is a free text field that can be used to show remarks or information related to the confirmed order, e.g. shipping conditions, delivery address or conditions related to the order.

    Alpha

    255

    N

    Empty 

    18

    Confirmed Order Free Text 2

    This is a free text field that can be used to show remarks or information related to the confirmed order, e.g. shipping conditions, delivery address or conditions related to the order.

    Alpha

    255

    N

     Empty

    19

    Confirmed Order Free Number 1

    This is a free numeric field that can be used to show numeric information related to the confirmed order. This field is numeric, limited to positions, maximum 2 decimals are permitted.

    Real

     

    N

     Empty

    20

    Confirmed Order Free Number 2

    This is a free numeric field that can be used to show numeric information related to the confirmed order. This field is numeric, limited to positions, maximum 2 decimals are permitted.

    Real

     

    N

     Empty

    21

    Order Type

    Specifies type of confirmed demand. Standard are blank or 1 for regular Confirmed Demand and 2 for Slim4 Production Orders. However possible to define up to 9 different types [0-9].

     

    1

    N

    1 = Sales order

    2 = Transfer order

    4 = Production BOM line 

    22

    Line Number

    Line number of order.

    Integer

    10

    Y

     Line number * 1000

    See Also