JDBC Driver for Sage Intacct

Build 22.0.8462

Task

Retrieves Task report data.

Columns

Name Type ReadOnly Description
Recordno [KEY] String False

The Recordno field of the Task object.

Parentkey Int64 False

The Parentkey field of the Task object.

Name String False

The Name field of the Task object.

Parenttaskname String False

The Parenttaskname field of the Task object.

Projectkey Int64 False

The Projectkey field of the Task object.

Projectid String False

The Projectid field of the Task object.

Projectname String False

The Projectname field of the Task object.

Projectbegindate Datetime False

The Projectbegindate field of the Task object.

Projectenddate Datetime False

The Projectenddate field of the Task object.

Customerkey Int64 False

The Customerkey field of the Task object.

Customerid String False

The Customerid field of the Task object.

Customername String False

The Customername field of the Task object.

Itemkey Int64 False

The Itemkey field of the Task object.

Itemid String False

The Itemid field of the Task object.

Itemname String False

The Itemname field of the Task object.

Pbegindate Datetime False

The Pbegindate field of the Task object.

Penddate Datetime False

The Penddate field of the Task object.

Abegindate Datetime False

The Abegindate field of the Task object.

Aenddate Datetime False

The Aenddate field of the Task object.

Budgetqty Double False

The Budgetqty field of the Task object.

Estqty Double False

The Estqty field of the Task object.

Actualqty Double False

The Actualqty field of the Task object.

Remainingqty Double False

The Remainingqty field of the Task object.

Approvedqty Double False

The Approvedqty field of the Task object.

Percentcomplete Double False

The Percentcomplete field of the Task object.

Obspercentcomplete Double False

The Obspercentcomplete field of the Task object.

Description String False

The Description field of the Task object.

Ismilestone Boolean False

The Ismilestone field of the Task object.

Utilized Boolean False

The Utilized field of the Task object.

Billable Boolean False

The Billable field of the Task object.

Taskno Int64 False

The Taskno field of the Task object.

Priority Int64 False

The Priority field of the Task object.

Taskstatus String False

The Taskstatus field of the Task object.

Timetypekey Int64 False

The Timetypekey field of the Task object.

Timetypename String False

The Timetypename field of the Task object.

Classid String False

The Classid field of the Task object.

Classname String False

The Classname field of the Task object.

Classkey Int64 False

The Classkey field of the Task object.

Whencreated Datetime False

The Whencreated field of the Task object.

Whenmodified Datetime False

The Whenmodified field of the Task object.

Createdby Int64 False

The Createdby field of the Task object.

Modifiedby Int64 False

The Modifiedby field of the Task object.

Record_url String False

The Record_url field of the Task object.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462