Item Mappings

* = Required

Name

Description

Type

Values

ExternalId*

The External Id of the Item. (Inherited from ExternalIdBaseObject). String  

BatchSize

Jobs and Purchase Orders must be in integer multiples of this value. Double  

BatchWindowHrs

When batching demand to create Jobs or Purchases the batch should not reach out further than this value in order to reach the MaxOrderQty. Double  

Cost

The cost of the item. This value is used to calculate the value of inventory, reporting, and financial optimization. Decimal  

DefaultLeadTimeDays

Used by Material Requirements when there is no Inventory record for the Item at any available Warehouse. Specifies the time it takes between when items are ordered to when they are received. Double  

Description

Text for describing the object. String  

ItemGroup

Can be used for visually grouping Items into categories. String  

ItemType

The type of item that is produced, stocked, or consumed.  String FinishedGood
Intermediate
Raw Material
Resource
Sub-Assembly
ByProduct
CoProduct

JobAutoSplitQty

The quantity to be split off of the job. Jobs are auto-split if the item's JobAutoSplitQty is greater than the job's first manufacturing order's required quantity.  Double  

LotUsability

Specifies how the lot can be used. String

Uncontrolled
Wear
ShelfLife
LotControlled

MaxNbrBatches***

Each Job and Purchase Order for this item must be no more than this number of Batches (see Batch Size). Int32 ***Note: This field is no longer imported/ published in versions 11.46 and later. This will not affect users set up with this field in earlier versions. For simplicity, MinOrderQty, MaxOrderQty, and BatchSize should be used to calculate min and max batch sizes.

MinNbrBatches***

Each Job and Purchase Order for this item must be at least this number of Batches (see Batch Size). Int32 ***Note: This field is no longer imported/ published in versions 11.46 and later. This will not affect users set up with this field in earlier versions. For simplicity, MinOrderQty, MaxOrderQty, and BatchSize should be used to calculate min and max batch sizes.

MinOrderQty

Each Job or Purchase Order for this item must be at least this quantity. Used in conjunction with BatchSize to calculate the minimum number of batches required. Decimal  

MaxOrderQty

Each Job and Purchase Order for this item must be no more than this quantity. Used in conjunction with BatchSize to calculate the maximum number of batches allowed. Decimal  

MinOrderQtyRoundupLimit

This value is added to the MinOrderQty when generating purchases to stocks when the quantity short is greater than this value.  Decimal  

Name

Unique, changeable, text identifier. String  

Notes

Comments or special considerations pertaining to this object. String  

PlanInventory

Whether the Item should be included in the Inventory Plan. Boolean  

RollupAttributesToParent

Whether the operation attributes are "rolled-up" into the job recursively as needed.  Boolean  

ShelfLifeHrs

The maximum amount of time that the Item can remain in inventory before being used. Double  

Source

Where the Item originates from. This is for information only and has no effect on scheduling. String Purchased
Manufactured
PurchasedOrManufactured

TransferQty

As this product is produced it is transferred to Inventory in quantities of this size. Double  

UserFields

Optional list of user-defined fields. Null if not initialized. String