Condition to display active customer accounts/sites in Customers extract OTBI Report

Summary:

Hi,

We used subject area named "Receivables- Customer real time" to create an OTBI to extract customer master. however, we couldn't find a column in any folder to filter the report data with active customer accounts/sites. we tried using columns named "Account Status" and "site status" but this doesn't work.

the requirement is to filter the report where the "account termination date" or "site termination date" is before system date.

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):