Order and Inventory Management Data Dictionary

SCMC__Inventory_Position__c

Label: Inventory Position

This Object describes the Items that are stored within a warehouse bin location. This object supports inventory management business processes such as cycle counting, consignment, hold status, and shelf life processes. It also supports Inventory consumption business processes such as fulfilling a customer sales order. There are workflow, attachments, and business intelligences dependent on this object.

Field NameField LabelCreated in VersionDescriptionTypeRequiredDefault Value
SCMC__Acquisition_Cost__c Acquisition Cost Pre-Spring 2018 Cost for the item from the actual acquisition (PO,Misc receipt)

 Number(18,9) false 0
SCMC__Acquisition_Currency__c Acquisition Currency Pre-Spring 2018 The currency the part was acquired in

Looks up to: SCMC__Currency_Master__c
 Lookup false
SCMC__Adjustment_Cost__c Adjustment Cost Pre-Spring 2018 This fields displays the delta between the initial inventory position value and any adjustments made to the current value.

 Number(18,9) false 0
SCMC__Availability_Code__c Availability Code Pre-Spring 2018 The availability code indicates specifics about whether the item inventory is available to be used, sold, or lent.

 Picklist:
After Receiving Inspection
In Stock
In Transit
In WIP
Installed
Missing Cost
On Hold
Out for Service
Out on Service Purchase Order
Received from Miscellaneous Receipt
Received from Purchase Order
Waiting for Receiving Inspection
SCMC__Availability__c Availability Pre-Spring 2018 Indicates whether the inventory is available for use.

 Checkbox false
SCMC__Bin__c Inventory Location Pre-Spring 2018 The location of the item in inventory.

Looks up to: SCMC__Inventory_Location__c
 Lookup false
SCMC__CSN__c CSN Pre-Spring 2018 The number of cycles the part has on it since the part was new.

Formula:
SCMC__Receiving_Inspection__r.SCMC__CSN__c
 Text false
SCMC__CSO__c CSO Pre-Spring 2018 Cycles since last overhaul.

Formula:
SCMC__Receiving_Inspection__r.SCMC__CSO__c
 Text false
SCMC__CSR__c CSR Pre-Spring 2018 The number of cycles the part has on it since the part was removed.

Formula:
SCMC__Receiving_Inspection__r.SCMC__CSR__c
 Text false
SCMC__Condition_Code__c Condition Pre-Spring 2018 This information helps describe the condition of the item (e.g., item is serviceable or new).

Looks up to: SCMC__Condition_Code__c
 Lookup false
SCMC__Current_Value__c Current Value Pre-Spring 2018 The current value of the item in inventory.

 Number(18,9) false
SCMC__Cycle_Count_Detail__c Cycle Count Detail Pre-Spring 2018 This field is populated when this inventory position is scheduled to be cycle counted. When the cycle count is confirmed the reference is removed. This provides visibility to current inventory and also prevents double scheduling a specific item for cycle count.

Looks up to: SCMC__Cycle_Count_Detail__c
 Lookup false
SCMC__Cycle_Count_Status__c Cycle Count Status Pre-Spring 2018 If the inventory position is included in a cycle count batch, this status indicates, based on the count, whether this position should be added to or removed from inventory. This is here mainly to support parts that are under serial, lot, or shelf life control. This is set by a background process.

 Picklist:
Add on confirm
Remove on confirm
SCMC__Date_Placed_in_Inventory__c Date Placed in Inventory Pre-Spring 2018 The date the item was placed in inventory. This date should be used instead of date created to determine first in for allocation. The split on the inventory position resets created date. Receiving and miscellaneous receipt set this date and time.

 DateTime false
SCMC__ICP_Acquisition_Cost__c ICP Acquisition Cost Pre-Spring 2018 The unit cost to acquire in the currency that is used for the ICP.

 Number(18,9) false
SCMC__ICP_Currency__c ICP Currency Pre-Spring 2018 The currency used to hold the inventory in the specific ICP.

Looks up to: SCMC__Currency_Master__c
 Lookup false
SCMC__Internal_Repair_Cost__c Internal Repair Cost Pre-Spring 2018 Number(18,9) false 0
SCMC__Inventory_Attachment__c Inventory Attachment Pre-Spring 2018 Looks up to: SCMC__Inventory_Attachment__c
 Lookup false
