Electronic Work Paper project
Structured query language - SQL
"Under the hood" of the Audit Commander is an industry standard language called Structured Query Language - SQL. Based upon the information and parameters entered by the auditor, the system generates and runs SQL automatically and reports the SQL that was used. This information can be useful in identifying errors such as misspellings, extra commas, etc. The information is necessary for postings to the forum, e-mails and telephone support calls. An example of SQL is shown below:
select round((cost /life),2) as [Estimated Depreciation],* from [fa$]
Note, however, that the auditor does not need to enter this information. It is provided for error identification and training purposes. It also documents the basis for the auditor's tests performed.
