Work Order Item DMO

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

• ServiceTerritoryId has a FOREIGNKEY relationship with the Service Territory DMO Id field.
• ProductServiceCampaignItemId has a FOREIGNKEY relationship with the Product Service Campaign Item DMO Id field.
• ProductServiceCampaignId has a FOREIGNKEY relationship with the Product Service Campaign DMO Id field.
• SalesOrderId has a FOREIGNKEY relationship with the Sales Order DMO Id field.
• WorkTypeId has a FOREIGNKEY relationship with the Work Type DMO Id field.
• WorkOrderId has a FOREIGNKEY relationship with the Work Order DMO Id field.
• AssetId has a FOREIGNKEY relationship with the Asset DMO Id field.
• AddressId has a FOREIGNKEY relationship with the Address DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.
• DurationUOMId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• CreatedById has a FOREIGNKEY relationship with the User DMO Id field.
• AssetWarrantyTermId has a FOREIGNKEY relationship with the Asset Warranty Term 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.
• LocationId has a FOREIGNKEY relationship with the Location DMO Id field.
• ReturnOrderProductId has a FOREIGNKEY relationship with the Return Order Product DMO Id field.
• ReturnOrderId has a FOREIGNKEY relationship with the Return Order DMO Id field.
• ParentWorkOrderItemId has a FOREIGNKEY relationship with the Work Order Item DMO Id field.
• RootWorkOrderItemId has a FOREIGNKEY relationship with the Work Order Item DMO Id field.

• AddressId
• AssetId
• AssetWarrantyTermId
• cdp_sys_record_currency
• CreatedById
• CreatedDate
• Currency
• DataSourceId
• DataSourceObjectId
• Description
• DiscountPercent
• DurationInMinutes
• DurationQuantity
• DurationUOMId
• EndDateTime
• GenerationMethodCode
• GeocodeAccuracy
• Id
• InternalOrganizationId
• IsClosed
• IsGeneratedFromMaintenancePlan
• KQ_AddressId
• KQ_AssetId
• KQ_AssetWarrantyTermId
• KQ_CreatedById
• KQ_DurationUOMId
• KQ_Id
• KQ_LastModifiedById
• KQ_LocationId
• KQ_ParentWorkOrderItemId
• KQ_PriceBookEntryId
• KQ_ProductId
• KQ_ProductServiceCampaignId
• KQ_ProductServiceCampaignItemId
• KQ_ReturnOrderId
• KQ_ReturnOrderProductId
• KQ_RootWorkOrderItemId
• KQ_SalesOrderId
• KQ_ServiceTerritoryId
• KQ_WorkOrderId
• KQ_WorkTypeId
• LastModifiedById
• LastModifiedDate
• ListPriceAmount
• LocationId
• MinimumCrewSizeNumber
• ParentWorkOrderItemId
• PricebookEntryId
• ProcessType
• ProductId
• ProductServiceCampaignId
• ProductServiceCampaignItemId
• Quantity
• RecommendedCrewSizeNumber
• ReturnOrderId
• ReturnOrderProductId
• RootWorkOrderItemId
• SalesOrderId
• ServiceAppointmentCount
• ServiceTerritoryId
• StartDateTime
• SubjectText
• SubTotalAmount
• SuggestedMaintenanceDateTime
• SystemModstamp
• TotalPriceAmount
• UnitPriceAmount
• WorkOrderDurationSource
• WorkOrderId
• WorkOrderItemPriority
• WorkOrderLineItemNumber
• WorkOrderStatus
• WorkOrderStatusCategory
• WorkTypeId

• Field API Name: ssot__AddressId__c
• Data Type: TEXT
• Description: Address where the Work Order item is completed.

• Field API Name: ssot__AssetId__c
• Data Type: TEXT
• Description: Reference to the related Asset.

• Field API Name: ssot__AssetWarrantyTermId__c
• Data Type: TEXT
• Description: Reference to the related Asset Warranty Term.

• 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__CreatedById__c
• Data Type: TEXT
• Description: User who created the record.

• Field API Name: ssot__CreatedDate__c
• Data Type: DATETIME
• Description: Date and time when this record was created.

• Field API Name: ssot__Currency__c
• Data Type: TEXT
• Description: ISO 4217 currency code associated with the record.

• 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 of the Work Order.

• Field API Name: ssot__DiscountPercent__c
• Data Type: DOUBLE
• Description: The percentage value for discount percent of the work order item.

• Field API Name: ssot__DurationInMinutes__c
• Data Type: DOUBLE
• Description: Duration In Minutes.

• Field API Name: ssot__DurationQuantity__c
• Data Type: DOUBLE
• Description: The estimated time required to complete the work order item.

• Field API Name: ssot__DurationUOMId__c
• Data Type: TEXT
• Description: Unit of Measurement of the Duration. For example, Hours, Minutes.

• Field API Name: ssot__EndDateTime__c
• Data Type: DATETIME
• Description: The date when the work order is completed.

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

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

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

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

• Field API Name: ssot__IsClosed__c
• Data Type: TEXT
• Description: Whether the work order item is closed.

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

