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)

CONumber

This is the Confirmed Sales or Production Order number.

String(100)

Sales order

Transfer order (outbound)

Production BOM line

RequiredDate

This is the requested delivery date for the confirmed order number.

YYYYMMDD

Requested (confirmed) ship date

Raw material date

RequiredQuantity

This is the open required quantity associated with the confirmed order number.

Integer

Open requested quantity (summarized inventory transactions On order + Ordered reserved + Reserved physical)

Negative sales lines: summarized ordered inventory transactions

ExceptionLevel

This is the percentage of the weekly forecast, which when exceeded by the confirmed demand orders, will trigger Slim4 to add to the forecast. If left blank, the Slim4 default will be used. This field should be set to 0 for orders which are not part of the forecast and therefore the total quantity of the order needs to be added. No percentage signs are permitted, e.g. 80 for 80%.

Integer

0

OrderType

This field indicates what type of confirmed demand is associated with the confirmed order number, e.g. production order or customer order.

String(60)

Sales, Project (Item requirements)

Transfer shipment

(Production) BOM line

CustomerDetails

These are the details of the customer requesting the quantity associated with the confirmed order number, e.g. the customer name and/or number.

String(100)

Customer ID (or customer ID and name if export GDPR data = yes)

BOM line: work center

ProductionDetails

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.

String(100)

Sales rep name

COComment

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.

String(4000)

Empty

Limited to str40 

Original

Quantity

This is the originally requested quantity associated with the confirmed order number.

Integer

Original quantity on order.

Not updated through deliver remainder.

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.

Integer

Supplied quantity, i.e. Picked quantity + Delivered quantity

FreeText1

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.

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

Type

Order Type Number specifies type of confirmed demand. For regular Confirmed Demand use blank, 0 or 1, for Production Orders use 2. It is possible to define up to 9 different types. Number 9 is reserved for Slim4 Production orders.

Integer

1=Sales

2=Production BOM line

3=Transfer shipment

LineNumber

Line number of orderline.

Integer

Line number * 1000

If line numbers are not unique, the next higher line number is used