IC Outbox Jnl_ Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables IIC Outbox Jnl_ Line

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

Table Type: Company

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

Table Number: 415

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$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_$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_$IC Outbox Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Outbox Jnl_ Line]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [IC Outbox Jnl_ Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [IC Outbox Jnl_ Line].[Currency Code] = [Currency].[Code]

Show/hide columns in IC Outbox Jnl_ Line table

Column ID	Column Name	Data Type
1	timestamp	timestamp
2	Transaction No_	int
3	IC Partner Code	nvarchar(40)
	Key to join to the IC Partner table. Show/hide example query SELECT [IC Outbox Jnl_ Line].[IC Partner Code] ,[IC Partner].[Code] FROM [CRONUS UK Ltd_$IC Outbox Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Outbox Jnl_ Line] LEFT JOIN [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner] ON [IC Outbox Jnl_ Line].[IC Partner Code] = [IC Partner].[Code]
4	Transaction Source	int
5	Line No_	int
6	Account Type	int
7	Account No_	nvarchar(40)
8	Amount	decimal(38,38)
9	Description	nvarchar(200)
10	VAT Amount	decimal(38,38)
11	Currency Code	nvarchar(20)
	Key to join to the Currency table. Show/hide example query SELECT [IC Outbox Jnl_ Line].[Currency Code] ,[Currency].[Code] FROM [CRONUS UK Ltd_$IC Outbox Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Outbox Jnl_ Line] LEFT JOIN [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency] ON [IC Outbox Jnl_ Line].[Currency Code] = [Currency].[Code]
12	Due Date	datetime
13	Payment Discount _	decimal(38,38)
14	Payment Discount Date	datetime
15	Quantity	decimal(38,38)
16	Document No_	nvarchar(40)
17	$systemId	uniqueidentifier
18	$systemCreatedAt	datetime
19	$systemCreatedBy	uniqueidentifier
20	$systemModifiedAt	datetime
21	$systemModifiedBy	uniqueidentifier