FA Ledger Entry

Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Ledger Entry

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

Table Type: Company

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

Table Number: 5601

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$FA 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]
   ,[Depreciation Book Code]
   ,[FA Posting Category]
   ,[FA Posting Type]
   ,[Amount]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Reclassification Entry]
   ,[Part of Book Value]
   ,[Part of Depreciable Basis]
   ,[Disposal Calculation Method]
   ,[Disposal Entry No_]
   ,[No_ of Depreciation Days]
   ,[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]
   ,[Depreciation Method]
   ,[Depreciation Starting Date]
   ,[Straight-Line _]
   ,[No_ of Depreciation Years]
   ,[Fixed Depr_ Amount]
   ,[Declining-Balance _]
   ,[Depreciation Table Code]
   ,[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]
   ,[FA Exchange Rate]
   ,[Amount (LCY)]
   ,[Result on Disposal]
   ,[Correction]
   ,[Index Entry]
   ,[Canceled from FA No_]
   ,[Depreciation Ending Date]
   ,[Use FA Ledger Check]
   ,[Automatic Entry]
   ,[Depr_ Starting Date (Custom 1)]
   ,[Depr_ Ending Date (Custom 1)]
   ,[Accum_ Depr_ _ (Custom 1)]
   ,[Depr_ _ this year (Custom 1)]
   ,[Property Class (Custom 1)]
   ,[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_$FA 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_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [FA Ledger Entry].[Document Type] = [Sales Header].[Document Type]
      AND
         [FA Ledger Entry].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [FA Ledger Entry].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [FA Ledger Entry].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [FA Ledger Entry].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Subclass$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Subclass]
      ON
         [FA Ledger Entry].[FA Subclass Code] = [FA Subclass].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Location]
      ON
         [FA 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
         [FA Ledger Entry].[FA Posting Group] = [FA Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [FA Ledger Entry].[Global Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [FA Ledger Entry].[Global Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [FA Ledger Entry].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Table Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Table Header]
      ON
         [FA Ledger Entry].[Depreciation Table Code] = [Depreciation Table Header].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [FA Ledger Entry].[Source Code] = [Source Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [FA Ledger Entry].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
      ON
         [FA Ledger Entry].[FA Class Code] = [FA Class].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [FA Ledger Entry].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [FA 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
         [FA 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
         [FA Ledger Entry].[Shortcut Dimension 3 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [FA Ledger Entry].[Shortcut Dimension 4 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [FA Ledger Entry].[Shortcut Dimension 5 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [FA Ledger Entry].[Shortcut Dimension 6 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [FA Ledger Entry].[Shortcut Dimension 7 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [FA Ledger Entry].[Shortcut Dimension 8 Code] = [Dimension].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Ledger Entry].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Ledger Entry].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in FA 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
       [FA Ledger Entry].[G_L Entry No_]
       ,[G/L Entry].[Entry No_]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$G_L Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [G/L Entry]
              ON
                     [FA 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
       [FA Ledger Entry].[FA No_]
       ,[Fixed Asset].[No_]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
              ON
                     [FA 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)
11Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [FA Ledger Entry].[Depreciation Book Code]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [FA Ledger Entry].[Depreciation Book Code] = [Depreciation Book].[Code]
12FA Posting Category SearchFA Posting CategoryNormalOption4FA Posting Categoryint
Available options are:
  • ” “
  • “Disposal”
  • “Bal. Disposal”
13FA 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”
14Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
15Debit Amount SearchDebit AmountNormalDecimal12Debit Amountdecimal(38,38)
16Credit Amount SearchCredit AmountNormalDecimal12Credit Amountdecimal(38,38)
17Reclassification Entry SearchReclassification EntryNormalBoolean4Reclassification Entrytinyint
18Part of Book Value SearchPart of Book ValueNormalBoolean4Part of Book Valuetinyint
19Part of Depreciable Basis SearchPart of Depreciable BasisNormalBoolean4Part of Depreciable Basistinyint
20Disposal Calculation Method SearchDisposal Calculation MethodNormalOption4Disposal Calculation Methodint
Available options are:
  • ” “
  • “Net”
  • “Gross”
21Disposal Entry No. SearchDisposal Entry No.NormalInteger4Disposal Entry No_int
22No. of Depreciation Days SearchNo. of Depreciation DaysNormalInteger4No_ of Depreciation Daysint
23Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
24FA 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
       [FA Ledger Entry].[FA No__Budgeted FA No_]
       ,[Fixed Asset].[No_]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
              ON
                     [FA Ledger Entry].[FA No__Budgeted FA No_] = [Fixed Asset].[No_]
25FA Subclass Code SearchFA Subclass CodeNormalCode10FA Subclass Codenvarchar(20)
Key to join to the FA Subclass table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [FA Ledger Entry].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [FA Ledger Entry].[Location Code] = [Location].[Code]
32User ID SearchUser IDNormalCode50User IDnvarchar(100)
33Depreciation Method SearchDepreciation MethodNormalOption4Depreciation Methodint
Available options are:
  • “Straight-Line”
  • “Declining-Balance 1”
  • “Declining-Balance 2”
  • “DB1/SL”
  • “DB2/SL”
  • “User-Defined”
  • “Manual”
34Depreciation Starting Date SearchDepreciation Starting DateNormalDate4Depreciation Starting Datedatetime
35Straight-Line % SearchStraight-Line %NormalDecimal12Straight-Line _decimal(38,38)
36No. of Depreciation Years SearchNo. of Depreciation YearsNormalDecimal12No_ of Depreciation Yearsdecimal(38,38)
37Fixed Depr. Amount SearchFixed Depr. AmountNormalDecimal12Fixed Depr_ Amountdecimal(38,38)
38Declining-Balance % SearchDeclining-Balance %NormalDecimal12Declining-Balance _decimal(38,38)
39Depreciation Table Code SearchDepreciation Table CodeNormalCode10Depreciation Table Codenvarchar(20)
Key to join to the Depreciation Table Header table.

Show/hide example query

SELECT
       [FA Ledger Entry].[Depreciation Table Code]
       ,[Depreciation Table Header].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Table Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Table Header]
              ON
                     [FA Ledger Entry].[Depreciation Table Code] = [Depreciation Table Header].[Code]
40Journal Batch Name SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
41Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

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

Show/hide example query

SELECT
       [FA Ledger Entry].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [FA Ledger Entry].[Reason Code] = [Reason Code].[Code]
43Transaction No. SearchTransaction No.NormalInteger4Transaction No_int
44Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Customer”
  • “Vendor”
  • “Bank Account”
  • “Fixed Asset”
  • “IC Partner”
  • “Employee”
  • “Allocation Account”
45Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
46VAT Amount SearchTax AmountNormalDecimal12VAT Amountdecimal(38,38)
47Gen. Posting Type SearchGen. Posting TypeNormalOption4Gen_ Posting Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Sale”
  • “Settlement”
48Gen. 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
       [FA Ledger Entry].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [FA Ledger Entry].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
49Gen. 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
       [FA Ledger Entry].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [FA Ledger Entry].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
50FA Class Code SearchFA Class CodeNormalCode10FA Class Codenvarchar(20)
Key to join to the FA Class table.

Show/hide example query

SELECT
       [FA Ledger Entry].[FA Class Code]
       ,[FA Class].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$FA Class$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Class]
              ON
                     [FA Ledger Entry].[FA Class Code] = [FA Class].[Code]
51FA Exchange Rate SearchFA Exchange RateNormalDecimal12FA Exchange Ratedecimal(38,38)
52Amount (LCY) SearchAmount ($)NormalDecimal12Amount (LCY)decimal(38,38)
53Result on Disposal SearchResult on DisposalNormalOption4Result on Disposalint
Available options are:
  • ” “
  • “Gain”
  • “Loss”
54Correction SearchCorrectionNormalBoolean4Correctiontinyint
55Index Entry SearchIndex EntryNormalBoolean4Index Entrytinyint
56Canceled from FA No. SearchCanceled from FA No.NormalCode20Canceled from FA No_nvarchar(40)
57Depreciation Ending Date SearchDepreciation Ending DateNormalDate4Depreciation Ending Datedatetime
58Use FA Ledger Check SearchUse FA Ledger CheckNormalBoolean4Use FA Ledger Checktinyint
59Automatic Entry SearchAutomatic EntryNormalBoolean4Automatic Entrytinyint
60Depr. Starting Date (Custom 1) SearchDepr. Starting Date (Custom 1)NormalDate4Depr_ Starting Date (Custom 1)datetime
61Depr. Ending Date (Custom 1) SearchDepr. Ending Date (Custom 1)NormalDate4Depr_ Ending Date (Custom 1)datetime
62Accum. Depr. % (Custom 1) SearchAccum. Depr. % (Custom 1)NormalDecimal12Accum_ Depr_ _ (Custom 1)decimal(38,38)
63Depr. % this year (Custom 1) SearchDepr. % this year (Custom 1)NormalDecimal12Depr_ _ this year (Custom 1)decimal(38,38)
64Property Class (Custom 1) SearchProperty Class (Custom 1)NormalOption4Property Class (Custom 1)int
Available options are:
  • ” “
  • “Personal Property”
  • “Real Property”
65No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [FA Ledger Entry].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [FA Ledger Entry].[Tax Group Code] = [Tax Group].[Code]
69Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
70VAT 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
       [FA Ledger Entry].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [FA Ledger Entry].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
71VAT 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
       [FA Ledger Entry].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [FA Ledger Entry].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
72Reversed SearchReversedNormalBoolean4Reversedtinyint
73Reversed by Entry No. SearchReversed by Entry No.NormalInteger4Reversed by Entry No_int
74Reversed 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
       [FA Ledger Entry].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [FA 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
       [FA Ledger Entry].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [FA 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
       [FA Ledger Entry].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$FA Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Ledger Entry]
LEFT JOIN
       [User] AS [User]
              ON
                     [FA Ledger Entry].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from FA Ledger Entry table

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

Leave a Reply

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