# Consumed Location Product DMO

## Object Properties

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

## Relationships

- **LocationProductInventoryId** has a FOREIGNKEY relationship with the [Location Product Inventory DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-locationproductinventorydmo-dmo.md) `Id` field.
- **QuantityUnitOfMeasure** has a FOREIGNKEY relationship with the [Unit of Measure DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-unitofmeasuredmo-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.
- **PriceBookEntryId** has a FOREIGNKEY relationship with the [Price Book Entry DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-pricebookentrydmo-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.
- **WorkOrderId** has a FOREIGNKEY relationship with the [Work Order DMO](/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderdmo-dmo.md) `Id` field.

## Fields

- [cdp_sys_record_currency](#cdp_sys_record_currency)
- [ConsumedQuantity](#consumedquantity)
- [CreatedById](#createdbyid)
- [CreatedDate](#createddate)
- [DataSourceId](#datasourceid)
- [DataSourceObjectId](#datasourceobjectid)
- [Description](#description)
- [DiscountPercent](#discountpercent)
- [Id](#id)
- [InternalOrganizationId](#internalorganizationid)
- [IsConsumed](#isconsumed)
- [IsProductSerialized](#isproductserialized)
- [KQ_CreatedById](#kq_createdbyid)
- [KQ_Id](#kq_id)
- [KQ_LocationProductInventoryId](#kq_locationproductinventoryid)
- [KQ_PriceBookEntryId](#kq_pricebookentryid)
- [KQ_ProductId](#kq_productid)
- [KQ_QuantityUnitOfMeasure](#kq_quantityunitofmeasure)
- [KQ_WorkOrderId](#kq_workorderid)
- [ListPriceAmount](#listpriceamount)
- [LocationProductInventoryId](#locationproductinventoryid)
- [Name](#name)
- [PriceBookEntryId](#pricebookentryid)
- [ProductId](#productid)
- [QuantityUnitOfMeasure](#quantityunitofmeasure)
- [SubTotalPriceAmount](#subtotalpriceamount)
- [TotalPriceAmount](#totalpriceamount)
- [UnitPrice](#unitprice)
- [WorkOrderId](#workorderid)
- [WorkOrderItemId](#workorderitemid)

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

### ConsumedQuantity

- **Field API Name:** `ssot__ConsumedQuantity__c`
- **Data Type:** DOUBLE
- **Description:** The quantity of the product consumed.

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

### Description

- **Field API Name:** `ssot__Description__c`
- **Data Type:** TEXT
- **Description:** Description for the Consumed Location Product.

### DiscountPercent

- **Field API Name:** `ssot__DiscountPercent__c`
- **Data Type:** DOUBLE
- **Description:** The discount percentage provided.

### Id

- **Field API Name:** `ssot__Id__c`
- **Data Type:** TEXT
- **Description:** A unique, system-generated identifier for this ConsumedLocationProduct 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.

### IsConsumed

- **Field API Name:** `ssot__IsConsumed__c`
- **Data Type:** TEXT
- **Description:** The subject context for whom the clinical alert was created.

### IsProductSerialized

- **Field API Name:** `ssot__IsProductSerialized__c`
- **Data Type:** TEXT
- **Description:** Whether a product is a serialized product. The default is false.

### 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_LocationProductInventoryId

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

### KQ_PriceBookEntryId

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

### KQ_ProductId

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

### KQ_QuantityUnitOfMeasure

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

### KQ_WorkOrderId

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

### ListPriceAmount

- **Field API Name:** `ssot__ListPriceAmount__c`
- **Data Type:** DOUBLE
- **Description:** The list price of the product.

### LocationProductInventoryId

- **Field API Name:** `ssot__LocationProductInventoryId__c`
- **Data Type:** TEXT
- **Description:** The stock of a particular product at a particular location in field service, such as all bolts stored in your main warehouse.

### Name

- **Field API Name:** `ssot__Name__c`
- **Data Type:** TEXT
- **Description:** Name for the Consumed Location Product.

### PriceBookEntryId

- **Field API Name:** `ssot__PriceBookEntryId__c`
- **Data Type:** TEXT
- **Description:** Reference to the related Price Book Entry.

### ProductId

- **Field API Name:** `ssot__ProductId__c`
- **Data Type:** TEXT
- **Description:** Reference to the related Product.

### QuantityUnitOfMeasure

- **Field API Name:** `ssot__QuantityUnitOfMeasure__c`
- **Data Type:** TEXT
- **Description:** Unit of Measure of the Consumed Quantity.

### SubTotalPriceAmount

- **Field API Name:** `ssot__SubTotalPriceAmount__c`
- **Data Type:** DOUBLE
- **Description:** The total price of the product items before discount.

### TotalPriceAmount

- **Field API Name:** `ssot__TotalPriceAmount__c`
- **Data Type:** DOUBLE
- **Description:** The total price paid for the product items.

### UnitPrice

- **Field API Name:** `ssot__UnitPrice__c`
- **Data Type:** DOUBLE
- **Description:** Numeric value representing the unit price. Do not include currency symbols or commas.

### WorkOrderId

- **Field API Name:** `ssot__WorkOrderId__c`
- **Data Type:** TEXT
- **Description:** Reference to the related Work Order.

### WorkOrderItemId

- **Field API Name:** `ssot__WorkOrderItemId__c`
- **Data Type:** TEXT
- **Description:** Reference to the related Work Order Item.