Timesheet Create - Sage Intacct Data Target Requirements

Timesheets ensure workers are paid appropriately and help project managers invoice clients and track overall project costs and expenses over time.

Timesheets are used in both Projects and Time & Expenses. You can access Timesheets from both applications, but you need a subscription to Projects if you want to approve timesheets and save timesheets as drafts.

Each time a timesheet entry is submitted, a timesheet approval history object is created for tracking purposes.

Name

 

Required

 

Type

 

Description

 

EMPLOYEEID

Required

string

Employee ID

BEGINDATE

Required

string

Begin date in format mm/dd/yyyy

GLPOSTDATE

Optional

string

GL posting date in format mm/dd/yyyy

DESCRIPTION

Optional

string

Description

SUPDOCID

Optional

string

Attachments ID

STATE

Optional

string

Use Action to be submitted. 

TIMESHEETENTRIES

Required

array of TIMESHEETENTRY

Timesheet entries, must have at least 1.

 
Time Sheet Entry

Name

 

Required

 

Type

 

Description

 

LINENO

Optional

integer

Line number to add entry to.

CUSTOMERID

Optional

string

Customer ID

ITEMID

Optional

string

Item ID

PROJECTID

Optional

string

Project ID

TASKID

Optional

string

Task ID. Do not use if TASKKEY is set.

TASKKEY

Optional

integer

Task RECORDNO. Do not use if TASKID is set.

COSTTYPEID

Optional

string

Cost type ID. Only available when PROJECTID and task are specified. (Construction subscription)

TIMETYPE

Optional

string

Time type

BILLABLE

Optional

boolean

Billable. Use false for No, true for Yes.

EMPPOSITIONID

Optional

string

POSITIONID of an active employee position.

LABORCLASSID

Optional

string

LABORCLASSID of an active labor class.

LABORSHIFTID

Optional

string

LABORSHIFTID of an active labor shift.

LABORUNIONID

Optional

string

LABORUNIONID of an active labor union.

LOCATIONID

Optional

string

LOCATIONID of an active location. Required if company is multi-entity enabled.

DEPARTMENTID

Optional

string

Department ID

ENTRYDATE

Required

string

Entry date in format mm/dd/yyyy

QTY

Required

number

Hours/Quantity

DESCRIPTION

Optional

string

Description

NOTES

Optional

string

Notes

VENDORID

Optional

string

Vendor ID

CLASSID

Optional

string

Class ID

CONTRACTID

Optional

string

Contract ID

WAREHOUSEID

Optional

string

Warehouse ID

EXTBILLRATE

Optional

currency

External bill rate

EXTCOSTRATE

Optional

currency

External cost rate

EXTAMOUNT

Optional

currency

Labor amount

EXTEMPLOYERTAXES

Optional

currency

Employer taxes

EXTFRINGES

Optional

currency

Fringes

EXTCASHFRINGES

Optional

currency

Cash fringes

Custom field name

varies

varies

Custom field names and values as defined for this object.
For a multi-pick-list custom field, implode multiple field values with #~#.