| Description | Value |
|---|
| Prepared By | IMAN Auditor |
| Date | 01-19-2009 |
| Reviewed By | G. Audit Supervisor |
| Review Date | 03-24-2009 |
| Audit Step | 36 |
| Audit Objective | Extract all invoices which have the character sequence 247 in any position in the invoice number |
| Data Source | c:\test\data\EWP.xls |
| Date Run | 04-19-09 17:13:15 |
| Table/WorkSheet | Trans$ |
| Column | (none) |
| Command | extract - Extract data based upon criteria specified |
| Parameters Used | (none) |
| First Parameter | (none) |
| Where | instr([Invoice Number],'247') = -1 |
| Second Parameter | (none) |
| SQL used | select * from [Trans$] where instr([Invoice Number],'247') = -1 |
| Processing status | Normal process - 0 rows |
| Finding (Condition, Cause, Effect) | |
| Conclusions | |
| Recommendations | |
| Discussed with | |
| Management agrees? | |
| Management comments | |
| Auditor comments | |
|
