FA Depreciation Book

Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Depreciation Book

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

Table Type: Company

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

Table Number: 5612

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [FA No_]
   ,[Depreciation Book Code]
   ,[Depreciation Method]
   ,[Depreciation Starting Date]
   ,[Straight-Line _]
   ,[No_ of Depreciation Years]
   ,[No_ of Depreciation Months]
   ,[Fixed Depr_ Amount]
   ,[Declining-Balance _]
   ,[Depreciation Table Code]
   ,[Final Rounding Amount]
   ,[Ending Book Value]
   ,[FA Posting Group]
   ,[Depreciation Ending Date]
   ,[Acquisition Date]
   ,[G_L Acquisition Date]
   ,[Disposal Date]
   ,[Last Acquisition Cost Date]
   ,[Last Depreciation Date]
   ,[Last Write-Down Date]
   ,[Last Appreciation Date]
   ,[Last Custom 1 Date]
   ,[Last Custom 2 Date]
   ,[Last Salvage Value Date]
   ,[FA Exchange Rate]
   ,[Fixed Depr_ Amount below Zero]
   ,[Last Date Modified]
   ,[First User-Defined Depr_ Date]
   ,[Use FA Ledger Check]
   ,[Last Maintenance Date]
   ,[Depr_ below Zero _]
   ,[Projected Disposal Date]
   ,[Projected Proceeds on Disposal]
   ,[Depr_ Starting Date (Custom 1)]
   ,[Depr_ Ending Date (Custom 1)]
   ,[Accum_ Depr_ _ (Custom 1)]
   ,[Depr_ This Year _ (Custom 1)]
   ,[Property Class (Custom 1)]
   ,[Description]
   ,[Main Asset_Component]
   ,[Component of Main Asset]
   ,[FA Add_-Currency Factor]
   ,[Use Half-Year Convention]
   ,[Use DB_ First Fiscal Year]
   ,[Temp_ Ending Date]
   ,[Temp_ Fixed Depr_ Amount]
   ,[Ignore Def_ Ending Book Value]
   ,[Default FA Depreciation Book]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$FA Depreciation Book$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 Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Depreciation Book]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [FA Depreciation Book].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Table Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Table Header]
      ON
         [FA Depreciation Book].[Depreciation Table Code] = [Depreciation Table Header].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
      ON
         [FA Depreciation Book].[FA Posting Group] = [FA Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
      ON
         [FA Depreciation Book].[Maintenance Code Filter] = [Maintenance].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
      ON
         [FA Depreciation Book].[Component of Main Asset] = [Fixed Asset].[No_]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Depreciation Book].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [FA Depreciation Book].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in FA Depreciation Book table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1FA No. SearchFA No.NormalCode20FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
	       [FA Depreciation Book].[FA No_]
	       ,[Fixed Asset].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Depreciation Book]
	LEFT JOIN
	       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
	              ON
	                     [FA Depreciation Book].[FA No_] = [Fixed Asset].[No_]
2Depreciation Book Code Primary Key SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
	       [FA Depreciation Book].[Depreciation Book Code]
	       ,[Depreciation Book].[Code]
	FROM
	       [CRONUS UK Ltd_$FA Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Depreciation Book]
	LEFT JOIN
	       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
	              ON
	                     [FA Depreciation Book].[Depreciation Book Code] = [Depreciation Book].[Code]
3Depreciation Method Primary Key SearchDepreciation MethodNormalOption4Depreciation Methodint
Available options are:
  • “Straight-Line”
  • “Declining-Balance 1”
  • “Declining-Balance 2”
  • “DB1/SL”
  • “DB2/SL”
  • “User-Defined”
  • “Manual”
