Table "FS Work Order Service"

ID 6406
Namespace: Microsoft.Integration.FieldService

Obsolete

This element will become obsolete from version 25.0. Field Service is moved to Field Service Integration app.

Properties

Name Value
ExternalName msdyn_workorderservice
TableType CRM
Description Record all services proposed and performed for work order
DataClassification SystemMetadata
ObsoleteReason Field Service is moved to Field Service Integration app.
ObsoleteState Pending
ObsoleteTag 25.0

Fields

Name Type Description
WorkOrderServiceId Guid
CreatedOn DateTime
CreatedBy Guid
ModifiedOn DateTime
ModifiedBy Guid
CreatedOnBehalfBy Guid
ModifiedOnBehalfBy Guid
OwnerId Guid
OwningBusinessUnit Guid
OwningUser Guid
OwningTeam Guid
StateCode Option
StatusCode Option
VersionNumber BigInteger
ImportSequenceNumber Integer
OverriddenCreatedOn Date
TimeZoneRuleVersionNumber Integer
UTCConversionTimeZoneCode Integer
Name Text[200]
AdditionalCost Decimal
TransactionCurrencyId Guid
ExchangeRate Decimal
AdditionalCost_Base Decimal
Booking Guid
CalculatedUnitAmount Decimal
CalculatedUnitAmount_Base Decimal
CommissionCosts Decimal
CommissionCosts_Base Decimal
CustomerAsset Guid
Description Blob
DisableEntitlement Boolean
DiscountAmount Decimal
DiscountAmount_Base Decimal
DiscountPercent Decimal
Duration Integer
DurationToBill Integer
EstimateCalculatedUnitAmount Decimal
EstimateCalculatedUnitAmount_Base Decimal
EstimateDiscountAmount Decimal
EstimateDiscountAmount_Base Decimal
EstimateDiscountPercent Decimal
EstimateDuration Integer
EstimateSubtotal Decimal
EstimateSubtotal_Base Decimal
EstimateTotalAmount Decimal
EstimateTotalAmount_Base Decimal
EstimateTotalCost Decimal
EstimateTotalCost_Base Decimal
EstimateUnitAmount Decimal
EtimateUnitAmount_Base Decimal
EstimateUnitCost Decimal
EstimateUnitCost_Base Decimal
InternalDescription Blob
InternalFlags Blob
LineOrder Integer
LineStatus Option
MinimumChargeAmount Decimal
MinimumChargeAmount_Base Decimal
MinimumChargeDuration Integer
PriceList Guid
Service Guid
Subtotal Decimal
Subtotal_Base Decimal
Taxable Boolean
TotalAmount Decimal
TotalAmount_Base Decimal
TotalCost Decimal
TotalCost_Base Decimal
Unit Guid
UnitAmount Decimal
UnitAmount_Base Decimal
UnitCost Decimal
UnitCost_Base Decimal
WorkOrder Guid
WorkOrderIncident Guid
BookingName Text[100]
CustomerAssetName Text[100]
WorkOrderName Text[100]
WorkOrderIncidentName Text[100]
CompanyId Guid
ProjectTask Guid
WorkOrderStatus Option
DurationConsumed Integer
DurationInvoiced Integer
SystemId Guid
SystemRowVersion BigInteger

See also