Live export details table

Table included

Export Details (this table contains Live data and is not a monthly snapshot).

Data source objective

You can use this data source to:

• Review information regarding up-to-date exports as they occur
• View items that have been reviewed and exported over time, including the latest exports
• Monitor the user acceptance of using IBM® Maximo Inventory Optimization Recommendation by Optimal Optimal Best (OOB) status
• View details of Exports including Export Type and by User Calculations in data source

  • Last Export Reorder Code 1

    Returns the Reorder Code 1 which was recorded for the item during the previous export of the item record.

  • Last Export Reorder Code 2

    Returns the Reorder Code 2 which was recorded for the item during the previous export of the item record.

  • Last Recorded ROP

    Returns the Reorder Point which was recorded for the item during the previous export of the item record.

  • Last Recorded ROQ

    Returns the Reorder Quantity which was recorded for the item during the previous export of the item record.

  • 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 of stock in Corporate Currency. If the Corporate Currency 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 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 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 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 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 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 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 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 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 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 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 is greater than zero, then multiply the Available Stock Value (Available Quantity * Average Price) by the Corporate Currency rate.

  • Corporate Max Holding Value

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

  • Corporate Minimum Holding Value

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

  • Is Reviewed and Exported Same Month

    This flag is set for item records that have had both their most recent review and export within the same month. 1 = Item was reviewed and exported in the same month, 0 = Last Item review was not in the same month as the export, Include both (ie. no filter) = All Item records. Determines the Reorder strategy of an item. If an item’s Reorder Point is set to “Optimal”, its Reorder Quantity set to “Optimal” and its Forecast Method set to “Best” then the value is set to “OOB”. Otherwise, it is set to “Not OOB”.