Users
Users table for AvalaraAvatax data provider.
Insert
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', 'smith@gmail.com', 'AccountUser')
Update
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
Delete
To delete a user, you need to specify Id and AccountId in WHERE clause.
DELETE FROM Users WHERE Id = 332668 AND AccountId = 2000137504
Columns
| Name | Type | ReadOnly | Description |
| Id [KEY] | Int | False |
The unique ID number of this user. |
| AccountId [KEY] | Int | False |
The unique ID number of the account to which this user belongs. |
| PostalCode | String | False |
The postal code in which this user resides. |
| SecurityRoleId | String | False |
The security level for this user. |
| ModifiedDate | Datetime | False |
The date/time when this record was last modified. |
| PasswordStatus | String | False |
The status of the user's password. For a new user created, this is always going to be `UserMustChange`. |
| String | False |
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. | |
| UserName | String | False |
The username which is used to log on to the AvaTax website, or to authenticate against API calls. |
| CompanyId | Int | False |
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. |
| FirstName | String | False |
The first or given name of the user. |
| LastName | String | False |
The last or family name of the user. |
| IsActive | Bool | False |
True if this user is currently active. |
| CreatedDate | Datetime | False |
The date when this record was created. |
| PageKey | String | False |