The Smart Dispute Product uses the ConvertTextToAcctNumber function frequently across multiple OOTB report definitions to convert the AccountNumber text property to a decimal.

As mentioned in the SR below, the impact of using a CAST function is that it prevents database indexes from being used, which causes performance impacts.

The enhancement request would be to check if AccountNumber can either be initially declared as a decimal instead of a text property, or to have the AccountNumber converted to a decimal before use through report definitions.  This would allow the reports to run more efficiently and to utilize the needed indexes.

Note that the tickets below were based on custom report definitions sourced from OOTB reports.

SR-121432: Sev4/10 - TDBANK - Explain and Execution plan for SQL Query

INC-242229: Sev2/40 - TDBANK - Report Query Timeout - Prod Only