CR
PMCRActivity
PX.Objects.CR99 of 99 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
TimeActivityNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
AllDay | bit | All Day | - | |
Description:No description available | ||||
Application | int | Originated By | - | |
Description:No description available | ||||
ApprovalStatus | char(2) | Status | - | |
Description:No description available | ||||
ApprovedDate | datetime2 | Approved Date | - | |
Description:No description available | ||||
ApproverID | int | Approver | EPEmployee | |
Description:No description available | ||||
ARDocTypeNonexistent in DB | nchar(3) | Type | - | |
Description:No description available | ||||
ARRefNbrNonexistent in DB | nvarchar(15) | Reference Nbr. | ARRegister | |
Description:No description available | ||||
BAccountID | int | Related Account | BAccount | |
Description:No description available | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
Body | nvarchar(MAX) | Activity Details | - | |
Description:No description available | ||||
CategoryID | int | Category | EPEventCategory | |
Description:No description available | ||||
ChildKeyNonexistent in DB | uniqueidentifier | - | ||
Description:No description available | ||||
ClassIconNonexistent in DB | nvarchar(MAX) | Class Icon | - | |
Description:No description available | ||||
ClassID | int | Class | EPActivityType | |
Description:No description available | ||||
ClassInfoNonexistent in DBObsolete | nvarchar(MAX) | Type | - | |
Description:No description available | ||||
CompletedDate | datetime2 | Completed On | - | |
Description:No description available | ||||
ContactID | int | Related Contact | Contact | |
Description:No description available | ||||
ContractID | int | Contract | Contract | |
Description:No description available | ||||
CostCodeID | int | Cost Code | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | CreatedByID | Users | |
Description:No description available | ||||
CreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created At | - | |
Description:No description available | ||||
Date | datetime2 | Date | - | |
Description:No description available | ||||
DayOfWeekNonexistent in DB | int | Day Of Week | - | |
Description:No description available | ||||
DeletedDatabaseRecord | bit | - | ||
Description:No description available | ||||
DisplayStatusNonexistent in DB | nvarchar(MAX) | Status | - | |
Description:No description available | ||||
DocumentNoteID | uniqueidentifier | Related Document | - | |
Description:No description available | ||||
EarningTypeID | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
EmployeeRate | decimal | EmployeeRate | - | |
Description:No description available | ||||
EndDate | datetime2 | End Date | - | |
Description:No description available | ||||
EntityDescriptionNonexistent in DB | nvarchar(MAX) | Entity | - | |
Description:No description available | ||||
ExtRefNbr | nvarchar(30) | External Ref. Nbr | - | |
Description:No description available | ||||
Incoming | bit | Incoming | - | |
Description:No description available | ||||
IsBillable | bit | Billable | - | |
Description:No description available | ||||
IsCompleteIconNonexistent in DB | nvarchar(MAX) | Complete Icon | - | |
Description:No description available | ||||
IsCorrected | bit | - | ||
Description:No description available | ||||
IsExternal | bit | IsExternal | - | |
Description:No description available | ||||
IsLocked | bit | Is Locked | - | |
Description:No description available | ||||
IsOverdueNonexistent in DB | bit | - | ||
Description:No description available | ||||
IsPinnedNonexistent in DB | varchar(MAX) | Is Pinned | - | |
Description:No description available | ||||
IsPrivate | bit | Internal | - | |
Description:No description available | ||||
JobID | int | - | ||
Description:No description available | ||||
LabourItemID | int | LabourItemID | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
Location | nvarchar(255) | Location | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigNoteID | uniqueidentifier | PMTimeActivity | ||
Description:No description available | ||||
Outgoing | bit | Outgoing | - | |
Description:No description available | ||||
OvertimeBillable | int | Billable Overtime | - | |
Description:No description available | ||||
OvertimeItemID | int | OvertimeItemID | InventoryItem | |
Description:No description available | ||||
OvertimeSpent | int | Overtime | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentNoteID | uniqueidentifier | Parent Activity | Contact | |
Description:No description available | ||||
ParentTaskNoteID | uniqueidentifier | Task | CRActivity | |
Description:No description available | ||||
PercentCompletion | int | Completion (%) | - | |
Description:No description available | ||||
Priority | int | Priority | - | |
Description:No description available | ||||
PriorityIconNonexistent in DB | nvarchar(MAX) | Priority Icon | - | |
Description:No description available | ||||
ProjectID | int | Project | - | |
Description:No description available | ||||
ProjectTaskID | int | Project Task | - | |
Description:No description available | ||||
ProvidesCaseSolution | bit | Case Solution Provided | - | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | Related Entity | CRActivity | |
Description:No description available | ||||
RefNoteIDType | nvarchar(MAX) | Related Entity Type | - | |
Description:No description available | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReportedInTimeZoneID | varchar(32) | Reported in Time Zone | - | |
Description:No description available | ||||
ResponseActivityNoteID | uniqueidentifier | Response Provided In | Contact | |
Description:No description available | ||||
ResponseDueDateTime | datetime2 | Response Due | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
SelectorDescriptionNonexistent in DB | nvarchar(MAX) | Description | - | |
Description:No description available | ||||
ShiftID | int | EPShiftCode | ||
Description:No description available | ||||
ShowAsID | int | Show As | - | |
Description:No description available | ||||
SourceNonexistent in DB | nvarchar(MAX) | Related Entity | - | |
Description:No description available | ||||
StartDate | datetime | Start Date | - | |
Description:No description available | ||||
Subject | nvarchar(998) | Summary | - | |
Description:No description available | ||||
Summary | nvarchar(256) | Summary | - | |
Description:No description available | ||||
SummaryLineNbr | int | - | ||
Description:No description available | ||||
Synchronize | bit | Synchronize | - | |
Description:No description available | ||||
TimeActivityCreatedByID | uniqueidentifier | TimeActivityCreatedByID | - | |
Description:No description available | ||||
TimeActivityCreatedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
TimeActivityCreatedDateTime | datetime | Created At | - | |
Description:No description available | ||||
TimeActivityLastModifiedByID | uniqueidentifier | Last Modified By | - | |
Description:No description available | ||||
TimeActivityLastModifiedByScreenID | varchar(8) | - | ||
Description:No description available | ||||
TimeActivityLastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
TimeActivityOwner | int | Owner | - | |
Description:No description available | ||||
TimeActivityRefNoteID | uniqueidentifier | - | ||
Description:No description available | ||||
TimeBillable | int | Billable Time | - | |
Description:No description available | ||||
TimeCardCD | nvarchar(10) | TimeCardCD | EPTimeCard | |
Description:No description available | ||||
TimeSheetCD | nvarchar(15) | TimeSheetCD | - | |
Description:No description available | ||||
TimeSpent | int | Time Spent | - | |
Description:No description available | ||||
TimeZone | varchar(32) | Time Zone | - | |
Description:No description available | ||||
TrackTime | bit | Track Time | - | |
Description:No description available | ||||
TranID | bigint | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
Type | char(5) | Type | EPActivityType | |
Description:No description available | ||||
UIStatus | char(2) | Status | - | |
Description:No description available | ||||
WeekID | int | Time Card Week | - | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||