MARIProject Database Structure

/*
 * MARIProject Version 4.9
 * ProjectManagement.SQLScript4.9.HoursBillableWithSalesPrice.sql
 */
 
SELECT 
	MARIProjectTimeKeepingLines.Quantity AS HoursUsed, 
	MARIProjectTimeKeepingLines.InvQty AS HoursBillable, 
	MARIProjectTimeKeepingHeader.EmployeeNumber,
	MARIProjectTimeKeepingLines.ServiceDate AS ServiceDay,
	MARIContract.Customer AS CustomerCode,
	MARIProjectTimeKeepingLinesServices.SalesPrice AS SalesPriceSingle,
	MARIProjectTimeKeepingLines.TargetedRevenues AS SalesPriceValue
FROM MARIProjectTimeKeepingHeader
INNER JOIN MARIProjectTimeKeepingLines 
	ON MARIProjectTimeKeepingHeader.TimeKeepingHeaderID = MARIProjectTimeKeepingLines.TimeKeepingHeaderID
INNER JOIN MARIProjectTimeKeepingLinesServices 
	ON MARIProjectTimeKeepingLinesServices.TimeSheetEntryID = MARIProjectTimeKeepingLines.DocumentID
	AND MARIProjectTimeKeepingLinesServices.PositionID=0
INNER JOIN MARIContract 
	ON MARIContract.ContractID=MARIProjectTimeKeepingLinesServices.ContractID