G/L Entry – VAT Entry Link

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

Table Type: Company

Table Name: G/L Entry – VAT Entry Link
Database Table Name: CRONUS UK Ltd_$G_L Entry – VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 253

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 G/L Entry – VAT Entry Link can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

FROM
   [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry - VAT Entry Link]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Entry - VAT Entry Link].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [G/L Entry - VAT Entry Link].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in G/L Entry – VAT Entry Link table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1G/L Entry No. Primary Key SearchG/L Entry No.NormalInteger4G_L Entry No_int
Key to join to the G/L Entry table.

Show/hide example query

SELECT
       [G/L Entry - VAT Entry Link].[G_L Entry No_]
       ,[G/L Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry - VAT Entry Link]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
              ON
                     [G/L Entry - VAT Entry Link].[G_L Entry No_] = [G/L Entry].[Entry No_]
2VAT Entry No. Primary Key SearchTax Entry No.NormalInteger4VAT Entry No_int
Key to join to the VAT Entry table.

Show/hide example query

SELECT
       [G/L Entry - VAT Entry Link].[VAT Entry No_]
       ,[VAT Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry - VAT Entry Link]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Entry]
              ON
                     [G/L Entry - VAT Entry Link].[VAT Entry No_] = [VAT Entry].[Entry No_]
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
       [G/L Entry - VAT Entry Link].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry - VAT Entry Link]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Entry - VAT Entry Link].[$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
       [G/L Entry - VAT Entry Link].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$G_L Entry - VAT Entry Link$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry - VAT Entry Link]
LEFT JOIN
       [User] AS [User]
              ON
                     [G/L Entry - VAT Entry Link].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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