LexisNexis TimeMatters Client/Matter import queries

Below are sample queries that can be used when creating a custom SQL import from LexisNexis TimeMatters:

Client level:

SELECT DISTINCT client AS ClientNumber, client2 AS ClientName
FROM lntmu11.matter
WHERE Archive = '0'

Matter level:

SELECT client AS ParentClientNumber, mat_no AS MatterNumber,
mat_ref AS MatterName
FROM lntmu11.matter
WHERE Archive = '0'