JDBC Driver for Sage Intacct

Build 20.0.7654

TimesheetEntry

Retrieves TimesheetEntry report data.

Columns

Name Type Description
Recordno [KEY] String The Recordno field of the TimesheetEntry object.
Lineno Int64 The Lineno field of the TimesheetEntry object.
Timesheetkey Int64 The Timesheetkey field of the TimesheetEntry object.
Projectkey Int64 The Projectkey field of the TimesheetEntry object.
Projectid String The Projectid field of the TimesheetEntry object.
Projectname String The Projectname field of the TimesheetEntry object.
Project_classid String The Project_classid field of the TimesheetEntry object.
Taskkey Int64 The Taskkey field of the TimesheetEntry object.
Taskname String The Taskname field of the TimesheetEntry object.
Task_classid String The Task_classid field of the TimesheetEntry object.
Customerkey Int64 The Customerkey field of the TimesheetEntry object.
Customerid String The Customerid field of the TimesheetEntry object.
Customername String The Customername field of the TimesheetEntry object.
Itemkey Int64 The Itemkey field of the TimesheetEntry object.
Itemid String The Itemid field of the TimesheetEntry object.
Itemname String The Itemname field of the TimesheetEntry object.
Entrydate Datetime The Entrydate field of the TimesheetEntry object.
Qty Double The Qty field of the TimesheetEntry object.
Description String The Description field of the TimesheetEntry object.
Notes String The Notes field of the TimesheetEntry object.
State String The State field of the TimesheetEntry object.
Locationkey Int64 The Locationkey field of the TimesheetEntry object.
Locationid String The Locationid field of the TimesheetEntry object.
Locationname String The Locationname field of the TimesheetEntry object.
Departmentkey Int64 The Departmentkey field of the TimesheetEntry object.
Departmentid String The Departmentid field of the TimesheetEntry object.
Departmentname String The Departmentname field of the TimesheetEntry object.
Timetypekey Int64 The Timetypekey field of the TimesheetEntry object.
Timetype String The Timetype field of the TimesheetEntry object.
Timetype_earningtypekey Int64 The Timetype_earningtypekey field of the TimesheetEntry object.
Timetype_glaccountkey Int64 The Timetype_glaccountkey field of the TimesheetEntry object.
Timetype_gloffsetaccountkey Int64 The Timetype_gloffsetaccountkey field of the TimesheetEntry object.
Billable Boolean The Billable field of the TimesheetEntry object.
Billed String The Billed field of the TimesheetEntry object.
Employeedimkey Int64 The Employeedimkey field of the TimesheetEntry object.
Employeeid String The Employeeid field of the TimesheetEntry object.
Employeename String The Employeename field of the TimesheetEntry object.
Employee_earningtypekey Int64 The Employee_earningtypekey field of the TimesheetEntry object.
Ts_begindate Datetime The Ts_begindate field of the TimesheetEntry object.
Ts_enddate Datetime The Ts_enddate field of the TimesheetEntry object.
Ts_locationkey Int64 The Ts_locationkey field of the TimesheetEntry object.
Ts_locationid String The Ts_locationid field of the TimesheetEntry object.
Statjournalkey Int64 The Statjournalkey field of the TimesheetEntry object.
Billuacctkey Int64 The Billuacctkey field of the TimesheetEntry object.
Nonbilluacctkey Int64 The Nonbilluacctkey field of the TimesheetEntry object.
Billnuacctkey Int64 The Billnuacctkey field of the TimesheetEntry object.
Nonbillnuacctkey Int64 The Nonbillnuacctkey field of the TimesheetEntry object.
Statglbatchkey Int64 The Statglbatchkey field of the TimesheetEntry object.
Statglentrylineno Int64 The Statglentrylineno field of the TimesheetEntry object.
Laborglbatchkey Int64 The Laborglbatchkey field of the TimesheetEntry object.
Laborglentrylineno Int64 The Laborglentrylineno field of the TimesheetEntry object.
Laborglentryoffsetlineno Int64 The Laborglentryoffsetlineno field of the TimesheetEntry object.
Laborglentryamount Double The Laborglentryamount field of the TimesheetEntry object.
Laborglentrytrxamount Double The Laborglentrytrxamount field of the TimesheetEntry object.
Laborglentrycostrate Double The Laborglentrycostrate field of the TimesheetEntry object.
Statglentryamount Double The Statglentryamount field of the TimesheetEntry object.
Varglentryamount Double The Varglentryamount field of the TimesheetEntry object.
Varglentrytrxamount Double The Varglentrytrxamount field of the TimesheetEntry object.
Varglbatchkey Int64 The Varglbatchkey field of the TimesheetEntry object.
Varglentrylineno Int64 The Varglentrylineno field of the TimesheetEntry object.
Varglentryoffsetlineno Int64 The Varglentryoffsetlineno field of the TimesheetEntry object.
Clznamount Double The Clznamount field of the TimesheetEntry object.
Extcostrate String The Extcostrate field of the TimesheetEntry object.
Extbillrate String The Extbillrate field of the TimesheetEntry object.
Whencreated Datetime The Whencreated field of the TimesheetEntry object.
Whenmodified Datetime The Whenmodified field of the TimesheetEntry object.
Createdby Int64 The Createdby field of the TimesheetEntry object.
Modifiedby Int64 The Modifiedby field of the TimesheetEntry object.
Projectdimkey Int64 The Projectdimkey field of the TimesheetEntry object.
Vendordimkey Int64 The Vendordimkey field of the TimesheetEntry object.
Vendorid String The Vendorid field of the TimesheetEntry object.
Vendorname String The Vendorname field of the TimesheetEntry object.
Classdimkey Int64 The Classdimkey field of the TimesheetEntry object.
Classid String The Classid field of the TimesheetEntry object.
Classname String The Classname field of the TimesheetEntry object.
Record_url String The Record_url field of the TimesheetEntry object.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7654