Time_Entry table

Column Type

Time_Entry_Id

String

Project_Id

String

Project_Name

String

Customer_Id

String

Customer_Name

String

Task_Id

String

Task_Name

String

User_Id

String

User_Name

String

Is_Current_User

Boolean

Log_Date

Date

Begin_Time

Timestamp

End_Time

Timestamp

Log_Time

Timestamp

Is_Billable

Boolean

Is_Paused

Boolean

Billed_Status

String

Invoice_Id

String

Notes

String

Timer_Started_At

String

Timer_Started_At_Utc_Time

Timestamp

Timer_Duration_In_Minutes

Number

Timer_Duration_In_Seconds

Number

Created_Time

Timestamp

Timesheet_Custom_Fields

String

Zohopeople_Time_Entry_Id

Timestamp

Can_Create_User_Approval

Boolean

Project_Head_Name

String

Customer_First_Name

String

Can_Create_Client_Approval

Boolean

Project_Head_Id

String

Can_Be_Invoiced

Boolean

Logged_Day

Number

Can_Continue_Timer

Boolean

Billing_Rate_Frequency

String

Is_Client_Approval_Needed

Boolean

Invoice_Number

String

Examples

INSERT INTO
    Time_Entry (Project_Id, Task_Id, Log_Date, Log_Time)
VALUES
    (
        '579676000000093167',
        '579676000000093228',
        '2024-08-14',
        '02:00'
    )
UPDATE Time_Entry
SET
    Log_Time = '03:00'
WHERE
    Time_Entry_Id = '579676000000160017'
DELETE FROM Time_Entry
WHERE
    Time_Entry_Id = '579676000000160017'