IC Comment Line

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

Table Type: Company

Table Name: IC Comment Line
Database Table Name: CRONUS UK Ltd_$IC Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 424

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 IC Comment Line can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$IC Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [Table Name]
   ,[Transaction No_]
   ,[IC Partner Code]
   ,[Line No_]
   ,[Date]
   ,[Comment]
   ,[Transaction Source]
   ,[Created By IC Partner Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$IC Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$IC Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Comment Line]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [IC Comment Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [IC Comment Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [IC Comment Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in IC Comment Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Table Name Primary Key SearchTable NameNormalOption4Table Nameint
Available options are:
  • “IC Inbox Transaction”
  • “IC Outbox Transaction”
  • “Handled IC Inbox Transaction”
  • “Handled IC Outbox Transaction”
2Transaction No. Primary Key SearchTransaction No.NormalInteger4Transaction No_int
3IC Partner Code Primary Key SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [IC Comment Line].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$IC Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Comment Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [IC Comment Line].[IC Partner Code] = [IC Partner].[Code]
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Date SearchDateNormalDate4Datedatetime
6Comment SearchCommentNormalText50Commentnvarchar(100)
7Transaction Source Primary Key SearchTransaction SourceNormalOption4Transaction Sourceint
Available options are:
  • “Rejected”
  • “Created”
8Created By IC Partner Code SearchCreated By IC Partner CodeNormalCode20Created By IC Partner Codenvarchar(40)
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [IC Comment Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$IC Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Comment Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [IC Comment Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [IC Comment Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$IC Comment Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Comment Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [IC Comment Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from IC Comment Line table

Leave a Reply

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