Skip to main content
Solved

Table name of users company and site

  • November 15, 2021
  • 4 replies
  • 260 views

Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1265 replies

Hello,

does anybody know the table or view name of the company and site?

 

 

Thank you

Best answer by ShawnBerk

You are looking for User_Allowed_Site and User_Finance which is a child table to Company_Finance.

This topic has been closed for replies.

4 replies

Thiwanka Sandaruwan
Hero (Employee)
Forum|alt.badge.img+9

Hi @Link ,

 

Just try below statements.

 

Tables:

 

SELECT * FROM company_tab;

SELECT * FROM site_tab;

 

Views:

 

SELECT * FROM company;

SELECT * FROM site;

 

Best Regards,

Thiwanka

 


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • 1265 replies
  • November 15, 2021

Hi @Link ,

 

Just try below statements.

 

Tables:

 

SELECT * FROM company_tab;

SELECT * FROM site_tab;

 

Views:

 

SELECT * FROM company;

SELECT * FROM site;

 

Best Regards,

Thiwanka

 


Hi Thiwanka,

I need the table or view with all users, companies and sites.

If I activeate these checkboxes the user must be saved in a table. I am I right?

Thank you a lot.

 

Kind regards

 


Forum|alt.badge.img+28
  • Superhero (Customer)
  • 1482 replies
  • Answer
  • November 15, 2021

You are looking for User_Allowed_Site and User_Finance which is a child table to Company_Finance.


Link
Superhero (Customer)
Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • 1265 replies
  • November 15, 2021

You are looking for User_Allowed_Site and User_Finance which is a child table to Company_Finance.


Yes, that is true.

Thank your very much.