Work Order Item DMO

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

• AssetId has a FOREIGNKEY relationship with the Asset 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.
• ProductServiceCampaignItemId has a FOREIGNKEY relationship with the Product Service Campaign Item DMO Id field.
• ReturnOrderProductId has a FOREIGNKEY relationship with the Return Order Product DMO Id field.
• WorkOrderId has a FOREIGNKEY relationship with the Work Order DMO Id field.
• LocationId has a FOREIGNKEY relationship with the Location DMO Id field.
• ProductServiceCampaignId has a FOREIGNKEY relationship with the Product Service Campaign DMO Id field.
• AssetWarrantyTermId has a FOREIGNKEY relationship with the Asset Warranty Term DMO Id field.
• RootWorkOrderItemId has a FOREIGNKEY relationship with the Work Order Item DMO Id field.
• ReturnOrderId has a FOREIGNKEY relationship with the Return Order DMO Id field.
• WorkTypeId has a FOREIGNKEY relationship with the Work Type DMO Id field.
• LastModifiedById has a FOREIGNKEY relationship with the User DMO Id field.
• PriceBookEntryId has a FOREIGNKEY relationship with the Price Book Entry DMO Id field.
• ParentWorkOrderItemId has a FOREIGNKEY relationship with the Work Order Item DMO Id field.
• AddressId has a FOREIGNKEY relationship with the Address DMO Id field.
• SalesOrderId has a FOREIGNKEY relationship with the Sales Order DMO Id field.
• ServiceTerritoryId has a FOREIGNKEY relationship with the Service Territory DMO Id field.
• ProductId has a FOREIGNKEY relationship with the Product 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
• 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: std__AddressId__c
• Data Type: TEXT
• Description: Address where the Work Order item is completed.

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

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

• Field API Name: std__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

• Field API Name: std__CreatedById__c
• Data Type: TEXT
• Description: User who created the record.

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

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

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

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

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

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

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

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

• Field API Name: std__DurationUomid__c
• Data Type: TEXT
• Description: Unit of measure identifier for the duration value associated with the record.

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

• Field API Name: std__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: std__GeocodeAccuracy__c
• Data Type: TEXT
• Description: The level of accuracy of a location's geographical coordinates compared with its physical address.

• Field API Name: std__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this WorkOrderItem record. Maximum size is 36 characters.

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

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

• Field API Name: std__IsGeneratedFromMaintenancePlan__c
• Data Type: TEXT
• Description: Indicates that the work order was generated from a maintenance plan rather than manually created.

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

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

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

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

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

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

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

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

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

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

• Field API Name: std__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: std__Quantity__c
• Data Type: DOUBLE
• Description: Quantity on the work order item.

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

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

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

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

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

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

• Field API Name: std__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: std__StartDateTime__c
• Data Type: DATETIME
• Description: The date when the work order goes into effect.

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

• Field API Name: std__SubTotalAmount__c
• Data Type: DOUBLE
• Description: The total of the work order line items' subtotals before discounts and taxes are applied.

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

• Field API Name: std__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: std__TotalPriceAmount__c
• Data Type: DOUBLE
• Description: Total Price Amount for the Work Order Item.

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

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

• Field API Name: std__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: std__WorkOrderItemPriority__c
• Data Type: TEXT
• Description: Priority associated with the Work Order.

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

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

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

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