NAV App Tenant Operation

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

Table Type: System

Table Name: NAV App Tenant Operation
Database Table Name: NAV App Tenant Operation

Table Number: 2000000200

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 NAV App Tenant Operation can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [NAV App Tenant Operation]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Operation ID]
   ,[Started On]
   ,[Operation Type]
   ,[Status]
   ,[Details]
   ,[Metadata Version]
   ,[Metadata]
   ,[Metadata Key]
   ,[Description]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [NAV App Tenant Operation]

Show/hide columns in NAV App Tenant Operation table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Operation ID Primary Key Searchuniqueidentifier
3Started On Searchdatetime
4Operation Type Searchint
5Status Searchint
6Details Searchimage
7Metadata Version Searchint
8Metadata Searchimage
9Metadata Key Searchnvarchar(500)
10Description Searchnvarchar(500)
11$systemId Searchuniqueidentifier
12$systemCreatedAt Searchdatetime
13$systemCreatedBy Searchuniqueidentifier
14$systemModifiedAt Searchdatetime
15$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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