ODBC Driver for Sage Intacct

Build 25.0.9434

UserInfo

Captures user credentials and profile data, including contact details and system preferences for each Intacct user.

Columns

Name Type ReadOnly Description
Loginid [KEY] String False

The unique login ID of the user.

Description String False

The description of the user.

Contactinfo_contactname String False

The full contact name of the user.

Contactinfo_prefix String False

The prefix for the user's name (for example, Mr., Mrs.).

Contactinfo_firstname String False

The first name of the user.

Contactinfo_initial String False

The initial of the user.

Contactinfo_lastname String False

The last name of the user.

Contactinfo_companyname String False

The company name associated with the user.

Contactinfo_printas String False

The name to be used for printing purposes.

Contactinfo_phone1 String False

The primary phone number of the user.

Contactinfo_phone2 String False

The secondary phone number of the user.

Contactinfo_cellphone String False

The cellphone number of the user.

Contactinfo_pager String False

The pager number of the user.

Contactinfo_fax String False

The fax number of the user.

Contactinfo_email1 String False

The primary email address of the user.

Contactinfo_email2 String False

The secondary email address of the user.

Contactinfo_url1 String False

The first URL associated with the user.

Contactinfo_url2 String False

The second URL associated with the user.

Contactinfo_mailaddress_address1 String False

The primary address line of the user.

Contactinfo_mailaddress_address2 String False

The secondary address line of the user.

Contactinfo_mailaddress_city String False

The city of the user's address.

Contactinfo_mailaddress_state String False

The state of the user's address.

Contactinfo_mailaddress_zip String False

The ZIP code of the user's address.

Contactinfo_mailaddress_country String False

The country of the user's address.

Contactinfo_mailaddress_countrycode String False

The country code of the user's address.

Admin String False

Indicates whether the user is an admin.

Usertype String False

The type of user (for example, regular, admin, etc.).

Visible String False

Indicates whether the user is visible in the system.

Status String False

The status of the user (for example, active, inactive).

Unrestricted Boolean False

Indicates if the user has unrestricted access.

Logindisabled Boolean False

Indicates whether the user's login is disabled.

Pwdneverexpires Boolean False

Indicates whether the user's password never expires.

Resetpassword String False

Indicates if the user's password has been reset.

Pwdqlynotenforced Boolean False

Indicates whether password quality is not enforced.

Whencreated Datetime False

The date and time when this user record was created.

Whenmodified Datetime False

The date and time when this user record was last modified.

Createdby Int64 False

The user ID of the creator of this user record.

Modifiedby Int64 False

The user ID of the last modifier of this user record.

Recordno Int64 False

The unique identifier of the user record.

Contactkey Int64 False

The contact key associated with the user.

Chatter_disabled Boolean False

Indicates whether the user's chatter feature is disabled.

Megaentitykey Int64 False

The megaentity key associated with the user.

Megaentityid String False

The megaentity ID associated with the user.

Megaentityname String False

The name of the megaentity associated with the user.

Record_url String False

The URL for accessing the user record.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434