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