Users

Below are the schemas and relationships of Users.

---

Column	Description	Type
Id	Internal identifier	String
TenantId	Customer identifier	String
UpdatedAt	Date of the last record update	Datetime
SnapshotAt	Reference date of the transaction	Datetime
UserId	Primary key for the schema of User	String
Name	User name	String
Email	User email address	String
Login	User login	String
LastUpdate	Date of the last update in the user record	Datetime
Status	Login status (Active, Inactive)	String
JobRole	User access level (Profile). Example: viewer, requester, consultant, administrator, buyer, approver, and others.	String
HasUpdated	Indicates whether the user record was updated (true/false)	Boolean
LastAccess	Date of the user's last access	Datetime
AccessLevel	User role. Options include: developer, viewer, requester, consultant, administrator, buyer, and approver.	String
RoleId	Identifier of the user's role/position in the company	String
RoleName	Name of the user's role/position in the company	String

Users Schema Joins

The Users schema has relationships with the following schemas:

Schema	Relationship Column	Description
Orders	BuyerId	Relates the rows of Users with the rows of Orders.
PreOrders	BuyerId	Relates the rows of Users with the rows of PreOrders.
Requests	RequesterEmail	Relates the rows of Users with the rows of Requests.
RequestItems	BuyerId*	Relates the rows of Users with the rows of RequestItems.
Rfqs	OwnerId*	Relates the rows of Users with the rows of Rfqs.

• The Buyer and OwnerId columns in the schemas listed above must be the same as the UserId column in the User schema.