JDBC Driver for Sage Intacct

Build 22.0.8462

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

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