FA Ledger Entry – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables FFA 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 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_$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_$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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Entry No.	Entry No.	Normal	Integer	4	Entry No_	int
2	G/L Entry No.	G/L Entry No.	Normal	Integer	4	G_L Entry No_	int
3	FA No.	FA No.	Normal	Code	20	FA 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_]
4	FA Posting Date	FA Posting Date	Normal	Date	4	FA Posting Date	datetime
5	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
6	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
7	Document Date	Document Date	Normal	Date	4	Document Date	datetime
8	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
9	External Document No.	External Document No.	Normal	Code	35	External Document No_	nvarchar(70)
10	Description	Description	Normal	Text	100	Description	nvarchar(200)
11	Depreciation Book Code	Depreciation Book Code	Normal	Code	10	Depreciation Book Code	nvarchar(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]
12	FA Posting Category	FA Posting Category	Normal	Option	4	FA Posting Category	int
	Available options are: ” “ “Disposal” “Bal. Disposal”
13	FA Posting Type	FA Posting Type	Normal	Option	4	FA Posting Type	int
	Available options are: “Acquisition Cost” “Depreciation” “Write-Down” “Appreciation” “Custom 1” “Custom 2” “Proceeds on Disposal” “Salvage Value” “Gain/Loss” “Book Value on Disposal”
14	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
15	Debit Amount	Debit Amount	Normal	Decimal	12	Debit Amount	decimal(38,38)
16	Credit Amount	Credit Amount	Normal	Decimal	12	Credit Amount	decimal(38,38)
17	Reclassification Entry	Reclassification Entry	Normal	Boolean	4	Reclassification Entry	tinyint
18	Part of Book Value	Part of Book Value	Normal	Boolean	4	Part of Book Value	tinyint
19	Part of Depreciable Basis	Part of Depreciable Basis	Normal	Boolean	4	Part of Depreciable Basis	tinyint
20	Disposal Calculation Method	Disposal Calculation Method	Normal	Option	4	Disposal Calculation Method	int
	Available options are: ” “ “Net” “Gross”
21	Disposal Entry No.	Disposal Entry No.	Normal	Integer	4	Disposal Entry No_	int
22	No. of Depreciation Days	No. of Depreciation Days	Normal	Integer	4	No_ of Depreciation Days	int
23	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
24	FA No./Budgeted FA No.	FA No./Budgeted FA No.	Normal	Code	20	FA No__Budgeted FA No_	nvarchar(40)
25	FA Subclass Code	FA Subclass Code	Normal	Code	10	FA Subclass Code	nvarchar(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]
26	FA Location Code	FA Location Code	Normal	Code	10	FA Location Code	nvarchar(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]
27	FA Posting Group	FA Posting Group	Normal	Code	20	FA Posting Group	nvarchar(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]
28	Global Dimension 1 Code	Global Dimension 1 Code	Normal	Code	20	Global Dimension 1 Code	nvarchar(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]
29	Global Dimension 2 Code	Global Dimension 2 Code	Normal	Code	20	Global Dimension 2 Code	nvarchar(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]
30	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
32	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
33	Depreciation Method	Depreciation Method	Normal	Option	4	Depreciation Method	int
	Available options are: “Straight-Line” “Declining-Balance 1” “Declining-Balance 2” “DB1/SL” “DB2/SL” “User-Defined” “Manual”
34	Depreciation Starting Date	Depreciation Starting Date	Normal	Date	4	Depreciation Starting Date	datetime
35	Straight-Line %	Straight-Line %	Normal	Decimal	12	Straight-Line _	decimal(38,38)
36	No. of Depreciation Years	No. of Depreciation Years	Normal	Decimal	12	No_ of Depreciation Years	decimal(38,38)
37	Fixed Depr. Amount	Fixed Depr. Amount	Normal	Decimal	12	Fixed Depr_ Amount	decimal(38,38)
38	Declining-Balance %	Declining-Balance %	Normal	Decimal	12	Declining-Balance _	decimal(38,38)
39	Depreciation Table Code	Depreciation Table Code	Normal	Code	10	Depreciation Table Code	nvarchar(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]
40	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
41	Source Code	Source Code	Normal	Code	10	Source Code	nvarchar(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]
42	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(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]
43	Transaction No.	Transaction No.	Normal	Integer	4	Transaction No_	int
44	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Customer” “Vendor” “Bank Account” “Fixed Asset” “IC Partner” “Employee” “Allocation Account”
45	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
46	VAT Amount	Tax Amount	Normal	Decimal	12	VAT Amount	decimal(38,38)
47	Gen. Posting Type	Gen. Posting Type	Normal	Option	4	Gen_ Posting Type	int
	Available options are: ” “ “Purchase” “Sale” “Settlement”
