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