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