Workflow Cancellation Report

[Former Member]

Hi,

I am new to CLM

I was trying to customize the Workflow cancellation report to add more fields from Master Agreement and Sub Agreement, but I could not find the foreign keys to connect the below tables.

FCI_WORK_PROCESS

FCI_WORK_ PROC TEMPLATE

FCI_CONTRACT

FCI_AGREEMENT

FCI_CONTRACT

FCI_CONGEN_CONTRACT_DOC

Can any body let me know how they are connected.

Need Experts Advise on this !!

Thanks,

Roopesh

[vikram_shanmugasundaram]

Hi Roopesh,

My suggestion would be look at some of the standard Query Definitions in the system and see how the tables are joined. I would start with the Current Workflow Processes report FCI-WorkflowCurrentProcesses.

Regards,

Vikram