Table 6400 FS Work Order

Base Application, Microsoft.Integration.FieldService

src/Layers/W1/BaseApp/Integration/FieldService/FSWorkOrder.Table.al930 lines, Copyright (c) Microsoft Corporation. MIT

#if not CLEANSCHEMA28 // ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Integration.FieldService;using Microsoft.Integration.D365Sales;table 6400 "FS Work Order"{    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 = Removed;    ObsoleteTag = '28.0';    fields    {        field(1; WorkOrderId; GUID)        {            ExternalName = 'msdyn_workorderId';            ExternalType = 'Uniqueidentifier';            ExternalAccess = Insert;            Description = 'Shows the entity instances.';            Caption = 'WO Number';            DataClassification = SystemMetadata;        }        field(2; CreatedOn; Datetime)        {            ExternalName = 'createdon';            ExternalType = 'DateTime';            ExternalAccess = Read;            Description = 'Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.';            Caption = 'Created On';            DataClassification = SystemMetadata;        }        field(3; CreatedBy; GUID)        {            ExternalName = 'createdby';            ExternalType = 'Lookup';            ExternalAccess = Read;            Description = 'Unique identifier of the user who created the record.';            Caption = 'Created By';            TableRelation = "CRM Systemuser".SystemUserId;            DataClassification = SystemMetadata;        }        field(4; ModifiedOn; Datetime)        {            ExternalName = 'modifiedon';            ExternalType = 'DateTime';            ExternalAccess = Read;            Description = 'Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options.';            Caption = 'Modified On';            DataClassification = SystemMetadata;        }        field(5; ModifiedBy; GUID)        {            ExternalName = 'modifiedby';            ExternalType = 'Lookup';            ExternalAccess = Read;            Description = 'Unique identifier of the user who modified the record.';            Caption = 'Modified By';            TableRelation = "CRM Systemuser".SystemUserId;            DataClassification = SystemMetadata;        }        field(6; CreatedOnBehalfBy; GUID)        {            ExternalName = 'createdonbehalfby';            ExternalType = 'Lookup';            ExternalAccess = Read;            Description = 'Shows who created the record on behalf of another user.';            Caption = 'Created By (Delegate)';            TableRelation = "CRM Systemuser".SystemUserId;            DataClassification = SystemMetadata;        }        field(7; ModifiedOnBehalfBy; GUID)        {            ExternalName = 'modifiedonbehalfby';            ExternalType = 'Lookup';            ExternalAccess = Read;            Description = 'Shows who last updated the record on behalf of another user.';            Caption = 'Modified By (Delegate)';            TableRelation = "CRM Systemuser".SystemUserId;            DataClassification = SystemMetadata;        }        field(16; OwnerId; GUID)        {            ExternalName = 'ownerid';            ExternalType = 'Owner';            Description = 'Owner Id';            Caption = 'Owner';            DataClassification = SystemMetadata;        }        field(21; OwningBusinessUnit; GUID)        {            ExternalName = 'owningbusinessunit';            ExternalType = 'Lookup';            ExternalAccess = Read;            Description = 'Unique identifier for the business unit that owns the record';            Caption = 'Owning Business Unit';            TableRelation = "CRM Businessunit".BusinessUnitId;            DataClassification = SystemMetadata;        }        field(22; OwningUser; GUID)        {            ExternalName = 'owninguser';            ExternalType = 'Lookup';            ExternalAccess = Read;            Description = 'Unique identifier for the user that owns the record.';            Caption = 'Owning User';            TableRelation = "CRM Systemuser".SystemUserId;            DataClassification = SystemMetadata;        }        field(23; OwningTeam; GUID)        {            ExternalName = 'owningteam';            ExternalType = 'Lookup';            ExternalAccess = Read;            Description = 'Unique identifier for the team that owns the record.';            Caption = 'Owning Team';            TableRelation = "CRM Team".TeamId;            DataClassification = SystemMetadata;        }        field(25; StateCode; Option)        {            ExternalName = 'statecode';            ExternalType = 'State';            ExternalAccess = Modify;            Description = 'Status of the Work Order';            Caption = 'Status';            InitValue = " ";            OptionMembers = " ",Active,Inactive;            OptionOrdinalValues = -1, 0, 1;            DataClassification = SystemMetadata;        }        field(27; StatusCode; Option)        {            ExternalName = 'statuscode';            ExternalType = 'Status';            Description = 'Reason for the status of the Work Order';            Caption = 'Status Reason';            InitValue = " ";            OptionMembers = " ",Active,Inactive;            OptionOrdinalValues = -1, 1, 2;            DataClassification = SystemMetadata;        }        field(29; VersionNumber; BigInteger)        {            ExternalName = 'versionnumber';            ExternalType = 'BigInt';            ExternalAccess = Read;            Description = 'Version Number';            Caption = 'Version Number';            DataClassification = SystemMetadata;        }        field(30; ImportSequenceNumber; Integer)        {            ExternalName = 'importsequencenumber';            ExternalType = 'Integer';            ExternalAccess = Insert;            Description = 'Shows the sequence number of the import that created this record.';            Caption = 'Import Sequence Number';            DataClassification = SystemMetadata;        }        field(31; OverriddenCreatedOn; Date)        {            ExternalName = 'overriddencreatedon';            ExternalType = 'DateTime';            ExternalAccess = Insert;            Description = 'Shows the date and time that the record was migrated.';            Caption = 'Record Created On';            DataClassification = SystemMetadata;        }        field(32; TimeZoneRuleVersionNumber; Integer)        {            ExternalName = 'timezoneruleversionnumber';            ExternalType = 'Integer';            Description = 'For internal use only.';            Caption = 'Time Zone Rule Version Number';            DataClassification = SystemMetadata;        }        field(33; UTCConversionTimeZoneCode; Integer)        {            ExternalName = 'utcconversiontimezonecode';            ExternalType = 'Integer';            Description = 'Shows the time zone code that was in use when the record was created.';            Caption = 'UTC Conversion Time Zone Code';            DataClassification = SystemMetadata;        }        field(34; Name; Text[100])        {            ExternalName = 'msdyn_name';            ExternalType = 'String';            Description = 'Enter the name of the custom entity.';            Caption = 'Work Order Number';            DataClassification = SystemMetadata;        }        field(35; ProcessId; GUID)        {            ExternalName = 'processid';            ExternalType = 'Uniqueidentifier';            Description = 'Shows the ID of the process associated with the entity.';            Caption = 'Process Id';            DataClassification = SystemMetadata;        }        field(36; StageId; GUID)        {            ExternalName = 'stageid';            ExternalType = 'Uniqueidentifier';            Description = 'Shows the ID of the stage where the entity is located.';            Caption = 'Stage Id';            DataClassification = SystemMetadata;        }        field(37; TraversedPath; Text[1250])        {            ExternalName = 'traversedpath';            ExternalType = 'String';            Description = 'Shows a comma-separated list of string values representing the unique identifiers of stages in a business process flow instance in the order that they occur.';            Caption = 'Traversed Path';            DataClassification = SystemMetadata;        }        field(38; Address1; Text[250])        {            ExternalName = 'msdyn_address1';            ExternalType = 'String';            Caption = 'Street 1';            DataClassification = SystemMetadata;        }        field(39; Address2; Text[250])        {            ExternalName = 'msdyn_address2';            ExternalType = 'String';            Caption = 'Street 2';            DataClassification = SystemMetadata;        }        field(40; Address3; Text[250])        {            ExternalName = 'msdyn_address3';            ExternalType = 'String';            Caption = 'Street 3';            DataClassification = SystemMetadata;        }        field(41; AddressName; Text[250])        {            ExternalName = 'msdyn_addressname';            ExternalType = 'String';            Caption = 'Address Name';            DataClassification = SystemMetadata;        }        field(43; AutoNumbering; Text[100])        {            ExternalName = 'msdyn_autonumbering';            ExternalType = 'String';            Description = 'Internal field used to generate the next name upon entity creation. It is optionally copied to the msdyn_name field.';            Caption = 'Auto-Numbering';            DataClassification = SystemMetadata;        }        field(44; BillingAccount; GUID)        {            ExternalName = 'msdyn_billingaccount';            ExternalType = 'Lookup';            Description = 'Account to be billed. If a billing account has been set on service account it will be populated by default. Otherwise, the billing account will be the same as the service account.';            Caption = 'Billing Account';            TableRelation = "CRM Account".AccountId;            DataClassification = SystemMetadata;        }        field(45; BookingSummary; BLOB)        {            ExternalName = 'msdyn_bookingsummary';            ExternalType = 'Memo';            Description = 'For internal use only.';            Caption = 'Booking Summary';            Subtype = Memo;            DataClassification = SystemMetadata;        }        field(46; ChildIndex; Integer)        {            ExternalName = 'msdyn_childindex';            ExternalType = 'Integer';            Caption = 'Child Index';            DataClassification = SystemMetadata;        }        field(47; City; Text[80])        {            ExternalName = 'msdyn_city';            ExternalType = 'String';            Caption = 'City';            DataClassification = SystemMetadata;        }        field(48; ClosedBy; GUID)        {            ExternalName = 'msdyn_closedby';            ExternalType = 'Lookup';            Description = 'The user that last closed this work order';            Caption = 'Closed By';            TableRelation = "CRM Systemuser".SystemUserId;            DataClassification = SystemMetadata;        }        field(49; Country; Text[80])        {            ExternalName = 'msdyn_country';            ExternalType = 'String';            Caption = 'Country/Region';            DataClassification = SystemMetadata;        }        field(50; CustomerAsset; GUID)        {            ExternalName = 'msdyn_customerasset';            ExternalType = 'Lookup';            Description = 'Customer Asset related to this incident reported';            Caption = 'Primary Incident Customer Asset';            TableRelation = "FS Customer Asset".CustomerAssetId;            DataClassification = SystemMetadata;        }        field(51; DateWindowEnd; Date)        {            ExternalName = 'msdyn_datewindowend';            ExternalType = 'DateTime';            Caption = 'Date Window End';            DataClassification = SystemMetadata;        }        field(52; DateWindowStart; Date)        {            ExternalName = 'msdyn_datewindowstart';            ExternalType = 'DateTime';            Caption = 'Date Window Start';            DataClassification = SystemMetadata;        }        field(53; EstimateSubtotalAmount; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_estimatesubtotalamount';            ExternalType = 'Money';            Description = 'Enter the summary of total estimated billing amount for this work order';            Caption = 'Estimate Subtotal Amount';            DataClassification = SystemMetadata;        }        field(54; TransactionCurrencyId; GUID)        {            ExternalName = 'transactioncurrencyid';            ExternalType = 'Lookup';            Description = 'Unique identifier of the currency associated with the entity.';            Caption = 'Currency';            TableRelation = "CRM Transactioncurrency".TransactionCurrencyId;            DataClassification = SystemMetadata;        }        field(56; ExchangeRate; Decimal)        {            AutoFormatType = 0;            ExternalName = 'exchangerate';            ExternalType = 'Decimal';            ExternalAccess = Read;            Description = 'Shows the exchange rate for the currency associated with the entity with respect to the base currency.';            Caption = 'Exchange Rate';            DataClassification = SystemMetadata;        }        field(57; EstimateSubtotalAmount_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_estimatesubtotalamount_base';            ExternalType = 'Money';            ExternalAccess = Read;            Description = 'Shows the value of the estimate subtotal amount in the base currency.';            Caption = 'Estimate Subtotal Amount (Base)';            DataClassification = SystemMetadata;        }        field(58; FollowUpNote; BLOB)        {            ExternalName = 'msdyn_followupnote';            ExternalType = 'Memo';            Description = 'Indicate the details of the follow up work';            Caption = 'Follow Up Note (Deprecated)';            Subtype = Memo;            DataClassification = SystemMetadata;        }        field(59; FollowUpRequired; Boolean)        {            ExternalName = 'msdyn_followuprequired';            ExternalType = 'Boolean';            Description = 'Allows indication if follow up work is required for a work order.';            Caption = 'Follow Up Required (Deprecated)';            DataClassification = SystemMetadata;        }        field(61; Instructions; BLOB)        {            ExternalName = 'msdyn_instructions';            ExternalType = 'Memo';            Description = 'Shows instructions for booked resources. By default, this information is taken from the work order instructions field on the service account.';            Caption = 'Instructions';            Subtype = Memo;            DataClassification = SystemMetadata;        }        field(62; InternalFlags; BLOB)        {            ExternalName = 'msdyn_internalflags';            ExternalType = 'Memo';            Description = 'For internal use only.';            Caption = 'Internal Flags';            Subtype = Memo;            DataClassification = SystemMetadata;        }        field(63; IsFollowUp; Boolean)        {            ExternalName = 'msdyn_isfollowup';            ExternalType = 'Boolean';            Caption = 'Is FollowUp (Deprecated)';            DataClassification = SystemMetadata;        }        field(65; IsMobile; Boolean)        {            ExternalName = 'msdyn_ismobile';            ExternalType = 'Boolean';            Caption = 'Is Mobile';            DataClassification = SystemMetadata;        }        field(67; Latitude; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_latitude';            ExternalType = 'Double';            Description = '';            Caption = 'Latitude';            DataClassification = SystemMetadata;        }        field(68; Longitude; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_longitude';            ExternalType = 'Double';            Description = '';            Caption = 'Longitude';            DataClassification = SystemMetadata;        }        field(69; MapControl; Text[100])        {            ExternalName = 'msdyn_mapcontrol';            ExternalType = 'String';            ExternalAccess = Read;            Description = '';            Caption = 'This field should only be used to load the custom map control';            DataClassification = SystemMetadata;        }        field(70; OpportunityId; GUID)        {            ExternalName = 'msdyn_opportunityid';            ExternalType = 'Lookup';            Description = 'Unique identifier for Opportunity associated with Work Order.';            Caption = 'Opportunity';            TableRelation = "CRM Opportunity".OpportunityId;            DataClassification = SystemMetadata;        }        field(71; ParentWorkOrder; GUID)        {            ExternalName = 'msdyn_parentworkorder';            ExternalType = 'Lookup';            Description = 'Unique identifier for Work Order associated with Work Order.';            Caption = 'Parent Work Order';            DataClassification = SystemMetadata;        }        field(72; PostalCode; Text[20])        {            ExternalName = 'msdyn_postalcode';            ExternalType = 'String';            Caption = 'Postal Code';            DataClassification = SystemMetadata;        }        field(73; PreferredResource; GUID)        {            ExternalName = 'msdyn_preferredresource';            ExternalType = 'Lookup';            Description = 'The customer Preferred Resource to work on this job. Should be taken into consideration while scheduling resources';            Caption = 'Preferred Resource (Deprecated)';            TableRelation = "FS Bookable Resource".BookableResourceId;            DataClassification = SystemMetadata;        }        field(74; PriceList; GUID)        {            ExternalName = 'msdyn_pricelist';            ExternalType = 'Lookup';            Description = 'Price List that controls pricing for products / services added to this work order. By default the system will use the Price List specified on the account';            Caption = 'Price List';            TableRelation = "CRM Pricelevel".PriceLevelId;            DataClassification = SystemMetadata;        }        field(75; PrimaryIncidentDescription; BLOB)        {            ExternalName = 'msdyn_primaryincidentdescription';            ExternalType = 'Memo';            Description = 'Incident description';            Caption = 'Primary Incident Description';            Subtype = Memo;            DataClassification = SystemMetadata;        }        field(76; PrimaryIncidentEstimatedDuration; Integer)        {            ExternalName = 'msdyn_primaryincidentestimatedduration';            ExternalType = 'Integer';            Description = 'Shows the time estimated to resolve this incident.';            Caption = 'Primary Incident Estimated Duration';            DataClassification = SystemMetadata;        }        field(79; ReportedByContact; GUID)        {            ExternalName = 'msdyn_reportedbycontact';            ExternalType = 'Lookup';            Description = 'The contact that reported this Work Order';            Caption = 'Reported By Contact';            TableRelation = "CRM Contact".ContactId;            DataClassification = SystemMetadata;        }        field(80; ServiceAccount; GUID)        {            ExternalName = 'msdyn_serviceaccount';            ExternalType = 'Lookup';            Description = 'Account to be serviced';            Caption = 'Service Account';            TableRelation = "CRM Account".AccountId;            DataClassification = SystemMetadata;        }        field(81; ServiceRequest; GUID)        {            ExternalName = 'msdyn_servicerequest';            ExternalType = 'Lookup';            Description = 'Case of which this work order originates from';            Caption = 'Case';            TableRelation = "CRM Incident".IncidentId;            DataClassification = SystemMetadata;        }        field(83; StateOrProvince; Text[50])        {            ExternalName = 'msdyn_stateorprovince';            ExternalType = 'String';            Caption = 'State Or Province';            DataClassification = SystemMetadata;        }        field(84; SubStatus; GUID)        {            ExternalName = 'msdyn_substatus';            ExternalType = 'Lookup';            Description = 'Work Order subsstatus';            Caption = 'Substatus';            TableRelation = "FS Work Order Substatus".WorkOrderSubstatusId;            DataClassification = SystemMetadata;        }        field(85; SubtotalAmount; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_subtotalamount';            ExternalType = 'Money';            Description = 'Enter the summary of subtotal billing amount excluding tax for this work order.';            Caption = 'Subtotal Amount';            DataClassification = SystemMetadata;        }        field(86; SubTotalAmount_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_subtotalamount_base';            ExternalType = 'Money';            ExternalAccess = Read;            Description = 'Shows the value of the subtotal amount in the base currency.';            Caption = 'Subtotal Amount (Base)';            DataClassification = SystemMetadata;        }        field(87; SupportContact; GUID)        {            ExternalName = 'msdyn_supportcontact';            ExternalType = 'Lookup';            Description = 'A support contact can be specified so that the individual working on the work order has someone to contact for assistance.';            Caption = 'Support Contact';            TableRelation = "FS Bookable Resource".BookableResourceId;            DataClassification = SystemMetadata;        }        field(88; SystemStatus; Option)        {            ExternalName = 'msdyn_systemstatus';            ExternalType = 'Picklist';            Description = 'Tracks the current system status.';            Caption = 'System Status';            InitValue = " ";            OptionMembers = " ",Unscheduled,Scheduled,InProgress,Completed,Posted,Canceled;            OptionOrdinalValues = -1, 690970000, 690970001, 690970002, 690970003, 690970004, 690970005;            DataClassification = SystemMetadata;        }        field(90; Taxable; Boolean)        {            ExternalName = 'msdyn_taxable';            ExternalType = 'Boolean';            Description = 'Shows whether sales tax is to be charged for this work order.';            Caption = 'Taxable';            DataClassification = SystemMetadata;        }        field(93; TimeClosed; Datetime)        {            ExternalName = 'msdyn_timeclosed';            ExternalType = 'DateTime';            Description = 'Enter the time this work order was last closed.';            Caption = 'Closed On';            DataClassification = SystemMetadata;        }        field(94; TimeFromPromised; Datetime)        {            ExternalName = 'msdyn_timefrompromised';            ExternalType = 'DateTime';            Description = 'Enter the starting range of the time promised to the account that incidents will be resolved.';            Caption = 'Time From Promised';            DataClassification = SystemMetadata;        }        field(97; TimeToPromised; Datetime)        {            ExternalName = 'msdyn_timetopromised';            ExternalType = 'DateTime';            Description = 'Enter the ending range of the time promised to the account that incidents will be resolved.';            Caption = 'Time To Promised';            DataClassification = SystemMetadata;        }        field(98; TimeWindowEnd; Datetime)        {            ExternalName = 'msdyn_timewindowend';            ExternalType = 'DateTime';            Caption = 'Time Window End';            DataClassification = SystemMetadata;        }        field(99; TimeWindowStart; Datetime)        {            ExternalName = 'msdyn_timewindowstart';            ExternalType = 'DateTime';            Caption = 'Time Window Start';            DataClassification = SystemMetadata;        }        field(100; TotalAmount; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_totalamount';            ExternalType = 'Money';            Description = 'Enter the summary of total billing amount for this work order.';            Caption = 'Total Amount';            DataClassification = SystemMetadata;        }        field(101; TotalAmount_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_totalamount_base';            ExternalType = 'Money';            ExternalAccess = Read;            Description = 'Shows the value of the total amount in the base currency.';            Caption = 'Total Amount (Base)';            DataClassification = SystemMetadata;        }        field(102; TotalSalesTax; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_totalsalestax';            ExternalType = 'Money';            Description = 'Enter the summary of total sales tax charged for this work order.';            Caption = 'Total Sales Tax';            DataClassification = SystemMetadata;        }        field(103; TotalSalesTax_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_totalsalestax_base';            ExternalType = 'Money';            ExternalAccess = Read;            Description = 'Shows the value of the total sales tax in the base currency.';            Caption = 'Total Sales Tax (Base)';            DataClassification = SystemMetadata;        }        field(105; WorkLocation; Option)        {            ExternalName = 'msdyn_worklocation';            ExternalType = 'Picklist';            Caption = 'Work Location';            InitValue = Onsite;            OptionMembers = Onsite,Facility,LocationAgnostic;            OptionOrdinalValues = 690970000, 690970001, 690970002;            DataClassification = SystemMetadata;        }        field(109; WorkOrderSummary; BLOB)        {            ExternalName = 'msdyn_workordersummary';            ExternalType = 'Memo';            Description = 'Type a summary description of the job.';            Caption = 'Work Order Summary';            Subtype = Memo;            DataClassification = SystemMetadata;        }        field(110; WorkOrderType; GUID)        {            ExternalName = 'msdyn_workordertype';            ExternalType = 'Lookup';            Description = 'Work Order Type';            Caption = 'Work Order Type';            TableRelation = "FS Work Order Type".WorkOrderTypeId;            DataClassification = SystemMetadata;        }        field(115; PreferredResourceName; Text[100])        {            FieldClass = FlowField;            CalcFormula = lookup("FS Bookable Resource".Name where(BookableResourceId = field(PreferredResource)));            ExternalName = 'msdyn_preferredresourcename';            ExternalType = 'String';            ExternalAccess = Read;        }        field(116; SupportContactName; Text[100])        {            FieldClass = FlowField;            CalcFormula = lookup("FS Bookable Resource".Name where(BookableResourceId = field(SupportContact)));            ExternalName = 'msdyn_supportcontactname';            ExternalType = 'String';            ExternalAccess = Read;        }        field(121; CustomerAssetName; Text[100])        {            FieldClass = FlowField;            CalcFormula = lookup("FS Customer Asset".Name where(CustomerAssetId = field(CustomerAsset)));            ExternalName = 'msdyn_customerassetname';            ExternalType = 'String';            ExternalAccess = Read;        }        field(128; ParentWorkOrderName; Text[100])        {            FieldClass = FlowField;            ExternalName = 'msdyn_parentworkordername';            ExternalType = 'String';            ExternalAccess = Read;        }        field(129; SubStatusName; Text[100])        {            FieldClass = FlowField;            CalcFormula = lookup("FS Work Order Substatus".Name where(WorkOrderSubstatusId = field(SubStatus)));            ExternalName = 'msdyn_substatusname';            ExternalType = 'String';            ExternalAccess = Read;        }        field(130; WorkOrderTypeName; Text[100])        {            FieldClass = FlowField;            CalcFormula = lookup("FS Work Order Type".Name where(WorkOrderTypeId = field(WorkOrderType)));            ExternalName = 'msdyn_workordertypename';            ExternalType = 'String';            ExternalAccess = Read;        }        field(138; completedon; Datetime)        {            ExternalName = 'msdyn_completedon';            ExternalType = 'DateTime';            Description = 'When Bookings are used on a Work Order, this field is auto-populated based on the latest End Time from the related Bookings. Otherwise, this field is populated based on the change of System Status.';            Caption = 'Completed On';            DataClassification = SystemMetadata;        }        field(139; CostNTEPercent; Integer)        {            ExternalName = 'msdyn_costntepercent';            ExternalType = 'Integer';            Description = 'Indicates the percentage proximity or overage of the work order cost based on applied Cost not-to-exceed (rounded up to the nearest whole number).';            Caption = 'Cost not-to-exceed';            DataClassification = SystemMetadata;        }        field(140; firstarrivedon; Datetime)        {            ExternalName = 'msdyn_firstarrivedon';            ExternalType = 'DateTime';            Description = 'When Bookings are used on a Work Order, this field is auto-populated based on the earliest Actual Arrival Time from the related Bookings.';            Caption = 'First Arrived On';            DataClassification = SystemMetadata;        }        field(142; NotToExceedCostAmount; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_nottoexceedcostamount';            ExternalType = 'Money';            Description = 'The value of not-to-exceed cost for the work order in base currency.';            Caption = 'Cost not-to-exceed';            DataClassification = SystemMetadata;        }        field(143; NotToExceedCostAmount_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_nottoexceedcostamount_base';            ExternalType = 'Money';            ExternalAccess = Read;            Description = 'Value of the Cost not-to-exceed in base currency.';            Caption = 'Cost not-to-exceed (Base)';            DataClassification = SystemMetadata;        }        field(144; NotToExceedPriceAmount; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_nottoexceedpriceamount';            ExternalType = 'Money';            Description = 'The value of not-to-exceed price for the work order in base currency.';            Caption = 'Price not-to-exceed';            DataClassification = SystemMetadata;        }        field(145; NotToExceedPriceAmount_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_nottoexceedpriceamount_base';            ExternalType = 'Money';            ExternalAccess = Read;            Description = 'Value of the Price not-to-exceed in base currency.';            Caption = 'Price not-to-exceed (Base)';            DataClassification = SystemMetadata;        }        field(146; PhoneNumber; Text[250])        {            ExternalName = 'msdyn_phoneNumber';            ExternalType = 'String';            Caption = 'Customer Phone Number';            DataClassification = SystemMetadata;        }        field(147; PriceNTEPercent; Integer)        {            ExternalName = 'msdyn_pricentepercent';            ExternalType = 'Integer';            Description = 'Indicates the percentage proximity or overage of the work order price based on applied Price not-to-exceed (rounded up to the nearest whole number).';            Caption = 'Price not-to-exceed';            DataClassification = SystemMetadata;        }        field(149; ProductsServicesCost; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_productsservicescost';            ExternalType = 'Money';            Description = 'The total actual cost of the products and services';            Caption = 'Total Cost';            DataClassification = SystemMetadata;        }        field(150; ProductsServicesCost_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_productsservicescost_base';            ExternalType = 'Money';            Description = 'Value of the Total Cost in base currency.';            Caption = 'Total Cost (Base)';            DataClassification = SystemMetadata;        }        field(151; ProductsServicesEstimatedCost; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_productsservicesestimatedcost';            ExternalType = 'Money';            Description = 'The total estimated cost of the products and services';            Caption = 'Total Estimated Cost';            DataClassification = SystemMetadata;        }        field(152; ProductsServicesEstimatedCost_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_productsservicesestimatedcost_base';            ExternalType = 'Money';            Description = 'Value of the Total Estimated Cost in base currency.';            Caption = 'Total Estimated Cost (Base)';            DataClassification = SystemMetadata;        }        field(153; TotalEstimatedAfterTaxPrice; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_totalestimatedaftertaxprice';            ExternalType = 'Money';            Description = 'The estimated price after adding tax to the subtotal';            Caption = 'Total Estimated After Tax Price';            DataClassification = SystemMetadata;        }        field(154; TotalEstimatedAfterTaxPrice_Base; Decimal)        {            AutoFormatType = 0;            ExternalName = 'msdyn_totalestimatedaftertaxprice_base';            ExternalType = 'Money';            Description = 'Value of the Total Estimated After Tax Price in base currency.';            Caption = 'Total Estimated After Tax Price (Base)';            DataClassification = SystemMetadata;        }        field(155; TotalEstimatedDuration; Integer)        {            ExternalName = 'msdyn_totalestimatedduration';            ExternalType = 'Integer';            Description = 'Calculated from the estimated duration of Work Order Incidents and Work Order Service Tasks not related to a Work Order Incident on the Work Order. Intended to be read-only.';            Caption = 'Total Estimated Duration';            DataClassification = SystemMetadata;        }        field(162; DisplayAddress; Text[2048])        {            ExternalName = 'msdyn_displayaddress';            ExternalType = 'String';            ExternalAccess = Read;            Description = 'Combined address field suitable for display';            Caption = 'Display Address';            DataClassification = SystemMetadata;        }        field(163; ProjectTask; GUID)        {            ExternalName = 'bcbi_businesscentralprojecttask';            ExternalType = 'Lookup';            Description = 'Business Central Project Task';            Caption = 'Business Central Project Task';            TableRelation = "FS Project Task".ProjectTaskId;            DataClassification = SystemMetadata;        }        field(164; CompanyId; GUID)        {            ExternalName = 'bcbi_company';            ExternalType = 'Lookup';            Description = 'Business Central Company';            Caption = 'Company Id';            TableRelation = "CDS Company".CompanyId;            DataClassification = SystemMetadata;        }    }    keys    {        key(PK; WorkOrderId)        {            Clustered = true;        }        key(Name; Name)        {        }    }    fieldgroups    {        fieldgroup(DropDown; Name)        {        }    }}#endif