The discussion that follows presumes that any joining of tables or file copying necessary to produce test data was done so under adequate controls to preserve data integrity. These files may reside on either a mainframe or a PC. The audit tests described next are applicable to both environments. The focus is on explaining the logic underlying various substantive tests and on illustrating the functionality of ACL in achieving audit objectives.