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'

Have more questions? Submit a request


Please sign in to leave a comment.