Time
Time
68 columns Fetched February 27, 2026
Columns
Time_RecID Numeric
Also in 5 reports
member_recid Numeric nullable
member_id Text
first_name Text nullable
last_name Text nullable
Owner_Level_RecID Numeric
Also in 48 reports
Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Member Owner Level Portal Agr Type Portal Invoices Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location
Location Text nullable
Billing_Log_RecID Numeric nullable
BusGroup Text nullable
Billing_Unit_RecID Numeric
Also in 29 reports
Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Member Portal Agr Type Project Header Purchase Order Purchase Order Template Service Code Service Item Service Status Service Sub Type Service Team Service Type User Defined Field Billing Units Warehouse Warehouse Bin
Company_RecID Numeric
Also in 44 reports
Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code Company Company Address Company Company Type Descriptions Company Company Types Company Custom Fields Company Group Company Markets Company Mgmt Company State Tax Rate Company Team Company Work Roles Company Work Types Configuration Contact Contact Group Document Expense Invoice Expense Invoice Header Invoice Time Invoices Management Report Setup Member Certifications Opportunity Opportunity Restricted Portal Config Names Portal Invoices Pricing Schedule Project Header Purchase Order Template Sales Commission Sales Order Service Location Service Summary Service Summary Open Unposted Expense Unposted Invoice Warehouse
company_name Text nullable
te_status_id Numeric
time_status Text nullable
Activity_Subject Text nullable
option_id Text nullable
billable_flag Boolean
invoice_flag Boolean
Date_Start DateTime nullable
time_start DateTime nullable
time_end DateTime nullable
date_entered_utc DateTime
work_role Text nullable
work_type Text nullable
Hourly_Rate Numeric nullable
Hourly_Cost Text nullable
hours_actual Numeric
Billable_Amt Numeric nullable
Billable_Hrs Numeric nullable
NonBillable_Hrs Numeric nullable
AgrAmtCovered Numeric
AgrHrsCovered Numeric
InvAdj_Total Numeric
InvAdj_Firm Numeric nullable
AgrAdj_Total Numeric
AgrAdj_Firm Numeric nullable
Agreement Text
PM_Project_RecID Numeric
project_name Text nullable
Project_Phase Text nullable
Project_Activity Text nullable
Charge_Code Text nullable
SR_Service_RecID Numeric
Also in 21 reports
Document Expense Invoice Expense Invoice Product Invoice Time Project Schedule Screen Connect Session Service Service Custom Fields Service Metrics Aging Service Metrics Counts Service Note Service Task Service Open Service SLA Service Summary Service Summary Open Surveys By Ticket Ticket Audit Transaction
sr_summary Text nullable
sr_status Text nullable
TE_Charge_Code_RecID Numeric nullable
Also in 2 reports
SO_Activity_RecID Numeric nullable
Also in 2 reports
Opportunity_RecID Numeric nullable
charge_to Text nullable
Invoice_Number Text nullable
date_invoice DateTime nullable
Notes Text nullable
internal_note Text nullable
Territory Text nullable
Time_Sheet_RecID Numeric nullable
Also in 3 reports
Updated_By Text nullable
Last_Update_UTC DateTime nullable
Last_Update DateTime nullable
Time_Zone Text nullable
Utilization_Flag Boolean nullable
NonBillable_Amt Numeric nullable
Actual_Utilized_Hrs Numeric nullable
Billable_Utilized_Hrs Numeric nullable
Hourly_Cost_Decimal Numeric nullable
AGR_Header_RecID Numeric nullable
Also in 20 reports
Invoice_Ready Numeric
Time_Start_UTC DateTime nullable
Time_End_UTC DateTime nullable
| Name | Type | Nullable | Also In |
|---|---|---|---|
| Time_RecID | Numeric | No | |
| member_recid | Numeric | Yes | unique |
| member_id | Text | No | unique |
| first_name | Text | Yes | unique |
| last_name | Text | Yes | unique |
| Owner_Level_RecID | Numeric | No | 48 reports Accounts Receivable Aging Agr Type Billing Setup Billing Unit Location Charge Code Company Company Team Company Work Roles Company Work Types Configs Configuration Contacts Expense Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Marketing Campaign Member Owner Level Portal Agr Type Portal Invoices Portal Project Portal Ticket Types Price Header Pricing Schedule Project Header Purchase Order Purchase Order Template Sales Commission Service Board Service Code Service Item Service Status Service Sub Type Service Team Service Type Transaction Unposted Expense Unposted Invoice Unposted Procurement User Defined Field Owner Levels Warehouse Warehouse Bin Work Roles Location |
| Location | Text | Yes | unique |
| Billing_Log_RecID | Numeric | Yes | |
| BusGroup | Text | Yes | unique |
| Billing_Unit_RecID | Numeric | No | 29 reports Accounts Receivable Aging Agr Type Billing Unit Billing Unit Location Charge Code Company Team Configs Configuration Invoice Header Invoice Time Invoices Kb Resolution Audit Trail Knowledgebase Category Knowledgebase Sub Category Location Bus Group Member Portal Agr Type Project Header Purchase Order Purchase Order Template Service Code Service Item Service Status Service Sub Type Service Team Service Type User Defined Field Billing Units Warehouse Warehouse Bin |
| Company_RecID | Numeric | No | 44 reports Accounts Receivable Aging Activity Agr Config Renewals Agr Site Agreement Invoice Charge Code Company Company Address Company Company Type Descriptions Company Company Types Company Custom Fields Company Group Company Markets Company Mgmt Company State Tax Rate Company Team Company Work Roles Company Work Types Configuration Contact Contact Group Document Expense Invoice Expense Invoice Header Invoice Time Invoices Management Report Setup Member Certifications Opportunity Opportunity Restricted Portal Config Names Portal Invoices Pricing Schedule Project Header Purchase Order Template Sales Commission Sales Order Service Location Service Summary Service Summary Open Unposted Expense Unposted Invoice Warehouse |
| company_name | Text | Yes | unique |
| te_status_id | Numeric | No | unique |
| time_status | Text | Yes | unique |
| Activity_Subject | Text | Yes | unique |
| option_id | Text | Yes | unique |
| billable_flag | Boolean | No | unique |
| invoice_flag | Boolean | No | unique |
| Date_Start | DateTime | Yes | unique |
| time_start | DateTime | Yes | unique |
| time_end | DateTime | Yes | unique |
| date_entered_utc | DateTime | No | unique |
| work_role | Text | Yes | unique |
| work_type | Text | Yes | unique |
| Hourly_Rate | Numeric | Yes | unique |
| Hourly_Cost | Text | Yes | unique |
| hours_actual | Numeric | No | unique |
| Billable_Amt | Numeric | Yes | unique |
| Billable_Hrs | Numeric | Yes | unique |
| NonBillable_Hrs | Numeric | Yes | unique |
| AgrAmtCovered | Numeric | No | unique |
| AgrHrsCovered | Numeric | No | unique |
| InvAdj_Total | Numeric | No | unique |
| InvAdj_Firm | Numeric | Yes | unique |
| AgrAdj_Total | Numeric | No | unique |
| AgrAdj_Firm | Numeric | Yes | unique |
| Agreement | Text | No | unique |
| PM_Project_RecID | Numeric | No | |
| project_name | Text | Yes | unique |
| Project_Phase | Text | Yes | unique |
| Project_Activity | Text | Yes | unique |
| Charge_Code | Text | Yes | unique |
| SR_Service_RecID | Numeric | No | 21 reports Document Expense Invoice Expense Invoice Product Invoice Time Project Schedule Screen Connect Session Service Service Custom Fields Service Metrics Aging Service Metrics Counts Service Note Service Task Service Open Service SLA Service Summary Service Summary Open Surveys By Ticket Ticket Audit Transaction |
| sr_summary | Text | Yes | unique |
| sr_status | Text | Yes | unique |
| TE_Charge_Code_RecID | Numeric | Yes | 2 reports |
| SO_Activity_RecID | Numeric | Yes | 2 reports |
| Opportunity_RecID | Numeric | Yes | |
| charge_to | Text | Yes | unique |
| Invoice_Number | Text | Yes | unique |
| date_invoice | DateTime | Yes | unique |
| Notes | Text | Yes | unique |
| internal_note | Text | Yes | unique |
| Territory | Text | Yes | unique |
| Time_Sheet_RecID | Numeric | Yes | |
| Updated_By | Text | Yes | unique |
| Last_Update_UTC | DateTime | Yes | unique |
| Last_Update | DateTime | Yes | unique |
| Time_Zone | Text | Yes | unique |
| Utilization_Flag | Boolean | Yes | unique |
| NonBillable_Amt | Numeric | Yes | unique |
| Actual_Utilized_Hrs | Numeric | Yes | unique |
| Billable_Utilized_Hrs | Numeric | Yes | unique |
| Hourly_Cost_Decimal | Numeric | Yes | unique |
| AGR_Header_RecID | Numeric | Yes | 20 reports |
| Invoice_Ready | Numeric | No | unique |
| Time_Start_UTC | DateTime | Yes | unique |
| Time_End_UTC | DateTime | Yes | unique |