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
   [Transaction No_]
   ,[IC Partner Code]
   ,[Line No_]
   ,[Account Type]
   ,[Account No_]
   ,[Amount]
   ,[Description]
   ,[VAT Amount]
   ,[Currency Code]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Payment Discount Date]
   ,[Quantity]
   ,[Transaction Source]
   ,[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]
LEFT JOIN
   [User] AS [User]
      ON
         [Handled IC Outbox Jnl. Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Handled IC Outbox Jnl. Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Handled IC Outbox Jnl. Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Transaction No. Primary Key SearchTransaction No.NormalInteger4Transaction No_int
2IC Partner Code Primary Key SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(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]
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Account Type SearchAccount TypeNormalOption4Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “IC Partner”
  • “Bank Account”
5Account No. SearchAccount No.NormalCode20Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Handled IC Outbox Jnl. Line].[Account No_]
       ,[G/L Account].[No_]
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_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Handled IC Outbox Jnl. Line].[Account No_] = [G/L Account].[No_]
6Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
7Description SearchDescriptionNormalText100Descriptionnvarchar(200)
8VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
9Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
11Due Date SearchDue DateNormalDate4Due Datedatetime
12Payment Discount % SearchPayment Discount %NormalDecimal12Payment Discount _decimal(38,38)
13Payment Discount Date SearchPayment Discount DateNormalDate4Payment Discount Datedatetime
14Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
15Transaction Source Primary Key SearchTransaction SourceNormalOption4Transaction Sourceint
Available options are:
  • “Rejected by Current Company”
  • “Created by Current Company”
16Document No. SearchDocument No.NormalCode20Document No_nvarchar(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
       [Handled IC Outbox Jnl. Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Jnl. Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Handled IC Outbox Jnl. 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
       [Handled IC Outbox Jnl. Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Jnl_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Jnl. Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Handled IC Outbox Jnl. Line].[$systemModifiedBy] = [User].[User Security ID]

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 *