• Field API Name: KQ_AddressId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AddressId

• Field API Name: KQ_AssetId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AssetId

• Field API Name: KQ_AssetWarrantyTermId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AssetWarrantyTermId

• Field API Name: KQ_CreatedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for CreatedById

• Field API Name: KQ_DurationUOMId__c
• Data Type: TEXT
• Description: Key Qualifier system field for DurationUOMId

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

• Field API Name: KQ_LastModifiedById__c
• Data Type: TEXT
• Description: Key Qualifier system field for LastModifiedById

• Field API Name: KQ_LocationId__c
• Data Type: TEXT
• Description: Key Qualifier system field for LocationId

• Field API Name: KQ_ParentWorkOrderItemId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ParentWorkOrderItemId

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

• Field API Name: KQ_ProductServiceCampaignItemId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ProductServiceCampaignItemId

• Field API Name: KQ_ReturnOrderId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ReturnOrderId

• Field API Name: KQ_ReturnOrderProductId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ReturnOrderProductId

• Field API Name: KQ_RootWorkOrderItemId__c
• Data Type: TEXT
• Description: Key Qualifier system field for RootWorkOrderItemId

• Field API Name: KQ_SalesOrderId__c
• Data Type: TEXT
• Description: Key Qualifier system field for SalesOrderId

• Field API Name: KQ_ServiceTerritoryId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ServiceTerritoryId

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

• Field API Name: KQ_WorkTypeId__c
• Data Type: TEXT
• Description: Key Qualifier system field for WorkTypeId

• Field API Name: ssot__LastModifiedById__c
• Data Type: TEXT
• Description: User who most recently changed the record.

• Field API Name: ssot__LastModifiedDate__c
• Data Type: DATETIME
• Description: Date and time when a user last modified this record.

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

• Field API Name: ssot__LocationId__c
• Data Type: TEXT
• Description: Reference to the associated Location.

• Field API Name: ssot__MinimumCrewSizeNumber__c
• Data Type: DOUBLE
• Description: The minimum crew size allowed for a crew assigned to the work order item.

• Field API Name: ssot__ParentWorkOrderItemId__c
• Data Type: TEXT
• Description: Self reference to the parent work order item.

• Field API Name: ssot__PricebookEntryId__c
• Data Type: TEXT
• Description: Reference to the associated price book entry.

• Field API Name: ssot__ProcessType__c
• Data Type: TEXT
• Description: Specifies the process type of the work order line item.

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

• Field API Name: ssot__ProductServiceCampaignId__c
• Data Type: TEXT
• Description: A customer messaging plan related to repairs that a specific product requires.

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

• Field API Name: ssot__Quantity__c
• Data Type: DOUBLE
• Description: Quantity on the work order item.

• Field API Name: ssot__RecommendedCrewSizeNumber__c
• Data Type: DOUBLE
• Description: The recommended crew size allowed for a crew assigned to the work order.

• Field API Name: ssot__ReturnOrderId__c
• Data Type: TEXT
• Description: Reference to the associated Return Order.

• Field API Name: ssot__ReturnOrderProductId__c
• Data Type: TEXT
• Description: Reference to the associated Return Order Item.

• Field API Name: ssot__RootWorkOrderItemId__c
• Data Type: TEXT
• Description: Self reference to the root work order item.

• Field API Name: ssot__SalesOrderId__c
• Data Type: TEXT
• Description: Reference to the associated Sales Order.

• Field API Name: ssot__ServiceAppointmentCount__c
• Data Type: DOUBLE
• Description: Count of service appointment associated with the Work order Item.

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

• Field API Name: ssot__StartDateTime__c
• Data Type: DATETIME
• Description: The date when the work order goes into effect.

• Field API Name: ssot__SubjectText__c
• Data Type: TEXT
• Description: Short Description of the Work Order.

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

• Field API Name: ssot__SuggestedMaintenanceDateTime__c
• Data Type: DATETIME
• Description: Suggested Maintenance Date.

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

• Field API Name: ssot__TotalPriceAmount__c
• Data Type: DOUBLE
• Description: Total Price Amount for the Work Order Item.

• Field API Name: ssot__UnitPriceAmount__c
• Data Type: DOUBLE
• Description: Unit price amount of the work order item.

• Field API Name: ssot__WorkOrderDurationSource__c
• Data Type: TEXT
• Description: Duration Source associated with the Work Order item.

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

• Field API Name: ssot__WorkOrderItemPriority__c
• Data Type: TEXT
• Description: Priority associated with the Work Order.

• Field API Name: ssot__WorkOrderLineItemNumber__c
• Data Type: TEXT
• Description: Work Order Line Item Number.

• Field API Name: ssot__WorkOrderStatus__c
• Data Type: TEXT
• Description: Status associated with the Work Order item.

• Field API Name: ssot__WorkOrderStatusCategory__c
• Data Type: TEXT
• Description: Status category associated with the Work Order item.

• Field API Name: ssot__WorkTypeId__c
• Data Type: TEXT
• Description: Reference to the associated Work Type.