TRANS – This table stores all time entries in the Track-IT pro database.
Ÿ ID – The unique ID for a transaction. (PK)
Ÿ PROJECT – The project ID for the transaction. (FK)
Ÿ TASK – The task ID for the transaction. (FK)
Ÿ EMPLOYEE – The employee ID for the transaction. (FK)
Ÿ GROUP – The group ID for the transaction.
Ÿ DATE – The date for the transaction. (FK)
Ÿ START – The start time for the transaction.
Ÿ STOP – The stop time for the transaction.
Ÿ TOTAL – The total time for the transaction.
Ÿ DESC – The description of the transaction.
Ÿ BILLABLE - "T" if the transaction is charged to the client, "F" otherwise.
Ÿ BILLED – "T" if the transaction has already been billed, "F" otherwise.
Ÿ APPROVED – "T" if the transaction is approved, "F" otherwise.
Ÿ EMPRATE – The charge amount per hour.
Ÿ EMPCOST – The wage amount per hour.
Ÿ PRORATE – The prorating for this transaction.
Ÿ OTCOST – The overtime prorating for the wage.
Ÿ OTRATE – The overtime prorating for the charge.
Ÿ RATEID – The charge rate ID.
Ÿ COSTID – The cost rate ID.
Ÿ OTCOSTID – The overtime rule ID for the wage.
Ÿ OTRATEID – The overtime rule ID for the charge.
Ÿ ERROR – "T" if the transaction has an error, "F" otherwise.
Ÿ WASLINKED – "F" if the transaction still needs to be sent to MS Project, "T" 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.
Ÿ INTEGRATE – This field contains Quick Books link information, which is used internally by the software.