Maintenance Ledger Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesMMaintenance Ledger Entry

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

Table Type: Company

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

Table Number: 5625

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Entry No_]
   ,[G_L Entry No_]
   ,[FA No_]
   ,[FA Posting Date]
   ,[Posting Date]
   ,[Document Type]
   ,[Document Date]
   ,[Document No_]
   ,[External Document No_]
   ,[Description]
   ,[Amount]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Quantity]
   ,[FA No__Budgeted FA No_]
   ,[FA Subclass Code]
   ,[FA Location Code]
   ,[FA Posting Group]
   ,[Global Dimension 1 Code]
   ,[Global Dimension 2 Code]
   ,[Location Code]
   ,[User ID]
   ,[Journal Batch Name]
   ,[Source Code]
   ,[Reason Code]
   ,[Transaction No_]
   ,[Bal_ Account Type]
   ,[Bal_ Account No_]
   ,[VAT Amount]
   ,[Gen_ Posting Type]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[FA Class Code]
   ,[Depreciation Book Code]
   ,[FA Exchange Rate]
   ,[Amount (LCY)]
   ,[Maintenance Code]
   ,[Correction]
   ,[Index Entry]
   ,[Automatic Entry]
   ,[No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Reversed]
   ,[Reversed by Entry No_]
   ,[Reversed Entry No_]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Maintenance Ledger 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_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Maintenance Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Maintenance Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Maintenance Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [Maintenance Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
      ON
         [Maintenance Ledger Entry].[FA Subclass Code] = [FA Subclass].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
      ON
         [Maintenance Ledger Entry].[FA Location Code] = [FA Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
      ON
         [Maintenance Ledger Entry].[FA Posting Group] = [FA Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Maintenance Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Maintenance Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Maintenance Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Maintenance Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Maintenance Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
      ON
         [Maintenance Ledger Entry].[FA Class Code] = [FA Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Maintenance Ledger Entry].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
      ON
         [Maintenance Ledger Entry].[Maintenance Code] = [Maintenance].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Maintenance Ledger Entry].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Maintenance Ledger Entry].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Maintenance Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Maintenance Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Maintenance Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Maintenance Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Maintenance Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Maintenance Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Maintenance Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Maintenance Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Maintenance Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Maintenance Ledger Entry table

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

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[G_L Entry No_]
       ,[G/L Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
              ON
                     [Maintenance Ledger Entry].[G_L Entry No_] = [G/L Entry].[Entry No_]
3FA No. SearchFA No.NormalCode20FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[FA No_]
       ,[Fixed Asset].[No_]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
              ON
                     [Maintenance Ledger Entry].[FA No_] = [Fixed Asset].[No_]
4FA Posting Date SearchFA Posting DateNormalDate4FA Posting Datedatetime
5Posting Date SearchPosting DateNormalDate4Posting Datedatetime
6Document Type SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
7Document Date SearchDocument DateNormalDate4Document Datedatetime
8Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
9External Document No. SearchExternal Document No.NormalCode35External Document No_nvarchar(70)
10Description SearchDescriptionNormalText100Descriptionnvarchar(200)
12Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
13Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
14Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16FA No./Budgeted FA No. SearchFA No./Budgeted FA No.NormalCode20FA No__Budgeted FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[FA No__Budgeted FA No_]
       ,[Fixed Asset].[No_]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
              ON
                     [Maintenance Ledger Entry].[FA No__Budgeted FA No_] = [Fixed Asset].[No_]
17FA Subclass Code SearchFA Subclass CodeNormalCode10FA Subclass Codenvarchar(20)
Key to join to the FA Subclass table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[FA Subclass Code]
       ,[FA Subclass].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
              ON
                     [Maintenance Ledger Entry].[FA Subclass Code] = [FA Subclass].[Code]
18FA Location Code SearchFA Location CodeNormalCode10FA Location Codenvarchar(20)
Key to join to the FA Location table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[FA Location Code]
       ,[FA Location].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
              ON
                     [Maintenance Ledger Entry].[FA Location Code] = [FA Location].[Code]
19FA Posting Group SearchFA Posting GroupNormalCode20FA Posting Groupnvarchar(40)
Key to join to the FA Posting Group table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[FA Posting Group]
       ,[FA Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
              ON
                     [Maintenance Ledger Entry].[FA Posting Group] = [FA Posting Group].[Code]
20Global Dimension 1 Code SearchGlobal Dimension 1 CodeNormalCode20Global Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Global Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Maintenance Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
21Global Dimension 2 Code SearchGlobal Dimension 2 CodeNormalCode20Global Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Global Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Maintenance Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
22Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Maintenance Ledger Entry].[Location Code] = [Location].[Code]
24User ID SearchUser IDNormalCode50User IDnvarchar(100)
25Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
26Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Maintenance Ledger Entry].[Source Code] = [Source Code].[Code]
27Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Maintenance Ledger Entry].[Reason Code] = [Reason Code].[Code]
28Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
29Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
30Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
31VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
32Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
33Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Maintenance Ledger Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
34Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Maintenance Ledger Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
35FA Class Code SearchFA Class CodeNormalCode10FA Class Codenvarchar(20)
Key to join to the FA Class table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[FA Class Code]
       ,[FA Class].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
              ON
                     [Maintenance Ledger Entry].[FA Class Code] = [FA Class].[Code]
36Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Depreciation Book Code]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Maintenance Ledger Entry].[Depreciation Book Code] = [Depreciation Book].[Code]
37FA Exchange Rate SearchFA Exchange RateNormalDecimal12FA Exchange Ratedecimal(38,38)
38Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
39Maintenance Code SearchMaintenance CodeNormalCode10Maintenance Codenvarchar(20)
Key to join to the Maintenance table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Maintenance Code]
       ,[Maintenance].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
              ON
                     [Maintenance Ledger Entry].[Maintenance Code] = [Maintenance].[Code]
40Correction SearchCorrectionNormalBoolean4Correctiontinyint
41Index Entry SearchIndex EntryNormalBoolean4Index Entrytinyint
42Automatic Entry SearchAutomatic EntryNormalBoolean4Automatic Entrytinyint
43No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Maintenance Ledger Entry].[No_ Series] = [No. Series].[Code]
44Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Maintenance Ledger Entry].[Tax Area Code] = [Tax Area].[Code]
45Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
46Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Maintenance Ledger Entry].[Tax Group Code] = [Tax Group].[Code]
47Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
48VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Maintenance Ledger Entry].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
49VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Maintenance Ledger Entry].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
50Reversed SearchReversedNormalBoolean4Reversedtinyint
51Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
52Reversed Entry No. SearchReversed Entry No.NormalInteger4Reversed Entry No_int
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Maintenance Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Maintenance Ledger Entry].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
481Shortcut Dimension 3 Code SearchShortcut Dimension 3 CodeFlowFieldCode20
482Shortcut Dimension 4 Code SearchShortcut Dimension 4 CodeFlowFieldCode20
483Shortcut Dimension 5 Code SearchShortcut Dimension 5 CodeFlowFieldCode20
484Shortcut Dimension 6 Code SearchShortcut Dimension 6 CodeFlowFieldCode20
485Shortcut Dimension 7 Code SearchShortcut Dimension 7 CodeFlowFieldCode20
486Shortcut Dimension 8 Code SearchShortcut Dimension 8 CodeFlowFieldCode20
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
       [Maintenance Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Maintenance Ledger 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
       [Maintenance Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Maintenance Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [Maintenance Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Maintenance Ledger Entry table

LocationSales HeaderSales Header ArchiveTax AreaTax Group
Dynamics 365 BC Table ReferenceTablesCompany TablesMMaintenance Ledger Entry

Leave a Reply

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