**Description:** We require a crystal report using a SQL Server query language that produces a report as per attached PDF ‘job [login to view URL]’
## Deliverables
**Job Transaction Report**
**Description:** We require a crystal report using a SQL Server query language that produces a report as per attached PDF ‘job [login to view URL]’
**Fields / Table Required**
Header
-? ? ? ? ? ? ? ? ? Client Name. (refer sales order table)
-? ? ? ? ? ? ? ? ? Job Id Number. (refer job line table)
-? ? ? ? ? ? ? ? ? Job Name. (refer job line table)
Body (3 parts to the body)
1. Timesheet information. (refer Grenfell / Hardie etc from first page) (refer timesheet & timesheet line tables)
2. Supplier billing information. (refer southern steels from first page) (refer AP invoice & AP invoice line table)
3. Invoice Information. (refer page 4/6 Gujarat NRE line) (refer AR invoice & AR invoice line tables)
Footer (2 parts)
1. Job totals which are sums of the 3 parts of the body eg labour costs, material costs & invoice totals.
2. Est details found in the quoting part of the accounting software. (refer quote & quote line tables)