Handled IC Outbox Jnl_ Line

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

Table Type: Company

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

Table Number: 417

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Transaction No_]
   ,[IC Partner Code]
   ,[Transaction Source]
   ,[Line No_]
   ,[Account Type]
   ,[Account No_]
   ,[Amount]
   ,[Description]
   ,[VAT Amount]
   ,[Currency Code]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Payment Discount Date]
   ,[Quantity]
   ,[Document No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Handled IC Outbox Jnl_ 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_$Handled IC Outbox Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Jnl_ Line]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Handled IC Outbox Jnl_ Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Handled IC Outbox Jnl_ Line].[Currency Code] = [Currency].[Code]

Show/hide columns in Handled IC Outbox Jnl_ Line 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 Jnl_ Line].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Jnl_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Handled IC Outbox Jnl_ Line].[IC Partner Code] = [IC Partner].[Code]
4Transaction Source Primary Key Searchint
5Line No_ Primary Key Searchint
6Account Type Searchint
7Account No_ Searchnvarchar(40)
8Amount Searchdecimal(38,38)
9Description Searchnvarchar(200)
10VAT Amount Searchdecimal(38,38)
11Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Handled IC Outbox Jnl_ Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Jnl_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Handled IC Outbox Jnl_ Line].[Currency Code] = [Currency].[Code]
12Due Date Searchdatetime
13Payment Discount _ Searchdecimal(38,38)
14Payment Discount Date Searchdatetime
15Quantity Searchdecimal(38,38)
16Document No_ Searchnvarchar(40)
17$systemId Searchuniqueidentifier
18$systemCreatedAt Searchdatetime
19$systemCreatedBy Searchuniqueidentifier
20$systemModifiedAt Searchdatetime
21$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Handled IC Outbox Jnl_ Line table

Leave a Reply

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