CRCase

PX.Objects.CR

View API Entity: Case/entity/Default/24.200.001/Case

57 of 57 fields

	Field Name	Type	Display Name	Foreign Key
	`CaseCD`Default Navigation	`nvarchar(15)`	Case ID	-
Description:No description available
	`Age`Nonexistent in DB	`int`	Age	-
Description:The time elapsed from the creation of the case.
	`ARRefNbr`Default Navigation	`nvarchar(15)`	AR Reference Nbr.	ARInvoice
Description:No description available
	`AssignDate`	`datetime`	Assignment Date	-
Description:The date and time when the case was assigned by CRCase.OwnerID.
	`Attributes`Nonexistent in DB	`unspecified`		-
Description:The attributes list available for the current case. The field is preserved for internal use.
	`CaseClassID`Default Navigation	`nvarchar(10)`	Case Class	CRCaseClass
Description:No description available
	`ClosureNotes`	`nvarchar(MAX)`	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`Default Navigation	`int`	Contact	Contact
Description:No description available
	`ContractID`Default Navigation	`int`	Contract	Contract
Description:No description available
	`CreatedByID`Default Navigation	`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`Default Navigation	`int`	Business Account	BAccount
Description:No description available
	`Date`	`datetime2`	Billing Date	-
Description:No description available
	`Description`	`nvarchar(MAX)`	Description	-
Description:A detailed description of the case or relevant notes.
	`DescriptionAsPlainText`Nonexistent in DB	`nvarchar(MAX)`	DescriptionAsPlainText	-
Description:A detailed description of the case in plain text format. Corresponds to the value of the CRCase.Description field formatted in plain text.
	`ETA`Nonexistent 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.
	`InitResponse`Obsolete	`int`	Init. Response	-
Description:No description available
	`InitResponseMinutes`Nonexistent 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 .
	`IsBillable`	`bit`	Billable	-
Description:The field indicates whether the case is billable.
	`LastActivity`Nonexistent in DB	`datetime`	Last Activity	-
Description:The date and time of the last activity of this case.
	`LastActivityAge`Nonexistent in DBObsolete	`int`	Last Activity Age	-
Description:This field contains the age (in years) of the last activity of the case.
	`LastModified`Nonexistent in DB	`datetime`	Last Modified	-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LocationID`Default Navigation	`int`	Location	Location
Description:No description available
	`ManualBillableTimes`	`bit`	Manual Override	-
Description:The field indicates whether the billable time and billable overtime can be changed manually.
	`NoteID`	`uniqueidentifier`		CRActivity
Description:No description available
	`OvertimeBillable`	`int`	Billable Overtime	-
Description:The billable overtime (in hours) spent on the case.
	`OvertimeSpent`	`int`	Overtime Spent	-
Description:The overtime (in hours) spent on the case activity.
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:The user name of the employee assigned to the case.
	`Priority`	`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.
	`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 .
	`RemaininingDate`Nonexistent in DBObsolete	`int`	Remaining	-
Description:The amount of time required to close the case (in minutes).
	`RemaininingDateMinutes`Nonexistent in DBObsolete	`int`	Remaining (minutes)	-
Description:No description available
	`ReportedOnDateTime`	`datetime`	Reported On	-
Description:Date and time of the case creation.
	`Resolution`	`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`	`datetime2`	Closed On	-
Description:The date and time when the case was closed. The field is filled in by the system.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:No description available
	`Severity`	`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.
	`SLAETA`Nonexistent in DBObsolete	`datetime`	SLA	-
Description:The date and time when the case should be closed according to the SLA.
	`SolutionActivityNoteID`Default Navigation	`uniqueidentifier`	Solution Provided In	-
Description:No description available
	`SolutionProvidedDateTime`	`datetime2`	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.
	`Status`	`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`	`datetime2`		-
Description:This field contains the date when the current case status is set.
	`StatusRevision`	`int`		-
Description:No description available
	`Subject`	`nvarchar(256)`	Subject	-
Description:A subject of the case.
	`TimeBillable`	`int`	Billable Time	-
Description:The billable time (in hours) spent on the case.
	`TimeEstimated`Obsolete	`int`	Estimation	-
Description:The estimation of the time (in minutes) required for the case resolution.
	`TimeResolution`	`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.
	`TimeResolutionMinutes`Nonexistent in DB	`int`	Resolution Time (Minutes)	-
Description:No description available
	`TimeSpent`	`int`	Time Spent	-
Description:The time (in hours) spent on the case activity.
	`tstamp`	`timestamp`		-
Description:No description available
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The company tree workgroup to work on the case.