FA Setup

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

Table Type: Company

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

Table Number: 5603

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns by name

SELECT
   [Primary Key]
   ,[Allow Posting to Main Assets]
   ,[Default Depr_ Book]
   ,[Allow FA Posting From]
   ,[Allow FA Posting To]
   ,[Insurance Depr_ Book]
   ,[Automatic Insurance Posting]
   ,[Fixed Asset Nos_]
   ,[Insurance Nos_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Setup]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Setup].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Setup].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in FA Setup table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Primary Key Primary Key SearchPrimary KeyNormalCode10Primary Keynvarchar(20)
3Allow Posting to Main Assets SearchAllow Posting to Main AssetsNormalBoolean4Allow Posting to Main Assetstinyint
4Default Depr. Book SearchDefault Depr. BookNormalCode10Default Depr_ Booknvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [FA Setup].[Default Depr_ Book]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [FA Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [FA Setup].[Default Depr_ Book] = [Depreciation Book].[Code]
5Allow FA Posting From SearchAllow FA Posting FromNormalDate4Allow FA Posting Fromdatetime
6Allow FA Posting To SearchAllow FA Posting ToNormalDate4Allow FA Posting Todatetime
7Insurance Depr. Book SearchInsurance Depr. BookNormalCode10Insurance Depr_ Booknvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [FA Setup].[Insurance Depr_ Book]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [FA Setup]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [FA Setup].[Insurance Depr_ Book] = [Depreciation Book].[Code]
8Automatic Insurance Posting SearchAutomatic Insurance PostingNormalBoolean4Automatic Insurance Postingtinyint
9Fixed Asset Nos. SearchFixed Asset Nos.NormalCode20Fixed Asset Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [FA Setup].[Fixed Asset Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [FA Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [FA Setup].[Fixed Asset Nos_] = [No. Series].[Code]
10Insurance Nos. SearchInsurance Nos.NormalCode20Insurance Nos_nvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [FA Setup].[Insurance Nos_]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [FA Setup]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [FA Setup].[Insurance Nos_] = [No. Series].[Code]
6090LastEntryNo SearchLast Entry No. CheckedNormalInteger4
6091Last time scanned SearchLast time scannedNormalDateTime8
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 Setup].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [FA Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [FA 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 Setup].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$FA Setup$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [FA Setup]
LEFT JOIN
       [User] AS [User]
              ON
                     [FA Setup].[$systemModifiedBy] = [User].[User Security ID]

Leave a Reply

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