JDBC Driver for Sage Intacct

Build 22.0.8462

UserInfo

Retrieves UserInfo report data.

Columns

Name Type ReadOnly Description
Loginid [KEY] String False

The Loginid field of the UserInfo object.

Description String False

The Description field of the UserInfo object.

Contactinfo_contactname String False

The Contactinfo_contactname field of the UserInfo object.

Contactinfo_prefix String False

The Contactinfo_prefix field of the UserInfo object.

Contactinfo_firstname String False

The Contactinfo_firstname field of the UserInfo object.

Contactinfo_initial String False

The Contactinfo_initial field of the UserInfo object.

Contactinfo_lastname String False

The Contactinfo_lastname field of the UserInfo object.

Contactinfo_companyname String False

The Contactinfo_companyname field of the UserInfo object.

Contactinfo_printas String False

The Contactinfo_printas field of the UserInfo object.

Contactinfo_phone1 String False

The Contactinfo_phone1 field of the UserInfo object.

Contactinfo_phone2 String False

The Contactinfo_phone2 field of the UserInfo object.

Contactinfo_cellphone String False

The Contactinfo_cellphone field of the UserInfo object.

Contactinfo_pager String False

The Contactinfo_pager field of the UserInfo object.

Contactinfo_fax String False

The Contactinfo_fax field of the UserInfo object.

Contactinfo_email1 String False

The Contactinfo_email1 field of the UserInfo object.

Contactinfo_email2 String False

The Contactinfo_email2 field of the UserInfo object.

Contactinfo_url1 String False

The Contactinfo_url1 field of the UserInfo object.

Contactinfo_url2 String False

The Contactinfo_url2 field of the UserInfo object.

Contactinfo_mailaddress_address1 String False

The Contactinfo_mailaddress_address1 field of the UserInfo object.

Contactinfo_mailaddress_address2 String False

The Contactinfo_mailaddress_address2 field of the UserInfo object.

Contactinfo_mailaddress_city String False

The Contactinfo_mailaddress_city field of the UserInfo object.

Contactinfo_mailaddress_state String False

The Contactinfo_mailaddress_state field of the UserInfo object.

Contactinfo_mailaddress_zip String False

The Contactinfo_mailaddress_zip field of the UserInfo object.

Contactinfo_mailaddress_country String False

The Contactinfo_mailaddress_country field of the UserInfo object.

Contactinfo_mailaddress_countrycode String False

The Contactinfo_mailaddress_countrycode field of the UserInfo object.

Admin String False

The Admin field of the UserInfo object.

Usertype String False

The Usertype field of the UserInfo object.

Visible String False

The Visible field of the UserInfo object.

Status String False

The Status field of the UserInfo object.

Unrestricted Boolean False

The Unrestricted field of the UserInfo object.

Logindisabled Boolean False

The Logindisabled field of the UserInfo object.

Pwdneverexpires Boolean False

The Pwdneverexpires field of the UserInfo object.

Resetpassword String False

The Resetpassword field of the UserInfo object.

Pwdqlynotenforced Boolean False

The Pwdqlynotenforced field of the UserInfo object.

Whencreated Datetime False

The Whencreated field of the UserInfo object.

Whenmodified Datetime False

The Whenmodified field of the UserInfo object.

Createdby Int64 False

The Createdby field of the UserInfo object.

Modifiedby Int64 False

The Modifiedby field of the UserInfo object.

Recordno Int64 False

The Recordno field of the UserInfo object.

Contactkey Int64 False

The Contactkey field of the UserInfo object.

Chatter_disabled Boolean False

The Chatter_disabled field of the UserInfo object.

Megaentitykey Int64 False

The Megaentitykey field of the UserInfo object.

Megaentityid String False

The Megaentityid field of the UserInfo object.

Megaentityname String False

The Megaentityname field of the UserInfo object.

Record_url String False

The Record_url field of the UserInfo object.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462