Table 5349 CRM Incident
- App
- Base Application
- Namespace
- Microsoft.Integration.D365Sales
- Versions
- 17-28
Versions171819202122232425262728
Source29
Source in 29
src/Layers/W1/BaseApp/Integration/D365Sales/CRMIncident.Table.al789 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------
// 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.D365Sales;
table 5349 "CRM Incident"
{
// Dynamics CRM Version: 7.1.0.2040
Caption = 'CRM Incident';
Description = 'Service request case associated with a contract.';
ExternalName = 'incident';
TableType = CRM;
DataClassification = CustomerContent;
fields
{
field(1; IncidentId; Guid)
{
Caption = 'Case';
Description = 'Unique identifier of the case.';
ExternalAccess = Insert;
ExternalName = 'incidentid';
ExternalType = 'Uniqueidentifier';
}
field(2; OwningBusinessUnit; Guid)
{
Caption = 'Owning Business Unit';
Description = 'Unique identifier of the business unit that owns the case.';
ExternalAccess = Read;
ExternalName = 'owningbusinessunit';
ExternalType = 'Lookup';
TableRelation = "CRM Businessunit".BusinessUnitId;
}
field(3; ContractId; Guid)
{
Caption = 'Contract';
Description = 'Choose the service contract that the case should be logged under to make sure the customer is eligible for support services.';
ExternalName = 'contractid';
ExternalType = 'Lookup';
TableRelation = "CRM Contract".ContractId;
}
field(4; OwningUser; Guid)
{
Caption = 'Owning User';
Description = 'Unique identifier of the user who owns the case.';
ExternalAccess = Read;
ExternalName = 'owninguser';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(5; ActualServiceUnits; Integer)
{
Caption = 'Actual Service Units';
Description = 'Type the number of service units that were actually required to resolve the case.';
ExternalName = 'actualserviceunits';
ExternalType = 'Integer';
MaxValue = 1000000000;
MinValue = 0;
}
field(6; CaseOriginCode; Option)
{
Caption = 'Origin';
Description = 'Select how contact about the case was originated, such as email, phone, or web, for use in reporting and analysis.';
ExternalName = 'caseorigincode';
ExternalType = 'Picklist';
InitValue = " ";
OptionCaption = ' ,Phone,Email,Web,Facebook,Twitter';
OptionOrdinalValues = -1, 1, 2, 3, 2483, 3986;
OptionMembers = " ",Phone,Email,Web,Facebook,Twitter;
}
field(7; BilledServiceUnits; Integer)
{
Caption = 'Billed Service Units';
Description = 'Type the number of service units that were billed to the customer for the case.';
ExternalName = 'billedserviceunits';
ExternalType = 'Integer';
MaxValue = 1000000000;
MinValue = 0;
}
field(8; CaseTypeCode; Option)
{
Caption = 'Case Type';
Description = 'Select the type of case to identify the incident for use in case routing and analysis.';
ExternalName = 'casetypecode';
ExternalType = 'Picklist';
InitValue = " ";
OptionCaption = ' ,Question,Problem,Request';
OptionOrdinalValues = -1, 1, 2, 3;
OptionMembers = " ",Question,Problem,Request;
}
field(9; ProductSerialNumber; Text[100])
{
Caption = 'Serial Number';
Description = 'Type the serial number of the product that is associated with this case, so that the number of cases per product can be reported.';
ExternalName = 'productserialnumber';
ExternalType = 'String';
}
field(10; Title; Text[200])
{
Caption = 'Case Title';
ToolTip = 'Specifies the name of the case.';
Description = 'Type a subject or descriptive name, such as the request, issue, or company name, to identify the case in Microsoft Dynamics CRM views.';
ExternalName = 'title';
ExternalType = 'String';
}
field(11; ProductId; Guid)
{
Caption = 'Product';
Description = 'Choose the product associated with the case to identify warranty, service, or other product issues and be able to report the number of incidents for each product.';
ExternalName = 'productid';
ExternalType = 'Lookup';
TableRelation = "CRM Product".ProductId;
}
field(12; ContractServiceLevelCode; Option)
{
Caption = 'Service Level';
Description = 'Select the service level for the case to make sure the case is handled correctly.';
ExternalName = 'contractservicelevelcode';
ExternalType = 'Picklist';
InitValue = " ";
OptionCaption = ' ,Gold,Silver,Bronze';
OptionOrdinalValues = -1, 1, 2, 3;
OptionMembers = " ",Gold,Silver,Bronze;
}
field(13; AccountId; Guid)
{
Caption = 'Account';
Description = 'Unique identifier of the account with which the case is associated.';
ExternalAccess = Read;
ExternalName = 'accountid';
ExternalType = 'Lookup';
TableRelation = "CRM Account".AccountId;
}
field(14; Description; BLOB)
{
Caption = 'Description';
Description = 'Type additional information to describe the case to assist the service team in reaching a resolution.';
ExternalName = 'description';
ExternalType = 'Memo';
SubType = Memo;
}
field(15; ContactId; Guid)
{
Caption = 'Contact';
Description = 'Unique identifier of the contact associated with the case.';
ExternalAccess = Read;
ExternalName = 'contactid';
ExternalType = 'Lookup';
TableRelation = "CRM Contact".ContactId;
}
field(16; IsDecrementing; Boolean)
{
Caption = 'Decrementing';
Description = 'For system use only.';
ExternalName = 'isdecrementing';
ExternalType = 'Boolean';
}
field(17; CreatedOn; DateTime)
{
Caption = 'Created On';
ToolTip = 'Specifies when the sales order was created.';
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 CRM options.';
ExternalAccess = Read;
ExternalName = 'createdon';
ExternalType = 'DateTime';
}
field(18; TicketNumber; Text[100])
{
Caption = 'Case Number';
ToolTip = 'Specifies the number of the case.';
Description = 'Shows the case number for customer reference and searching capabilities. This cannot be modified.';
ExternalAccess = Insert;
ExternalName = 'ticketnumber';
ExternalType = 'String';
}
field(19; PriorityCode; Option)
{
Caption = 'Priority';
Description = 'Select the priority so that preferred customers or critical issues are handled quickly.';
ExternalName = 'prioritycode';
ExternalType = 'Picklist';
InitValue = Normal;
OptionCaption = 'High,Normal,Low';
OptionOrdinalValues = 1, 2, 3;
OptionMembers = High,Normal,Low;
}
field(20; CustomerSatisfactionCode; Option)
{
Caption = 'Satisfaction';
Description = 'Select the customer''s level of satisfaction with the handling and resolution of the case.';
ExternalName = 'customersatisfactioncode';
ExternalType = 'Picklist';
InitValue = " ";
OptionCaption = ' ,Very Satisfied,Satisfied,Neutral,Dissatisfied,Very Dissatisfied';
OptionOrdinalValues = -1, 5, 4, 3, 2, 1;
OptionMembers = " ",VerySatisfied,Satisfied,Neutral,Dissatisfied,VeryDissatisfied;
}
field(21; IncidentStageCode; Option)
{
Caption = 'Case Stage';
Description = 'Select the current stage of the service process for the case to assist service team members when they review or transfer a case.';
ExternalName = 'incidentstagecode';
ExternalType = 'Picklist';
InitValue = DefaultValue;
OptionCaption = 'Default Value';
OptionOrdinalValues = 1;
OptionMembers = DefaultValue;
}
field(22; ModifiedOn; DateTime)
{
Caption = 'Modified On';
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 CRM options.';
ExternalAccess = Read;
ExternalName = 'modifiedon';
ExternalType = 'DateTime';
}
field(23; CreatedBy; Guid)
{
Caption = 'Created By';
Description = 'Shows who created the record.';
ExternalAccess = Read;
ExternalName = 'createdby';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(24; FollowupBy; Date)
{
Caption = 'Follow Up By';
Description = 'Enter the date by which a customer service representative has to follow up with the customer on this case.';
ExternalName = 'followupby';
ExternalType = 'DateTime';
}
field(25; ModifiedBy; Guid)
{
Caption = 'Modified By';
Description = 'Shows who last updated the record.';
ExternalAccess = Read;
ExternalName = 'modifiedby';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(26; VersionNumber; BigInteger)
{
Caption = 'Version Number';
Description = 'Version number of the case.';
ExternalAccess = Read;
ExternalName = 'versionnumber';
ExternalType = 'BigInt';
}
field(27; StateCode; Option)
{
Caption = 'Status';
ToolTip = 'Specifies the status of the case.';
Description = 'Shows whether the case is active, resolved, or canceled. Resolved and canceled cases are read-only and can''t be edited unless they are reactivated.';
ExternalAccess = Modify;
ExternalName = 'statecode';
ExternalType = 'State';
InitValue = Active;
OptionCaption = 'Active,Resolved,Canceled';
OptionOrdinalValues = 0, 1, 2;
OptionMembers = Active,Resolved,Canceled;
}
field(28; SeverityCode; Option)
{
Caption = 'Severity';
Description = 'Select the severity of this case to indicate the incident''s impact on the customer''s business.';
ExternalName = 'severitycode';
ExternalType = 'Picklist';
InitValue = DefaultValue;
OptionCaption = 'Default Value';
OptionOrdinalValues = 1;
OptionMembers = DefaultValue;
}
field(29; StatusCode; Option)
{
Caption = 'Status Reason';
Description = 'Select the case''s status.';
ExternalName = 'statuscode';
ExternalType = 'Status';
InitValue = " ";
OptionCaption = ' ,Problem Solved,Information Provided,Canceled,Merged,In Progress,On Hold,Waiting for Details,Researching';
OptionOrdinalValues = -1, 5, 1000, 6, 2000, 1, 2, 3, 4;
OptionMembers = " ",ProblemSolved,InformationProvided,Canceled,Merged,InProgress,OnHold,WaitingforDetails,Researching;
}
field(30; ResponsibleContactId; Guid)
{
Caption = 'Responsible Contact';
Description = 'Choose an additional customer contact who can also help resolve the case.';
ExternalName = 'responsiblecontactid';
ExternalType = 'Lookup';
TableRelation = "CRM Contact".ContactId;
}
field(31; AccountIdName; Text[160])
{
CalcFormula = lookup("CRM Account".Name where(AccountId = field(AccountId)));
Caption = 'AccountIdName';
ExternalAccess = Read;
ExternalName = 'accountidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(32; ContactIdName; Text[160])
{
CalcFormula = lookup("CRM Contact".FullName where(ContactId = field(ContactId)));
Caption = 'ContactIdName';
ExternalAccess = Read;
ExternalName = 'contactidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(33; ResponsibleContactIdName; Text[160])
{
CalcFormula = lookup("CRM Contact".FullName where(ContactId = field(ResponsibleContactId)));
Caption = 'ResponsibleContactIdName';
ExternalAccess = Read;
ExternalName = 'responsiblecontactidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(34; ContractIdName; Text[100])
{
CalcFormula = lookup("CRM Contract".Title where(ContractId = field(ContractId)));
Caption = 'ContractIdName';
ExternalAccess = Read;
ExternalName = 'contractidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(35; ProductIdName; Text[100])
{
CalcFormula = lookup("CRM Product".Name where(ProductId = field(ProductId)));
Caption = 'ProductIdName';
ExternalAccess = Read;
ExternalName = 'productidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(36; CreatedByName; Text[200])
{
CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(CreatedBy)));
Caption = 'CreatedByName';
ExternalAccess = Read;
ExternalName = 'createdbyname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(37; ModifiedByName; Text[200])
{
CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(ModifiedBy)));
Caption = 'ModifiedByName';
ExternalAccess = Read;
ExternalName = 'modifiedbyname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(38; CustomerId; Guid)
{
Caption = 'Customer';
Description = 'Select the customer account or contact to provide a quick link to additional customer details, such as account information, activities, and opportunities.';
ExternalName = 'customerid';
ExternalType = 'Customer';
TableRelation = if (CustomerIdType = const(account)) "CRM Account".AccountId
else
if (CustomerIdType = const(contact)) "CRM Contact".ContactId;
}
field(39; CustomerIdType; Option)
{
Caption = 'Customer Type';
ExternalName = 'customeridtype';
ExternalType = 'EntityName';
OptionCaption = ' ,account,contact';
OptionMembers = " ",account,contact;
}
field(40; OwnerId; Guid)
{
Caption = 'Owner';
Description = 'Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user.';
ExternalName = 'ownerid';
ExternalType = 'Owner';
TableRelation = if (OwnerIdType = const(systemuser)) "CRM Systemuser".SystemUserId
else
if (OwnerIdType = const(team)) "CRM Team".TeamId;
}
field(41; OwnerIdType; Option)
{
Caption = 'OwnerIdType';
ExternalName = 'owneridtype';
ExternalType = 'EntityName';
OptionCaption = ' ,systemuser,team';
OptionMembers = " ",systemuser,team;
}
field(42; TimeZoneRuleVersionNumber; Integer)
{
Caption = 'Time Zone Rule Version Number';
Description = 'For internal use only.';
ExternalName = 'timezoneruleversionnumber';
ExternalType = 'Integer';
MinValue = -1;
}
field(43; ImportSequenceNumber; Integer)
{
Caption = 'Import Sequence Number';
Description = 'Unique identifier of the data import or data migration that created this record.';
ExternalAccess = Insert;
ExternalName = 'importsequencenumber';
ExternalType = 'Integer';
}
field(44; UTCConversionTimeZoneCode; Integer)
{
Caption = 'UTC Conversion Time Zone Code';
Description = 'Time zone code that was in use when the record was created.';
ExternalName = 'utcconversiontimezonecode';
ExternalType = 'Integer';
MinValue = -1;
}
field(45; OverriddenCreatedOn; Date)
{
Caption = 'Record Created On';
Description = 'Date and time that the record was migrated.';
ExternalAccess = Insert;
ExternalName = 'overriddencreatedon';
ExternalType = 'DateTime';
}
field(46; CreatedOnBehalfBy; Guid)
{
Caption = 'Created By (Delegate)';
Description = 'Shows who created the record on behalf of another user.';
ExternalAccess = Read;
ExternalName = 'createdonbehalfby';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(47; CreatedOnBehalfByName; Text[200])
{
CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(CreatedOnBehalfBy)));
Caption = 'CreatedOnBehalfByName';
ExternalAccess = Read;
ExternalName = 'createdonbehalfbyname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(48; ModifiedOnBehalfBy; Guid)
{
Caption = 'Modified By (Delegate)';
Description = 'Shows who last updated the record on behalf of another user.';
ExternalAccess = Read;
ExternalName = 'modifiedonbehalfby';
ExternalType = 'Lookup';
TableRelation = "CRM Systemuser".SystemUserId;
}
field(49; ModifiedOnBehalfByName; Text[200])
{
CalcFormula = lookup("CRM Systemuser".FullName where(SystemUserId = field(ModifiedOnBehalfBy)));
Caption = 'ModifiedOnBehalfByName';
ExternalAccess = Read;
ExternalName = 'modifiedonbehalfbyname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(50; OwningTeam; Guid)
{
Caption = 'Owning Team';
Description = 'Unique identifier of the team who owns the case.';
ExternalAccess = Read;
ExternalName = 'owningteam';
ExternalType = 'Lookup';
TableRelation = "CRM Team".TeamId;
}
field(51; TransactionCurrencyId; Guid)
{
Caption = 'Currency';
Description = 'Choose the local currency for the record to make sure budgets are reported in the correct currency.';
ExternalName = 'transactioncurrencyid';
ExternalType = 'Lookup';
TableRelation = "CRM Transactioncurrency".TransactionCurrencyId;
}
field(52; TransactionCurrencyIdName; Text[100])
{
CalcFormula = lookup("CRM Transactioncurrency".CurrencyName where(TransactionCurrencyId = field(TransactionCurrencyId)));
Caption = 'TransactionCurrencyIdName';
ExternalAccess = Read;
ExternalName = 'transactioncurrencyidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(53; ExchangeRate; Decimal)
{
AutoFormatType = 0;
Caption = 'Exchange Rate';
Description = 'Shows the conversion rate of the record''s currency. The exchange rate is used to convert all money fields in the record from the local currency to the system''s default currency.';
ExternalAccess = Read;
ExternalName = 'exchangerate';
ExternalType = 'Decimal';
}
field(54; ServiceStage; Option)
{
Caption = 'Service Stage';
Description = 'Select the stage, in the case resolution process, that the case is in.';
ExternalName = 'servicestage';
ExternalType = 'Picklist';
InitValue = " ";
OptionCaption = ' ,Identify,Research,Resolve';
OptionOrdinalValues = -1, 0, 1, 2;
OptionMembers = " ",Identify,Research,Resolve;
}
field(55; ExistingCase; Guid)
{
Caption = 'Existing Case';
Description = 'Select an existing case for the customer that has been populated. For internal use only.';
ExternalName = 'existingcase';
ExternalType = 'Lookup';
TableRelation = "CRM Incident".IncidentId;
}
field(56; StageId; Guid)
{
Caption = 'Process Stage';
Description = 'Shows the ID of the stage.';
ExternalName = 'stageid';
ExternalType = 'Uniqueidentifier';
}
field(57; ProcessId; Guid)
{
Caption = 'Process';
Description = 'Shows the ID of the process.';
ExternalName = 'processid';
ExternalType = 'Uniqueidentifier';
}
field(58; EntityImageId; Guid)
{
Caption = 'Entity Image Id';
Description = 'For internal use only.';
ExternalAccess = Read;
ExternalName = 'entityimageid';
ExternalType = 'Uniqueidentifier';
}
field(59; CheckEmail; Boolean)
{
Caption = 'Check Email';
Description = 'This attribute is used for Sample Service Business Processes.';
ExternalName = 'checkemail';
ExternalType = 'Boolean';
}
field(60; ActivitiesComplete; Boolean)
{
Caption = 'Activities Complete';
Description = 'This attribute is used for Sample Service Business Processes.';
ExternalName = 'activitiescomplete';
ExternalType = 'Boolean';
}
field(61; FollowUpTaskCreated; Boolean)
{
Caption = 'Follow up Task Created';
Description = 'This attribute is used for Sample Service Business Processes.';
ExternalName = 'followuptaskcreated';
ExternalType = 'Boolean';
}
field(62; NumberOfChildIncidents; Integer)
{
Caption = 'Child Cases';
Description = 'Number of child incidents associated with the incident.';
ExternalAccess = Read;
ExternalName = 'numberofchildincidents';
ExternalType = 'Integer';
MinValue = 0;
}
field(63; MessageTypeCode; Option)
{
Caption = 'Received As';
Description = 'Shows whether the post originated as a public or private message.';
ExternalAccess = Insert;
ExternalName = 'messagetypecode';
ExternalType = 'Picklist';
InitValue = " ";
OptionCaption = ' ,Public Message,Private Message';
OptionOrdinalValues = -1, 0, 1;
OptionMembers = " ",PublicMessage,PrivateMessage;
}
field(64; BlockedProfile; Boolean)
{
Caption = 'Blocked Profile';
Description = 'Details whether the profile is blocked or not.';
ExternalAccess = Insert;
ExternalName = 'blockedprofile';
ExternalType = 'Boolean';
}
field(65; MasterId; Guid)
{
Caption = 'Master Case';
Description = 'Choose the primary case the current case was merged into.';
ExternalName = 'masterid';
ExternalType = 'Lookup';
TableRelation = "CRM Incident".IncidentId;
}
field(66; MasterIdName; Text[200])
{
CalcFormula = lookup("CRM Incident".Title where(IncidentId = field(MasterId)));
Caption = 'MasterIdName';
ExternalAccess = Read;
ExternalName = 'masteridname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(67; TraversedPath; Text[250])
{
Caption = 'Traversed Path';
Description = 'For internal use only.';
ExternalName = 'traversedpath';
ExternalType = 'String';
}
field(68; ParentCaseId; Guid)
{
Caption = 'Parent Case';
Description = 'Choose the parent case for a case.';
ExternalName = 'parentcaseid';
ExternalType = 'Lookup';
TableRelation = "CRM Incident".IncidentId;
}
field(69; DecrementEntitlementTerm; Boolean)
{
Caption = 'Decrement Entitlement Terms';
Description = 'Shows whether terms of the associated entitlement should be decremented or not.';
ExternalName = 'decremententitlementterm';
ExternalType = 'Boolean';
}
field(70; ParentCaseIdName; Text[200])
{
CalcFormula = lookup("CRM Incident".Title where(IncidentId = field(ParentCaseId)));
Caption = 'ParentCaseIdName';
ExternalAccess = Read;
ExternalName = 'parentcaseidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(71; SentimentValue; Decimal)
{
AutoFormatType = 0;
Caption = 'Sentiment Value';
Description = 'Value derived after assessing words commonly associated with a negative, neutral, or positive sentiment that occurs in a social post. Sentiment information can also be reported as numeric values.';
ExternalAccess = Insert;
ExternalName = 'sentimentvalue';
ExternalType = 'Double';
}
field(72; InfluenceScore; Decimal)
{
AutoFormatType = 0;
Caption = 'Influence Score';
Description = 'Will contain the Influencer score coming from NetBreeze.';
ExternalAccess = Insert;
ExternalName = 'influencescore';
ExternalType = 'Double';
}
field(73; Merged; Boolean)
{
Caption = 'Internal Use Only';
Description = 'Tells whether the incident has been merged with another incident.';
ExternalAccess = Read;
ExternalName = 'merged';
ExternalType = 'Boolean';
}
field(74; RouteCase; Boolean)
{
Caption = 'Route Case';
Description = 'Tells whether the incident has been routed to queue or not.';
ExternalAccess = Insert;
ExternalName = 'routecase';
ExternalType = 'Boolean';
}
field(75; ResolveBy; DateTime)
{
Caption = 'Resolve By';
Description = 'Enter the date by when the case must be resolved.';
ExternalName = 'resolveby';
ExternalType = 'DateTime';
}
field(76; ResponseBy; DateTime)
{
Caption = 'First Response By';
Description = 'For internal use only.';
ExternalName = 'responseby';
ExternalType = 'DateTime';
}
field(77; CustomerContacted; Boolean)
{
Caption = 'Customer Contacted';
Description = 'Tells whether customer service representative has contacted the customer or not.';
ExternalAccess = Insert;
ExternalName = 'customercontacted';
ExternalType = 'Boolean';
}
field(78; IsEscalated; Boolean)
{
Caption = 'IsEscalated';
Description = 'Indicates if the case has been escalated.';
ExternalName = 'isescalated';
ExternalType = 'Boolean';
}
field(79; EscalatedOn; DateTime)
{
Caption = 'Escalated On';
Description = 'Indicates the date and time when the case was escalated.';
ExternalAccess = Read;
ExternalName = 'escalatedon';
ExternalType = 'DateTime';
}
field(80; PrimaryContactId; Guid)
{
Caption = 'Contact';
Description = 'Select a primary contact for this case.';
ExternalName = 'primarycontactid';
ExternalType = 'Lookup';
TableRelation = "CRM Contact".ContactId;
}
field(81; PrimaryContactIdName; Text[160])
{
CalcFormula = lookup("CRM Contact".FullName where(ContactId = field(PrimaryContactId)));
Caption = 'PrimaryContactIdName';
ExternalAccess = Read;
ExternalName = 'primarycontactidname';
ExternalType = 'String';
FieldClass = FlowField;
}
field(82; FirstResponseSent; Boolean)
{
Caption = 'First Response Sent';
Description = 'Indicates if the first response has been sent.';
ExternalName = 'firstresponsesent';
ExternalType = 'Boolean';
}
field(83; FirstResponseSLAStatus; Option)
{
Caption = 'First Response SLA Status';
Description = 'Shows the status of the initial response time for the case according to the terms of the SLA.';
ExternalName = 'firstresponseslastatus';
ExternalType = 'Picklist';
InitValue = InProgress;
OptionCaption = 'In Progress,Nearing Noncompliance,Succeeded,Noncompliant';
OptionOrdinalValues = 1, 2, 3, 4;
OptionMembers = InProgress,NearingNoncompliance,Succeeded,Noncompliant;
}
field(84; ResolveBySLAStatus; Option)
{
Caption = 'Resolve By SLA Status';
Description = 'Shows the status of the resolution time for the case according to the terms of the SLA.';
ExternalName = 'resolvebyslastatus';
ExternalType = 'Picklist';
InitValue = InProgress;
OptionCaption = 'In Progress,Nearing Noncompliance,Succeeded,Noncompliant';
OptionOrdinalValues = 1, 2, 3, 4;
OptionMembers = InProgress,NearingNoncompliance,Succeeded,Noncompliant;
}
field(85; OnHoldTime; Integer)
{
Caption = 'On Hold Time (Minutes)';
Description = 'Shows the duration in minutes for which the case was on hold.';
ExternalAccess = Read;
ExternalName = 'onholdtime';
ExternalType = 'Integer';
}
field(86; LastOnHoldTime; DateTime)
{
Caption = 'Last On Hold Time';
Description = 'Contains the date time stamp of the last on hold time.';
ExternalName = 'lastonholdtime';
ExternalType = 'DateTime';
}
}
keys
{
key(Key1; IncidentId)
{
Clustered = true;
}
key(Key2; Title)
{
}
}
fieldgroups
{
fieldgroup(DropDown; Title)
{
}
}
}