ADO.NET Provider for Sage Intacct

Build 26.0.9655

TimesheetLine

Represents individual lines within a timesheet, capturing hours worked, billable status, labor class and shift assignments, external payroll details, and time type references.

Columns

Name Type ReadOnly Description
auditCreatedBy String True

The user who created the timesheet line.

auditCreatedDateTime Datetime True

The date and time when the timesheet line was created.

auditModifiedBy String True

The user who last modified the timesheet line.

auditModifiedDateTime Datetime True

The date and time when the timesheet line was last modified.

description String False

The description of this timesheet line.

entryDate Date False

The date on which time was recorded for this timesheet line.

externalPayrollAmount Decimal False

The external payroll amount associated with this timesheet line.

externalPayrollBillingRate Decimal False

The billing rate from the external payroll system for this timesheet line.

externalPayrollCashFringes Decimal False

The cash fringes amount from the external payroll system for this timesheet line.

externalPayrollCostRate Decimal False

The cost rate from the external payroll system for this timesheet line.

externalPayrollEmployerTaxes Decimal False

The employer taxes amount from the external payroll system for this timesheet line.

externalPayrollFringes Decimal False

The total fringes amount from the external payroll system for this timesheet line.

hoursApproved Decimal True

The total approved hours on this timesheet line.

hoursApprovedBillable Decimal True

The approved billable hours on this timesheet line.

hoursApprovedNonBillable Decimal True

The approved non-billable hours on this timesheet line.

hoursApprovedNonUtilized Decimal True

The approved non-utilized hours on this timesheet line.

hoursApprovedUtilized Decimal True

The approved utilized hours on this timesheet line.

hoursBillable Decimal True

The total billable hours recorded on this timesheet line.

hoursNonBillable Decimal True

The total non-billable hours recorded on this timesheet line.

hoursNonUtilized Decimal True

The total non-utilized hours recorded on this timesheet line.

hoursUtilized Decimal True

The total utilized hours recorded on this timesheet line.

href String True

The URL of the timesheet line resource.

id String True

The unique identifier of the timesheet line record.

isBillable Bool False

Indicates whether this timesheet line is billable to a customer.

isBilled String True

The billing status of this timesheet line, indicating whether it has been billed.

key [KEY] String True

The system-assigned key that uniquely identifies the timesheet line record.

laborClass_Href String True

The URL of the labor class associated with this timesheet line.

laborClass_Id String False

The Id of the labor class associated with this timesheet line.

laborClass_Key String False

The system-assigned key of the labor class associated with this timesheet line.

laborClass_Name String True

The name of the labor class associated with this timesheet line.

laborShift_Href String True

The URL of the labor shift associated with this timesheet line.

laborShift_Id String False

The Id of the labor shift associated with this timesheet line.

laborShift_Key String False

The system-assigned key of the labor shift associated with this timesheet line.

laborShift_Name String True

The name of the labor shift associated with this timesheet line.

laborUnion_Href String True

The URL of the labor union associated with this timesheet line.

laborUnion_Id String False

The Id of the labor union associated with this timesheet line.

laborUnion_Key String False

The system-assigned key of the labor union associated with this timesheet line.

laborUnion_Name String True

The name of the labor union associated with this timesheet line.

lineNumber Int True

The line number of this timesheet line within its parent timesheet.

notes String False

The notes or comments recorded on this timesheet line.

quantity Decimal False

The quantity of hours or units recorded on this timesheet line.

state String True

The current state of this timesheet line, such as draft, submitted, or approved.

timeType_Href String True

The URL of the time type associated with this timesheet line.

timeType_Id String False

The Id of the time type associated with this timesheet line.

timeType_Key String False

The system-assigned key of the time type associated with this timesheet line.

timesheet_Href String True

The URL of the timesheet associated with this timesheet line.

timesheet_Id String False

The Id of the timesheet associated with this timesheet line.

timesheet_Key String False

The system-assigned key of the timesheet associated with this timesheet line.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9655