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

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Sohaib Cheema 49,668 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Clark.Walliser on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No