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. |