PROJECT table

PROJECT – This table is used to store the project information for the Track-IT pro database.

Ÿ      ID – The unique ID for a project. (PK)

Ÿ      CLIENT – The client ID for the client this project is assigned to.

Ÿ      NAME – The name of the project.

Ÿ      LEADER – The employee ID for the leader of the project.

Ÿ      DESC – The description for the project.

Ÿ      STATUS – The status of the Project "A" for active, "E" for Estimate. "F" for Finished, "Q" for Quotation and "T" for Terminated.

Ÿ      GROUP – The group ID for the project group this project belongs to.

Ÿ      START – The start date for the project.

Ÿ      END – The end date for the project.

Ÿ      BILL – The billing for the project. "E" for Estimated Hours, "F" for Fixed Cost etc.

Ÿ      COST – The fixed cost for a project.

Ÿ      ACTASSONLY – Show only Active Assignments.

Ÿ      RESENTRY – Prevent Entries outside view date range.

Ÿ      TARGET – The target for a project.

Ÿ      LINK – "T" if the project is linked, "F" otherwise.

Ÿ      LINKPATH – If the project is linked, this field contains the path to the MS Project file.

Ÿ      ARCHIVE – "T" if the project is flagged for archive, "F" otherwise.

Ÿ      OUTSIDE – Can contain information not internally used by the software. Is used by the Import/Export tool, and can also be used for other customizable purposes.

Ÿ      HIDE – "T" if the item is to be hidden in project lists, "F" otherwise.

Ÿ      INTEGRATE – This field contains Quick Books link information, which is used internally by the software.

Ÿ      TRABILLABLE – "T" to set this project’s time entries as default billable, "F" otherwise.

Ÿ      EXPBILLABLE - "T" to set this project’s expense entries as default billable, "F" otherwise.