4Depreciation Starting Date SearchDepreciation Starting DateNormalDate4Depreciation Starting Datedatetime
5Straight-Line % SearchStraight-Line %NormalDecimal12Straight-Line _decimal(38,38)
6No. of Depreciation Years SearchNo. of Depreciation YearsNormalDecimal12No_ of Depreciation Yearsdecimal(38,38)
7No. of Depreciation Months SearchNo. of Depreciation MonthsNormalDecimal12No_ of Depreciation Monthsdecimal(38,38)
8Fixed Depr. Amount SearchFixed Depr. AmountNormalDecimal12Fixed Depr_ Amountdecimal(38,38)
9Declining-Balance % SearchDeclining-Balance %NormalDecimal12Declining-Balance _decimal(38,38)
10Depreciation Table Code SearchDepreciation Table CodeNormalCode10Depreciation Table Codenvarchar(20)
Key to join to the Depreciation Table Header table.

Show/hide example query

SELECT
	       [FA Depreciation Book].[Depreciation Table Code]
	       ,[Depreciation Table Header].[Code]
	FROM
	       [CRONUS UK Ltd_$FA Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Depreciation Book]
	LEFT JOIN
	       [CRONUS UK Ltd_$Depreciation Table Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Table Header]
	              ON
	                     [FA Depreciation Book].[Depreciation Table Code] = [Depreciation Table Header].[Code]
11Final Rounding Amount SearchFinal Rounding AmountNormalDecimal12Final Rounding Amountdecimal(38,38)
12Ending Book Value SearchEnding Book ValueNormalDecimal12Ending Book Valuedecimal(38,38)
13FA Posting Group SearchFA Posting GroupNormalCode20FA Posting Groupnvarchar(40)
Key to join to the FA Posting Group table.

Show/hide example query

SELECT
	       [FA Depreciation Book].[FA Posting Group]
	       ,[FA Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$FA Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Depreciation Book]
	LEFT JOIN
	       [CRONUS UK Ltd_$FA Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Posting Group]
	              ON
	                     [FA Depreciation Book].[FA Posting Group] = [FA Posting Group].[Code]
14Depreciation Ending Date SearchDepreciation Ending DateNormalDate4Depreciation Ending Datedatetime
15Acquisition Cost SearchAcquisition CostFlowFieldDecimal12
16Depreciation SearchDepreciationFlowFieldDecimal12
17Book Value SearchBook ValueFlowFieldDecimal12
18Proceeds on Disposal SearchProceeds on DisposalFlowFieldDecimal12
19Gain/Loss SearchGain/LossFlowFieldDecimal12
20Write-Down SearchWrite-DownFlowFieldDecimal12
21Appreciation SearchAppreciationFlowFieldDecimal12
22Custom 1 SearchCustom 1FlowFieldDecimal12
23Custom 2 SearchCustom 2FlowFieldDecimal12
24Depreciable Basis SearchDepreciable BasisFlowFieldDecimal12
25Salvage Value SearchSalvage ValueFlowFieldDecimal12
26Book Value on Disposal SearchBook Value on DisposalFlowFieldDecimal12
27Maintenance SearchMaintenanceFlowFieldDecimal12
28Maintenance Code Filter SearchMaintenance Code FilterFlowFilterCode10
Key to join to the Maintenance table.

Show/hide example query

