EP
EPActivityOpen
PX.Objects.EP54 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 | 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 | ||||
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 | 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 | - | |
Description:No description available | ||||
EarningTypeID | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
EmployeeRate | decimal | Cost Rate | - | |
Description:No description available | ||||
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:No description available | ||||
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 | varchar(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
NeedToBeDeletedNonexistent in DB | bit | - | ||
Description:No description available | ||||
OrigNoteID | uniqueidentifier | PMTimeActivity | ||
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 | ||||
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:No description available | ||||
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: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 | ||||
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 | ||||