Table Definition: xct_tblACUser


The main table in AC that is used for user accounts/logins is: xct_tblACUser
Column Description

siteID Required, used to setup multiple installs or test/live. Corresponds to the siteID in the ACConfigfile.
userGUID Required, SQL Unique Key. Used for all lookups in the system.
emailAddress Required, The username, must be unique
password Required, Passwords are one-way hashes and are randomly generated initially unless set in admin or the user account settings screen.
custID Required, The SL CustId tied to this user.
fName Optional, the User's first name
lName Optional, the User's last name
lastUpdated Optional/automatic, records the last time the record was modified
userContent Optional, text/html data specific to the user.
timeStamp Required, the date the entry was first created
active Required, whether this account should be allowed access. 1 = active, 0 = inactive
admin Required, 1 = allows access to acAdmin. 0 = normal user
user1 Optional, for customization purposes
user2 Optional, for customization purposes
user3 Optional, for customization purposes
user4 Optional, for customization purposes
user5 Optional, for customization purposes
user6 Optional, for customization purposes
user7 Optional, for customization purposes
user8 Optional, for customization purposes
user9 Optional, for customization purposes
user10 Optional, for customization purposes
user11 Optional, for customization purposes