Depreciation Book

Dynamics 365 BC Table ReferenceTablesCompany TablesDDepreciation Book

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

Table Type: Company

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

Table Number: 5611

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Description]
   ,[G_L Integration - Acq_ Cost]
   ,[G_L Integration - Depreciation]
   ,[G_L Integration - Write-Down]
   ,[G_L Integration - Appreciation]
   ,[G_L Integration - Custom 1]
   ,[G_L Integration - Custom 2]
   ,[G_L Integration - Disposal]
   ,[G_L Integration - Maintenance]
   ,[Disposal Calculation Method]
   ,[Use Custom 1 Depreciation]
   ,[Allow Depr_ below Zero]
   ,[Use FA Exch_ Rate in Duplic_]
   ,[Part of Duplication List]
   ,[Last Date Modified]
   ,[Allow Indexation]
   ,[Use Same FA+G_L Posting Dates]
   ,[Default Exchange Rate]
   ,[Use FA Ledger Check]
   ,[Use Rounding in Periodic Depr_]
   ,[New Fiscal Year Starting Date]
   ,[No_ of Days in Fiscal Year]
   ,[Allow Changes in Depr_ Fields]
   ,[Default Final Rounding Amount]
   ,[Default Ending Book Value]
   ,[Periodic Depr_ Date Calc_]
   ,[Mark Errors as Corrections]
   ,[Add-Curr Exch Rate - Acq_ Cost]
   ,[Add_-Curr_ Exch_ Rate - Depr_]
   ,[Add-Curr Exch Rate -Write-Down]
   ,[Add-Curr_ Exch_ Rate - Apprec_]
   ,[Add-Curr_ Exch Rate - Custom 1]
   ,[Add-Curr_ Exch Rate - Custom 2]
   ,[Add_-Curr_ Exch_ Rate - Disp_]
   ,[Add_-Curr_ Exch_ Rate - Maint_]
   ,[Use Default Dimension]
   ,[Subtract Disc_ in Purch_ Inv_]
   ,[Allow Correction of Disposal]
   ,[Allow more than 360_365 Days]
   ,[VAT on Net Disposal Entries]
   ,[Allow Acq_ Cost below Zero]
   ,[Allow Identical Document No_]
   ,[Fiscal Year 365 Days]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

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

Show/hide columns in Depreciation Book table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code SearchCodeNormalCode10Codenvarchar(20)
2Description Primary Key SearchDescriptionNormalText100Descriptionnvarchar(200)
3G/L Integration – Acq. Cost SearchG/L Integration – Acq. CostNormalBoolean4G_L Integration – Acq_ Costtinyint
4G/L Integration – Depreciation SearchG/L Integration – DepreciationNormalBoolean4G_L Integration – Depreciationtinyint
5G/L Integration – Write-Down SearchG/L Integration – Write-DownNormalBoolean4G_L Integration – Write-Downtinyint
6G/L Integration – Appreciation SearchG/L Integration – AppreciationNormalBoolean4G_L Integration – Appreciationtinyint
7G/L Integration – Custom 1 SearchG/L Integration – Custom 1NormalBoolean4G_L Integration – Custom 1tinyint
8G/L Integration – Custom 2 SearchG/L Integration – Custom 2NormalBoolean4G_L Integration – Custom 2tinyint
9G/L Integration – Disposal SearchG/L Integration – DisposalNormalBoolean4G_L Integration – Disposaltinyint
10G/L Integration – Maintenance SearchG/L Integration – MaintenanceNormalBoolean4G_L Integration – Maintenancetinyint
11Disposal Calculation Method SearchDisposal Calculation MethodNormalOption4Disposal Calculation Methodint
Available options are:
  • “Net”
  • “Gross”