48	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(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]
49	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(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]
50	FA Class Code	FA Class Code	Normal	Code	10	FA Class Code	nvarchar(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]
51	FA Exchange Rate	FA Exchange Rate	Normal	Decimal	12	FA Exchange Rate	decimal(38,38)
52	Amount (LCY)	Amount ($)	Normal	Decimal	12	Amount (LCY)	decimal(38,38)
53	Result on Disposal	Result on Disposal	Normal	Option	4	Result on Disposal	int
	Available options are: ” “ “Gain” “Loss”
54	Correction	Correction	Normal	Boolean	4	Correction	tinyint
55	Index Entry	Index Entry	Normal	Boolean	4	Index Entry	tinyint
56	Canceled from FA No.	Canceled from FA No.	Normal	Code	20	Canceled from FA No_	nvarchar(40)
	Key to join to the Fixed Asset table. Show/hide example query SELECT [FA Ledger Entry].[Canceled from 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].[Canceled from FA No_] = [Fixed Asset].[No_]
57	Depreciation Ending Date	Depreciation Ending Date	Normal	Date	4	Depreciation Ending Date	datetime
58	Use FA Ledger Check	Use FA Ledger Check	Normal	Boolean	4	Use FA Ledger Check	tinyint
59	Automatic Entry	Automatic Entry	Normal	Boolean	4	Automatic Entry	tinyint
60	Depr. Starting Date (Custom 1)	Depr. Starting Date (Custom 1)	Normal	Date	4	Depr_ Starting Date (Custom 1)	datetime
61	Depr. Ending Date (Custom 1)	Depr. Ending Date (Custom 1)	Normal	Date	4	Depr_ Ending Date (Custom 1)	datetime
62	Accum. Depr. % (Custom 1)	Accum. Depr. % (Custom 1)	Normal	Decimal	12	Accum_ Depr_ _ (Custom 1)	decimal(38,38)
63	Depr. % this year (Custom 1)	Depr. % this year (Custom 1)	Normal	Decimal	12	Depr_ _ this year (Custom 1)	decimal(38,38)
64	Property Class (Custom 1)	Property Class (Custom 1)	Normal	Option	4	Property Class (Custom 1)	int
	Available options are: ” “ “Personal Property” “Real Property”
65	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(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]
66	Tax Area Code	Tax Area Code	Normal	Code	20	Tax Area Code	nvarchar(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]
67	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
68	Tax Group Code	Tax Group Code	Normal	Code	20	Tax Group Code	nvarchar(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]
69	Use Tax	Use Tax	Normal	Boolean	4	Use Tax	tinyint
70	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(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]
71	VAT Prod. Posting Group	VAT Prod. Posting Group	Normal	Code	20	VAT Prod_ Posting Group	nvarchar(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]
72	Reversed	Reversed	Normal	Boolean	4	Reversed	tinyint
73	Reversed by Entry No.	Reversed by Entry No.	Normal	Integer	4	Reversed by Entry No_	int
74	Reversed Entry No.	Reversed Entry No.	Normal	Integer	4	Reversed Entry No_	int
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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]
481	Shortcut Dimension 3 Code	Shortcut Dimension 3 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [FA Ledger Entry].[] ,[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].[] = [Dimension].[Code]
482	Shortcut Dimension 4 Code	Shortcut Dimension 4 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [FA Ledger Entry].[] ,[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].[] = [Dimension].[Code]
483	Shortcut Dimension 5 Code	Shortcut Dimension 5 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [FA Ledger Entry].[] ,[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].[] = [Dimension].[Code]
484	Shortcut Dimension 6 Code	Shortcut Dimension 6 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [FA Ledger Entry].[] ,[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].[] = [Dimension].[Code]
485	Shortcut Dimension 7 Code	Shortcut Dimension 7 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [FA Ledger Entry].[] ,[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].[] = [Dimension].[Code]
486	Shortcut Dimension 8 Code	Shortcut Dimension 8 Code	FlowField	Code	20
	Key to join to the Dimension table. Show/hide example query SELECT [FA Ledger Entry].[] ,[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].[] = [Dimension].[Code]
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from FA Ledger Entry table

Dynamics 365 BC Table Reference Tables Company Tables FFA Ledger Entry

Leave a Reply Cancel reply