MARIProject Database Structure

/*
 * MARIProject Version 4.9
 * ProjectManagement.SQLScript4.9.HotlineIssuesTimeBooking.sql
 * Shows Time Booking on issues
 */

SELECT 
	MARIProjectTimeKeepingLines.SourceReference AS IssueID,
	MARIProjectTimeKeepingLines.Quantity AS HoursUsed, 
	MARIProjectTimeKeepingLines.InvQty AS HoursBillable, 
	MARIProjectTimeKeepingHeader.EmployeeNumber,
	MARIEmployeeMaster.Matchcode AS EmployeeMatchcode,
	MARIProjectTimeKeepingLines.ServiceDate,
	MARIProjectTimeKeepingLines.ActivityText AS Activity,
	MARIContract.Customer AS CustomerCode,
	MARIProjectTimeKeepingLinesServices.SalesPrice AS SalesPriceSingle,
	MARIProjectTimeKeepingLines.TargetedRevenues AS SalesPriceValue
FROM MARIProjectTimeKeepingHeader
INNER JOIN MARIProjectTimeKeepingLines 
	ON MARIProjectTimeKeepingHeader.TimeKeepingHeaderID = MARIProjectTimeKeepingLines.TimeKeepingHeaderID
INNER JOIN MARIEmployeeMaster 
	ON MARIEmployeeMaster.EmployeeNumber=MARIProjectTimeKeepingHeader.EmployeeNumber
LEFT JOIN MARIProjectTimeKeepingLinesServices 
	ON MARIProjectTimeKeepingLinesServices.TimeSheetEntryID = MARIProjectTimeKeepingLines.TimeSheetEntryID
	AND MARIProjectTimeKeepingLinesServices.PositionID=0
LEFT JOIN MARIContract 
	ON MARIContract.ContractID=MARIProjectTimeKeepingLinesServices.ContractID
WHERE SourceType=2