12Use Custom 1 Depreciation SearchUse Custom 1 DepreciationNormalBoolean4Use Custom 1 Depreciationtinyint
13Allow Depr. below Zero SearchAllow Depr. below ZeroNormalBoolean4Allow Depr_ below Zerotinyint
14Use FA Exch. Rate in Duplic. SearchUse FA Exch. Rate in Duplic.NormalBoolean4Use FA Exch_ Rate in Duplic_tinyint
15Part of Duplication List SearchPart of Duplication ListNormalBoolean4Part of Duplication Listtinyint
17Last Date Modified SearchLast Date ModifiedNormalDate4Last Date Modifieddatetime
18Allow Indexation SearchAllow IndexationNormalBoolean4Allow Indexationtinyint
19Use Same FA+G/L Posting Dates SearchUse Same FA+G/L Posting DatesNormalBoolean4Use Same FA+G_L Posting Datestinyint
20Default Exchange Rate SearchDefault Exchange RateNormalDecimal12Default Exchange Ratedecimal(38,38)
23Use FA Ledger Check SearchUse FA Ledger CheckNormalBoolean4Use FA Ledger Checktinyint
24Use Rounding in Periodic Depr. SearchUse Rounding in Periodic Depr.NormalBoolean4Use Rounding in Periodic Depr_tinyint
25New Fiscal Year Starting Date SearchNew Fiscal Year Starting DateNormalDate4New Fiscal Year Starting Datedatetime
26No. of Days in Fiscal Year SearchNo. of Days in Fiscal YearNormalInteger4No_ of Days in Fiscal Yearint
27Allow Changes in Depr. Fields SearchAllow Changes in Depr. FieldsNormalBoolean4Allow Changes in Depr_ Fieldstinyint
28Default Final Rounding Amount SearchDefault Final Rounding AmountNormalDecimal12Default Final Rounding Amountdecimal(38,38)
29Default Ending Book Value SearchDefault Ending Book ValueNormalDecimal12Default Ending Book Valuedecimal(38,38)
32Periodic Depr. Date Calc. SearchPeriodic Depr. Date Calc.NormalOption4Periodic Depr_ Date Calc_int
Available options are:
  • “Last Entry”
  • “Last Depr. Entry”
33Mark Errors as Corrections SearchMark Errors as CorrectionsNormalBoolean4Mark Errors as Correctionstinyint
34Add-Curr Exch Rate – Acq. Cost SearchAdd-Curr Exch Rate – Acq. CostNormalBoolean4Add-Curr Exch Rate – Acq_ Costtinyint
35Add.-Curr. Exch. Rate – Depr. SearchAdd.-Curr. Exch. Rate – Depr.NormalBoolean4Add_-Curr_ Exch_ Rate – Depr_tinyint
36Add-Curr Exch Rate -Write-Down SearchAdd-Curr Exch Rate -Write-DownNormalBoolean4Add-Curr Exch Rate -Write-Downtinyint
37Add-Curr. Exch. Rate – Apprec. SearchAdd-Curr. Exch. Rate – Apprec.NormalBoolean4Add-Curr_ Exch_ Rate – Apprec_tinyint
38Add-Curr. Exch Rate – Custom 1 SearchAdd-Curr. Exch Rate – Custom 1NormalBoolean4Add-Curr_ Exch Rate – Custom 1tinyint
39Add-Curr. Exch Rate – Custom 2 SearchAdd-Curr. Exch Rate – Custom 2NormalBoolean4Add-Curr_ Exch Rate – Custom 2tinyint
40Add.-Curr. Exch. Rate – Disp. SearchAdd.-Curr. Exch. Rate – Disp.NormalBoolean4Add_-Curr_ Exch_ Rate – Disp_tinyint
41Add.-Curr. Exch. Rate – Maint. SearchAdd.-Curr. Exch. Rate – Maint.NormalBoolean4Add_-Curr_ Exch_ Rate – Maint_tinyint
42Use Default Dimension SearchUse Default DimensionNormalBoolean4Use Default Dimensiontinyint
43Subtract Disc. in Purch. Inv. SearchSubtract Disc. in Purch. Inv.NormalBoolean4Subtract Disc_ in Purch_ Inv_tinyint
44Allow Correction of Disposal SearchAllow Correction of DisposalNormalBoolean4Allow Correction of Disposaltinyint
45Allow more than 360/365 Days SearchAllow more than 360/365 DaysNormalBoolean4Allow more than 360_365 Daystinyint
46VAT on Net Disposal Entries SearchTax on Net Disposal EntriesNormalBoolean4VAT on Net Disposal Entriestinyint
47Allow Acq. Cost below Zero SearchAllow Acq. Cost below ZeroNormalBoolean4Allow Acq_ Cost below Zerotinyint
48Allow Identical Document No. SearchAllow Identical Document No.NormalBoolean4Allow Identical Document No_tinyint
49Fiscal Year 365 Days SearchFiscal Year 365 DaysNormalBoolean4Fiscal Year 365 Daystinyint
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
	       [Depreciation Book].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Depreciation Book].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Dynamics 365 BC Table ReferenceTablesCompany TablesDDepreciation Book

Leave a Reply

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