Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2000000169
Table Type: System
Table Name: NAV App Tenant Add-In
Database Table Name: NAV App Tenant Add-In
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 Add-In can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[NAV App Tenant Add-In]Show/hide an example select of all columns by name
SELECT
[App ID]
,[Add-In Name]
,[Public Key Token]
,[Version]
,[Category]
,[Description]
,[Resource]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[NAV App Tenant Add-In]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[NAV App Tenant Add-In] AS [NAV App Tenant Add-In]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[NAV App Tenant Add-In].[Version] = [Guided Experience Item].[Version]
LEFT JOIN
[CRONUS UK Ltd_$Workflow Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Category]
ON
[NAV App Tenant Add-In].[Category] = [Workflow Category].[Code]
LEFT JOIN
[User] AS [User]
ON
[NAV App Tenant Add-In].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[NAV App Tenant Add-In].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in NAV App Tenant Add-In table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | App ID   | App ID | Normal | GUID | 16 | App ID | uniqueidentifier |
| 2 | Add-In Name | Add-In Name | Normal | Text | 220 | Add-In Name | nvarchar(440) |
| 3 | Public Key Token | Public Key Token | Normal | Text | 20 | Public Key Token | nvarchar(40) |
| 4 | Version | Version | Normal | Text | 25 | Version | nvarchar(50) |
Key to join to the Guided Experience Item table.Show/hide example querySELECT
[NAV App Tenant Add-In].[Version]
,[Guided Experience Item].[Version]
FROM
[NAV App Tenant Add-In] AS [NAV App Tenant Add-In]
LEFT JOIN
[CRONUS UK Ltd_$Guided Experience Item$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Guided Experience Item]
ON
[NAV App Tenant Add-In].[Version] = [Guided Experience Item].[Version] | |||||||
| 5 | Category | Category | Normal | Option | 4 | Category | int |
Key to join to the Workflow Category table.Show/hide example querySELECT
[NAV App Tenant Add-In].[Category]
,[Workflow Category].[Code]
FROM
[NAV App Tenant Add-In] AS [NAV App Tenant Add-In]
LEFT JOIN
[CRONUS UK Ltd_$Workflow Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Workflow Category]
ON
[NAV App Tenant Add-In].[Category] = [Workflow Category].[Code]
| |||||||
| 6 | Description | Description | Normal | Text | 250 | Description | nvarchar(500) |
| 7 | Resource | Resource | Normal | BLOB | 8 | Resource | image |
| 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 Add-In].[$systemCreatedBy]
,[User].[User Security ID]
FROM
[NAV App Tenant Add-In] AS [NAV App Tenant Add-In]
LEFT JOIN
[User] AS [User]
ON
[NAV App Tenant Add-In].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |
Key to join to the User table.Show/hide example querySELECT
[NAV App Tenant Add-In].[$systemModifiedBy]
,[User].[User Security ID]
FROM
[NAV App Tenant Add-In] AS [NAV App Tenant Add-In]
LEFT JOIN
[User] AS [User]
ON
[NAV App Tenant Add-In].[$systemModifiedBy] = [User].[User Security ID] | |||||||