CR
PMTimeActivity
PX.Objects.CR54 of 54 fields
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
ApprovalStatus | char(2) | Approval Status | - | |
Description:No description available | ||||
ApprovedDate | datetime | 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 | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
CertifiedJob | bit | Certified Job | - | |
Description:No description available | ||||
ContractID | int | Contract | Contract | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | CreatedByID | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created At | - | |
Description:No description available | ||||
Date | datetime | Date | - | |
Description:No description available | ||||
DayOfWeekNonexistent in DB | int | Day | - | |
Description:No description available | ||||
EarningTypeID | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
EmployeeRate | decimal(19, 6) | Cost Rate | - | |
Description:Stores Employee's Hourly rate at the time the activity was released to PM | ||||
ExtRefNbr | nvarchar(30) | External Ref. Nbr | - | |
Description:No description available | ||||
IsActivityExistsNonexistent in DB | bit | Activity Exists | - | |
Description:No description available | ||||
IsBillable | bit | Billable | - | |
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. | ||||
JobID | int | - | ||
Description:No description available | ||||
LabourItemID | int | Labor Item | InventoryItem | |
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NeedToBeDeletedNonexistent in DB | bit | - | ||
Description:No description available | ||||
OrigNoteID | uniqueidentifier | PMTimeActivity | ||
Description:Use for correction. Stores the reference to the original activity. | ||||
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 | ||||
ParentTaskNoteID | uniqueidentifier | Task | CRActivity | |
Description:No description available | ||||
ProjectID | int | Project | PMProject | |
Description:No description available | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:No description available | ||||
RefNoteID | uniqueidentifier | RefNoteID | CRActivity | |
Description:The identifier of the related CRActivity. This field is included in FK.Related. Corresponds to the value of the CRActivity.NoteID field. | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReportedInTimeZoneID | varchar(32) | Reported in Time Zone | - | |
Description:No description available | ||||
ReportedOnDateNonexistent in DB | datetime | Reported On | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bit | Selected | - | |
Description:No description available | ||||
ShiftID | int | Shift Code | EPShiftCode | |
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. | ||||
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 | ||||
TrackTime | bit | Track Time and Costs | - | |
Description:No description available | ||||
TranID | bigint | - | ||
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||
UnionID | nvarchar(15) | Union Local | PMUnion | |
Description:No description available | ||||
WeekID | int | Time Card Week | EPTimeActivitiesSummary | |
Description:No description available | ||||
WorkCodeID | nvarchar(15) | WCC Code | PMWorkCode | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||