Attribute

Description

Field type

Microsoft Dynamics 365 for Finance and Operations field

Remark

Warehouse

Warehouse

String(20)

Warehouse

ArticleCode

Article code (SKU)

String(40)

Released product (Released product variant)

PONumber

This is the Purchase Order number, purchase agreement, transfer receipt, production order

String(100)

Purchase order

Purchase agreement

Transfer order

Production order

Planned receipt in this warehouse

DeliveryDate

This is the expected arrival date of the purchase order.

YYYYMMDD

Expected (confirmed) receipt date

Purchase agreement: expiry date

OpenQuantity

This is the open quantity associated with the incoming purchase order number.

Integer

Open quantity (summarize inventory transactions with status Ordered)

Purchase agreement remaining release quantity

Supplier

Details

These are the supplier details (name and/or number) associated with the purchase order number.

String(100)

Purchase order and agreeement: Vendor ID and name

Transfer order: From-warehouse and name

Production order: Pool

PoComment

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.

String(4000)

Purchase order: external item ID

Original

Quantity

This is the originally ordered quantity associated with the purchase order number.

Integer

Original quantity ordered.

Not updated through deliver remainder.

Supplied

Quantity

This is the part-supplied quantity associated with the purchase order number. The supplied quantity + open quantity should equal the original quantity, unless deliver remainder is used.

Integer

Quantity that was already received

FreeText1

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.

String(255)

Field mapping

FreeText2

Idem

Idem

Field mapping

FreeNumber1

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.

Num(15,4)

Field mapping

FreeNumber2

Idem

Idem

Field mapping

OrderType

Number

Specifies type of purchase. Standard are blank or 1 for regular Purchase Order, and 2 for Purchase Contract. It is possible to define up to 9 different types [0-9] in total combined with confirmed orders.

Integer

1=Purchase order

2=Purchase agreement

3=Transfer order receipt

4=Production order

LineNumber

Line number of orderline.

Integer

Line number * 1000

Exclude

Setting

Specifies exclude setting of purchase types. Options are;

0: no exclusions

1: no order requisitions allowed before latest arrival date of purchase

2: order should be ignored whilst date is not within horizon and only allow for new purchase requisitions up to an Exclude Before Date

3: order should be ignored completely

Integer

Empty

ExcludeDate

With exclude setting 2 an exclude before date can be specified

YYYYMMDD

Empty

Exclude

FromAM

A purchase order line can be excluded from Allocation Manager (AM) by specifying a 1 in this column. This particular line is then excluded when loading data in the Allocation Manager. In order to exclude the complete Purchase Order, all lines should be filled with 1.

Integer

Empty

Supplier

Number

This is the code associated with your supplier. If more than one supplier exists for an article, use the suppliers file/table, or supply the preferred supplier code only.

String(20)

Purchase order and agreement: Vendor ID

Transfer order: From-warehouse

Supplier

Name

This is the name of the supplier associated with the code above.

String(60)

Purchase order and agreement: Vendor name

Transfer order: From-warehouse name

ActiveDate

Related to the purchaseContract module. In case of contracts in the file, this is the date when a contract is active from.

YYYYMMDD

Purchase agreement: Effective date

DefaultContract

Related to the purchaseContract module. This is a 0 or 1, that indicates if the contract should be applied on the article by default. This is imported especially when multiple contract exists for the same article. NOTE: only one contract can have 1 for a given article.

Integer

0

BuyingPrice

This is the buying price of the item on the purchase order.

Num(15,4)

Purchase (agreement) line price for 1 inventory unit converted to company currency

Production order and transfer order: cost price for 1 unit 

OrderDate

The order/creation date of the purchase order

YYYYMMDD

Creation date of the order

RequestDate

The request date of the purchase order

YYYYMMDD

Empty