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

SQL for InterProject Contracts

Received Response
25
Views
1
Comments

We need to build 2 reports for InterProject Contracts and we need to know the relevant tables that can help us fetch the data -

1st Report: InterProject Contract Statuses:

Report Fields: Inter-Project Contract No., Inter-Project Contract Type, Inter-Project Contract Description, Source CapEx ID, Source CapEx Title, Target CapEx ID, Target CapEx Title, Inter-Project Contract created by, Inter-Project Contract submitted date, Inter-Project Contract Status (approved or pending with whom), Inter-Project Contract Approved by, Inter-Project Contract final approval date, Inter-Project Contract Expiry Date.


2nd Report: InterProject Bill & Invoice Statuses:

Report Fields: Inter-Project Draft Bill No., Inter-Project Draft Bill Description, Inter-Project Draft Bill Amount, Inter-Project Draft Bill Type, Inter-Project Draft Bill created by, Inter-Project Draft Bill submitted Date, Inter-Project Draft Bill Status (approved or pending with whom), Inter-Project Draft Bill Approved by, Inter-Project Draft Bill final approval date, Inter-Project Contract No., Source CapEx ID, Source CapEx Title, Target CapEx ID, Target CapEx Title, Referenced AR Invoice No., Referenced AP Invoice No., AP Invoice Status (approved or pending with whom), AP Invoice Approved by, AP Invoice final approval date.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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