
HI'
What is the difference between User & User Setup Tables. Do User Setup table are company specific
Thanks
The table User is the main/parent table where all users created are stored and with basic information like Windows security id, authentication email i.e. required if your authentication type is O365 and License Type etc. The data in table User is not company specific. It is shared across all the companies on the database. This table is more related to access permissions and authentication to NAV client.
The table User Setup is table that is not necessary to be used. But we used it if we want to keep some additional checks. Like which user has access of posting on which dates. Users in this User Setup table are inherited from the table User. Similarly in this table we can make link of user to the salesperson, and we also use this table while using approval module. The data in User Setup table is company specific. It is not shared across all the companies. This table is related to control operations inside NAV. It is not necessary to use this table always.