This project default specifies whether data queries are case sensitive.
If the project default is set to Y, the query is case sensitive; that is, data is only returned if it exactly matches your query in terms of case. Otherwise, it is not returned.
If the project default is set to N, upper and lower case are ignored when querying data.
Example
If a record exists in the database with company name = ABC, this record is only found with project default ZX_QRY_CS = Y if you query for ABC and ZX_QRY_CS = Y.
If the default is set to N, it is found if you query for abc or aBc.
Currently, this feature is only available on the A.10.23 Companies and P.20.01 Suppliers/Subcontractors screens.
-
Module(s) affected by this setting: A1023, P2001
-
Default value: Y
-
List of Values: N/Y