Maintenance 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
   [timestamp]
   ,[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_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Maintenance Ledger Entry].[Location Code] = [Location].[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]

Show/hide columns in Maintenance Ledger Entry table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Entry No_ Primary Key Searchint
3G_L Entry No_ Searchint
4FA No_ Searchnvarchar(40)
5FA Posting Date Searchdatetime
6Posting Date Searchdatetime
7Document Type Searchint
8Document Date Searchdatetime
9Document No_ Searchnvarchar(40)
10External Document No_ Searchnvarchar(70)
11Description Searchnvarchar(200)
12Amount Searchdecimal(38,38)
13Debit Amount Searchdecimal(38,38)
14Credit Amount Searchdecimal(38,38)
15Quantity Searchdecimal(38,38)
16FA No__Budgeted FA No_ Searchnvarchar(40)
17FA Subclass Code Searchnvarchar(20)
18FA Location Code Searchnvarchar(20)
19FA Posting Group Searchnvarchar(40)
20Global Dimension 1 Code Searchnvarchar(40)
21Global Dimension 2 Code Searchnvarchar(40)
22Location Code Searchnvarchar(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]
23User ID Searchnvarchar(100)
24Journal Batch Name Searchnvarchar(20)
25Source Code Searchnvarchar(20)
26Reason Code Searchnvarchar(20)
27Transaction No_ Searchint
28Bal_ Account Type Searchint
29Bal_ Account No_ Searchnvarchar(40)
30VAT Amount Searchdecimal(38,38)
31Gen_ Posting Type Searchint
32Gen_ Bus_ Posting Group Searchnvarchar(40)
33Gen_ Prod_ Posting Group Searchnvarchar(40)
34FA Class Code Searchnvarchar(20)
35Depreciation Book Code Searchnvarchar(20)
36FA Exchange Rate Searchdecimal(38,38)
37Amount (LCY) Searchdecimal(38,38)
38Maintenance Code Searchnvarchar(20)
39Correction Searchtinyint
40Index Entry Searchtinyint
41Automatic Entry Searchtinyint
42No_ Series Searchnvarchar(40)
43Tax Area Code Searchnvarchar(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]
44Tax Liable Searchtinyint
45Tax Group Code Searchnvarchar(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]
46Use Tax Searchtinyint
47VAT Bus_ Posting Group Searchnvarchar(40)
48VAT Prod_ Posting Group Searchnvarchar(40)
49Reversed Searchtinyint
50Reversed by Entry No_ Searchint
51Reversed Entry No_ Searchint
52Dimension Set ID Searchint
53$systemId Searchuniqueidentifier
54$systemCreatedAt Searchdatetime
55$systemCreatedBy Searchuniqueidentifier
56$systemModifiedAt Searchdatetime
57$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Maintenance Ledger Entry table

Leave a Reply

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