Skip to main content

How the Users \u0027Company\u0027 value is calculated

Explains how the Company column on the Users table is set by User Type: location DBA for employees, or the first linked Supplier, Customer, Chain, AR Account, AP Account or Vendor. Requires v22.01+.

B
Written by Bailey Naas-Thornton

Minimum Version Required: 22.01

Fields And Definitions

The 'Company' column on the Users table is calculated differently based on the User Type that the user belongs to:

Employee
​
​

- The Company will be the DBA from the primary location the user is attached to
​
​

- This logic is the same for both Employee_Restricted and Employee_Not_Restricted

Supplier
​
​

- The Company will be the first Supplier found that the user is attached to via Supplier Users

Customers
​
​

- The Company will be the first Customer found that the user is attached to via Customer Users

Chains
​
​

- The Company will be the first Chain found that the user is attached to via Chain Users

AR Accounts
​
​

- The Company will be the first AR Account found that the user is attached to via AR Account Users

AP Accounts
​
​

- The Company will be the first AP Account found that the user is attached to via AP Account Users

Vendors
​
​

- The Company will be the first Vendor found that the user is attached to via Vendor Users

Did this answer your question?