SELECT
	       [FA Depreciation Book].[]
	       ,[Maintenance].[Code]
	FROM
	       [CRONUS UK Ltd_$FA Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Depreciation Book]
	LEFT JOIN
	       [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
	              ON
	                     [FA Depreciation Book].[] = [Maintenance].[Code]
29FA Posting Date Filter SearchFA Posting Date FilterFlowFilterDate4
30Acquisition Date SearchAcquisition DateNormalDate4Acquisition Datedatetime
31G/L Acquisition Date SearchG/L Acquisition DateNormalDate4G_L Acquisition Datedatetime
32Disposal Date SearchDisposal DateNormalDate4Disposal Datedatetime
33Last Acquisition Cost Date SearchLast Acquisition Cost DateNormalDate4Last Acquisition Cost Datedatetime
34Last Depreciation Date SearchLast Depreciation DateNormalDate4Last Depreciation Datedatetime
35Last Write-Down Date SearchLast Write-Down DateNormalDate4Last Write-Down Datedatetime
36Last Appreciation Date SearchLast Appreciation DateNormalDate4Last Appreciation Datedatetime
37Last Custom 1 Date SearchLast Custom 1 DateNormalDate4Last Custom 1 Datedatetime
38Last Custom 2 Date SearchLast Custom 2 DateNormalDate4Last Custom 2 Datedatetime
39Last Salvage Value Date SearchLast Salvage Value DateNormalDate4Last Salvage Value Datedatetime
40FA Exchange Rate SearchFA Exchange RateNormalDecimal12FA Exchange Ratedecimal(38,38)
41Fixed Depr. Amount below Zero SearchFixed Depr. Amount below ZeroNormalDecimal12Fixed Depr_ Amount below Zerodecimal(38,38)
42Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
43First User-Defined Depr. Date SearchFirst User-Defined Depr. DateNormalDate4First User-Defined Depr_ Datedatetime
44Use FA Ledger Check SearchUse FA Ledger CheckNormalBoolean4Use FA Ledger Checktinyint
45Last Maintenance Date SearchLast Maintenance DateNormalDate4Last Maintenance Datedatetime
46Depr. below Zero % SearchDepr. below Zero %NormalDecimal12Depr_ below Zero _decimal(38,38)
47Projected Disposal Date SearchProjected Disposal DateNormalDate4Projected Disposal Datedatetime
48Projected Proceeds on Disposal SearchProjected Proceeds on DisposalNormalDecimal12Projected Proceeds on Disposaldecimal(38,38)
50Depr. Starting Date (Custom 1) SearchDepr. Starting Date (Custom 1)NormalDate4Depr_ Starting Date (Custom 1)datetime
51Depr. Ending Date (Custom 1) SearchDepr. Ending Date (Custom 1)NormalDate4Depr_ Ending Date (Custom 1)datetime
52Accum. Depr. % (Custom 1) SearchAccum. Depr. % (Custom 1)NormalDecimal12Accum_ Depr_ _ (Custom 1)decimal(38,38)
53Depr. This Year % (Custom 1) SearchDepr. This Year % (Custom 1)NormalDecimal12Depr_ This Year _ (Custom 1)decimal(38,38)
54Property Class (Custom 1) SearchProperty Class (Custom 1)NormalOption4Property Class (Custom 1)int
Available options are:
  • ” “
  • “Personal Property”
  • “Real Property”
55Description SearchDescriptionNormalText100Descriptionnvarchar(200)
56Main Asset/Component SearchMain Asset/ComponentNormalOption4Main Asset_Componentint
57Component of Main Asset SearchComponent of Main AssetNormalCode20Component of Main Assetnvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
	       [FA Depreciation Book].[Component of Main Asset]
	       ,[Fixed Asset].[No_]
	FROM
	       [CRONUS UK Ltd_$FA Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Depreciation Book]
	LEFT JOIN
	       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
	              ON
	                     [FA Depreciation Book].[Component of Main Asset] = [Fixed Asset].[No_]
58FA Add.-Currency Factor SearchFA Add.-Currency FactorNormalDecimal12FA Add_-Currency Factordecimal(38,38)
59Use Half-Year Convention SearchUse Half-Year ConventionNormalBoolean4Use Half-Year Conventiontinyint
60Use DB% First Fiscal Year SearchUse DB% First Fiscal YearNormalBoolean4Use DB_ First Fiscal Yeartinyint
61Temp. Ending Date SearchTemp. Ending DateNormalDate4Temp_ Ending Datedatetime
62Temp. Fixed Depr. Amount SearchTemp. Fixed Depr. AmountNormalDecimal12Temp_ Fixed Depr_ Amountdecimal(38,38)
63Ignore Def. Ending Book Value SearchIgnore Def. Ending Book ValueNormalBoolean4Ignore Def_ Ending Book Valuetinyint
70Default FA Depreciation Book SearchDefault FA Depreciation BookNormalBoolean4Default FA Depreciation Booktinyint
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 Depreciation Book].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$FA Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [FA Depreciation Book]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [FA Depreciation Book].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesFFA Depreciation Book

Leave a Reply

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