Inventory Mappings

* = Required

Name

Description

Type

Values

ItemExternalId*

The Item whose stock is being stored. String  

WarehouseExternalId*

The Id 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

  Double  

DbrReceivingBufferDays

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

DbrShippingBufferDays

The Shipping Buffer of the Product’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.

- 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 order is not fully consumed yet.

- Spread: Finds the forecasts before and after the sales order then calculates the ratio between the sales order and forecast. Forecasts is consumed by the ratio amounts. 

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 forecasts. String

Quarter

Month

Week

Day

LeadTimeDays

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

MaxInventory

Specifies the maximum quantity of items that can be stored in inventory.  Double  

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 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

Last Parent Job

All Parent Jobs Equally

All Parent Jobs Proportionally

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

The amount of physical inventory in stock for this Item in this Warehouse. Double  

PlannerExternalId

The External Id of the Planner responsible for monitoring and managing this Items stock level at this Warehouse. String  

SafetyStock

The target level of this Item to have on hand at this Warehouse 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.  Double  

SafetyStockJobPriority

Sets the priority value that is used for optimization. Lower priority numbers are usually favored over higher numbers.  Int32  

SafetyStockWarningLevel

If a job’s classification is “Safety Stock”, then 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.”

Double  

StorageCapacity

Can be used by a Scheduling Add-In to limit scheduling based upon availability of storage space. Double  

TemplateJobExternalId

The Id of the template job using this item as a material.  String