Salesforce Docs Portal

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: Sharing is available for the object.