Data Model > Data Dictionary > P > Product Stock
Product Stock
Product stock is used to store inventory information for a product in a given location and status along with reordering information.
API Label: SVMXC__Product_Stock__c
No. of Fields: 20
Field Label
Field Name
Data Type
Description
Roll-up Summary Fields
Allocated Qty
SVMXC__Allocated_Qty__c
Roll-up Summary(SUM Allocated Stock)
Custom Relationship Fields
Location
SVMXC__Location__c
Lookup(Location)
Current physical location of the product. This is a lookup to an existing site record.
Partner Account
SVMXC__Partner_Account__c
Lookup(Account)
Lookup to Account, set by trigger.
Partner Contact
SVMXC__Partner_Contact__c
Lookup(Contact)
Lookup to Contact, set by trigger.
Product
SVMXC__Product__c
Lookup(Product)
Name of the product. This is a lookup to an existing Salesforce product record.
Standard Fields
Name
Name
Auto Number
The auto-generated record number.
Custom Fields
Actual Quantity Before Update
SVMXC__ActualQtyBeforeUpdate__c
Number(18,0)
This field used internally by ServiceMax. This field is being calculated by inventory engine to stop simultaneous update of records.
At or Below Reorder
SVMXC__At_or_Below_Reorder__c
Formula(Text)
Indicates whether the stockable item is at or below the defined reorder point and should now be ordered.
Available Qty
SVMXC__Available_Qty__c
Formula(Number)
Composite Key
SVMXC__ProdStockCompositeKey__c
Text(255) (Unique Case Sensitive)
This field is combination of Product, Location and Status field to make the record unique.
Is Partner
SVMXC__IsPartner__c
Formula (Text)
Flag indicates if transaction is for/by a Partner or not.
IsPartnerRecord
SVMXC__IsPartnerRecord__c
Checkbox
Flag indicates if transaction is for/ by a Partner or not.
Product Cost
SVMXC__Product_Cost__c
Currency(15, 3)
Product cost, copied from Product. For internal use only.
Qty
SVMXC__Quantity2__c
Number(13, 5)
Quantity of product in the provided location.
Reorder Point
SVMXC__Reorder_Level2__c
Number(14,4)
Reorder level of this product for the provided location.
Reorder Qty
SVMXC__Reorder_Quantity2__c
Number(14,4)
Reorder quantity for the provided product and location when reorder level is reached.
Required Qty
SVMXC__Required_Quantity2__c
Formula(Number)
Calculated required quantity for reordering.
Status
SVMXC__Status__c
Picklist
Current Status of Product-Stock.
Stock Value
SVMXC__Stock_Value__c
Formula (Currency)
Value of current stock. Used for reporting purposes.
Target Stock Level
SVMXC__SM_Target_Stock_Level__c
Number(13,5)
Target Stock Level.
Was this helpful?