Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/0
Table Type: System
Table Name: NAV App Capabilities
Database Table Name: NAV App Capabilities
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 Capabilities can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[NAV App Capabilities]Show/hide an example select of all columns by name
SELECT
[timestamp]
,[Package ID]
,[Capability ID]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[NAV App Capabilities]Show/hide columns in NAV App Capabilities table
| Column ID | Column Name | Data Type |
|---|---|---|
| 1 | timestamp  | timestamp |
| 2 | Package ID  | uniqueidentifier |
| 3 | Capability ID | int |
| 4 | $systemId | uniqueidentifier |
| 5 | $systemCreatedAt | datetime |
| 6 | $systemCreatedBy | uniqueidentifier |
| 7 | $systemModifiedAt | datetime |
| 8 | $systemModifiedBy | uniqueidentifier |