PjEstimate
Retreives Project Estimate report data
Table Specific Information
When updating the PjEstimate table, Sage Intacct needs to have LocationsId or ClientID connection properties set if updating IsPrimary field. One Entity-Level Project Estimate cannot be updated from the Top-Level. Therefore when updating the Project Estimate table, you must provide an ID representing the Entity to which the Project Estimate relates. The Above properties must be configured to the value of the MegaEntityId column, which is found in the ProjectEstimate table.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | Long | True |
Record number |
| Pjestimateid | String | False |
Estimate ID |
| Description | String | False |
Description |
| Estimatedate | Date | False |
Estimate date |
| Isprimary | Bool | False |
Primary |
| Status | String | False |
Active/Inactive/Finalized |
| Posted | Bool | False |
Post to GL budgets |
| Glbudgetheaderkey | Long | True |
GL Budget Header Key |
| Glbudgetid | String | False |
GL budget ID |
| Postto | String | False |
Posting period |
| Projectkey | Long | True |
Project key |
| Projectid | String | False |
Project ID |
| Projectname | String | True |
Project name |
| Pjestimatetypekey | Long | True |
Estimate type key |
| Pjestimatetypename | String | False |
Estimate type |
| Selectedwftypes | String | True |
Selected estimate entry workflow types |
| Currency | String | True |
Currency |
| Projectbegindate | Date | True |
Project begin date |
| Projectenddate | Date | True |
Project end date |
| Total | Decimal | True |
Estimate total |
| Locationkey | Long | True |
Location key |
| Locationid | String | True |
Location |
| Locationname | String | True |
Location name |
| Parentprojectkey | Long | True |
Parent project key |
| Parentprojectid | String | True |
Parent project ID |
| Parentprojectname | String | True |
Parent project name |
| Customerkey | Long | True |
Customer key |
| Customerid | String | True |
Customer |
| Customername | String | True |
Customer name |
| Supdocid | String | False |
Attachment |
| Whenmodified | Datetime | True |
timestamp marking last time this was changed. |
| Whencreated | Datetime | True |
timestamp marking last time this was created. |
| Modifiedby | Long | True |
User who modified this. |
| Createdby | Long | True |
User who created this. |
| Megaentitykey | Long | True |
No description specified |
| Megaentityid | String | True |
No description specified |
| Megaentityname | String | True |
No description specified |