Object Access Intent Override

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000205

Table Type: System

Table Name: Object Access Intent Override
Database Table Name: Object Access Intent Override

Table Number: 2000000205

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Object Access Intent Override can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [Object Access Intent Override]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Object Type]
   ,[Object ID]
   ,[Access Intent]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [Object Access Intent Override]

Show/hide columns in Object Access Intent Override table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Object Type Primary Key Searchint
3Object ID Primary Key Searchint
4Access Intent Searchint
5$systemId Searchuniqueidentifier
6$systemCreatedAt Searchdatetime
7$systemCreatedBy Searchuniqueidentifier
8$systemModifiedAt Searchdatetime
9$systemModifiedBy Searchuniqueidentifier

Leave a Reply

Your email address will not be published. Required fields are marked *