Identify auto-renewing contract

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!

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.

Thanks! I think that's what I need