Wind2 or Deltek FMS project import queries

Below are sample queries that can be used when creating a custom SQL import from Wind2 or Deltek FMS:

Project level:

SELECT CPROJECT AS ProjectNumber, MPROJTITLE AS ProjectName
FROM BMPROJ WHERE Linactive = '0'

Phase level:

SELECT CPHASEID AS PhaseNumber, CPHASEDESC AS PhaseName,
CPROJECT AS ParentProjectNumber
FROM BMPHASE a
INNER JOIN BMPROJ b
ON a.bmproj_id = b.bmproj_id
WHERE a.Linactive = '0'