Location Product Inventory DMO

Object API Name: ssot__LocationProductInventory__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

• OwnerId has a FOREIGNKEY relationship with the User DMO Id field.
• InventoryLocationId has a FOREIGNKEY relationship with the Location DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.
• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.

• cdp_sys_record_currency
• CreatedById
• CreatedDate
• DataSourceId
• DataSourceObjectId
• Id
• InternalOrganizationId
• InventoryItemNumber
• InventoryLocationId
• KQ_CreatedById
• KQ_Id
• KQ_InventoryLocationId
• KQ_LastModifiedById
• KQ_OwnerId
• KQ_ProductId
• LastModifiedById
• LastModifiedDate
• Name
• OnHandQuantity
• OwnerId
• OwnerObject
• ProductId
• QuantityUOM
• SerialNumber

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: ssot__CreatedById__c
• Data Type: TEXT
• Description: The user who created the record.

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: The date and time when this record was created.

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this LocationProductInventory record. Maximum size is 15 characters.

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

• Field API Name: ssot__InventoryItemNumber__c
• Data Type: TEXT
• Description: Auto-generated number identifying the inventory item.

• Field API Name: ssot__InventoryLocationId__c
• Data Type: TEXT
• Description: Location associated with the product item. This usually indicates where the product item is stored.

• Field API Name: KQ_CreatedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for CreatedById

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_InventoryLocationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for InventoryLocationId

• Field API Name: KQ_LastModifiedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for LastModifiedById

• Field API Name: KQ_OwnerId__c
• Data Type: TEXT
• Description: Key Qualifier system field for OwnerId

• Field API Name: KQ_ProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductId

• Field API Name: ssot__LastModifiedById__c
• Data Type: TEXT
• Description: The user who most recently changed the record.

• Field API Name: ssot__LastModifiedDate__c
• Data Type: DATETIME
• Description: The date and time when a user last modified this record.

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: A name for the product item. Try to select a name that indicates what is being stored where; for example, Batteries in Warehouse A.

• Field API Name: ssot__OnHandQuantity__c
• Data Type: DOUBLE
• Description: The quantity at the location. If you want to add a serial number, this value must be 1.

• Field API Name: ssot__OwnerId__c
• Data Type: TEXT
• Description: The Location Product Inventory item’s owner.

• Field API Name: ssot__OwnerObject__c
• Data Type: TEXT
• Description: The name of the related owner object, such as User or UserGroup. Maximum size is 255 characters.

• Field API Name: ssot__ProductId__c
• Data Type: TEXT
• Description: Product associated with the product item, which represents the type of product in your inventory.

• Field API Name: ssot__QuantityUOM__c
• Data Type: TEXT
• Description: Units of the product item; for example, kilograms or liters. Quantity Unit of Measure picklist values are inherited from the Quantity Unit of Measure field on products.

• Field API Name: ssot__SerialNumber__c
• Data Type: TEXT
• Description: A number indicating a product or asset’s place in a series and used as a means of identification.