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)

StockOnHand

Amount of stock on hand. Consider together with confirmed orders and purchase orders to get to the correct stock position for order advice calculation.

Integer

Physical on hand inventory, grouped by batch number

BatchId

Identification code of stock on hand batch, together with warehouse and code. This should be unique.

String(50)

(internal) Batch number

StockType

Defines the type of stock this batch represents, like Showroom, Defect, QualityControl, etc..

String(100)

Empty

ExcludeSetting

In order to exclude a certain stock batch. 0 = Include, 1 = Exclude. When no value provided, default is include.

Integer

Empty

ExcludeTillDate

This is the date till this batch of stock is excluded.

YYYYMMDD

Production date

Before this date, the batch is not available for sales or other demand

ExcludeFromDate

This is the date from this batch of stock is excluded.

YYYYMMDD

Expiry date

After this date, the batch is not available for sales or other demand

InitialShelfLife

Number of days this stock batch initially had for shelf life.

Num(15,4)

Shelf life period in days

Item data

RemainingShelfLife

Number of days this stock batch remaning for this stock batch.

Num(15,4)

Remaining shelf life for this batch

Negative shelf life: batch is expired

UserDefinedStock1

This is a free text field that can be used to show remarks or information related to stock batches, e.g. stocking location, supplier for this batch, quality. This field is alphanumeric, limited to 255 characters.

String(255)

Empty

UserDefinedStock2

Idem

Idem

Empty

UserDefinedStock3

Idem

Idem

Empty

UserDefinedStock4

Idem

Idem

Empty