SCMC__Item_Description__c Item Description Pre-Spring 2018 Item description

Formula:
SCMC__Item_Master__r.SCMC__Item_Description__c
 Text false
SCMC__Item_Master__c Item Master Pre-Spring 2018 The item number for the part in inventory.

Looks up to: SCMC__Item__c
 Lookup false
SCMC__Item_Serial_Number__c Item Serial Number Pre-Spring 2018 The serial number of the item in inventory. This replaces the serial number field that was originally on the inventory position - it was too short.

 Text(100) false
SCMC__Item_Warehouse__c Item Warehouse Pre-Spring 2018 This field is added to the inventory position so that the lookup on the action queue can be a dependent filter. Specifically for put away, only locations within the current warehouse can be selected.

Looks up to: SCMC__Warehouse__c
 Lookup false
SCMC__Labor_Cost__c Labor Cost Pre-Spring 2018 The labor cost for this item per unit.

 Number(18,9) false 0
SCMC__Last_Cycle_Count_Performed__c Last Cycle Count Performed Pre-Spring 2018 This date is added as a result of a cycle count confirmation record being generated and is the basis for calculating the next due automated request cycle count

 Date false
SCMC__List_Type__c List Type Pre-Spring 2018 The listing type associated with this inventory position when this item is listed. This is set by software only

 Picklist:
G
M
N
Q
R
S
Y
SCMC__List_on_ILS__c DEPRECATED: List on ILS Pre-Spring 2018 This field is obsolete.

 Checkbox false
SCMC__Listed_Date__c Listed Date Pre-Spring 2018 The date and time of registration for the inventory position.

 DateTime false
SCMC__Listed_on_ILS__c DEPRECATED: Listed on ILS? Pre-Spring 2018 This inventory position is listed on ILSMart if this field is checked/true. This field is not set by the user.

 Checkbox false
SCMC__Location__c Location Pre-Spring 2018 ICP and Warehose

Formula:
SCMC__Bin__r.SCMC__Warehouse__r.SCMC__ICP__r.Name & BR() & SCMC__Bin__r.SCMC__Warehouse__r.Name
 Text false
SCMC__Logistics_Cost__c Logistics Cost Pre-Spring 2018 Number(18,9) false 0
SCMC__Logistics_Purchase_Order_Line_Item__c Logistics Purchase Order Line Item Pre-Spring 2018 Looks up to: SCMC__Purchase_Order_Line_Item__c
 Lookup false
SCMC__Lot_Number__c Lot Number Pre-Spring 2018 The lot number for the part(s) in inventory. The lot number must be specified if the part is defined to be a lot controled part.

 Text(50) false
SCMC__Manufacturer_CAGE__c Manufacturer CAGE Pre-Spring 2018 Commercial And Government Entity (CAGE) code is a five-character ID number that identifies government contractors.

 Text(5) false
SCMC__Manufacturer__c Manufacturer Pre-Spring 2018 Manufacturer of Item

Looks up to: SCMC__Manufacturer__c
 Lookup false
SCMC__Owned_By__c Owned By Pre-Spring 2018 The field indicates who owns the part. This will eventually be a lookup field

 Text(80) false
SCMC__Ownership_Code__c Ownership Code Pre-Spring 2018 This information helps describe the Ownership of the item (i.e., item owned by a certain Supplier or Customer)

Looks up to: SCMC__Ownership_Code__c
 Lookup false
SCMC__Production_Order_Line__c Production Order Line Pre-Spring 2018 Production order line to which this is allocated.

Looks up to: SCMC__Production_Order_Line__c
 Lookup false
SCMC__Production_Order__c Production Order Pre-Spring 2018 This refers to the production order that created this item.

Looks up to: SCMC__Production_Order__c
 Lookup false
SCMC__Purchase_Order_Line_Item__c Purchase Order Line Item Pre-Spring 2018 The purchase order line item the parts are allocated to. This field contains data only if the part(s) are allocated to a purchase order. This is usually for outside service.

Looks up to: SCMC__Purchase_Order_Line_Item__c
 Lookup false
