FA Reclass. Journal Line

Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Reclass. Journal Line

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

Table Type: Company

Table Name: FA Reclass. Journal Line
Database Table Name: CRONUS UK Ltd_$FA Reclass_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5624

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 Reclass. Journal Line can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$FA Reclass_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Journal Template Name]
   ,[Journal Batch Name]
   ,[Line No_]
   ,[FA No_]
   ,[New FA No_]
   ,[FA Posting Date]
   ,[Posting Date]
   ,[Depreciation Book Code]
   ,[Reclassify Acq_ Cost Amount]
   ,[Reclassify Acq_ Cost _]
   ,[Reclassify Acquisition Cost]
   ,[Reclassify Depreciation]
   ,[Reclassify Write-Down]
   ,[Reclassify Appreciation]
   ,[Reclassify Custom 1]
   ,[Reclassify Custom 2]
   ,[Reclassify Salvage Value]
   ,[Insert Bal_ Account]
   ,[Description]
   ,[Document No_]
   ,[Calc_ DB1 Depr_ Amount]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$FA Reclass_ Journal Line$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 Reclass_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Reclass. Journal Line]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [FA Reclass. Journal Line].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Reclass. Journal Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Reclass. Journal Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in FA Reclass. Journal Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Journal Template Name SearchJournal Template NameNormalCode10Journal Template Namenvarchar(20)
2Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4FA No. Primary Key SearchFA No.NormalCode20FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
	       [FA Reclass. Journal Line].[FA No_]
	       ,[Fixed Asset].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Reclass_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Reclass. Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
	              ON
	                     [FA Reclass. Journal Line].[FA No_] = [Fixed Asset].[No_]
5New FA No. SearchNew FA No.NormalCode20New FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
	       [FA Reclass. Journal Line].[New FA No_]
	       ,[Fixed Asset].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Reclass_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Reclass. Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
	              ON
	                     [FA Reclass. Journal Line].[New FA No_] = [Fixed Asset].[No_]
6FA Posting Date SearchFA Posting DateNormalDate4FA Posting Datedatetime
7Posting Date SearchPosting DateNormalDate4Posting Datedatetime
8Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
	       [FA Reclass. Journal Line].[Depreciation Book Code]
	       ,[Depreciation Book].[Code]
	FROM
	       [CRONUS UK Ltd_$FA Reclass_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Reclass. Journal Line]
	LEFT JOIN
	       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
	              ON
	                     [FA Reclass. Journal Line].[Depreciation Book Code] = [Depreciation Book].[Code]
9Reclassify Acq. Cost Amount SearchReclassify Acq. Cost AmountNormalDecimal12Reclassify Acq_ Cost Amountdecimal(38,38)
10Reclassify Acq. Cost % SearchReclassify Acq. Cost %NormalDecimal12Reclassify Acq_ Cost _decimal(38,38)
11Reclassify Acquisition Cost SearchReclassify Acquisition CostNormalBoolean4Reclassify Acquisition Costtinyint
12Reclassify Depreciation SearchReclassify DepreciationNormalBoolean4Reclassify Depreciationtinyint
13Reclassify Write-Down SearchReclassify Write-DownNormalBoolean4Reclassify Write-Downtinyint
14Reclassify Appreciation SearchReclassify AppreciationNormalBoolean4Reclassify Appreciationtinyint
15Reclassify Custom 1 SearchReclassify Custom 1NormalBoolean4Reclassify Custom 1tinyint
16Reclassify Custom 2 SearchReclassify Custom 2NormalBoolean4Reclassify Custom 2tinyint
17Reclassify Salvage Value SearchReclassify Salvage ValueNormalBoolean4Reclassify Salvage Valuetinyint
18Insert Bal. Account SearchInsert Bal. AccountNormalBoolean4Insert Bal_ Accounttinyint
19Description SearchDescriptionNormalText100Descriptionnvarchar(200)
20Document No. SearchDocument No.NormalCode20Document No_nvarchar(40)
22Calc. DB1 Depr. Amount SearchCalc. DB1 Depr. AmountNormalBoolean4Calc_ DB1 Depr_ Amounttinyint
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 Reclass. Journal Line].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$FA Reclass_ Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Reclass. Journal Line]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [FA Reclass. Journal Line].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Reclass. Journal Line

Leave a Reply

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