--- schema_version: "1" id: a88910a33c30ed15707bd6b939d398487c1bbae02533b24becde56e1488dd36c title: Work Order Item DMO collection: developer version: current locale: en-us portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-dmo-mapping/guides/std_dmos/c360dm-si-workorderitemdmo-dmo.md canonical_url: https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderitemdmo-dmo.html source_site: developer.salesforce.com content_type: documentation content_hash: 749f4fd9bc476209ff98091aa52724f312d7759861ce100d84e962970fa5d443 products: - Data 360 DMO and Mapping Guide - Data 360 Developer Documentation --- # Work Order Item DMO ## Object Properties **Object API Name:** `ssot__WorkOrderItem__dlm` **Category:** Unassigned **Availability:** Available in 254 and later versions **Primary Key Field:** Id ## Relationships - **ServiceTerritoryId** has a FOREIGNKEY relationship with the [Service Territory DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-serviceterritorydmo-dmo.md) `Id` field. - **ProductServiceCampaignItemId** has a FOREIGNKEY relationship with the [Product Service Campaign Item DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productservicecampaignitemdmo-dmo.md) `Id` field. - **ProductServiceCampaignId** has a FOREIGNKEY relationship with the [Product Service Campaign DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-productservicecampaigndmo-dmo.md) `Id` field. - **SalesOrderId** has a FOREIGNKEY relationship with the [Sales Order DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-salesorderdmo-dmo.md) `Id` field. - **WorkTypeId** has a FOREIGNKEY relationship with the [Work Type DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-worktypedmo-dmo.md) `Id` field. - **WorkOrderId** has a FOREIGNKEY relationship with the [Work Order DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderdmo-dmo.md) `Id` field. - **AssetId** has a FOREIGNKEY relationship with the [Asset DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-assetdmo-dmo.md) `Id` field. - **AddressId** has a FOREIGNKEY relationship with the [Address DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-addressdmo-dmo.md) `Id` field. - **LastModifiedById** has a FOREIGNKEY relationship with the [User DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field. - **DurationUOMId** has a FOREIGNKEY relationship with the [Unit of Measure DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-unitofmeasuredmo-dmo.md) `Id` field. - **CreatedById** has a FOREIGNKEY relationship with the [User DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-userdmo-dmo.md) `Id` field. - **AssetWarrantyTermId** has a FOREIGNKEY relationship with the [Asset Warranty Term DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-assetwarrantytermdmo-dmo.md) `Id` field. - **ProductId** has a FOREIGNKEY relationship with the [Product DMO](https://developer.salesforce.com/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](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-pricebookentrydmo-dmo.md) `Id` field. - **LocationId** has a FOREIGNKEY relationship with the [Location DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-locationdmo-dmo.md) `Id` field. - **ReturnOrderProductId** has a FOREIGNKEY relationship with the [Return Order Product DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-returnorderproductdmo-dmo.md) `Id` field. - **ReturnOrderId** has a FOREIGNKEY relationship with the [Return Order DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-returnorderdmo-dmo.md) `Id` field. - **ParentWorkOrderItemId** has a FOREIGNKEY relationship with the [Work Order Item DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderitemdmo-dmo.md) `Id` field. - **RootWorkOrderItemId** has a FOREIGNKEY relationship with the [Work Order Item DMO](https://developer.salesforce.com/docs/data/data-cloud-dmo-mapping/guide/c360dm-si-workorderitemdmo-dmo.md) `Id` field. ## Fields - [AddressId](#addressid) - [AssetId](#assetid) - [AssetWarrantyTermId](#assetwarrantytermid) - [cdp_sys_record_currency](#cdp_sys_record_currency) - [CreatedById](#createdbyid) - [CreatedDate](#createddate) - [Currency](#currency) - [DataSourceId](#datasourceid) - [DataSourceObjectId](#datasourceobjectid) - [Description](#description) - [DiscountPercent](#discountpercent) - [DurationInMinutes](#durationinminutes) - [DurationQuantity](#durationquantity) - [DurationUOMId](#durationuomid) - [EndDateTime](#enddatetime) - [GenerationMethodCode](#generationmethodcode) - [GeocodeAccuracy](#geocodeaccuracy) - [Id](#id) - [InternalOrganizationId](#internalorganizationid) - [IsClosed](#isclosed) - [IsGeneratedFromMaintenancePlan](#isgeneratedfrommaintenanceplan) - [KQ_AddressId](#kq_addressid) - [KQ_AssetId](#kq_assetid) - [KQ_AssetWarrantyTermId](#kq_assetwarrantytermid) - [KQ_CreatedById](#kq_createdbyid) - [KQ_DurationUOMId](#kq_durationuomid) - [KQ_Id](#kq_id) - [KQ_LastModifiedById](#kq_lastmodifiedbyid) - [KQ_LocationId](#kq_locationid) - [KQ_ParentWorkOrderItemId](#kq_parentworkorderitemid) - [KQ_PriceBookEntryId](#kq_pricebookentryid) - [KQ_ProductId](#kq_productid) - [KQ_ProductServiceCampaignId](#kq_productservicecampaignid) - [KQ_ProductServiceCampaignItemId](#kq_productservicecampaignitemid) - [KQ_ReturnOrderId](#kq_returnorderid) - [KQ_ReturnOrderProductId](#kq_returnorderproductid) - [KQ_RootWorkOrderItemId](#kq_rootworkorderitemid) - [KQ_SalesOrderId](#kq_salesorderid) - [KQ_ServiceTerritoryId](#kq_serviceterritoryid) - [KQ_WorkOrderId](#kq_workorderid) - [KQ_WorkTypeId](#kq_worktypeid) - [LastModifiedById](#lastmodifiedbyid) - [LastModifiedDate](#lastmodifieddate) - [ListPriceAmount](#listpriceamount) - [LocationId](#locationid) - [MinimumCrewSizeNumber](#minimumcrewsizenumber) - [ParentWorkOrderItemId](#parentworkorderitemid) - [PricebookEntryId](#pricebookentryid) - [ProcessType](#processtype) - [ProductId](#productid) - [ProductServiceCampaignId](#productservicecampaignid) - [ProductServiceCampaignItemId](#productservicecampaignitemid) - [Quantity](#quantity) - [RecommendedCrewSizeNumber](#recommendedcrewsizenumber) - [ReturnOrderId](#returnorderid) - [ReturnOrderProductId](#returnorderproductid) - [RootWorkOrderItemId](#rootworkorderitemid) - [SalesOrderId](#salesorderid) - [ServiceAppointmentCount](#serviceappointmentcount) - [ServiceTerritoryId](#serviceterritoryid) - [StartDateTime](#startdatetime) - [SubjectText](#subjecttext) - [SubTotalAmount](#subtotalamount) - [SuggestedMaintenanceDateTime](#suggestedmaintenancedatetime) - [SystemModstamp](#systemmodstamp) - [TotalPriceAmount](#totalpriceamount) - [UnitPriceAmount](#unitpriceamount) - [WorkOrderDurationSource](#workorderdurationsource) - [WorkOrderId](#workorderid) - [WorkOrderItemPriority](#workorderitempriority) - [WorkOrderLineItemNumber](#workorderlineitemnumber) - [WorkOrderStatus](#workorderstatus) - [WorkOrderStatusCategory](#workorderstatuscategory) - [WorkTypeId](#worktypeid) ### AddressId - **Field API Name:** `ssot__AddressId__c` - **Data Type:** TEXT - **Description:** Address where the Work Order item is completed. ### AssetId - **Field API Name:** `ssot__AssetId__c` - **Data Type:** TEXT - **Description:** Reference to the related Asset. ### AssetWarrantyTermId - **Field API Name:** `ssot__AssetWarrantyTermId__c` - **Data Type:** TEXT - **Description:** Reference to the related Asset Warranty Term. ### 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:** User who created the record. ### CreatedDate - **Field API Name:** `ssot__CreatedDate__c` - **Data Type:** DATETIME - **Description:** Date and time when this record was created. ### Currency - **Field API Name:** `ssot__Currency__c` - **Data Type:** TEXT - **Description:** ISO 4217 currency code associated with the record. ### 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 of the Work Order. ### DiscountPercent - **Field API Name:** `ssot__DiscountPercent__c` - **Data Type:** DOUBLE - **Description:** The percentage value for discount percent of the work order item. ### DurationInMinutes - **Field API Name:** `ssot__DurationInMinutes__c` - **Data Type:** DOUBLE - **Description:** Duration In Minutes. ### DurationQuantity - **Field API Name:** `ssot__DurationQuantity__c` - **Data Type:** DOUBLE - **Description:** The estimated time required to complete the work order item. ### DurationUOMId - **Field API Name:** `ssot__DurationUOMId__c` - **Data Type:** TEXT - **Description:** Unit of Measurement of the Duration. For example, Hours, Minutes. ### EndDateTime - **Field API Name:** `ssot__EndDateTime__c` - **Data Type:** DATETIME - **Description:** The date when the work order is completed. ### GenerationMethodCode - **Field API Name:** `ssot__GenerationMethodCode__c` - **Data Type:** TEXT - **Description:** WO generation method, Example: (1) Create Work Orders for Maintenance Plan with No Maintenance Asset; (2) Create 1 Work Order per Maintenance Asset. ### GeocodeAccuracy - **Field API Name:** `ssot__GeocodeAccuracy__c` - **Data Type:** TEXT - **Description:** The level of accuracy of a location's geographical coordinates compared with its physical address. ### Id - **Field API Name:** `ssot__Id__c` - **Data Type:** TEXT - **Description:** Required. A unique, system-generated identifier for this WorkOrderItem record. Maximum size is 36 characters. ### InternalOrganizationId - **Field API Name:** `ssot__InternalOrganizationId__c` - **Data Type:** TEXT - **Description:** A unique, system-generated identifier for this record. ### IsClosed - **Field API Name:** `ssot__IsClosed__c` - **Data Type:** TEXT - **Description:** Whether the work order item is closed. ### IsGeneratedFromMaintenancePlan - **Field API Name:** `ssot__IsGeneratedFromMaintenancePlan__c` - **Data Type:** TEXT - **Description:** Indicates that the work order was generated from a maintenance plan rather than manually created. ### KQ_AddressId - **Field API Name:** `KQ_AddressId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for AddressId ### KQ_AssetId - **Field API Name:** `KQ_AssetId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for AssetId ### KQ_AssetWarrantyTermId - **Field API Name:** `KQ_AssetWarrantyTermId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for AssetWarrantyTermId ### KQ_CreatedById - **Field API Name:** `KQ_CreatedById__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for CreatedById ### KQ_DurationUOMId - **Field API Name:** `KQ_DurationUOMId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for DurationUOMId ### KQ_Id - **Field API Name:** `KQ_Id__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for Id ### KQ_LastModifiedById - **Field API Name:** `KQ_LastModifiedById__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for LastModifiedById ### KQ_LocationId - **Field API Name:** `KQ_LocationId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for LocationId ### KQ_ParentWorkOrderItemId - **Field API Name:** `KQ_ParentWorkOrderItemId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ParentWorkOrderItemId ### 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_ProductServiceCampaignId - **Field API Name:** `KQ_ProductServiceCampaignId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ProductServiceCampaignId ### KQ_ProductServiceCampaignItemId - **Field API Name:** `KQ_ProductServiceCampaignItemId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ProductServiceCampaignItemId ### KQ_ReturnOrderId - **Field API Name:** `KQ_ReturnOrderId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ReturnOrderId ### KQ_ReturnOrderProductId - **Field API Name:** `KQ_ReturnOrderProductId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ReturnOrderProductId ### KQ_RootWorkOrderItemId - **Field API Name:** `KQ_RootWorkOrderItemId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for RootWorkOrderItemId ### KQ_SalesOrderId - **Field API Name:** `KQ_SalesOrderId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for SalesOrderId ### KQ_ServiceTerritoryId - **Field API Name:** `KQ_ServiceTerritoryId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for ServiceTerritoryId ### KQ_WorkOrderId - **Field API Name:** `KQ_WorkOrderId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for WorkOrderId ### KQ_WorkTypeId - **Field API Name:** `KQ_WorkTypeId__c` - **Data Type:** TEXT - **Description:** Key Qualifier system field for WorkTypeId ### LastModifiedById - **Field API Name:** `ssot__LastModifiedById__c` - **Data Type:** TEXT - **Description:** User who most recently changed the record. ### LastModifiedDate - **Field API Name:** `ssot__LastModifiedDate__c` - **Data Type:** DATETIME - **Description:** Date and time when a user last modified this record. ### ListPriceAmount - **Field API Name:** `ssot__ListPriceAmount__c` - **Data Type:** DOUBLE - **Description:** The list price for one unit of the order product. ### LocationId - **Field API Name:** `ssot__LocationId__c` - **Data Type:** TEXT - **Description:** Reference to the associated Location. ### MinimumCrewSizeNumber - **Field API Name:** `ssot__MinimumCrewSizeNumber__c` - **Data Type:** DOUBLE - **Description:** The minimum crew size allowed for a crew assigned to the work order item. ### ParentWorkOrderItemId - **Field API Name:** `ssot__ParentWorkOrderItemId__c` - **Data Type:** TEXT - **Description:** Self reference to the parent work order item. ### PricebookEntryId - **Field API Name:** `ssot__PricebookEntryId__c` - **Data Type:** TEXT - **Description:** Reference to the associated price book entry. ### ProcessType - **Field API Name:** `ssot__ProcessType__c` - **Data Type:** TEXT - **Description:** Specifies the process type of the work order line item. ### ProductId - **Field API Name:** `ssot__ProductId__c` - **Data Type:** TEXT - **Description:** Reference to the associated Product. ### ProductServiceCampaignId - **Field API Name:** `ssot__ProductServiceCampaignId__c` - **Data Type:** TEXT - **Description:** A customer messaging plan related to repairs that a specific product requires. ### ProductServiceCampaignItemId - **Field API Name:** `ssot__ProductServiceCampaignItemId__c` - **Data Type:** TEXT - **Description:** A purpose of product service campaign may be to inform customers about multiple issues, which could relate to either Inventory Products or Product Assets. ### Quantity - **Field API Name:** `ssot__Quantity__c` - **Data Type:** DOUBLE - **Description:** Quantity on the work order item. ### RecommendedCrewSizeNumber - **Field API Name:** `ssot__RecommendedCrewSizeNumber__c` - **Data Type:** DOUBLE - **Description:** The recommended crew size allowed for a crew assigned to the work order. ### ReturnOrderId - **Field API Name:** `ssot__ReturnOrderId__c` - **Data Type:** TEXT - **Description:** Reference to the associated Return Order. ### ReturnOrderProductId - **Field API Name:** `ssot__ReturnOrderProductId__c` - **Data Type:** TEXT - **Description:** Reference to the associated Return Order Item. ### RootWorkOrderItemId - **Field API Name:** `ssot__RootWorkOrderItemId__c` - **Data Type:** TEXT - **Description:** Self reference to the root work order item. ### SalesOrderId - **Field API Name:** `ssot__SalesOrderId__c` - **Data Type:** TEXT - **Description:** Reference to the associated Sales Order. ### ServiceAppointmentCount - **Field API Name:** `ssot__ServiceAppointmentCount__c` - **Data Type:** DOUBLE - **Description:** Count of service appointment associated with the Work order Item. ### ServiceTerritoryId - **Field API Name:** `ssot__ServiceTerritoryId__c` - **Data Type:** TEXT - **Description:** A geographic area, or a group of customers that are grouped together to streamline support functions and service pricing. ### StartDateTime - **Field API Name:** `ssot__StartDateTime__c` - **Data Type:** DATETIME - **Description:** The date when the work order goes into effect. ### SubjectText - **Field API Name:** `ssot__SubjectText__c` - **Data Type:** TEXT - **Description:** Short Description of the Work Order. ### SubTotalAmount - **Field API Name:** `ssot__SubTotalAmount__c` - **Data Type:** DOUBLE - **Description:** The total of the work order line items' subtotals before discounts and taxes are applied. ### SuggestedMaintenanceDateTime - **Field API Name:** `ssot__SuggestedMaintenanceDateTime__c` - **Data Type:** DATETIME - **Description:** Suggested Maintenance Date. ### SystemModstamp - **Field API Name:** `ssot__SystemModstamp__c` - **Data Type:** DATETIME - **Description:** Date and time when this record was last modified by a user or by an automated process. ### TotalPriceAmount - **Field API Name:** `ssot__TotalPriceAmount__c` - **Data Type:** DOUBLE - **Description:** Total Price Amount for the Work Order Item. ### UnitPriceAmount - **Field API Name:** `ssot__UnitPriceAmount__c` - **Data Type:** DOUBLE - **Description:** Unit price amount of the work order item. ### WorkOrderDurationSource - **Field API Name:** `ssot__WorkOrderDurationSource__c` - **Data Type:** TEXT - **Description:** Duration Source associated with the Work Order item. ### WorkOrderId - **Field API Name:** `ssot__WorkOrderId__c` - **Data Type:** TEXT - **Description:** A task or job, usually on behalf of a Customer, that can be assigned and scheduled. ### WorkOrderItemPriority - **Field API Name:** `ssot__WorkOrderItemPriority__c` - **Data Type:** TEXT - **Description:** Priority associated with the Work Order. ### WorkOrderLineItemNumber - **Field API Name:** `ssot__WorkOrderLineItemNumber__c` - **Data Type:** TEXT - **Description:** Work Order Line Item Number. ### WorkOrderStatus - **Field API Name:** `ssot__WorkOrderStatus__c` - **Data Type:** TEXT - **Description:** Status associated with the Work Order item. ### WorkOrderStatusCategory - **Field API Name:** `ssot__WorkOrderStatusCategory__c` - **Data Type:** TEXT - **Description:** Status category associated with the Work Order item. ### WorkTypeId - **Field API Name:** `ssot__WorkTypeId__c` - **Data Type:** TEXT - **Description:** Reference to the associated Work Type.