SCMC__Quantity_Allocated__c Quantity Allocated Pre-Spring 2018 The quantity that has been reserved to fill a Purchase, Sales, or Transfer Order

 Number(18,4) false 0
SCMC__Quantity__c Quantity Stored Pre-Spring 2018 The quantity of the part in the specific location

 Number(18,4) false 0
SCMC__Quantity_in_Transit__c Quantity in Transit Pre-Spring 2018 Number(18,4) false 0
SCMC__Receipt_Line__c Receipt Line Pre-Spring 2018 The receipt line that this inventory was received on

Looks up to: SCMC__Receipt_Line__c
 Lookup false
SCMC__Receiving_Inspection__c Receiving Inspection Pre-Spring 2018 Receiving Inspection associated with the parts in this inventory position entry. This field is null for parts that do not require inspection.

Looks up to: SCMC__Receiving_Inspection__c
 Lookup false
SCMC__Repair_Cost__c Net Change in Value Pre-Spring 2018 Formula:
SCMC__Current_Value__c - SCMC__ICP_Acquisition_Cost__c
 Number(18,9) false
SCMC__Reserve_Price__c Reserve Price Pre-Spring 2018 The minimum price at which a seller is willing to sell an item. Reservation prices are commonly used in auctions.

 Currency(12,2) false
SCMC__Revision_Level__c Revision Level Pre-Spring 2018 Engineering control revision of part in inventory

 Text(2) false
SCMC__Sale_Price__c Sale Price Pre-Spring 2018 The price that the inventory part is sold for.

 Number(18,2) false
SCMC__Sales_Order_Line_Item__c Sales Order Line Item Pre-Spring 2018 If inventory position is allocated to a sales order, this references the line item the allocation is for.

Looks up to: SCMC__Sales_Order_Line_Item__c
 Lookup false
SCMC__Serial_Number_Lookup__c Serial Number Lookup Pre-Spring 2018 Looks up to: SCMC__Serial_Number__c
 Lookup false
SCMC__Serial_Number__c Serial Number Obsolete Pre-Spring 2018 The serial number for the part. It must be present if the part is serialized (defined in the Item Master) This is obsolete because the length is a mismatch to the other objects in the system.

 Text(50) false
SCMC__Service_Cost__c Service Cost Pre-Spring 2018 The field is incremented whenever a service type purchase order is received into the system. The receipt of the service PO updates the current value of the item as well as this attribute.

 Number(18,9) false 0
SCMC__Shelf_Life_Expiration__c Shelf Life Expiration Pre-Spring 2018 Shelf life is the time that items can be stored, during which the defined quality of a specified proportion of the item remains acceptable under expected (or specified) conditions of distribution and storage.

 DateTime false
SCMC__TSN__c TSN Pre-Spring 2018 Time since the part was new. This is hours and tenths or minutes

Formula:
SCMC__Receiving_Inspection__r.SCMC__TSN__c
 Text false
SCMC__TSO__c TSO Pre-Spring 2018 Time since last overhaul.

Formula:
SCMC__Receiving_Inspection__r.SCMC__TSO__c
 Text false
SCMC__TSR__c TSR Pre-Spring 2018 Time since the part was removed. This is hours and tenths or minutes.

Formula:
SCMC__Receiving_Inspection__r.SCMC__TSR__c
 Text false
SCMC__Total_Acquisition_Cost__c Total Acquisition Cost Pre-Spring 2018 Formula:
SCMC__ICP_Acquisition_Cost__c * SCMC__Quantity__c
 Currency(18,9) false
SCMC__Total_Current_Value__c Total Current Value Pre-Spring 2018 Formula:
SCMC__Current_Value__c * SCMC__Quantity__c
 Currency(18,9) false
SCMC__Transfer_Request_Line__c Transfer Request Line Pre-Spring 2018 Looks up to: SCMC__Transfer_Request_Line__c
 Lookup false
SCMC__Warehouse__c Warehouse Pre-Spring 2018 This is an internal field only and is used to facilitate summarizing inventory by warehouse. The field is automatically populated.

Formula:
SCMC__Bin__r.SCMC__Warehouse__r.Name
 Text false


© Copyright 2009–2025 Certinia Inc. All rights reserved. Various trademarks held by their respective owners.