Project Costing (PPM) table where Invoice numbers stores.
SummaryProject Costing (PPM) table where Invoice numbers stores.
I am in development of Project reports. I have to capture AP invoices details which are created for projects.
In Project costing tables I am not getting neither AP invoices number nor Invoice_Line_ID.
For one project multiple invoices are created, In application front end (Manage Project Cost area) I can see multiple lines created for the same project.
Anyone please help me to find the table name or sql query to get Project number, Expenditure_Item_ID & AP Invoice number.