Skip to main content
EP

EPActivityApprove2

PX.Objects.EP
Field NameTypeDisplay NameForeign Key
NoteID
uniqueidentifier-
Description:No description available
ApprovalStatus
char(2)Status-
Description:No description available
ApprovedDate
datetime2Approved Date-
Description:No description available
ApproverIDDefault Navigation
intApprover-
Description:No description available
ARDocTypeNonexistent in DB
nchar(3)Type-
Description:No description available
ARRefNbrDefault NavigationNonexistent in DB
nvarchar(15)Reference Nbr.-
Description:No description available
Billed
bitBilled-
Description:No description available
CertifiedJob
bitCertified Job-
Description:No description available
ContractIDDefault Navigation
intContract-
Description:No description available
CostCodeDescriptionNonexistent in DB
nvarchar(MAX)Cost Code Description-
Description:No description available
CostCodeIDDefault Navigation
intCost Code-
Description:No description available
CreatedByIDDefault Navigation
uniqueidentifierCreatedByID-
Description:No description available
CreatedByScreenID
varchar(8)-
Description:No description available
CreatedDateTime
datetimeCreated At-
Description:No description available
Date
datetimeDate-
Description:No description available
DayOfWeekNonexistent in DB
intDay-
Description:No description available
EarningTypeIDDefault Navigation
nvarchar(15)Earning Type-
Description:No description available
EmployeeRate
decimalCost Rate-
Description:No description available
ExtRefNbr
nvarchar(30)External Ref. Nbr-
Description:No description available
HoldNonexistent in DB
bitHold-
Description:No description available
IsActivityExistsNonexistent in DB
bitActivity Exists-
Description:No description available
IsApprovedNonexistent in DB
bitApprove-
Description:No description available
IsBillable
bitBillable-
Description:No description available
IsCorrected
bit-
Description:No description available
IsRejectNonexistent in DB
bitReject-
Description:No description available
JobID
int-
Description:No description available
LabourItemIDDefault Navigation
intLabor Item-
Description:No description available
LastModifiedByIDDefault Navigation
uniqueidentifierLast Modified By-
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-
Description:No description available
OvertimeBillable
intBillable Overtime-
Description:No description available
OvertimeItemID
intOvertimeItemID-
Description:No description available
OvertimeSpent
intOvertime-
Description:No description available
OwnerIDDefault Navigation
intOwner-
Description:No description available
ParentTaskNoteIDDefault Navigation
uniqueidentifierTask-
Description:No description available
ProjectDescriptionNonexistent in DB
nvarchar(MAX)Project Description-
Description:No description available
ProjectIDDefault Navigation
intProject-
Description:No description available
ProjectTaskDescriptionNonexistent in DB
nvarchar(MAX)Project Task Description-
Description:No description available
ProjectTaskIDDefault Navigation
intProject Task-
Description:No description available
RefNoteID
uniqueidentifierRefNoteID-
Description:No description available
Released
bitReleased-
Description:No description available
ReportedInTimeZoneID
varchar(32)Reported in Time Zone-
Description:No description available
ReportedOnDateNonexistent in DB
datetimeReported On-
Description:No description available
SelectedNonexistent in DB
bitSelected-
Description:No description available
ShiftIDDefault Navigation
intShift Code-
Description:No description available
Summary
nvarchar(256)Summary-
Description:No description available
SummaryLineNbr
int-
Description:No description available
TimeBillable
intBillable Time-
Description:No description available
TimeCardCD
nvarchar(10)Time Card Ref.-
Description:No description available
TimeSheetCD
nvarchar(15)TimeSheetCD-
Description:No description available
TimeSpent
intTime Spent-
Description:No description available
TrackTime
bit-
Description:No description available
TranID
bigint-
Description:No description available
tstamp
timestamp-
Description:No description available
UnionIDDefault Navigation
nvarchar(15)Union Local-
Description:No description available
WeekIDDefault Navigation
intTime Card Week-
Description:No description available
WorkCodeIDDefault Navigation
nvarchar(15)WCC Code-
Description:No description available
WorkgroupIDDefault Navigation
intWorkgroup-
Description:No description available