--- schema_version: "1" id: b4656a183a9a465fe31a6b0ca6920e9f4ac6aa84d3b46eadf7a73511878df9a1 title: ProductInvSearchableField collection: legacydeveloper version: current locale: en-us portal_url: https://docs.salesforce.com/legacydeveloper/current/en-us/mfg_api_devguide/sforce_api_objects_productinvsearchablefield.md canonical_url: https://developer.salesforce.com/docs/atlas.en-us.mfg_api_devguide.meta/mfg_api_devguide/sforce_api_objects_productinvsearchablefield.htm source_site: developer.salesforce.com content_type: documentation content_hash: cdd65cc0a645afa7be7553e2bd9aacd5dbf7b2daf9d945e8103e5453e8c5a7ab description: 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. --- # 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 ### 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). - **Default value**: 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). - **Default value**: 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**: - 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. ## Associated Objects This object has the following associated objects. If the API version isn’t specified, they’re available in the same API versions as this object. Otherwise, they’re available in the specified API version and later. **[ProductInvSearchableFieldShare](https://developer.salesforce.com/docs/atlas.en-us.mfg_api_devguide.meta/mfg_api_devguide/sforce_api_associated_objects_share.htm "StandardObjectNameShare is the model for all share objects associated with standard objects. These objects represent a sharing entry on the standard object."):** Sharing is available for the object.