Power BI Connector for SugarCRM

Build 20.0.7587

ProjectTask

Create, update, delete, and query the ProjectTask module in SugarCRM.

Columns

Name Type ReadOnly Description
Team_Id String False

The Id of the primary team.

Team_Set_Id String False

The Id of the team set.

Team_Count String False

The count of the team set.

Team_Name String False

The name of the primary team.

Id [KEY] String False

The unique identifier of the project task.

Date_Entered Datetime False

The date the project task was entered.

Date_Modified Datetime False

The date the project task was modified.

Project_Id String False

The Id of the project associated with the task.

Project_Task_Id Int False

The Id of the project task.

Name String False

The name of the project task.

Status String False

The status of the project task.

Description String False

The full text of the note.

Resource_Id String False

The Id of the associated resource.

Resource_Name String False

The name of the associated resource.

Predecessors String False

The predecessors of the project task.

Date_Start Datetime False

The start date of the project task.

Time_Start Int False

The start time of the project task.

Time_Finish Int False

The finish time of the project task.

Date_Finish Datetime False

The finish date of the project task.

Duration Int False

The duration of the project task.

Duration_Unit String False

The duration unit of the project task.

Actual_Duration Int False

The actual duration of the project task.

Percent_Complete Int False

The percent that the project task is complete.

Date_Due Datetime False

The due date of the project task.

Time_Due String False

The time the project task is due.

Parent_Task_Id Int False

The Id of the parent task.

Assigned_User_Id String False

The Id of the user assigned to the project task.

Modified_User_Id String False

The Id of the user who last modified the project task.

Modified_By_Name String False

The user name of the user who last modified the project task.

Priority String False

The priority of the project task.

Created_By String False

The Id of the user who created the project task.

Created_By_Name String False

The user name of the user who created the project task.

Milestone_Flag Bool False

The name of the project task.

Order_Number Int False

The order number of the project task.

Task_Number Int False

The task number of the project task.

Estimated_Effort Int False

The estimated effort of the project task.

Actual_Effort Int False

The actual effort of the project task.

Deleted Bool False

Whether the project task is deleted.

Utilization Int False

The utilization of the project task.

Project_Name String False

The name of the project task.

Assigned_User_Name String False

The user name of the user assigned to the project task.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587