Inventory Mappings

* = Required

Name

Description

Type

Values

ItemExternalId*

The Item whose stock (inventory) is being stored. String  

WarehouseExternalId*

The External identifier of the Warehouse where the Item is being stored. String  

AutoGenerateForecasts

If True, PlanetTogether automatically generates forecasts for this inventory item when its sales orders are updated.  Boolean  

BufferStock

This is used in setting Warning Levels. Decimal  

DbrReceivingBufferDays

The Receiving Buffer Days of the Inventory for the Purchase to Stock. Double  

DbrShippingBufferDays

The Shipping Buffer of the Item’s Inventory. Double  

ForecastConsumption

Forecast consumption is used as part of MRP. This specifies how MRP should consume forecasts before the MRP logic is executed. 

- Backward: Will search for forecasts with the same or earlier period.

- Forward: Will search for forecasts with the same or later period.

- BackwardThenForward: Starts as a backward strategy but switches to forward when no more backward forecasts are available, and sales orders are not fully consumed yet.

- Spread: Finds the forecasts before and after the sales order then calculates the ratio between the sales order and forecast. The ratio amounts consume forecasts. 

String

None

Backward

Forward

BackwardThenForward

Spread

 

ForecastConsumptionWindowDays

The number of days within the forecast consumption window.  Double  

ForecastInterval

This specifies the amount of time between each generated forecast. String Quarter
Month
Week
Day

LeadTimeDays

The amount of time it takes between when the Item is ordered and delivered for this Warehouse. Double  

MaterialAllocation

This field specifies how material lots will be allocated.

- NotSet: No Lot Allocation rules are set.

- UseNewestFirst: Material requirements will pull from the latest (most recent) material source.

-UseOldestFirst: Material requirements will pull from the earliest (oldest) material source.

String NotSet
UseNewestFirst
UseOldestFirst

MaxInventory

Specifies the maximum quantity of items that can be stored in inventory. Used to set alerts when Inventory Levels are predicted to be above this value. Decimal  

MrpExcessQuantityAllocation

Controls which parent jobs are adjusted to accept the increased allocation when MRP-generated jobs produce excess. The following values are permitted for this field:

- None: Leave extra material as WIP in the warehouse or on the tank. This is the default.

- Last Parent Job: Allocate the remainder to the last consuming job (by Need Date).

- All Parent Jobs Equally: Divide the excess quantity equally among the parent jobs.

- All Parent Jobs Proportionally: Divide the excess quantity proportionally to the parent job quantities. 

String None
LastParentJob
AllParentJobsEqually
AllParentJobsProportionally

MrpProcessing

This specifies whether MRP should generate Purchase Orders or Jobs to supply the Item. String Ignore
GenerateJobs
GeneratePurchaseOrders

NumberOfIntervalsToForecast

This defines how many forecasts should be generated for the specified duration. Int32  

OnHandQty

This value reflects the amount of inventory you have available to work within this Warehouse. Decimal  

PlannerExternalId

The External identifier of the Planner is responsible for monitoring and managing this Item's stock level at this Warehouse. String  

ReplenishmentMin

This is the material minimum quantity that will trigger MRP to produce to the max. Decimal  

ReplenishmentMax

This is the product to the max quantity used by MRP when satisfying a demand. Decimal  

ReplenishmentContractDays

This value specifies how many days an item can be below the ReplenishmentMin quantity before MRP produces to the ReplenishmentMax quantity. Double  

SafetyStock

The target level of this Item to have on hand at this Warehouse is to provide the desired service level to customers. Falling below the safety stock will trigger a warning on the Inventory Plan to alert that additional material is required. Decimal  

SafetyStockJobPriority

Sets the Priority value of the Job replenishing the safety stock. This is used for optimization. Lower priority numbers are usually favored over higher numbers. Int32  

SafetyStockWarningLevel

If a job’s classification is “Safety Stock,” ignore the lateness if the current inventory is greater than the warning level.

If the Job’s classification is “Safety Stock,” and the Job has Products associated with it, then this value will be set to true only if the Job is later than the Safety Stock Warning Level of the Product’s Inventory.

Decimal  

StorageCapacity

A Scheduling Extension can use it to limit scheduling based upon the availability of storage space. Decimal  

TemplateJobExternalId

The External identifier of the Template used by MRP to generate Jobs for this item. String