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
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
[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 an example select of all columns including those from all joined tables
SELECT
*
FROM
[NAV App Tenant Operation] AS [NAV App Tenant Operation]
LEFT JOIN
[User] AS [User]
ON
[NAV App Tenant Operation].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[NAV App Tenant Operation].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in NAV App Tenant Operation table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Operation ID  | Operation ID | Normal | GUID | 16 | Operation ID | uniqueidentifier |
| 2 | Started On  | Started On | Normal | DateTime | 8 | Started On | datetime |
| 3 | Operation Type | Operation Type | Normal | Option | 4 | Operation Type | int |
Available options are:
| |||||||
| 4 | Status | Status | Normal | Option | 4 | Status | int |
Available options are:
| |||||||
| 5 | Details | Details | Normal | BLOB | 8 | Details | image |
| 6 | Metadata Version | Metadata Version | Normal | Integer | 4 | Metadata Version | int |
| 7 | Metadata | Metadata | Normal | BLOB | 8 | Metadata | image |
| 8 | Metadata Key | Metadata Key | Normal | Text | 250 | Metadata Key | nvarchar(500) |
| 9 | Description | Description | Normal | Text | 250 | Description | nvarchar(500) |
| 2000000000 | $systemId | System ID | Normal | GUID | 16 | $systemId | uniqueidentifier |
| 2000000001 | SystemCreatedAt | Created At | Normal | DateTime | 8 | $systemCreatedAt | datetime |
| 2000000002 | SystemCreatedBy | Created By | Normal | GUID | 16 | $systemCreatedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT [NAV App Tenant Operation].[$systemCreatedBy] ,[User].[User Security ID] FROM [NAV App Tenant Operation] AS [NAV App Tenant Operation] LEFT JOIN [User] AS [User] ON [NAV App Tenant Operation].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |