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
   [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_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Reversal Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Reversal Entry].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Reversal Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Reversal Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Reversal Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Reversal Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [Reversal Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Reversal Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Reversal Entry table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Line No. Primary Key SearchLine No.NormalInteger4Line No_int
2Entry Type SearchEntry TypeNormalOption4Entry Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “Maintenance”
  • “VAT”
  • “Employee”
  • “Statistical Account”
3Entry No. SearchEntry No.NormalInteger4Entry No_int
4G/L Register No. SearchG/L Register No.NormalInteger4G_L Register No_int
Key to join to the G/L Register table.

Show/hide example query

SELECT
       [Reversal Entry].[G_L Register No_]
       ,[G/L Register].[No_]
FROM
       [CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reversal Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Register$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Register]
              ON
                     [Reversal Entry].[G_L Register No_] = [G/L Register].[No_]
5Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Reversal Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reversal Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Reversal Entry].[Source Code] = [Source Code].[Code]
6Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
7Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
8Source Type SearchSource TypeNormalOption4Source Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
9Source No. SearchSource No.NormalCode20Source No_nvarchar(40)
10Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
11Description SearchDescriptionNormalText100Descriptionnvarchar(200)
12Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
13Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
14Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
15Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
16Debit Amount (LCY) SearchDebit Amount ($)NormalDecimal12Debit Amount (LCY)decimal(38,38)
17Credit Amount (LCY) SearchCredit Amount ($)NormalDecimal12Credit Amount (LCY)decimal(38,38)
18VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
19Posting Date SearchPosting DateNormalDate4Posting Datedatetime
20Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
21Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
22Account No. SearchAccount No.NormalCode20Account No_nvarchar(40)
Key to join to the G/L Account table.

Show/hide example query

SELECT
       [Reversal Entry].[Account No_]
       ,[G/L Account].[No_]
FROM
       [CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reversal Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Account]
              ON
                     [Reversal Entry].[Account No_] = [G/L Account].[No_]
23Account Name SearchAccount NameNormalText100Account Namenvarchar(200)
25Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
26Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
27FA Posting Category SearchFA Posting CategoryNormalOption4FA Posting Categoryint
Available options are:
  • ” “
  • “Disposal”
  • “Bal. Disposal”
28FA Posting Type SearchFA Posting TypeNormalOption4FA Posting Typeint
Available options are:
  • ” “
  • “Acquisition Cost”
  • “Depreciation”
  • “Write-Down”
  • “Appreciation”
  • “Custom 1”
  • “Custom 2”
  • “Proceeds on Disposal”
  • “Salvage Value”
  • “Gain/Loss”
  • “Book Value on Disposal”
30Reversal Type SearchReversal TypeNormalOption4Reversal Typeint
Available options are:
  • “Transaction”
  • “Register”
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
       [Reversal Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reversal Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Reversal Entry].[$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
       [Reversal Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Reversal Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reversal Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Reversal Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Reversal Entry table

Leave a Reply

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