URGENT HELP:Adding new fields to Contract Document table in MA & AGR.

[Former Member]

We have a requirement to add a new field to the contract document table for Master agreement & agreement.

I created an extension attribute in the default extension but not able to position it in Contract document table as a column.

Please advice.

[kushagra_agrawal]

Hi Pawan,

You hve to add the field in Contract Document extension and in the query use the below syntax when you are refering to the extension table

SELECT UNIQUE <%RESULTS%> FROM <%SCHEMA%>.FCI_CONGEN_CONTRACT_DOC T1 LEFT OUTER JOIN <%EXT_TABLE(doccommon.ContractDocument)%> T2

ON T1.OBJECTID = T2.PARENT_OBJECT_ID

Please let me know if it helps.

Thanks

Kushagra