# Location Product Inventory DMO

## Object Properties

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

## Relationships

- **OwnerId** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.
- **InventoryLocationId** has a FOREIGNKEY relationship with the [Location DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-locationdmo-dmo.md) `Id` field.
- **ProductId** has a FOREIGNKEY relationship with the [Product DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productdmo-dmo.md) `Id` field.
- **LastModifiedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.
- **CreatedById** has a FOREIGNKEY relationship with the [User DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [CreatedById](#createdbyid)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [InventoryItemNumber](#inventoryitemnumber)
- [InventoryLocationId](#inventorylocationid)
- [KQ_CreatedById](#kq_createdbyid)
- [KQ_Id](#kq_id)
- [KQ_InventoryLocationId](#kq_inventorylocationid)
- [KQ_LastModifiedById](#kq_lastmodifiedbyid)
- [KQ_OwnerId](#kq_ownerid)
- [KQ_ProductId](#kq_productid)
- [LastModifiedById](#lastmodifiedbyid)
- [LastModifiedDate](#lastmodifieddate)
- [Name](#name)
- [OnHandQuantity](#onhandquantity)
- [OwnerId](#ownerid)
- [OwnerObject](#ownerobject)
- [ProductId](#productid)
- [QuantityUOM](#quantityuom)
- [SerialNumber](#serialnumber)

### cdp_sys_record_currency

- **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.

### CreatedById

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

### CreatedDate

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

### DataSourceId

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

### DataSourceObjectId

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

### Id

- **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.

### InternalOrganizationId

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

### InventoryItemNumber

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

### InventoryLocationId

- **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.

### KQ_CreatedById

- **Field API Name:** `KQ_CreatedById__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for CreatedById

### KQ_Id

- **Field API Name:** `KQ_Id__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for Id

### KQ_InventoryLocationId

- **Field API Name:** `KQ_InventoryLocationId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for InventoryLocationId

### KQ_LastModifiedById

- **Field API Name:** `KQ_LastModifiedById__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for LastModifiedById

### KQ_OwnerId

- **Field API Name:** `KQ_OwnerId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for OwnerId

### KQ_ProductId

- **Field API Name:** `KQ_ProductId__c`
- **Data Type:** TEXT
- **Description:** Key Qualifier system field for ProductId

### LastModifiedById

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

### LastModifiedDate

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

### Name

- **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.

### OnHandQuantity

- **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.

### OwnerId

- **Field API Name:** `ssot__OwnerId__c`
- **Data Type:** TEXT
- **Description:** The Location Product Inventory item's owner.

### OwnerObject

- **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.

### ProductId

- **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.

### QuantityUOM

- **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.

### SerialNumber

- **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.