Table 6400 FS Work Order

Base Application, Microsoft.Integration.FieldService

103 fields

IdNameTypeVersions
1WorkOrderIdGuidnew in 24
2CreatedOnDateTimenew in 24
3CreatedByGuidnew in 24
4ModifiedOnDateTimenew in 24
5ModifiedByGuidnew in 24
6CreatedOnBehalfByGuidnew in 24
7ModifiedOnBehalfByGuidnew in 24
16OwnerIdGuidnew in 24
21OwningBusinessUnitGuidnew in 24
22OwningUserGuidnew in 24
23OwningTeamGuidnew in 24
25StateCodeOptionnew in 24
27StatusCodeOptionnew in 24
29VersionNumberBigIntegernew in 24
30ImportSequenceNumberIntegernew in 24
31OverriddenCreatedOnDatenew in 24
32TimeZoneRuleVersionNumberIntegernew in 24
33UTCConversionTimeZoneCodeIntegernew in 24
34NameText[100]new in 24
35ProcessIdGuidnew in 24
36StageIdGuidnew in 24
37TraversedPathText[1250]new in 24
38Address1Text[250]new in 24
39Address2Text[250]new in 24
40Address3Text[250]new in 24
41AddressNameText[250]new in 24
43AutoNumberingText[100]new in 24
44BillingAccountGuidnew in 24
45BookingSummaryBlobnew in 24
46ChildIndexIntegernew in 24
47CityText[80]new in 24
48ClosedByGuidnew in 24
49CountryText[80]new in 24
50CustomerAssetGuidnew in 24
51DateWindowEndDatenew in 24
52DateWindowStartDatenew in 24
53EstimateSubtotalAmountDecimalnew in 24
54TransactionCurrencyIdGuidnew in 24
56ExchangeRateDecimalnew in 24
57EstimateSubtotalAmount_BaseDecimalnew in 24
58FollowUpNoteBlobnew in 24
59FollowUpRequiredBooleannew in 24
61InstructionsBlobnew in 24
62InternalFlagsBlobnew in 24
63IsFollowUpBooleannew in 24
65IsMobileBooleannew in 24
67LatitudeDecimalnew in 24
68LongitudeDecimalnew in 24
69MapControlText[100]new in 24
70OpportunityIdGuidnew in 24
71ParentWorkOrderGuidnew in 24
72PostalCodeText[20]new in 24
73PreferredResourceGuidnew in 24
74PriceListGuidnew in 24
75PrimaryIncidentDescriptionBlobnew in 24
76PrimaryIncidentEstimatedDurationIntegernew in 24
79ReportedByContactGuidnew in 24
80ServiceAccountGuidnew in 24
81ServiceRequestGuidnew in 24
83StateOrProvinceText[50]new in 24
84SubStatusGuidnew in 24
85SubtotalAmountDecimalnew in 24
86SubTotalAmount_BaseDecimalnew in 24
87SupportContactGuidnew in 24
88SystemStatusOptionnew in 24
90TaxableBooleannew in 24
93TimeClosedDateTimenew in 24
94TimeFromPromisedDateTimenew in 24
97TimeToPromisedDateTimenew in 24
98TimeWindowEndDateTimenew in 24
99TimeWindowStartDateTimenew in 24
100TotalAmountDecimalnew in 24
101TotalAmount_BaseDecimalnew in 24
102TotalSalesTaxDecimalnew in 24
103TotalSalesTax_BaseDecimalnew in 24
105WorkLocationOptionnew in 24
109WorkOrderSummaryBlobnew in 24
110WorkOrderTypeGuidnew in 24
115PreferredResourceNameText[100]new in 24
116SupportContactNameText[100]new in 24
121CustomerAssetNameText[100]new in 24
128ParentWorkOrderNameText[100]new in 24
129SubStatusNameText[100]new in 24
130WorkOrderTypeNameText[100]new in 24
138completedonDateTimenew in 24
139CostNTEPercentIntegernew in 24
140firstarrivedonDateTimenew in 24
142NotToExceedCostAmountDecimalnew in 24
143NotToExceedCostAmount_BaseDecimalnew in 24
144NotToExceedPriceAmountDecimalnew in 24
145NotToExceedPriceAmount_BaseDecimalnew in 24
146PhoneNumberText[250]new in 24
147PriceNTEPercentIntegernew in 24
149ProductsServicesCostDecimalnew in 24
150ProductsServicesCost_BaseDecimalnew in 24
151ProductsServicesEstimatedCostDecimalnew in 24
152ProductsServicesEstimatedCost_BaseDecimalnew in 24
153TotalEstimatedAfterTaxPriceDecimalnew in 24
154TotalEstimatedAfterTaxPrice_BaseDecimalnew in 24
155TotalEstimatedDurationIntegernew in 24
162DisplayAddressText[2048]new in 24
163ProjectTaskGuidnew in 24
164CompanyIdGuidnew in 24