CRCaseRelated

PX.Objects.CRRelease 2025.2

No summary is documented for this DAC in the release source.

Select a row for its description 63 of 63 fields

	Field Name	Type	Display Name	Foreign Key
	`ARRefNbr`Default Navigation	`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.
	`Age`Nonexistent 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`Default Navigation	`int`	Assigned To	BAccountStaffMember
Description:No description available
	`Attributes`Nonexistent in DB	`string`		-
Description:The attributes list available for the current case. The field is preserved for internal use.
	`BranchLocationID`Default Navigation	`int`	Branch Location	FSBranchLocation
Description:No description available
	`CaseCD`Default Navigation	`nvarchar(15)`	Case ID	CRCase
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`Default Navigation	`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`Default Navigation	`int`	Contact	Contact
Description:The customer representative to be contacted about the case. Corresponds to the value of the Contact.ContactID field.
	`ContractID`Default Navigation	`int`	Contract	Contract
Description:The contract associated with the case. Corresponds to the value of the Contract.contractID field.
	`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:The business account associated with the case.
	`Date`	`datetime`	Billing Date	-
Description:No description available
	`Description`	`nvarchar`	Description	-
Description:A detailed description of the case or relevant notes.
	`DescriptionAsPlainText`Nonexistent 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.
	`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`Nonexistent in DBObsolete	`int?`	Init. Response	-
Description:The time from the creation of the case to the initial response.
	`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 true.
	`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:The date and time of the last modification of this case.
	`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: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`	`bit`	Manual Override	-
Description:The field indicates whether the billable time and billable overtime can be changed manually.
	`NoteID`	`uniqueidentifier`		-
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.
	`ProblemID`Default Navigation	`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.
	`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`	`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
	`SLAETA`Nonexistent in DBObsolete	`DateTime?`	SLA	-
Description:The date and time when the case should be closed according to the SLA.
	`Selected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`ServiceOrderRefNbr`Default Navigation	`nvarchar(15)`	Service Order Nbr.	FSServiceOrder
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.
	`SolutionActivityNoteID`Default Navigation	`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`Default Navigation	`char(4)`	Service Order Type	FSSrvOrdType
Description:No description available
	`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`	`datetime`		-
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`Nonexistent in DB	`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: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`	`int`	Time Spent	-
Description:The time (in hours) spent on the case activity.
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The company tree workgroup to work on the case.
	`tstamp`	`timestamp`		-
Description:No description available