Inventory Policy Details

Supply Chain Guru X Help

Home >

Submit Search

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Inventory Policy Details

Internal Table Name: InvOptimOutput_InventoryDetails

The Inventory Policy Details table outputs the results of Safety Stock Optimization by site-product-source-destination-BOM. When the site-product pair is connected to multiple sources, modes, or destinations, there will be multiple records for the site-product pair in this table.

Scenario

Table: InvOptimOutput_InventoryDetails

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the output data was generated.

Source Name

Table: InvOptimOutput_InventoryDetails

Internal Name: SourceName

The name of the source from which the site receives products.

Destination Name

Table: InvOptimOutput_InventoryDetails

Internal Name: DestinationName

The name of the site served by the source site.

Product Name

Table: InvOptimOutput_InventoryDetails

Internal Name: ProductName

The name of the product demanded at the customer.

Period Name

Table: InvOptimOutput_InventoryDetails

Internal Name: PeriodName

The period to which the safety stock and inventory policy applies.

BOM Name

Table: InvOptimOutput_InventoryDetails

Internal Name: BomName

The name of the bill of material (BOM) using the product at the site.

Mode

Table: InvOptimOutput_InventoryDetails

Internal Name: Mode

The transportation mode by which the site receives products from the source.

Service Time

Table: InvOptimOutput_InventoryDetails

Internal Name: ServiceTime

The amount of time the site quotes to its customer or downstream sites for getting their orders ready to ship. Service times are the decision variables of the optimization model. The service time customer-facing facilities quote to customers is zero by default, which means whenever a customer places an order, the customer-facing facilities have enough stock ready to ship immediately.

Immediate Lead Time

Table: InvOptimOutput_InventoryDetails

Internal Name: ImmediateLeadTime

The lead time required for the product to get replenished at the destination site from the nearest upstream source node or production site. Immediate Lead Time is the shortest time that product can be replenished assuming the nearest upstream site has on-hand stock.

For lanes, Immediate Lead Time = Sourcing Policies.Source Lead Time + Transportation Policies.Transport Time + Inventory Policies.Review Period
For Make policies, Immediate Lead Time = Production Policies.Fixed Order Time + Inventory Policies.Review Period

Max Lead Time

Table: InvOptimOutput_InventoryDetails

Internal Name: MaxLeadTime

The duration of the longest chain from the site to the furthest upstream node. For end products with Bills Of Material, Max Lead Time includes the lead time for components. For additional information, refer to Max Lead Time.

Scenario ID

Table: InvOptimOutput_InventoryDetails

Internal Name: ScenarioID

The identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: InvOptimOutput_InventoryDetails

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the summary data was generated.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No