ProductItemTransaction

Represents an action taken on a product item. Product item transactions track when a product is consumed, replenished, adjusted, or transferred. Product item transactions are auto-generated records that specify the quantity of products impacted by the action. This object is available in API version 60.0 and later.

Supported Calls

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

Fields

Description

  • Type: textarea
  • Properties: Create, Nillable, Update
  • Description: The description of the product item transaction.

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 isn’t null, the user accessed this record or list view indirectly.

ProductItemId

  • Type: reference
  • Properties: Create, Filter, Group, Sort
  • Description: The product item associated with the product item transaction.

    This field is a relationship field.

  • Relationship Name: ProductItem
  • Relationship Type: Lookup
  • Refers To: ProductItem

ProductItemTransactionNumber

  • Type: string
  • Properties: Autonumber, Defaulted on create, Filter, idLookup, Sort
  • Description: The auto-generated number identifying the product item transaction.

Quantity

  • Type: double
  • Properties: Create, Filter, Sort
  • Description: The quantity of the product item involved in the transaction. If inventory was consumed, the quantity is negative.

RelatedRecordId

  • Type: reference
  • Properties: Filter, Group, Nillable, Sort
  • Description: The product consumed, product transfer, or visit related to the action. If the action wasn’t related to consumption or transfer, the related record is blank.

    This field is a polymorphic relationship field.

  • Relationship Name: RelatedRecord
  • Relationship Type: Lookup
  • Refers To: ProductConsumed, ProductTransfer, Visit

TransactionType

  • Type: picklist
  • Properties: Create, Filter, Group, Restricted picklist, Sort
  • Description: The action that the transaction tracks.
  • Possible values:
    • Adjusted
    • Consumed
    • Replenished
    • Transferred