CR
CRPMTimeActivity
PX.Objects.CR98 of 98 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
NoteID | uniqueidentifier | ID | - | |
Description:No description available | ||||
AllDay | bit | All Day | - | |
Description:No description available | ||||
Application | int | Originated By | - | |
Description:No description available | ||||
ApprovalStatus | char(2) | Approval 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 | - | |
Description:No description available | ||||
ClassInfoNonexistent in DB | nvarchar(MAX) | Type | - | |
Description:No description available | ||||
CompletedDate | datetime | 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 | ||||
DocumentNoteID | uniqueidentifier | Related Document | - | |
Description:No description available | ||||
EarningTypeID | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
EmployeeRate | decimal | EmployeeRate | - | |
Description:Stores Employee's Hourly rate at the time the activity was released to PM | ||||
EndDate | datetime | 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:If true this Activity has been corrected in the Timecard and is no longer valid. Please hide this activity in all lists displayed in the UI since there is another valid activity. The valid activity has a refence back to the corrected activity via OrigTaskID field. | ||||
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 | ||||
OrigNoteID | uniqueidentifier | PMTimeActivity | ||
Description:Use for correction. Stores the reference to the original activity. | ||||
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:This is a adjusting activity for the summary line in the Timecard. | ||||
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 | ||||
TimeActivityNoteID | uniqueidentifier | - | ||
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 | ||||