Users table for AvalaraAvatax data provider.
To create a new user the following fields should be specified. A newly created user will receive an email inviting them to create their password. This means that you must provide a valid email address for all user accounts created.
INSERT INTO Users (AccountId, UserName, FirstName, LastName, Email, securityRoleId) VALUES (2000137504, 'user123', 'James', 'Smith', 'firstname.lastname@example.org', 'AccountUser')
Only user selectable fields can be updated. To update a user, you need to specify Id and AccountId in WHERE clause.
UPDATE Users SET IsActive = true WHERE Id = 332668 AND AccountId = 2000137504
To delete a user, you need to specify Id and AccountId in WHERE clause.
DELETE FROM Users WHERE Id = 332668 AND AccountId = 2000137504
The unique ID number of this user.
The unique ID number of the account to which this user belongs.
The postal code in which this user resides.
The security level for this user.
The date/time when this record was last modified.
The status of the user's password. For a new user created, this is always going to be `UserMustChange`.
The email address to be used to contact this user. If the user has forgotten a password, an email can be sent to this email address with information on how to reset this password.
The username which is used to log on to the AvaTax website, or to authenticate against API calls.
If this user is locked to one company (and its children), this is the unique ID number of the company to which this user belongs.
The first or given name of the user.
The last or family name of the user.
True if this user is currently active.
The date when this record was created.