Consumed Location Product DMO

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

• LocationProductInventoryId has a FOREIGNKEY relationship with the Location Product Inventory DMO Id field.
• QuantityUnitOfMeasure has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product DMO Id field.
• PriceBookEntryId has a FOREIGNKEY relationship with the Price Book Entry DMO Id field.
• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
• WorkOrderId has a FOREIGNKEY relationship with the Work Order DMO Id field.

• cdp_sys_record_currency
• ConsumedQuantity
• CreatedById
• CreatedDate
• DataSourceId
• DataSourceObjectId
• Description
• DiscountPercent
• Id
• InternalOrganizationId
• IsConsumed
• IsProductSerialized
• KQ_CreatedById
• KQ_Id
• KQ_LocationProductInventoryId
• KQ_PriceBookEntryId
• KQ_ProductId
• KQ_QuantityUnitOfMeasure
• KQ_WorkOrderId
• ListPriceAmount
• LocationProductInventoryId
• Name
• PriceBookEntryId
• ProductId
• QuantityUnitOfMeasure
• SubTotalPriceAmount
• TotalPriceAmount
• UnitPrice
• WorkOrderId
• WorkOrderItemId

• 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__ConsumedQuantity__c
• Data Type: DOUBLE
• Description: The quantity of the product consumed.

• 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__Description__c
• Data Type: TEXT
• Description: Description for the Consumed Location Product.

• Field API Name: ssot__DiscountPercent__c
• Data Type: DOUBLE
• Description: The discount percentage provided.

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this ConsumedLocationProduct 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__IsConsumed__c
• Data Type: TEXT
• Description: The subject context for whom the clinical alert was created.

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

• 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_LocationProductInventoryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocationProductInventoryId

• Field API Name: KQ_PriceBookEntryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for PriceBookEntryId

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

• Field API Name: KQ_QuantityUnitOfMeasure__c
• Data Type: TEXT
• Description: Key Qualifier system field for QuantityUnitOfMeasure

• Field API Name: KQ_WorkOrderId__c
• Data Type: TEXT
• Description: Key Qualifier system field for WorkOrderId

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

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

• Field API Name: ssot__Name__c
• Data Type: TEXT
• Description: Name for the Consumed Location Product.

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

• Field API Name: ssot__ProductId__c
• Data Type: TEXT
• Description: Reference to the related Product.

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

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

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

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

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

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