Skip to main content

Hello,

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

 

 

Thank you

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 @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

 


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


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.