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)

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)

Vendor account number

Supplier

Name

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

String(60)

Vendor name, initialized from the vendor

The name is retrieved again when Update export data is executed

Primary supplier

For the supplier number that is your primary supplier for an article+warehouse combination populate this field with a 1 to indicate normally you want to order at this supplier.

Integer (0/1)

Preference

This indicates the preference per item for the different suppliers (1,2,3,4..)

Integer

LeadTime

This is the time that expires between the point of order and when an item is available for use. This includes the manufacturing time as agreed with the supplier, as well as goods processing, shipping, etc.  Note: The unit in which the lead time is given (days, weeks or months) must be equal to the unit of the review time and consistent for all items.

Num(15,2)

Purchase lead time in days. Site specific lead times or default lead times 

7 days = 1 week

ReviewTime

This is the time that expires between two points of ordering. Note: The unit in which the review time is given (days, weeks or months) must be equal to the unit of the lead time and consistent for all items.

Num(15,2)

Inherited from the default review time on the vendor (in days). If not filled, inherited from the coverage group.

BuyingPrice

This is the buying price per unit

Num(15,4)

Purchase price in vendor currency, for one inventory unit, initialized from the trade agreements, for this vendor. The price-per qty (aka price unit) is taken into account. When the purchase unit is not equal to the inventory unit, the price per purchase unit is converted to the price per inventory unit. In the Export interface setup - Suppliers specify gross purchase price or net purchase price

Trade agreements are evaluated for inventory unit or for purchase unit (Export interface setup). This price is retrieved again from the trade agreements when Update export data is executed.

CurrencyCode

This field should be populated with a 3 character currency code corresponding to the field buying price

String(3)

Vendor currency, initialized from the vendor

Currency code is retrieved again from the vendor when Update export data is executed

MOQ

This is the minimum purchase order quantity permitted, as agreed with your supplier. If an entry is given in this field, any order suggestion in Slim4 will be rounded up to at least this value. It is also possible to enter a calculated Economic Order Quantity (EOQ) in this field.  Note: If there is no MOQ data available, this field must be left blank. Slim4 will then use a default value (usually 1, configurable in Slim4).

Num(15,2)

Minimum order quantity

IOQ

This is the incremental order quantity, to be used once the minimum order quantity has been reached. For any order suggestion in Slim4 that exceeds the MOQ, the order suggestion will be rounded up to multiples of this field, e.g. the MOQ is equal to a pallet quantity, the IOQ can be a pallet layer or the smallest amount permissible on a pallet.  Note: If there is no IOQ data available, this field must be left blank. Slim4 will then use a default value of 1.

Num(15,2)

Incremental (= Multiple) order quantity

EOQ

This is the Economic Order Quantity (EOQ), the optimum order quantity for an item according to rules and limits set by your company. Note: If there is no EOQ data available, this field must be left empty. Slim4 will use a default value of 1.

Integer

Economic (= Standard) order quantity

Supplier

Reliability

This field allows for additional time to be added to the lead time to cover for uncertainty in supply. There are 3 options: a. Add extra lead time (in same unit of measure as the lead time); b. Multiply lead time by a factor (1.xx); c. Deviation of the lead time.

Num(15,2)

Coverage group:

order margin + receipt margin

Supplier

Reliability

Type

Supplier reliability can be given as add (1), multiply (2) or deviation (3).

Integer

1 (add the reliability days to the lead time)

SupplierArticleCode

This is the article code used in communication with the supplier

String(65)

External item code for this vendor

This external item code is retrieved again when Update export data is executed 

Available

Inventory

This field can be used to show the available inventory at your supplier within Slim4. Use this in deciding to order at which supplier.

Num(15,2)

DesiredSplit

When there is a desired ordering split for a certain period (a year) this field indicates the purchase share per supplier. E.g. 50%/30%/20% for 3 different supplier for certain item. Please make sure all number for one item do add up to a 100%.

Num(15,2)

SuppliedQuantity

This is the quantity already supplied/ordered related to the desired split in the above field. When the above split is for the period if January 1th till December 31th. This field should contain the quantity that is already ordered from January 1th till today.

Num(15,2)

The supplied quantity is calculated again when Update export data is executed

OrderFromDate

Date from which it is possible to order at a certain supplier. Or when desired split is populated, the date from which the split is relevant.

YYYYMMDD

OrderToDate

Date till which it is possible to order at a certain supplier. Or when desired split is populated, the date till which the split is relevant..

YYYYMMDD

Logistics

Unit1

Number of articles per logistic unit. Smallest till largest. i.e. Consumer Unit, Box, Pallet Layer, Pallet

Integer

Product unit conversion (smallest)

Logistics

Unit2

Number of articles per logistic unit. Smallest till largest. i.e. Consumer Unit, Box, Pallet Layer, Pallet

Integer

Product unit conversion

Logistics

Unit3

Number of articles per logistic unit. Smallest till largest. i.e. Consumer Unit, Box, Pallet Layer, Pallet

Integer

Product unit conversion

Logistics

Unit4

Number of articles per logistic unit. Smallest till largest. i.e. Consumer Unit, Box, Pallet Layer, Pallet

Integer

Product unit conversion

Logistics

Unit5

Number of articles per logistic unit. Smallest till largest. i.e. Consumer Unit, Box, Pallet Layer, Pallet

Integer

Product unit conversion

Logistics

Unit6

Number of articles per logistic unit. Smallest till largest. i.e. Consumer Unit, Box, Pallet Layer, Pallet

Integer

Product unit conversion (largest)

UD1

Free field on article-supplier relation level.

String(40)

UD2

Free field on article-supplier relation level.

String(40)

UD3

Free field on article-supplier relation level.

String(40)

UD4

Free field on article-supplier relation level.

String(40)

UD5

Free field on article-supplier relation level.

String(40)

ReplishmentScheduleId

Specifies the unique replenishment schedule id.

String(60)

InboundGuaranteedShelfLife

Guaranteed shelf life as negotiated with the supplier.

Num(15,6)

OutboundGuaranteedShelfLife

Guaranteed shelf life as negotiated with your shop.

Num(15,6)

NetShelfLife

The difference between ‘Inbound guaranteed shelf life’ and ‘Outbound guaranteed shelf life’. For shops the Outbound guaranteed shelf life will typically be 0 (or 1), as on the date of expiration the item may still be sold.

Num(15,6)