Handled IC Outbox Trans_

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

Table Type: Company

Table Name: Handled IC Outbox Trans_
Database Table Name: CRONUS UK Ltd_$Handled IC Outbox Trans_$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 416

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 Handled IC Outbox Trans_ can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Transaction No_]
   ,[IC Partner Code]
   ,[Transaction Source]
   ,[Source Type]
   ,[Document Type]
   ,[Document No_]
   ,[Posting Date]
   ,[Document Date]
   ,[Status]
   ,[IC Partner G_L Acc_ No_]
   ,[Source Line No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Handled IC Outbox Trans_$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Handled IC Outbox Trans_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Trans_]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Handled IC Outbox Trans_].[IC Partner Code] = [IC Partner].[Code]

Show/hide columns in Handled IC Outbox Trans_ 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
       [Handled IC Outbox Trans_].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Trans_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Trans_]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Handled IC Outbox Trans_].[IC Partner Code] = [IC Partner].[Code]
4Transaction Source Primary Key Searchint
5Source Type Searchint
6Document Type Searchint
7Document No_ Searchnvarchar(40)
8Posting Date Searchdatetime
9Document Date Searchdatetime
10Status Searchint
11IC Partner G_L Acc_ No_ Searchnvarchar(40)
12Source Line No_ Searchint
13$systemId Searchuniqueidentifier
14$systemCreatedAt Searchdatetime
15$systemCreatedBy Searchuniqueidentifier
16$systemModifiedAt Searchdatetime
17$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Handled IC Outbox Trans_ table

Leave a Reply

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