FA 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
   [timestamp]
   ,[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 columns in FA Reclass_ Journal Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Journal Template Name Primary Key Searchnvarchar(20)
3Journal Batch Name Primary Key Searchnvarchar(20)
4Line No_ Primary Key Searchint
5FA No_ Searchnvarchar(40)
6New FA No_ Searchnvarchar(40)
7FA Posting Date Searchdatetime
8Posting Date Searchdatetime
9Depreciation Book Code Searchnvarchar(20)
10Reclassify Acq_ Cost Amount Searchdecimal(38,38)
11Reclassify Acq_ Cost _ Searchdecimal(38,38)
12Reclassify Acquisition Cost Searchtinyint
13Reclassify Depreciation Searchtinyint
14Reclassify Write-Down Searchtinyint
15Reclassify Appreciation Searchtinyint
16Reclassify Custom 1 Searchtinyint
17Reclassify Custom 2 Searchtinyint
18Reclassify Salvage Value Searchtinyint
19Insert Bal_ Account Searchtinyint
20Description Searchnvarchar(200)
21Document No_ Searchnvarchar(40)
22Calc_ DB1 Depr_ Amount Searchtinyint
23$systemId Searchuniqueidentifier
24$systemCreatedAt Searchdatetime
25$systemCreatedBy Searchuniqueidentifier
26$systemModifiedAt Searchdatetime
27$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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