Identify auto-renewing contract

[Lampson_sec]

How can I identify an auto-renewing contract when querying the database directly?

I was looking in BContracts, but couldn't find a field that identified auto-renewal settings.

Thanks!

[Support Team]

Re: Identify auto-renewing contract

Thank you for posting this.

Auto-renewal settings affect all Contracts in the same series therefore you should look at BContractSeries table.

The BContracts and BContractsSeries tables are linked by the SEQID field as all Contracts in the same series have the same SEQID value.

Hope this helps.

[Lampson_sec]

Re: Identify auto-renewing contract

Thanks! I think that's what I need