FA Journal Setup

Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Journal Setup

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

Table Type: Company

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

Table Number: 5605

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Depreciation Book Code]
   ,[User ID]
   ,[FA Jnl_ Template Name]
   ,[FA Jnl_ Batch Name]
   ,[Gen_ Jnl_ Template Name]
   ,[Gen_ Jnl_ Batch Name]
   ,[Insurance Jnl_ Template Name]
   ,[Insurance Jnl_ Batch Name]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in FA Journal Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Depreciation Book Code Primary Key SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [FA Journal Setup].[Depreciation Book Code]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$FA Journal Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Journal Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [FA Journal Setup].[Depreciation Book Code] = [Depreciation Book].[Code]
2User ID Primary Key SearchUser IDNormalCode50User IDnvarchar(100)
3FA Jnl. Template Name SearchFA Jnl. Template NameNormalCode10FA Jnl_ Template Namenvarchar(20)
Key to join to the FA Journal Template table.

Show/hide example query

SELECT
       [FA Journal Setup].[FA Jnl_ Template Name]
       ,[FA Journal Template].[Name]
FROM
       [CRONUS UK Ltd_$FA Journal Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Journal Setup]
LEFT JOIN
       [CRONUS UK Ltd_$FA Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Journal Template]
              ON
                     [FA Journal Setup].[FA Jnl_ Template Name] = [FA Journal Template].[Name]
4FA Jnl. Batch Name SearchFA Jnl. Batch NameNormalCode10FA Jnl_ Batch Namenvarchar(20)
5Gen. Jnl. Template Name SearchGen. Jnl. Template NameNormalCode10Gen_ Jnl_ Template Namenvarchar(20)
6Gen. Jnl. Batch Name SearchGen. Jnl. Batch NameNormalCode10Gen_ Jnl_ Batch Namenvarchar(20)
Key to join to the Deferral Header table.

Show/hide example query

SELECT
       [FA Journal Setup].[Gen_ Jnl_ Batch Name]
       ,[Deferral Header].[Gen_ Jnl_ Batch Name]
FROM
       [CRONUS UK Ltd_$FA Journal Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Journal Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Deferral Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Header]
              ON
                     [FA Journal Setup].[Gen_ Jnl_ Batch Name] = [Deferral Header].[Gen_ Jnl_ Batch Name]
7Insurance Jnl. Template Name SearchInsurance Jnl. Template NameNormalCode10Insurance Jnl_ Template Namenvarchar(20)
Key to join to the Insurance Journal Template table.

Show/hide example query

SELECT
       [FA Journal Setup].[Insurance Jnl_ Template Name]
       ,[Insurance Journal Template].[Name]
FROM
       [CRONUS UK Ltd_$FA Journal Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Journal Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Insurance Journal Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance Journal Template]
              ON
                     [FA Journal Setup].[Insurance Jnl_ Template Name] = [Insurance Journal Template].[Name]
8Insurance Jnl. Batch Name SearchInsurance Jnl. Batch NameNormalCode10Insurance Jnl_ Batch Namenvarchar(20)
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 Journal Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$FA Journal Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Journal Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [FA Journal Setup].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [FA Journal Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$FA Journal Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Journal Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [FA Journal Setup].[$systemModifiedBy] = [User].[User Security ID]
Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Journal Setup

Leave a Reply

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