CR
CRCaseRelated
PX.Objects.CR57 of 57 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CaseCD | nvarchar(15) | Case ID | - | |
Description:No description available | ||||
AgeNonexistent in DB | int | Age | - | |
Description:No description available | ||||
ARRefNbr | nvarchar(15) | AR Reference Nbr. | ARInvoice | |
Description:No description available | ||||
AssignDate | datetime2 | Assignment Date | - | |
Description:No description available | ||||
AttributesNonexistent in DB | unspecified | - | ||
Description:No description available | ||||
CaseClassID | nvarchar(10) | Case Class | CRCaseClass | |
Description:No description available | ||||
ClosureNotes | nvarchar(MAX) | Closure Notes | - | |
Description:No description available | ||||
ContactID | int | Contact | Contact | |
Description:No description available | ||||
ContractID | int | Contract | Contract | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Date Reported | - | |
Description:No description available | ||||
CustomerID | int | Business Account | BAccount | |
Description:No description available | ||||
Date | datetime2 | Billing Date | - | |
Description:No description available | ||||
Description | nvarchar(MAX) | Description | - | |
Description:No description available | ||||
DescriptionAsPlainTextNonexistent in DB | nvarchar(MAX) | DescriptionAsPlainText | - | |
Description:No description available | ||||
ETANonexistent in DBObsolete | datetime | Promised | - | |
Description:No description available | ||||
InitResponseObsolete | int | Init. Response | - | |
Description:No description available | ||||
InitResponseMinutesNonexistent in DBObsolete | int | Init. Response (minutes) | - | |
Description:No description available | ||||
IsActive | bit | Active | - | |
Description:No description available | ||||
IsBillable | bit | Billable | - | |
Description:No description available | ||||
LastActivityNonexistent in DB | datetime | Last Activity | - | |
Description:No description available | ||||
LastActivityAgeNonexistent in DBObsolete | int | Last Activity Age | - | |
Description:No description available | ||||
LastModifiedNonexistent in DB | datetime | Last Modified | - | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
LocationID | int | Location | Location | |
Description:No description available | ||||
ManualBillableTimes | bit | Manual Override | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | CRActivity | ||
Description:No description available | ||||
OvertimeBillable | int | Billable Overtime | - | |
Description:No description available | ||||
OvertimeSpent | int | Overtime Spent | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
Priority | char(1) | Priority | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
RemaininingDateNonexistent in DBObsolete | int | Remaining | - | |
Description:No description available | ||||
RemaininingDateMinutesNonexistent in DBObsolete | int | Remaining (minutes) | - | |
Description:No description available | ||||
ReportedOnDateTime | datetime2 | Reported On | - | |
Description:No description available | ||||
Resolution | char(2) | Reason | - | |
Description:No description available | ||||
ResolutionDate | datetime2 | Closed On | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
Severity | char(1) | Severity | - | |
Description:No description available | ||||
SLAETANonexistent in DBObsolete | datetime | SLA | - | |
Description:No description available | ||||
SolutionActivityNoteID | uniqueidentifier | Solution Provided In | - | |
Description:No description available | ||||
SolutionProvidedDateTime | datetime2 | Solution Provided On | - | |
Description:No description available | ||||
Source | char(2) | Source | - | |
Description:No description available | ||||
Status | char(1) | Status | - | |
Description:No description available | ||||
StatusDate | datetime | - | ||
Description:No description available | ||||
StatusRevision | int | - | ||
Description:No description available | ||||
Subject | nvarchar(256) | Subject | - | |
Description:No description available | ||||
TimeBillable | int | Billable Time | - | |
Description:No description available | ||||
TimeEstimatedObsolete | int | Estimation | - | |
Description:No description available | ||||
TimeResolution | int | Resolution Time | - | |
Description:No description available | ||||
TimeResolutionMinutesNonexistent in DB | int | Resolution Time (Minutes) | - | |
Description:No description available | ||||
TimeSpent | int | Time Spent | - | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||