Table 6400 FS Work Order
- App
- Base Application
- Namespace
- Microsoft.Integration.FieldService
- Versions
- 24-28
- Obsolete
- Removed 28.0, seen from 24. Field Service is moved to Field Service Integration app.
Versions171819202122232425262728
Source29
Source in 29
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