ODBC Driver for SAP Fieldglass

Build 23.0.8839

Users

Retrieve all active users for the logged in user's company using the User Download connector.

Columns

Name Type Description
Username String The user's SAP Fieldglass username. This item must be unique to the system (not just the buyer). SAP Fieldglass recommends the user's email address as the username. For Bulk Full version, this key field must be in the first position. See the Configuration Considerations section for more information.
Prefix String The prefix of the user's name.
First Name String The user's first name.
Last Name String The user's last name.
Display Name String How the user's name should be displayed throughout the application. If left blank, the user's display name will default to the 'Last Name, First Name' format.
Email String The user's email.
Phone Number String The user's phone number.
Fax Number String The user's fax number.
Mobile Number String The user's mobile number.
Additional Roles String The user's additional user roles.
Address 1 String The user's address, Line 1.
Address 2 String The user's address, Line 2.
City String The user's city.
State String The user's state/province. Use the 2-digit state code.
Country String The user's country. For example 'USA'.
ZIP Code String The user's postal code/zip code. Both 5- and 9-digit codes are accepted.
Employee ID String The identifier appointed to the user by the buyer company.
Title String The user's job title.
MSP User String Indicates if user belongs to an MSP company.
Role Name String The user role as defined in the SAP Fieldglass system. The user role defines what access and security privileges the user has.
Primary Business Unit String The Business Unit Code as defined in the SAP Fieldglass system. The business unit identifies what data the user has access to in SAP Fieldglass, as well as the approval groups that are executed.
Primary Supervisor Username String The SAP Fieldglass username of the user's primary supervisor from the buyer side, which is used for escalation and notifications. Usernames are defined in the SAP Fieldglass system.
Default Cost Center String The Cost Center Code as defined in the SAP Fieldglass system. The Default Cost Center identifies the preferred cost center of the user and what data the user has access to in SAP Fieldglass.
Default Site String The Site Code as defined in the SAP Fieldglass system. The default site identifies the preferred site of the user and what data the user has access to in SAP Fieldglass.
Default Legal Entity String Default legal entity from user profile. Company configuration 'Enable Legal Entity' must be enabled. Applicable for version 2.0 only.
Cost Center Access String Determines the method for which cost center access will be given to a user. ALL = All cost centers are associated with the user. Build = As cost centers are used by users that are subordinate to the user or appear on transactions requiring the user's approval, the user is given access. Associate = Cost centers must be explicitly associated with the user on their profile in SAP Fieldglass.
Business Unit Access String Determines the method for which business unit access will be given to a user. ALL = All business units are associated with the user. Build = As business units are used by users that are subordinate to the user or appear on transactions requiring the user's approval, the user is given access. Associate = Business units must be explicitly associated with the user on their profile in SAP Fieldglass.
Site Access String Determines the method for which sites access will be given to a user. ALL = All sites are associated with the user. Build = As sites are used by users that are subordinate to the user or appear on transactions requiring the user's approval, the user is given access. Associate = Sites must be explicitly associated with the user on their profile in SAP Fieldglass.
User Last Login String Date the user last logged in to SAP Fieldglass.
Receive Notifications via email before Registration String Indicates if supplier emails should be sent prior to worker registration.
View Administrative Product Documentation String Indicates the user can view documentation for buyer administrators on the SAP Fieldglass product page on the SAP Help Portal.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839