Reversal Entry

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

Table Type: Company

Table Name: Reversal Entry
Database Table Name: CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 179

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 Reversal Entry can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Line No_]
   ,[Entry Type]
   ,[Entry No_]
   ,[G_L Register No_]
   ,[Source Code]
   ,[Journal Batch Name]
   ,[Transaction No_]
   ,[Source Type]
   ,[Source No_]
   ,[Currency Code]
   ,[Description]
   ,[Amount]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Amount (LCY)]
   ,[Debit Amount (LCY)]
   ,[Credit Amount (LCY)]
   ,[VAT Amount]
   ,[Posting Date]
   ,[Document Type]
   ,[Document No_]
   ,[Account No_]
   ,[Account Name]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[FA Posting Category]
   ,[FA Posting Type]
   ,[Reversal Type]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reversal Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Reversal Entry].[Currency Code] = [Currency].[Code]

Show/hide columns in Reversal Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Line No_ Primary Key Searchint
3Entry Type Searchint
4Entry No_ Searchint
5G_L Register No_ Searchint
6Source Code Searchnvarchar(20)
7Journal Batch Name Searchnvarchar(20)
8Transaction No_ Searchint
9Source Type Searchint
10Source No_ Searchnvarchar(40)
11Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Reversal Entry].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reversal Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Reversal Entry].[Currency Code] = [Currency].[Code]
12Description Searchnvarchar(200)
13Amount Searchdecimal(38,38)
14Debit Amount Searchdecimal(38,38)
15Credit Amount Searchdecimal(38,38)
16Amount (LCY) Searchdecimal(38,38)
17Debit Amount (LCY) Searchdecimal(38,38)
18Credit Amount (LCY) Searchdecimal(38,38)
19VAT Amount Searchdecimal(38,38)
20Posting Date Searchdatetime
21Document Type Searchint
22Document No_ Searchnvarchar(40)
23Account No_ Searchnvarchar(40)
24Account Name Searchnvarchar(200)
25Bal_ Account Type Searchint
26Bal_ Account No_ Searchnvarchar(40)
27FA Posting Category Searchint
28FA Posting Type Searchint
29Reversal Type Searchint
30$systemId Searchuniqueidentifier
31$systemCreatedAt Searchdatetime
32$systemCreatedBy Searchuniqueidentifier
33$systemModifiedAt Searchdatetime
34$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Reversal Entry table

Leave a Reply

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