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

Fields

• 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

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.