Table 6406 FS Work Order Service

Base Application, Microsoft.Integration.FieldService

84 fields

IdNameTypeVersions
1WorkOrderServiceIdGuidnew 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[200]new in 24
35AdditionalCostDecimalnew in 24
36TransactionCurrencyIdGuidnew in 24
38ExchangeRateDecimalnew in 24
39AdditionalCost_BaseDecimalnew in 24
41BookingGuidnew in 24
42CalculatedUnitAmountDecimalnew in 24
43CalculatedUnitAmount_BaseDecimalnew in 24
44CommissionCostsDecimalnew in 24
45CommissionCosts_BaseDecimalnew in 24
46CustomerAssetGuidnew in 24
47DescriptionBlobnew in 24
48DisableEntitlementBooleannew in 24
50DiscountAmountDecimalnew in 24
51DiscountAmount_BaseDecimalnew in 24
52DiscountPercentDecimalnew in 24
53DurationIntegernew in 24
54DurationToBillIntegernew in 24
56EstimateCalculatedUnitAmountDecimalnew in 24
57EstimateCalculatedUnitAmount_BaseDecimalnew in 24
58EstimateDiscountAmountDecimalnew in 24
59EstimateDiscountAmount_BaseDecimalnew in 24
60EstimateDiscountPercentDecimalnew in 24
61EstimateDurationIntegernew in 24
62EstimateSubtotalDecimalnew in 24
63EstimateSubtotal_BaseDecimalnew in 24
64EstimateTotalAmountDecimalnew in 24
65EstimateTotalAmount_BaseDecimalnew in 24
66EstimateTotalCostDecimalnew in 24
67EstimateTotalCost_BaseDecimalnew in 24
68EstimateUnitAmountDecimalnew in 24
69EtimateUnitAmount_BaseDecimalnew in 24
70EstimateUnitCostDecimalnew in 24
71EstimateUnitCost_BaseDecimalnew in 24
72InternalDescriptionBlobnew in 24
73InternalFlagsBlobnew in 24
74LineOrderIntegernew in 24
75LineStatusOptionnew in 24
77MinimumChargeAmountDecimalnew in 24
78MinimumChargeAmount_BaseDecimalnew in 24
79MinimumChargeDurationIntegernew in 24
80PriceListGuidnew in 24
81ServiceGuidnew in 24
82SubtotalDecimalnew in 24
83Subtotal_BaseDecimalnew in 24
84TaxableBooleannew in 24
86TotalAmountDecimalnew in 24
87TotalAmount_BaseDecimalnew in 24
88TotalCostDecimalnew in 24
89TotalCost_BaseDecimalnew in 24
90UnitGuidnew in 24
91UnitAmountDecimalnew in 24
92UnitAmount_BaseDecimalnew in 24
93UnitCostDecimalnew in 24
94UnitCost_BaseDecimalnew in 24
95WorkOrderGuidnew in 24
96WorkOrderIncidentGuidnew in 24
97BookingNameText[100]new in 24
100CustomerAssetNameText[100]new in 24
101WorkOrderNameText[100]new in 24
102WorkOrderIncidentNameText[100]new in 24
106CompanyIdGuidnew in 24
107ProjectTaskGuidnew in 24
108WorkOrderStatusOptionnew in 24
112DurationConsumedIntegernew in 24
113DurationInvoicedIntegernew in 24