Live inventory details

Tables included

Item (Material) details for current month

Data source objective

You can use this data source to:

• Report on current Inventory Values
• Segment current Inventory by Division (Company), Site (Plant), Control Segment, Criticality and more

Calculations in data source

• Corporate Current Stock Value

  Calculates the current stock value in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Current Stock Value by the Corporate Currency Rate.

• Corporate Surplus Value

  Calculates the surplus value in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Surplus Value by the Corporate Currency Rate.

• Corporate Current Average Stock Value

  Calculates the current average stock value in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Current Average Stock Value by the Corporate Currency Rate.

• Corporate Recorded Average Stock Value

  Calculates the recorded average stock value in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Recorded Average Stock Value by the Corporate Currency Rate.

• Corporate Current Holding Cost

  Calculates the current holding cost in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Current Holding Cost by the Corporate Currency Rate.

• Corporate Recorded Holding Cost

  Calculates the recorded holding cost in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Recorded Holding Cost by the Corporate Currency Rate.

  • Corporate Current Purchase Order Cost

    Calculates the current purchase order cost in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Current Purchase Order Cost by the Corporate Currency Rate.

• Corporate Recorded Purchase Order Cost

  Calculates the recorded purchase order cost in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Recorded Purchase Order Cost by the Corporate Currency Rate.

• Corporate Current Stockout Cost

  Calculates the current stockout cost in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Current Stockout Cost by the Corporate Currency Rate.

• Corporate Recorded Stockout Cost

  Calculates the recorded stockout cost in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Recorded Stockout Cost by the Corporate Currency Rate.

• Corporate Current Total Cost

  Calculates the current total cost in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Current Total Cost by the Corporate Currency Rate.

• Corporate Recorded Total Cost

  Calculates the recorded total cost in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Recorded Total Cost by the Corporate Currency Rate.

• Corporate Available Stock Value

  Calculates the available stock value in Corporate Currency. If the Corporate Currency Rate is greaterthan zero, then multiply the Available Stock Value (Available Quantity * Average Price) by the Corporate Currency Rate.

• Corporate Maximum Holding Value

  Calculates the maximum holding value in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Maximum Holding Value (Current Maximum * Average Price) by the Corporate Currency Rate.

• Corporate Minimum Holding Value

  Calculates the minimum holding value in Corporate Currency. If the Corporate Currency Rate is greater than zero, then multiply the Minimum Holding Value (Host Reorder Code 1 * Average Price)by the Corporate Currency Rate.

• Is Issued Greater Than 2 Years Ago

  This flag is set for items that were last issued more than 2 years ago. 1 = Item was last issued more than 2 years ago, 0 = item has been issued within the last 2 years, include both (i.e. no filter) = All item records.

• Is Issued Greater Than 3 Years Ago

  This flag is set for items that were last issued more than 3 years ago. 1 = Item was last issued more than 3 years ago, 0 = item has been issued within the last 3 years, include both (i.e. no filter) = All item records.

• Is Issued Greater Than 4 Years Ago

  This flag is set for items that were last issued more than 4 years ago. 1 = Item was last issued more than 4 years ago, 0 = item has been issued within the last 4 years, include both (i.e. no filter) = All item records.

• Is Issued Greater Than 5 Years Ago

  This flag is set for items that were last issued more than 5 years ago. 1 = Item was last issued more than 5 years ago, 0 = item has been issued within the last 5 years, include both (i.e. no filter) = All item records.

Live inventory details all fields

Tables included

• Item (Material) details for current month

Data source objective

This data source is specifically written to expose all fields in the Item table for reporting. You can use this data source to:

• Report on current Inventory Values
• Segment current Inventory by Division (Company), Site (Plant), Control Segment, Criticality and more