You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to derive only accounted PPM cost transactions from backend tables?

Accepted answer
edited Aug 28, 2023 9:13AM in Project Management 1 comment


We have a requirement to derive only accounted project cost transactions by creating custom BIP report. Currently I am using pjc_cost_dist_lines_all table in my query to derive cost transactions data. But I am unable to find a column which will specify whether a cost transaction is accounted or not from the table pjc_cost_dist_lines_all.

Can anyone suggest a column or filtering condition it self to extract only accounted project cost transactions?

Version (include the version you are using, if applicable):

23C (


Ankit Bhadja

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!