ProductInvSearchableField

Represents a dataset on inventory information that's the basis for searching product inventory. Contains multiple fields from Product Item and related objects. This object is available in API version 62.0 and later.

Supported Calls

create(), delete(), describeLayout(), describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), search(), undelete(), update(), upsert()

Fields

Field	Details
AccountId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The account associated with the record. This field is a relationship field. Relationship Name Account Refers To Account
AccountName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The name of the account related to a product item.
BusinessBrandId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The business brand record associated with the record. This field is a relationship field. Relationship Name BusinessBrand Refers To BusinessBrand
BusinessBrandName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The name of the business brand of a product item.
ExcessQuantity	Type double Properties Filter, Nillable, Sort Description The excess quantity for the product item. Calculated as the difference between the quantity on hand and the maximum inventory quantity. If the quantity on hand is less than the maximum, this value is 0.
HarmonizedSystemCode	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The harmonized system code that's assigned to the product item.
InvLocationCoord	Type location Properties Nillable Description The location record associated with the record.
InvLocationCoordLatitude	Type double Properties Create, Filter, Nillable, Sort, Update Description The latitude of the inventory location.
InvLocationCoordLongitude	Type double Properties Create, Filter, Nillable, Sort, Update Description The longitude of the inventory location.
InventoryLocationId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The location record associated with the record. This field is a relationship field. Relationship Name InventoryLocation Refers To Location
InventoryLocationName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The name inventory location for a product item.
InventoryLocationType	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The type of an inventory location for a product item.
InvReplenishmentPolicy	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The replenishment policy record associated with the product item. This field identifies the inventory replenishment rules that apply to the product item. Relationship Name InvReplenishmentPolicy Refers To InvReplenishmentPolicy
InvReplenishmentPolicyName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The name of the replenishment policy applicable to the product item.
IsEnvrPrtcRegCompliant	Type boolean Properties Create, Defaulted on create, Filter, Group, Sort, Update Description Indicates whether the product item is compliant with environment protection regulations (true) or not (false). The default value is `false`.
IsProductSerialized	Type boolean Properties Create, Defaulted on create, Filter, Group, Sort, Update Description Indicates whether the product related to a product item is a serialized product (true) or not (false). The default value is `false`.
LastReferencedDate	Type dateTime Properties Filter, Nillable, Sort Description The timestamp when the current user last accessed this record indirectly, for example, through a list view or related record.
LastViewedDate	Type dateTime Properties Filter, Nillable, Sort Description The timestamp when the current user last viewed this record or list view. If this value is null, and LastReferenceDate is not null, the user accessed this record or list view indirectly.
MakeName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The make name of a product item.
ManufacturerPartNumber	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The unique number assigned by the manufacturer to identify a product item.
MinimumInventoryQuantity	Type double Properties Create, Filter, Nillable, Sort, Update Description The minimum inventory quantity specified in the replenishment policy.
MaximumInventoryQuantity	Type double Properties Create, Filter, Nillable, Sort, Update Description The maximum inventory quantity specified in the replenishment policy.
ModelName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The model name of a product item.
ModelYear	Type int Properties Create, Filter, Group, Nillable, Sort, Update Description The model year of a product item.
Name	Type string Properties Autonumber, Defaulted on create, Filter, idLookup, Sort Description The name of the product related to a product item.
OwnerId	Type reference Properties Create, Defaulted on create, Filter, Group, Sort, Update Description ID of the owner of this object. This field is a polymorphic relationship field. Relationship Name Owner Refers To Group, User
ParentInventoryLocationId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The parent inventory location associated with the record. This field is a relationship field. Relationship Name ParentInventoryLocation Refers To Location
ParentInventoryLocationName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The name of the parent inventory location for a product item.
ParentInventoryLocationType	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The type of the parent inventory location for a product item.
ProductCategoryCode	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The product category code of a product item.
ProductCode	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The product code for identifying a product item.
ProductDescription	Type textarea Properties Create, Filter, Nillable, Sort, Update Description The description of a product item.
ProductFamily	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Specifies the product family to which a product item belongs.
ProductId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The product record associated with the record. This field is a relationship field. Relationship Name Product Refers To Product2
ProductItemId	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The product item record associated with the record. This field is a relationship field. Relationship Name ProductItem Refers To ProductItem
ProductLineCode	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The product line category of a product item.
ProductManufacturerName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The name of the manufacturer that manufactured a product item.
ProductName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The name of the product related to a product item.
ProductVersionName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The version name of a product item.
ReplenishmentLocation	Type reference Properties Create, Filter, Group, Nillable, Sort, Update Description The inventory location from which replenishment should be sourced, based on the criteria defined in the replenishment policy. Relationship Name ReplenishmentLocation Refers To Location
ReplenishmentLocationName	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The name of the replenishment source location derived from the replenishment policy criteria.
ReplenishmentQuantity	Type double Properties Create, Filter, Nillable, Sort, Update Description The suggested replenishment quantity for the product item, calculated based on the formula defined in the associated replenishment policy.
ShortageQuantity	Type double Properties Create, Filter, Nillable, Sort, Update Description The quantity shortage for the product item. Calculated as the difference between the minimum inventory quantity and the quantity on hand. If the quantity on hand is greater than the minimum, this value is 0.
StockStatus	Type picklist Properties Filter, Nillable, Sort Description Indicates the stock status of the product item. Possible values are: Shortage In Range Excess
TotalQuantityAtLocation	Type double Properties Create, Filter, Nillable, Sort, Update Description The total quantity of a product item at an inventory location.
TotalQuantityUnitOfMeasure	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description Specifies the unit of measure for the total quantity at location.
UniversalProductCode	Type string Properties Create, Filter, Group, Nillable, Sort, Update Description The universal product code that's used to track the product item.

Manufacturing Cloud Developer Guide

ProductInvSearchableField

Supported Calls

Fields