FA Journal Line

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

Table Type: Company

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

Table Number: 5621

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$FA 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_]
   ,[Depreciation Book Code]
   ,[FA Posting Type]
   ,[FA No_]
   ,[FA Posting Date]
   ,[Posting Date]
   ,[Document Type]
   ,[Document Date]
   ,[Document No_]
   ,[External Document No_]
   ,[Description]
   ,[Amount]
   ,[Debit Amount]
   ,[Credit Amount]
   ,[Salvage Value]
   ,[Quantity]
   ,[Correction]
   ,[No_ of Depreciation Days]
   ,[Depr_ until FA Posting Date]
   ,[Depr_ Acquisition Cost]
   ,[FA Posting Group]
   ,[Maintenance Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Insurance No_]
   ,[Budgeted FA No_]
   ,[Use Duplication List]
   ,[Duplicate in Depreciation Book]
   ,[FA Reclassification Entry]
   ,[FA Error Entry No_]
   ,[Reason Code]
   ,[Source Code]
   ,[Recurring Method]
   ,[Recurring Frequency]
   ,[Expiration Date]
   ,[Index Entry]
   ,[Posting No_ Series]
   ,[Dimension Set ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$FA Journal Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in FA 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
5Depreciation Book Code Searchnvarchar(20)
6FA Posting Type Searchint
7FA No_ Searchnvarchar(40)
8FA Posting Date Searchdatetime
9Posting Date Searchdatetime
10Document Type Searchint
11Document Date Searchdatetime
12Document No_ Searchnvarchar(40)
13External Document No_ Searchnvarchar(70)
14Description Searchnvarchar(200)
15Amount Searchdecimal(38,38)
16Debit Amount Searchdecimal(38,38)
17Credit Amount Searchdecimal(38,38)
18Salvage Value Searchdecimal(38,38)
19Quantity Searchdecimal(38,38)
20Correction Searchtinyint
21No_ of Depreciation Days Searchint
22Depr_ until FA Posting Date Searchtinyint
23Depr_ Acquisition Cost Searchtinyint
24FA Posting Group Searchnvarchar(40)
25Maintenance Code Searchnvarchar(20)
26Shortcut Dimension 1 Code Searchnvarchar(40)
27Shortcut Dimension 2 Code Searchnvarchar(40)
28Insurance No_ Searchnvarchar(40)
29Budgeted FA No_ Searchnvarchar(40)
30Use Duplication List Searchtinyint
31Duplicate in Depreciation Book Searchnvarchar(20)
32FA Reclassification Entry Searchtinyint
33FA Error Entry No_ Searchint
34Reason Code Searchnvarchar(20)
35Source Code Searchnvarchar(20)
36Recurring Method Searchint
37Recurring Frequency Searchvarchar(32)
38Expiration Date Searchdatetime
39Index Entry Searchtinyint
40Posting No_ Series Searchnvarchar(40)
41Dimension Set ID Searchint
42$systemId Searchuniqueidentifier
43$systemCreatedAt Searchdatetime
44$systemCreatedBy Searchuniqueidentifier
45$systemModifiedAt Searchdatetime
46$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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