Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/2028
Table Type: Company
Table Name: MS – Image Analyzer Tags
Database Table Name: CRONUS UK Ltd_$MS – Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04
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 MS – Image Analyzer Tags can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04]Show/hide an example select of all columns by name
SELECT
FROM
[CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags]
LEFT JOIN
[CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
ON
[MS - Image Analyzer Tags].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Item Attribute Value$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attribute Value]
ON
[MS - Image Analyzer Tags].[Item Attribute Value ID] = [Item Attribute Value].[ID]
LEFT JOIN
[User] AS [User]
ON
[MS - Image Analyzer Tags].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
[User] AS [User]
ON
[MS - Image Analyzer Tags].[SystemModifiedBy] = [User].[User Security ID]Show/hide columns in MS – Image Analyzer Tags table
| Field No. | Field Name | Field Caption | Class | Type | Length | SQL Column Name | SQL DataType |
|---|---|---|---|---|---|---|---|
| 1 | Detected On Item No  | Detected On Item No | Normal | Code | 20 | Detected On Item No | nvarchar(40) |
| 2 | Tag Confidence  | Confidence Score (%) | Normal | Decimal | 12 | Tag Confidence | decimal(38,38) |
| 3 | Tag Name | Detected Attribute Name | Normal | Text | 250 | Tag Name | nvarchar(500) |
| 4 | Item Category Code | Item Category Code | Normal | Code | 20 | Item Category Code | nvarchar(40) |
Key to join to the Item Category table.Show/hide example querySELECT [MS - Image Analyzer Tags].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [MS - Image Analyzer Tags].[Item Category Code] = [Item Category].[Code] | |||||||
| 5 | Newly Created Item Category Co | Newly Created Item Category Code | Normal | Boolean | 4 | ||
| 6 | Item Attribute Value Id | Item Attribute Value Id | Normal | Integer | 4 | Item Attribute Value Id | int |
Key to join to the Item Attribute Value table.Show/hide example querySELECT [MS - Image Analyzer Tags].[Item Attribute Value Id] ,[Item Attribute Value].[ID] FROM [CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags] LEFT JOIN [CRONUS UK Ltd_$Item Attribute Value$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Attribute Value] ON [MS - Image Analyzer Tags].[Item Attribute Value Id] = [Item Attribute Value].[ID] | |||||||
| 7 | Action To Perform | Action to Perform | Normal | Option | 4 | Action To Perform | int |
Available options are:
| |||||||
| 8 | Details Text | Details | Normal | Text | 250 | Details Text | nvarchar(500) |
| 9 | Item Attribute Name Id | Item Attribute Name Id | Normal | Integer | 4 | Item Attribute Name Id | int |
| 10 | Item Attribute Name | Item Attribute Name | Normal | Text | 250 | Item Attribute Name | nvarchar(500) |
| 11 | Item Attribute Value Name | Item Attribute Value Name | Normal | Text | 250 | Item Attribute Value Name | 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 [MS - Image Analyzer Tags].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$MS - Image Analyzer Tags$e868ad92-21b8-4e08-af2b-8975a8b06e04] AS [MS - Image Analyzer Tags] LEFT JOIN [User] AS [User] ON [MS - Image Analyzer Tags].[$systemCreatedBy] = [User].[User Security ID] | |||||||
| 2000000003 | SystemModifiedAt | Modified At | Normal | DateTime | 8 | $systemModifiedAt | datetime |
| 2000000004 | SystemModifiedBy | Modified By | Normal | GUID | 16 | $systemModifiedBy | uniqueidentifier |