CR
CRCase
Represents a case (also referred to as support cases or tickets).
View API Entity: Case
/entity/Default/25.200.001/Case| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ARRefNbr | nvarchar(15) | AR Reference Nbr. | ARInvoice | |
Description:The reference number of the document. This field is a part of the compound key of the document. For most document types, the reference number is generated automatically from the corresponding numbering sequence, which is specified in the Accounts Receivable module preferences. | ||||
AgeNonexistent in DB | int? | Age | - | |
Description:The time elapsed from the creation of the case. | ||||
AssignDate | datetime | Assignment Date | - | |
Description:The date and time when the case was assigned by CRCase.OwnerID. | ||||
AssignedEmpID | int | Assigned To | BAccountStaffMember | |
Description:No description available | ||||
AttributesNonexistent in DB | string | - | ||
Description:The attributes list available for the current case. The field is preserved for internal use. | ||||
BranchLocationID | int | Branch Location | FSBranchLocation | |
Description:No description available | ||||
CaseCD API | nvarchar(15) | Case ID | - | |
Description:The unique identifier assigned to the case in accordance with the numbering sequence assigned to cases on the Customer Management Preferences (CR101000) form. | ||||
CaseClassID API | nvarchar(10) | Class ID | CRCaseClass | |
Description:The identifier of the case class. Corresponds to the value of the CRCaseClass.CaseClassID field. | ||||
ClosureNotes | nvarchar | Closure Notes | - | |
Description:On closing case user can record information about closing case or can update data if Closure Notes had any data before on case process steps. | ||||
ContactID API | int | Contact | Contact | |
Description:The customer representative to be contacted about the case. Corresponds to the value of the Contact.ContactID field. | ||||
ContractID API | int | Contract | Contract | |
Description:The contract associated with the case. Corresponds to the value of the Contract.contractID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Date Reported | - | |
Description:The date and time when the case was created. The field is filled in by the system. | ||||
CustomerID API | int | Business Account | BAccount | |
Description:The business account associated with the case. | ||||
Date | datetime | Billing Date | - | |
Description:No description available | ||||
Description API | nvarchar | Description | - | |
Description:A detailed description of the case or relevant notes. | ||||
DescriptionAsPlainTextNonexistent in DB | string | - | ||
Description:A detailed description of the case in plain text format. Corresponds to the value of the CRCase.Description field formatted in plain text. | ||||
ETANonexistent in DBObsolete | DateTime? | Promised | - | |
Description:The date given to the contact as the date of resolution. This field is calculated as CreatedDateTime increases by TimeEstimated minutes. | ||||
int? | Init. Response | - | ||
Description:The time from the creation of the case to the initial response. | ||||
InitResponseMinutesNonexistent in DBObsolete | int? | Init. Response (minutes) | - | |
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:This field indicates whether the case is active. A case is considered active if further communication or action is expected for it. If the check box is selected, the case is displayed in the list of cases on the related mass processing forms, such as the Assign Cases (CR503210) form. By default, the check box is cleared when the case is closed. The default value is true. | ||||
IsBillable API | bit | Billable | - | |
Description:The field indicates whether the case is billable. | ||||
DateTime? | Last Activity | - | ||
Description:The date and time of the last activity of this case. | ||||
LastActivityAgeNonexistent in DBObsolete | int? | Last Activity Age | - | |
Description:This field contains the age (in years) of the last activity of the case. | ||||
LastModifiedNonexistent in DB | DateTime? | Last Modified | - | |
Description:The date and time of the last modification of this case. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
LocationID API | int | Location | Location | |
Description:The identifier of the default Location object linked with the prospective or existing customer that is selected in the Business Account box. Corresponds to the value of the Location.LocationID field. Also, the Location.BAccountID value must be equal to the CRCase.CustomerID value of the current case. | ||||
ManualBillableTimes API | bit | Manual Override | - | |
Description:The field indicates whether the billable time and billable overtime can be changed manually. | ||||
NoteID API | uniqueidentifier | - | ||
Description:No description available | ||||
OvertimeBillable API | int | Billable Overtime | - | |
Description:The billable overtime (in hours) spent on the case. | ||||
OvertimeSpent API | int | Overtime Spent | - | |
Description:The overtime (in hours) spent on the case activity. | ||||
OwnerID API | int | Owner | Contact | |
Description:The user name of the employee assigned to the case. | ||||
Priority API | char(1) | Priority | - | |
Description:The priority of the case. The field can have one of the values listed in the CRCasePriorityAttribute class. The default value is CRCasePriorityAttribute._MEDIUM. | ||||
ProblemID | int | Problem | FSProblem | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:This field indicates whether the case has been released. Thus, the field indicates whether the CRCase.Status field has the States.Released value. The default value is false. | ||||
RemaininingDateNonexistent in DBObsolete | int? | Remaining | - | |
Description:The amount of time required to close the case (in minutes). | ||||
RemaininingDateMinutesNonexistent in DBObsolete | int? | Remaining (minutes) | - | |
Description:No description available | ||||
ReportedOnDateTime API | datetime | Reported On | - | |
Description:Date and time of the case creation. | ||||
Resolution API | char(2) | Reason | - | |
Description:The reason why the case has been changed to the current status. The field can have one of the values listed in the CaseWorkflow class. | ||||
ResolutionDate API | datetime | Closed On | - | |
Description:The date and time when the case was closed. The field is filled in by the system. | ||||
SDEnabled | bit | Create Service Order | - | |
Description:No description available | ||||
SLAETANonexistent in DBObsolete | DateTime? | SLA | - | |
Description:The date and time when the case should be closed according to the SLA. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ServiceOrderRefNbr | nvarchar(15) | Service Order Nbr. | FSServiceOrder | |
Description:No description available | ||||
Severity API | char(1) | Severity | - | |
Description:The severity level of the case. The field can have one of the values listed in the CRCaseSeverityAttribute class. The default value is CRCaseSeverityAttribute._MEDIUM. | ||||
SolutionActivityNoteID | uniqueidentifier | Solution Provided In | CRActivity | |
Description:The activity identifier which contains the solution for the case. Corresponds to the CRActivity.NoteID field. | ||||
SolutionProvidedDateTime | datetime | Solution Provided On | - | |
Description:The date and time when the solution was provided for the case. | ||||
Source | char(2) | Source | - | |
Description:The source of the case. The field can have one of the values listed in the CaseSourcesAttribute class. | ||||
SrvOrdType | char(4) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
Status API | char(1) | Status | - | |
Description:The current status of the case. The field can have one of the values listed in the States.ListAttribute class. The default value is States.New. | ||||
StatusDate | datetime | - | ||
Description:This field contains the date when the current case status is set. | ||||
StatusRevision | int | - | ||
Description:No description available | ||||
Subject API | nvarchar(256) | Subject | - | |
Description:A subject of the case. | ||||
TimeBillable API | int | Billable Time | - | |
Description:The billable time (in hours) spent on the case. | ||||
TimeEstimatedObsolete | int | Estimation | - | |
Description:The estimation of the time (in minutes) required for the case resolution. | ||||
int? | Resolution Time | - | ||
Description:The time (in minutes) of the case resolution. If the case is open, the field contains the time elapsed since the case was created. If the case is closed, the field contains the time from the creation of the case to its resolution. | ||||
TimeResolutionMinutesNonexistent in DB | int? | Resolution Time (Minutes) | - | |
Description:The time (in minutes) of the case resolution. If the case is open, the field contains the time elapsed since the case was created. If the case is closed, the field contains the time from the creation of the case to its resolution. | ||||
TimeSpent API | int | Time Spent | - | |
Description:The time (in hours) spent on the case activity. | ||||
WorkgroupID API | int | Workgroup | EPCompanyTree | |
Description:The company tree workgroup to work on the case. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||