|
This data object is used to show all user information.
This information can be found in the Users program within the Fusion business system.
URL
/frw/Users
Field Details…
| SQL Field Name | Field Type | Column Description |
|---|---|---|
| User Name | varchar(20) | System User Name in Fusion |
| Language | varchar(50) | Default User Language |
| Technician | varchar(20) | |
| Inactive | bit | True / False is user active |
| Disabled | bit | True / False is user disabled |
| Employee | varchar(20) | |
| User Default Printer | varchar(220) | |
| Salutation | varchar(50) | User Salutation (mr, Mrs, ms, Sir) |
| First Name | varchar(100) | User First Name |
| Last Name | varchar(100) | User last name |
| Title | varchar(50) | |
| Middle Initial | varchar(1) | Users Middle Initial |
| Work Phone | varchar(30) | Work Phone |
| Fax | varchar(30) | Fax Number |
| Home Phone | varchar(30) | Home Phone NUmber |
| Pager | varchar(30) | User Pager / Beeper Number |
| E-mail Address | varchar(100) | User Email Address |
| Web Address | varchar(100) | Users website URL |
| Bill-to Address 1 | varchar(100) | This field displays the Primary Bill-To address line 1 of the customer record. |
| Bill-to Address 2 | varchar(100) | This field displays the Primary Bill-To Address line 2 of the customer record. |
| Bill-to City | varchar(100) | This field displays the Primary Bill-To City of the customer record. |
| Bill-to Region | varchar(6) | This field displays the Primary Bill-To Region of the customer record. |
| Bill-to Postal Code | varchar(15) | This field displays the Primary Bill-To Postal Code of the customer record. |
| Bill-to Country | varchar(35) | Billing Country location |
| Bill-to County | varchar(35) | Billing County for US |
| Branch | varchar(10) | This field displays the code associated with a user base branch. |
| Department | varchar(10) | This field displays the department associated with a user |
| User Group | varchar(50) | |
| Salesperson Legacy Link | varchar(20) | |
| Unit Salesperson | bit | True / false flag for permissions |
| Inside Service Salesperson | bit | True / false flag for permissions |
| Inside Parts Salesperson | bit | True / false flag for permissions |
| Lease Salesperson | bit | True / false flag for permissions |
| Rental Salesperson | bit | True / false flag for permissions |
| Department Administrative User | bit | True / false flag for permissions |
| Branch Administrative User | bit | True / false flag for permissions |
| Division Administrative User | bit | True / false flag for permissions |
| Corporate Administrative User | bit | True / false flag for permissions |
| Set Default | bit | |
| Add User | varchar(20) | |
| Add Date | datetime | Date User was created |
| Last Update User | varchar(20) | |
| Last Update Date | datetime | Date User was updated |