Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) How to link EMPLTABLE ...

How to link EMPLTABLE to USERINFO table via SQL

(0) Share

Report

Posted on by Clark.Walliser

I'm new to AX, using AX 2009. I wan't to link the Employee table to the user information table, but the usual suspects like ID, RecID and PartyID don't appear to work.

Does anyone have a reference for SQL table linking relationships?

*This post is locked for comments

All responses (2)

Answers (1)

Clark.Walliser on at

Like (0)

Report

RE: How to link EMPLTABLE to USERINFO table via SQL

Thank you, Sohaib.

That looks like it will do what I want.

Do you gain this knowledge only through experience, or is there reference documentation available?

I’ve been searching for such documentation for 3 months with no success yet.
Verified answer

Sohaib Cheema 46,696 User Group Leader on at

Like (0)

Report

RE: How to link EMPLTABLE to USERINFO table via SQL

you can use table SysCompanyUserInfo

this table has UserId and EmplD.

UserId is also the primary key for this table. so for each user you can get if its has an associated employee Id.