IC Inbox Transaction

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

Table Type: Company

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

Table Number: 418

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 Inbox Transaction can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Transaction No_]
   ,[IC Partner Code]
   ,[Transaction Source]
   ,[Document Type]
   ,[Source Type]
   ,[Document No_]
   ,[Posting Date]
   ,[Document Date]
   ,[Line Action]
   ,[Original Document No_]
   ,[IC Partner G_L Acc_ No_]
   ,[Source Line No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$IC Inbox Transaction$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 Inbox Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Transaction]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [IC Inbox Transaction].[IC Partner Code] = [IC Partner].[Code]

Show/hide columns in IC Inbox Transaction table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Transaction No_ Primary Key Searchint
3IC Partner Code Primary Key Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [IC Inbox Transaction].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$IC Inbox Transaction$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Inbox Transaction]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [IC Inbox Transaction].[IC Partner Code] = [IC Partner].[Code]
4Transaction Source Primary Key Searchint
5Document Type Primary Key Searchint
6Source Type Searchint
7Document No_ Searchnvarchar(40)
8Posting Date Searchdatetime
9Document Date Searchdatetime
10Line Action Searchint
11Original Document No_ Searchnvarchar(40)
12IC Partner G_L Acc_ No_ Searchnvarchar(40)
13Source Line No_ Searchint
14$systemId Searchuniqueidentifier
15$systemCreatedAt Searchdatetime
16$systemCreatedBy Searchuniqueidentifier
17$systemModifiedAt Searchdatetime
18$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from IC Inbox Transaction table

Leave a Reply

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