Product documentation
In This Topic
Purchase order 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 purchase order file always has the value “8” in this field.

Integer

1

Y

Fixed Number: 8

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 number

7

Purchase Order Number

This is the Purchase Order, Transfer Order, Production Order, Purchase Contract number.

Alpha

100

Y

Purchase order number

Agreement number

Transfer receipt number

Production order 

8

Purchase Order Arrival Date

This is the expected arrival date of the order. Date Format should be consistent (see technical requirements of files).

DateStamp

 

Y

Expected receipt date

 

9

Purchase Order Open Quantity

This is the open quantity associated with the incoming purchase order number. This field is an integer, limited to positions. Decimals are not permitted.

Integer

10

Y

Open quantity (inventory unit) 

10

Purchase Order Supplier Details

These are the supplier details (name and/or number) associated with the purchase order number. This field is alphanumeric, limited to 100 characters.

Alpha

100

N

Vendor ID vendor name

Production name and pool

11

Purchase Order Comments

This is the comment associated with the purchase order number, either from the header or line PO line, or can be used for order details, such as shipping conditions, delivery address or conditions related to the order. This field is alphanumeric, limited to 4000 characters.

Alpha

4000

N

Vendor item ID 

12

Purchase Order Original Quantity

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

Real

 

N

Original or committed quantity

Production quantity scheduled 

13

Purchase Order Supplied Quantity

This is the part-supplied quantity associated with the purchase order number. The supplied quantity + open quantity should equal the original quantity. This field is numeric, limited to positions, maximum 2 decimals are permitted.

Real

 

N

Received quantity including registered quantity

14

Purchase Order Free Text 1

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

Alpha

255

N

Transfer order and production order: created date time 

15

Purchase Order Free Text 2

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

Alpha

255

N

 Empty

16

Purchase Order Free Number 1

This is a free numeric field that can be used to show numeric information related to the purchase order, e.g. order line number, number of items on the order, other article codes on the order, number of items already received from the order. This field is numeric, limited to positions, maximum 2 decimals are permitted.

Real

 

N

 Empty

17

Purchase Order Free Number 2

This is a free numeric field that can be used to show numeric information related to the purchase order, e.g. order line number, number of items on the order, other article codes on the order, number of items already received from the order. This field is numeric, limited to positions, maximum 2 decimals are permitted.

Real

 

N

 Empty

18

Order Type

Specifies type of purchase. Standard are 1 for regular Purchase Order, and 2 for Purchase Contract. However possible to define up to 9 different types [0-9].

Integer

1

Y

order type

1 = Purchase order

2 = Purchase agreement

3 = Transfer receipt

4 = Production

19

Line Number

Line number of order.

Integer

10

Y

Purchase line number

Purch. agreement line nr *1000

Transfer line number * 1000

Production: 1000

20

Blank

This field needs to be kept empty (blank).

 

 

Blank

 

21

Blank

This field needs to be kept empty (blank).

 

 

Blank

 

See Also