SSIS Components for Microsoft Project

Build 21.0.7867

TimesheetLines

Retrieve timesheet lines.

Columns

Name Type References Description
TimesheetLineId [KEY] String
ActualOvertimeWorkBillable Decimal
ActualOvertimeWorkNonBillable Decimal
ActualWorkBillable Decimal
ActualWorkNonBillable Decimal
AssignmentId String
CreatedDate Datetime
LastSavedWork Decimal
LCID Int
ModifiedDate Datetime
PeriodEndDate Datetime
PeriodStartDate Datetime
PlannedWork Decimal
ProjectId String
ProjectName String
TaskHierarchy String
TaskId String
TaskName String
TimesheetApproverResourceId String
TimesheetApproverResourceName String
TimesheetClassDescription String
TimesheetClassId String
TimesheetClassName String
TimesheetClassType Int
TimesheetId String
TimesheetLineComment String
TimesheetLineStatus String
TimesheetLineStatusId Int
TimesheetName String
TimesheetOwner String
TimesheetOwnerId String
TimesheetPeriodId String
TimesheetPeriodName String
TimesheetPeriodStatus String
TimesheetPeriodStatusId Int
TimesheetStatus String
TimesheetStatusId Int
LinkedActuals String
LinkedApproverResource String
LinkedTimesheet String
LinkedTimesheetClass String

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7867