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.