Project
Manages project records, capturing essential details like budget allocations, operational status, and relevant dimensions.
Table Specific Information
Select
- In the Legacy API, SELECT * queries return not only the columns documented below, but additional columns as well.
- In the non-Legacy API, you cannot use SELECT * with this table. You should build a query with the columns listed below, for example:
SELECT Projectid, Name, Description, Projectstatuskey, Begindate, Enddate FROM Project
Columns
| Name | Type | ReadOnly | Description |
| Recordno | Int64 | False |
Unique identifier for the project entry. |
| Projectid [KEY] | String | False |
Identifier for the project. |
| Name | String | False |
Name of the project. |
| Description | String | False |
Description of the project. |
| Currency | String | False |
Currency associated with the project. |
| Projectcategory | String | False |
Category of the project. |
| Projectstatuskey | Int64 | False |
Key for the project's status. |
| Projectstatus | String | False |
Current status of the project. |
| Preventtimesheet | Boolean | False |
Indicates if timesheets are prevented for this project. |
| Preventexpense | Boolean | False |
Indicates if expenses are prevented for this project. |
| Preventappo | Boolean | False |
Indicates if purchase orders are prevented for this project. |
| Preventgeninvoice | Boolean | False |
Indicates if general invoices are prevented for this project. |
| Status | String | False |
Overall status of the project. |
| Begindate | Datetime | False |
Start date of the project. |
| Enddate | Datetime | False |
End date of the project. |
| Budgetamount | Double | False |
Total budget amount allocated for the project. |
| Contractamount | Double | False |
Total contracted amount for the project. |
| Actualamount | Double | False |
Total actual amount spent on the project. |
| Budgetqty | Double | False |
Budgeted quantity for the project. |
| Estqty | Double | False |
Estimated quantity for the project. |
| Actualqty | Double | False |
Actual quantity used in the project. |
| Approvedqty | Double | False |
Approved quantity for the project. |
| Remainingqty | Double | False |
Remaining quantity available for the project. |
| Percentcomplete | Double | False |
Percentage of the project completed. |
| Obspercentcomplete | Double | False |
Observed percentage of the project completed. |
| Billingtype | String | False |
Billing type associated with the project. |
| Sonumber | String | False |
Sales order number associated with the project. |
| Ponumber | String | False |
Purchase order number associated with the project. |
| Poamount | Double | False |
Amount associated with the purchase order for the project. |
| Pqnumber | String | False |
Project quotation number associated with the project. |
| Sfdckey | String | False |
Salesforce key associated with the project. |
| Qarrowkey | String | False |
Qarrow key associated with the project. |
| Oakey | String | False |
OA key associated with the project. |
| Parentkey | Int64 | False |
Key for the parent project, if applicable. |
| Parentid | String | False |
Identifier for the parent project, if applicable. |
| Parentname | String | False |
Name of the parent project, if applicable. |
| Invoicewithparent | Boolean | False |
Indicates if invoices are generated with the parent project. |
| Customerkey | Int64 | False |
Key for the customer associated with the project. |
| Customerid | String | False |
Identifier for the customer associated with the project. |
| Customername | String | False |
Name of the customer associated with the project. |
| Salescontactkey | Int64 | False |
Key for the sales contact associated with the project. |
| Salescontactid | String | False |
Identifier for the sales contact associated with the project. |
| Salescontactname | String | False |
Name of the sales contact associated with the project. |
| Projecttypekey | Int64 | False |
Key for the type of project. |
| Projecttype | String | False |
Type of project. |
| Managerkey | Int64 | False |
Key for the manager associated with the project. |
| Managerid | String | False |
Identifier for the manager associated with the project. |
| Managercontactname | String | False |
Name of the manager associated with the project. |
| Projectdeptkey | Int64 | False |
Key for the department associated with the project. |
| Departmentid | String | False |
Identifier for the department associated with the project. |
| Departmentname | String | False |
Name of the department associated with the project. |
| Projectlocationkey | Int64 | False |
Key for the location associated with the project. |
| Locationid | String | False |
Identifier for the location associated with the project. |
| Locationname | String | False |
Name of the location associated with the project. |
| Contactinfo_contactname | String | False |
Name of the contact associated with the project. |
| Shipto_contactname | String | False |
Name of the 'ship to' contact for the project. |
| Billto_contactname | String | False |
Name of the 'bill to' contact for the project. |
| Termskey | Int64 | False |
Key for the terms associated with the project. |
| Termname | String | False |
Name of the terms associated with the project. |
| Docnumber | String | False |
Document number associated with the project. |
| Custuserkey | Int64 | False |
Key for the customer user associated with the project. |
| Custuserid | String | False |
Identifier for the customer user associated with the project. |
| Whencreated | Datetime | False |
Timestamp when the project was created. |
| Whenmodified | Datetime | False |
Timestamp when the project was last modified. |
| Createdby | Int64 | False |
User ID of the creator of the project. |
| Modifiedby | Int64 | False |
User ID of the person who last modified the project. |
| Budgetedcost | Double | False |
Total budgeted cost for the project. |
| Classid | String | False |
Identifier for the class associated with the project. |
| Classname | String | False |
Name of the class associated with the project. |
| Classkey | Int64 | False |
Key for the class associated with the project. |
| Userrestrictions | String | False |
Restrictions applied to users for the project. |
| Billableexpdefault | Boolean | False |
Indicates if billable expenses are enabled by default for the project. |
| Billableappodefault | Boolean | False |
Indicates if billable AP purchase orders are enabled by default for the project. |
| Budgetid | String | False |
Identifier for the budget associated with the project. |
| Budgetkey | Int64 | False |
Key for the budget associated with the project. |
| Billingrate | Double | False |
Billing rate applied to the project. |
| Billingpricing | String | False |
Billing pricing strategy for the project. |
| Expenserate | Double | False |
Expense rate applied to the project. |
| Expensepricing | String | False |
Expense pricing strategy for the project. |
| Poaprate | Double | False |
Rate applied for AP purchase orders in the project. |
| Poappricing | String | False |
Pricing strategy for AP purchase orders in the project. |
| Contactkey | Int64 | False |
Key for the contact associated with the project. |
| Shiptokey | Int64 | False |
Key for the 'ship to' contact associated with the project. |
| Billtokey | Int64 | False |
Key for the 'bill to' contact associated with the project. |
| Invoicemessage | String | False |
Message associated with project invoices. |
| Invoicecurrency | String | False |
Currency used for invoices in the project. |
| Megaentitykey | Int64 | False |
Key for the mega entity associated with the project. |
| Megaentityid | String | False |
Identifier for the mega entity associated with the project. |
| Megaentityname | String | False |
Name of the mega entity associated with the project. |
| Record_url | String | False |
URL linking to the record associated with the project. |