ODBC Driver for SugarCRM

Build 23.0.8839

ProjectTask

The ProjectTask table.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Date_Entered Datetime True

Date_Modified Datetime True

Project_Id String False

Project_Task_Id Int True

Name String False

Status String False

Description String False

Resource_Id String False

Resource_Name String False

Predecessors String False

Date_Start Date False

Time_Start Int True

Time_Finish Int True

Date_Finish Date False

Duration Int False

Duration_Unit String False

Actual_Duration Int True

Percent_Complete Int True

Date_Due Date False

Time_Due String True

Parent_Task_Id Int True

Assigned_User_Id String False

Modified_User_Id String True

Modified_By_Name String True

Priority String False

Created_By String True

Created_By_Name String True

Milestone_Flag Bool False

Order_Number Int True

Task_Number Int True

Estimated_Effort Int True

Actual_Effort Int True

Deleted Bool False

Utilization Int True

Project_Name String True

Assigned_User_Name String True

Team_Id String False

Team ID for the account

Team_Set_Id String False

Acl_Team_Set_Id String False

Team_Count String False

Team_Name String False

Acl_Team_Names String True

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839