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

Show/hide columns in FA 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)
12Depreciation Book Code Searchnvarchar(20)
13FA Posting Category Searchint
14FA Posting Type Searchint
15Amount Searchdecimal(38,38)
16Debit Amount Searchdecimal(38,38)
17Credit Amount Searchdecimal(38,38)
18Reclassification Entry Searchtinyint
19Part of Book Value Searchtinyint
20Part of Depreciable Basis Searchtinyint
21Disposal Calculation Method Searchint
22Disposal Entry No_ Searchint
23No_ of Depreciation Days Searchint
24Quantity Searchdecimal(38,38)
25FA No__Budgeted FA No_ Searchnvarchar(40)
26FA Subclass Code Searchnvarchar(20)
27FA Location Code Searchnvarchar(20)
28FA Posting Group Searchnvarchar(40)
29Global Dimension 1 Code Searchnvarchar(40)
30Global Dimension 2 Code Searchnvarchar(40)
31Location Code Searchnvarchar(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 Searchnvarchar(100)
33Depreciation Method Searchint
34Depreciation Starting Date Searchdatetime
35Straight-Line _ Searchdecimal(38,38)
36No_ of Depreciation Years Searchdecimal(38,38)
37Fixed Depr_ Amount Searchdecimal(38,38)
38Declining-Balance _ Searchdecimal(38,38)
39Depreciation Table Code Searchnvarchar(20)
40Journal Batch Name Searchnvarchar(20)
41Source Code Searchnvarchar(20)
42Reason Code Searchnvarchar(20)
43Transaction No_ Searchint
44Bal_ Account Type Searchint
45Bal_ Account No_ Searchnvarchar(40)
46VAT Amount Searchdecimal(38,38)
47Gen_ Posting Type Searchint
48Gen_ Bus_ Posting Group Searchnvarchar(40)
49Gen_ Prod_ Posting Group Searchnvarchar(40)
50FA Class Code Searchnvarchar(20)
51FA Exchange Rate Searchdecimal(38,38)
52Amount (LCY) Searchdecimal(38,38)
53Result on Disposal Searchint
54Correction Searchtinyint
55Index Entry Searchtinyint
56Canceled from FA No_ Searchnvarchar(40)
57Depreciation Ending Date Searchdatetime
58Use FA Ledger Check Searchtinyint
59Automatic Entry Searchtinyint
60Depr_ Starting Date (Custom 1) Searchdatetime
61Depr_ Ending Date (Custom 1) Searchdatetime
62Accum_ Depr_ _ (Custom 1) Searchdecimal(38,38)
63Depr_ _ this year (Custom 1) Searchdecimal(38,38)
64Property Class (Custom 1) Searchint
65No_ Series Searchnvarchar(40)
66Tax Area Code Searchnvarchar(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 Searchtinyint
68Tax Group Code Searchnvarchar(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 Searchtinyint
70VAT Bus_ Posting Group Searchnvarchar(40)
71VAT Prod_ Posting Group Searchnvarchar(40)
72Reversed Searchtinyint
73Reversed by Entry No_ Searchint
74Reversed Entry No_ Searchint
75Dimension Set ID Searchint
76$systemId Searchuniqueidentifier
77$systemCreatedAt Searchdatetime
78$systemCreatedBy Searchuniqueidentifier
79$systemModifiedAt Searchdatetime
80$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from FA Ledger Entry table

Leave a Reply

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