Month End Inventory Fields

The Month End Inventory object contains records that show a snapshot of the inventory at a specific point in time, such as at the end of the month. To create a snapshot, your administrator can schedule the SCMCreateInventorySnapShot Apex class to run at a specific interval. See Scheduling the Month End Inventory Snapshot. You can create reports based on the information in the Month End Inventory object. See Reports and Dashboards. Here is a description of the fields on the Month End Inventory object.

Field Name	Description
Acquisition Cost	Cost of acquiring one unit of inventory.
Acquisition Currency	Currency that the inventory was acquired in.
Availability	Indicates whether the item in inventory can be allocated.
Availability Code	Indicates whether the item in inventory is available to be used, sold, or lent.
Condition	Lookup to the condition code that applies to the item in inventory.
CSN Cycles Since New	Cycles since the item in inventory was new.
CSO Cycles Since Overhauled	Cycles since the item in inventory was overhauled.
CSR Cycles Since Removal	Cycles since the item to which the transaction relates was removed.
Current Value	Value of the item at the time the snapshot was taken.
Cycle Count Detail	Lookup to the cycle count detail record in a cycle count batch to which the item in inventory relates. This field is populated when a cycle count is initiated and is cleared when the cycle count batch is confirmed.
Cycle Count Status	If the inventory position is included in a cycle count batch, indicates whether this position should be added to or removed from inventory. This is determined by the count.
Date Placed in Inventory	Date on which the item was placed in inventory. The value of this field is set when the item is received or a miscellaneous receipt is created.
ICP Inventory Control Point. A distribution center or place around the globe that inventory items are controlled from. An ICP may have one or more warehouses. Acquisition Cost	Cost to acquire one unit of the item in the ICP currency.
ICP Currency	Currency used at the ICP in which the item is held.
Inventory Location	Lookup to the location of the item in inventory
IP Created By	Lookup to the user who created the inventory position.
IP Created Date Time	Date and time on which the inventory position was created.
IP Modified By	Lookup to the user who last modified the inventory position.
IP Modified Date Time	Date and time on which the inventory position was last modified.
Item Master	Item master record to which the item in inventory belongs.
Item Serial Number	Serial Number of the item in inventory.
Last Cycle Count Performed	Date on which the last cycle count was confirmed. This is used as the basis for calculating the next due date for an automated cycle count.
Lot Number	Lot number of the item in inventory.
Manufacturer	Lookup to the manufacturer of the item in inventory.
Manufacturer CAGE	CAGE Commercial and Government Entity Code. A unique identifier assigned to approved suppliers of government and defense agencies. CAGE codes identify a specific facility at a specific location. code of the manufacturer of the item in inventory.
Month End Inventory Name	Name of the Month End Inventory record.
Owned By	Owner of the item in inventory.
Ownership Code	Ownership code defined on the Codes tab that defines the ownership details of the item in inventory.
Purchase Order Line Item	Purchase order line item that the item in inventory is allocated to. This field only contains a value if the item is allocated to a purchase order. For instance, an item might be allocated to a purchase order if it has to be sent to the supplier so that work can be carried out on it.
Quantity	Quantity of the item in inventory at the inventory position.
Quantity Allocated	Quantity of the item in inventory that has been reserved to fill a purchase order, sales order or transfer request.
Quantity in Transit	Quantity of the item in transit.
Receipt Line	Receipt line to which the item in inventory relates.
Receiving Inspection	Lookup to the receiving inspection record associated with the items at this inventory position. This field only contains a value when the items require an inspection.
Reserve Price	Minimum price at which a seller is willing to sell the item. Reserve prices are commonly used in auctions.
Revision Level	Version or revision number of the item in inventory.
Sales Order Line Item	Sales order line item to which the item in inventory relates.
Sales Price	Price that the item in inventory is sold for.
Shelf Life Expiration	Time that the items in inventory can be stored for. During this time, the defined quality of a specified proportion of the item remains acceptable under the expected conditions of distribution and storage.
Snapshot Date/Time	Date and time on which the snapshot was taken.
Total Acquisition Cost	Total cost of acquiring the items at the inventory position.
Total Current Value	Total value of the items at the inventory position at the time the snapshot was taken.
TSN Time Since New	Time since the item in inventory was new.
TSO Time Since Overhauled	Time since the item in inventory was overhauled.
TSR Time Since Removed	Time since the item in inventory was removed.
Warehouse	Warehouse to which the inventory at the inventory position belongs.