Dataverse system tables and columns
Applies To
Access for Microsoft 365
| Note This feature is in General Availability (GA) in the Microsoft 365 Monthly Release Channel as of May 2022. If you are on the Microsoft Semi-annual Enterprise Channel, it is available in December 2022. For more information on how to participate, see aka.ms/AccessAndPowerPlatform. |
|---|
Both Dataverse and Dataverse for Teams have tables and columns that need to be present for data types and features to work properly. These are part of the default organizations and cannot be removed. When migrating from Access to Dataverse, you will see columns added to tables after the migration and additional linked tables added in Access to support the columns. The following information provides an overview of the these system tables and columns.
Tables
| Table name | Usage | Dataverse? | Dataverse for Teams? | Linked in Access? |
|---|---|---|---|---|
| Currency | Stores currency details for all transaction currencies including values like exchange rate, name, symbol, code, and so on. Required for Currency features. (logical name is Transactioncurrency) | Yes | Yes ¹ ² | No |
| Users | Stores users of the organization that use the apps or data. Used in lookup columns that are created by default. | Yes | Yes ¹ | Yes |
| Teams | Stores teams of users in the organization that use the apps or data. Used in lookup columns that are created by default. | Yes | Yes ¹ | Yes |
| Business Units | Stores Business Units users belong to in the organization that use the apps or data. Used in lookup columns that are created by default. | Yes | Yes ¹ | Yes |
1 Table is present and usable but not displayed by default.
2 Only present if a currency column is added.
Columns
The following columns are included in all tables of Dataverse and Dataverse for Teams and may be visible in Access linked tables. These columns cannot be deleted.
| Table name | Usage | Dataverse? | Dataverse for Teams? | Linked in Access? |
|---|---|---|---|---|
| <Primary Name> | A user-friendly text string used to identify rows. The name is chosen by the user. In Access you can either choose which field you want to use during migration or it is picked for you. | Yes | Yes | Yes |
| <Primary ID> | A unique identifier string used to identify rows. This is system generated. | Yes | Yes ¹ | Yes |
| CreatedBy | A lookup column to the users table selecting the user who created the row. | Yes | Yes | |
| CreatedBy (Delegate) |
A lookup column to the users table selecting the user who created the row as a delegate for another user. | Yes | Yes | |
| CreatedOn | A date time column that records the date and time a row was created. Stored in UTC. | Yes | Yes | |
| Currency | A lookup to the Currency column (logical name Transactioncurrency) to retrieve the details of a transaction currency for the purposes of calculating against the base currency. | Yes | Yes | |
| Exchange Rate | The Exchange rate value retrieved from the transaction currency on the currency table at the time the row was created. | Yes | Yes ¹ | |
| Import Sequence Number |
The row's place in the sequence of imported records that were added it to the table. | Yes | Yes | |
| ModifiedBy | A lookup column to the users table selecting the user who modified the row. | Yes | Yes | |
| ModifiedBy (Delegate) |
A lookup column to the users table selecting the user who modified the row as a delegate for another user. | Yes | Yes | |
| ModifiedOn | A date time column that records the date and time a row was modified. Stored in UTC. | Yes | Yes | |
| Owner | The unique OwnerID assigned to the user selected as the Owning User from the Users table. | Yes | Yes | |
| Owning Business Unit |
A lookup to the business unit table to select the appropriate business unit that owns the row. | Yes | Yes | |
| Owning Team | A lookup to the team table to select the appropriate team that owns the row. | Yes | Yes | |
| Owning User | A lookup to the user table to select the appropriate user that owns the row. | Yes | Yes | |
| Record Created On |
Date and time that a row was migrated. | Yes | Yes | |
| Status | An option set that allows a user to pick the state of a row. | Yes | Yes | |
| Status Reason |
An option set related to Status that allows a user to pick the status reason of a row based on the status selected. | Yes | Yes | |
| Time Zone Rule Version |
Internal only. Used to determine which set of time zone rules apply. | Yes | Yes | |
| UTC Conversion Time Zone Code |
The time zone offset code that was in use at the time the row was created. | Yes | Yes | |
| Version Number |
The version number of a row used to track previous changes if auditing is enabled. | Yes | Yes |
1 Column is present and usable but not displayed by default.