/* System: tServiceType.SQL - Revised on 15/05/2005 */
/* Original - prior to 15/05/2005 */
SELECT SD.*
FROM (SELECT SID2.*, tCentre.Description AS Centre, tActivity.Description AS Activity,
 tElement.ElementCode AS Element, tSubledger.Description AS Subledger, tValidAccountNumber.AccountNo
FROM (((((SELECT SID.*, tServiceType.Code, tServiceType.Description AS ServiceType, tCustomer.ID AS CustomerID,
 tCustomer.ShipTo, tCustomer.FullName AS Customer, tCentre.Description AS CustomerCentre,
 tActivity.Description AS CustomerActivity, tElement.ElementCode AS CustomerElement, tSubledger.Description AS CustomerSubledger,
 tGroup.Description AS GroupDesc, tDepartment.Description AS Department, tLocation.Description AS Location, tPerson.Person
 FROM (((((((((tServiceID AS SID LEFT JOIN tServiceType ON SID.ServiceTypeID = tServiceType.ID)
 LEFT JOIN tCentre ON SID.CustomerCentreID = tCentre.ID)
 LEFT JOIN tActivity ON SID.CustomerActivityID = tActivity.ID)
 LEFT JOIN tElement ON SID.CustomerElementID = tElement.ID)
 LEFT JOIN tLocation ON SID.LocationID = tLocation.ID)
 LEFT JOIN tSubledger ON SID.CustomerSubledgerID = tSubledger.ID)
 LEFT JOIN tDepartment ON tCentre.DepartmentID = tDepartment.ID)
 LEFT JOIN tGroup ON tDepartment.GroupID = tGroup.ID)
 LEFT JOIN tCustomer ON tGroup.CustomerID = tCustomer.ID)
 LEFT JOIN tPerson ON SID.PersonID = tPerson.ID) AS SID2
 LEFT JOIN tCentre ON SID2.CentreID = tCentre.ID)
 LEFT JOIN tActivity ON SID2.ActivityID = tActivity.ID)
 LEFT JOIN tElement ON SID2.ElementID = tElement.ID)
 LEFT JOIN tSubledger ON SID2.SubledgerID = tSubledger.ID)
 LEFT JOIN tValidAccountNumber ON SID2.SupplierAccountID = tValidAccountNumber.ID) AS SD
WHERE SD.Active = 1
ORDER BY SD.ServiceID


/* System: tServiceType.SQL - Revised on 15/05/2005 */
/* Added RevenueElementID and link to tElement */
SELECT SD.*
FROM (SELECT SID2.*, tCentre.Description AS Centre, tActivity.Description AS Activity,
 tElement.ElementCode AS Element, tSubledger.Description AS Subledger, tValidAccountNumber.AccountNo
FROM (((((SELECT SID.*, tServiceType.Code, tServiceType.Description AS ServiceType, tServiceType.RevenueElementID, tCustomer.ID AS CustomerID,
 tCustomer.ShipTo, tCustomer.FullName AS Customer, tCentre.Description AS CustomerCentre,
 tActivity.Description AS CustomerActivity, tElement.ElementCode AS CustomerElement, tSubledger.Description AS CustomerSubledger,
 tGroup.Description AS GroupDesc, tDepartment.Description AS Department, tLocation.Description AS Location, tPerson.Person
 FROM (((((((((tServiceID AS SID LEFT JOIN tServiceType ON SID.ServiceTypeID = tServiceType.ID)
 LEFT JOIN tCentre ON SID.CustomerCentreID = tCentre.ID)
 LEFT JOIN tActivity ON SID.CustomerActivityID = tActivity.ID)
 LEFT JOIN tElement ON SID.CustomerElementID = tElement.ID)
 LEFT JOIN tLocation ON SID.LocationID = tLocation.ID)
 LEFT JOIN tSubledger ON SID.CustomerSubledgerID = tSubledger.ID)
 LEFT JOIN tDepartment ON tCentre.DepartmentID = tDepartment.ID)
 LEFT JOIN tGroup ON tDepartment.GroupID = tGroup.ID)
 LEFT JOIN tCustomer ON tGroup.CustomerID = tCustomer.ID)
 LEFT JOIN tPerson ON SID.PersonID = tPerson.ID) AS SID2
 LEFT JOIN tCentre ON SID2.CentreID = tCentre.ID)
 LEFT JOIN tActivity ON SID2.ActivityID = tActivity.ID)
 LEFT JOIN tElement ON SID2.RevenueElementID = tElement.ID)
 LEFT JOIN tSubledger ON SID2.SubledgerID = tSubledger.ID)
 LEFT JOIN tValidAccountNumber ON SID2.SupplierAccountID = tValidAccountNumber.ID) AS SD
WHERE SD.Active = 1
ORDER BY SD.ServiceID