Table "FS Work Order"
ID 6400
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_workorder |
| TableType | CRM |
| Description | Work orders store all information about the job performed for an account. Stores incident details, resource, expenses, tasks, communications, billing and more |
| DataClassification | SystemMetadata |
| ObsoleteReason | Field Service is moved to Field Service Integration app. |
| ObsoleteState | Pending |
| ObsoleteTag | 25.0 |
Fields
| Name | Type | Description |
|---|---|---|
| WorkOrderId | 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[100] | |
| ProcessId | Guid | |
| StageId | Guid | |
| TraversedPath | Text[1250] | |
| Address1 | Text[250] | |
| Address2 | Text[250] | |
| Address3 | Text[250] | |
| AddressName | Text[250] | |
| AutoNumbering | Text[100] | |
| BillingAccount | Guid | |
| BookingSummary | Blob | |
| ChildIndex | Integer | |
| City | Text[80] | |
| ClosedBy | Guid | |
| Country | Text[80] | |
| CustomerAsset | Guid | |
| DateWindowEnd | Date | |
| DateWindowStart | Date | |
| EstimateSubtotalAmount | Decimal | |
| TransactionCurrencyId | Guid | |
| ExchangeRate | Decimal | |
| EstimateSubtotalAmount_Base | Decimal | |
| FollowUpNote | Blob | |
| FollowUpRequired | Boolean | |
| Instructions | Blob | |
| InternalFlags | Blob | |
| IsFollowUp | Boolean | |
| IsMobile | Boolean | |
| Latitude | Decimal | |
| Longitude | Decimal | |
| MapControl | Text[100] | |
| OpportunityId | Guid | |
| ParentWorkOrder | Guid | |
| PostalCode | Text[20] | |
| PreferredResource | Guid | |
| PriceList | Guid | |
| PrimaryIncidentDescription | Blob | |
| PrimaryIncidentEstimatedDuration | Integer | |
| ReportedByContact | Guid | |
| ServiceAccount | Guid | |
| ServiceRequest | Guid | |
| StateOrProvince | Text[50] | |
| SubStatus | Guid | |
| SubtotalAmount | Decimal | |
| SubTotalAmount_Base | Decimal | |
| SupportContact | Guid | |
| SystemStatus | Option | |
| Taxable | Boolean | |
| TimeClosed | DateTime | |
| TimeFromPromised | DateTime | |
| TimeToPromised | DateTime | |
| TimeWindowEnd | DateTime | |
| TimeWindowStart | DateTime | |
| TotalAmount | Decimal | |
| TotalAmount_Base | Decimal | |
| TotalSalesTax | Decimal | |
| TotalSalesTax_Base | Decimal | |
| WorkLocation | Option | |
| WorkOrderSummary | Blob | |
| WorkOrderType | Guid | |
| PreferredResourceName | Text[100] | |
| SupportContactName | Text[100] | |
| CustomerAssetName | Text[100] | |
| ParentWorkOrderName | Text[100] | |
| SubStatusName | Text[100] | |
| WorkOrderTypeName | Text[100] | |
| completedon | DateTime | |
| CostNTEPercent | Integer | |
| firstarrivedon | DateTime | |
| NotToExceedCostAmount | Decimal | |
| NotToExceedCostAmount_Base | Decimal | |
| NotToExceedPriceAmount | Decimal | |
| NotToExceedPriceAmount_Base | Decimal | |
| PhoneNumber | Text[250] | |
| PriceNTEPercent | Integer | |
| ProductsServicesCost | Decimal | |
| ProductsServicesCost_Base | Decimal | |
| ProductsServicesEstimatedCost | Decimal | |
| ProductsServicesEstimatedCost_Base | Decimal | |
| TotalEstimatedAfterTaxPrice | Decimal | |
| TotalEstimatedAfterTaxPrice_Base | Decimal | |
| TotalEstimatedDuration | Integer | |
| DisplayAddress | Text[2048] | |
| ProjectTask | Guid | |
| CompanyId | Guid | |
| SystemId | Guid | |
| SystemRowVersion | BigInteger |