JDBC Driver for Sage Intacct

Build 22.0.8462

Project

Retrieves Project report data.

Columns

Name Type ReadOnly Description
Recordno Int64 False

The Recordno field of the Project object.

Projectid [KEY] String False

The Projectid field of the Project object.

Name String False

The Name field of the Project object.

Description String False

The Description field of the Project object.

Currency String False

The Currency field of the Project object.

Projectcategory String False

The Projectcategory field of the Project object.

Projectstatuskey Int64 False

The Projectstatuskey field of the Project object.

Projectstatus String False

The Projectstatus field of the Project object.

Preventtimesheet Boolean False

The Preventtimesheet field of the Project object.

Preventexpense Boolean False

The Preventexpense field of the Project object.

Preventappo Boolean False

The Preventappo field of the Project object.

Preventgeninvoice Boolean False

The Preventgeninvoice field of the Project object.

Status String False

The Status field of the Project object.

Begindate Datetime False

The Begindate field of the Project object.

Enddate Datetime False

The Enddate field of the Project object.

Budgetamount Double False

The Budgetamount field of the Project object.

Contractamount Double False

The Contractamount field of the Project object.

Actualamount Double False

The Actualamount field of the Project object.

Budgetqty Double False

The Budgetqty field of the Project object.

Estqty Double False

The Estqty field of the Project object.

Actualqty Double False

The Actualqty field of the Project object.

Approvedqty Double False

The Approvedqty field of the Project object.

Remainingqty Double False

The Remainingqty field of the Project object.

Percentcomplete Double False

The Percentcomplete field of the Project object.

Obspercentcomplete Double False

The Obspercentcomplete field of the Project object.

Billingtype String False

The Billingtype field of the Project object.

Sonumber String False

The Sonumber field of the Project object.

Ponumber String False

The Ponumber field of the Project object.

Poamount Double False

The Poamount field of the Project object.

Pqnumber String False

The Pqnumber field of the Project object.

Sfdckey String False

The Sfdckey field of the Project object.

Qarrowkey String False

The Qarrowkey field of the Project object.

Oakey String False

The Oakey field of the Project object.

Parentkey Int64 False

The Parentkey field of the Project object.

Parentid String False

The Parentid field of the Project object.

Parentname String False

The Parentname field of the Project object.

Invoicewithparent Boolean False

The Invoicewithparent field of the Project object.

Customerkey Int64 False

The Customerkey field of the Project object.

Customerid String False

The Customerid field of the Project object.

Customername String False

The Customername field of the Project object.

Salescontactkey Int64 False

The Salescontactkey field of the Project object.

Salescontactid String False

The Salescontactid field of the Project object.

Salescontactname String False

The Salescontactname field of the Project object.

Projecttypekey Int64 False

The Projecttypekey field of the Project object.

Projecttype String False

The Projecttype field of the Project object.

Managerkey Int64 False

The Managerkey field of the Project object.

Managerid String False

The Managerid field of the Project object.

Managercontactname String False

The Managercontactname field of the Project object.

Projectdeptkey Int64 False

The Projectdeptkey field of the Project object.

Departmentid String False

The Departmentid field of the Project object.

Departmentname String False

The Departmentname field of the Project object.

Projectlocationkey Int64 False

The Projectlocationkey field of the Project object.

Locationid String False

The Locationid field of the Project object.

Locationname String False

The Locationname field of the Project object.

Contactinfo_contactname String False

The Contactinfo_contactname field of the Project object.

Shipto_contactname String False

The Shipto_contactname field of the Project object.

Billto_contactname String False

The Billto_contactname field of the Project object.

Termskey Int64 False

The Termskey field of the Project object.

Termname String False

The Termname field of the Project object.

Docnumber String False

The Docnumber field of the Project object.

Custuserkey Int64 False

The Custuserkey field of the Project object.

Custuserid String False

The Custuserid field of the Project object.

Whencreated Datetime False

The Whencreated field of the Project object.

Whenmodified Datetime False

The Whenmodified field of the Project object.

Createdby Int64 False

The Createdby field of the Project object.

Modifiedby Int64 False

The Modifiedby field of the Project object.

Budgetedcost Double False

The Budgetedcost field of the Project object.

Classid String False

The Classid field of the Project object.

Classname String False

The Classname field of the Project object.

Classkey Int64 False

The Classkey field of the Project object.

Userrestrictions String False

The Userrestrictions field of the Project object.

Billableexpdefault Boolean False

The Billableexpdefault field of the Project object.

Billableappodefault Boolean False

The Billableappodefault field of the Project object.

Budgetid String False

The Budgetid field of the Project object.

Budgetkey Int64 False

The Budgetkey field of the Project object.

Billingrate Double False

The Billingrate field of the Project object.

Billingpricing String False

The Billingpricing field of the Project object.

Expenserate Double False

The Expenserate field of the Project object.

Expensepricing String False

The Expensepricing field of the Project object.

Poaprate Double False

The Poaprate field of the Project object.

Poappricing String False

The Poappricing field of the Project object.

Contactkey Int64 False

The Contactkey field of the Project object.

Shiptokey Int64 False

The Shiptokey field of the Project object.

Billtokey Int64 False

The Billtokey field of the Project object.

Invoicemessage String False

The Invoicemessage field of the Project object.

Invoicecurrency String False

The Invoicecurrency field of the Project object.

Megaentitykey Int64 False

The Megaentitykey field of the Project object.

Megaentityid String False

The Megaentityid field of the Project object.

Megaentityname String False

The Megaentityname field of the Project object.

Record_url String False

The Record_url field of the Project object.

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