PR
PMTimeActivityExt
No summary is documented for this DAC in the release source.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMIsProd | bit | - | ||
Description:Indicates a production related time activity | ||||
ARDocTypeNonexistent in DB | string | Type | - | |
Description:No description available | ||||
ARRefNbrNonexistent in DB | string | Reference Nbr. | ARRegister | |
Description:No description available | ||||
ActivityDateNonexistent in DB | DateTime? | Date | - | |
Description:No description available | ||||
AppointmentCustomerID | int | Customer ID | Customer | |
Description:No description available | ||||
AppointmentID | int | Appointment Nbr. | FSAppointment | |
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 | ||||
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 | Created By | 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 | ||||
EmployeeIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
EmployeeRate | decimal | Cost Rate | - | |
Description:Stores Employee's Hourly rate at the time the activity was released to PM | ||||
ErrorMessageNonexistent in DB | string | - | ||
Description:No description available | ||||
ExtRefNbr | nvarchar(30) | External Ref. Nbr | - | |
Description:No description available | ||||
IsActivityExistsNonexistent in DB | bool? | 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. | ||||
IsCreatedFromTimeLogNonexistent in DB | bool? | Time Log | - | |
Description:Read-only field that is equal to "true" in case the record was created based on entity. | ||||
JobID | int | - | ||
Description:No description available | ||||
LabourItemID | int | Labor Item | InventoryItem | |
Description:No description available | ||||
LastBillableNonexistent in DB | bool? | - | ||
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 | ||||
LogLineNbr | int | Log Ref. Nbr. | FSAppointmentLog | |
Description:No description available | ||||
NeedToBeDeletedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
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 | InventoryItem | ||
Description:No description available | ||||
OvertimeSpent | int | Overtime | - | |
Description:No description available | ||||
OwnerID | int | Employee ID | 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 | 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 | nvarchar(32) | Reported in Time Zone | - | |
Description:No description available | ||||
ReportedOnDateNonexistent in DB | DateTime? | Reported On | - | |
Description:Date and Time are displayed and modified depending on the ReportedInTimeZoneID | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ServiceID | int | Service | InventoryItem | |
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) | EPTimeCard | ||
Description:No description available | ||||
TimeLogID | int | - | ||
Description:The time log associated with this time activity. The value of this field corresponds to the time log in EPTimeLog.timeLogID. | ||||
TimeSheetCD | nvarchar(15) | - | ||
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 | ||||
UnionID | nvarchar(15) | Union Local | PMUnion | |
Description:No description available | ||||
WeekID | int | Time Card Week | EPWeekRaw | |
Description:No description available | ||||
WorkCodeID | nvarchar(15) | WCC Code | PMWorkCode | |
Description:No description available | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||