Depreciation Book – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables DDepreciation 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	10	Code	nvarchar(20)
2	Description	Description	Normal	Text	100	Description	nvarchar(200)
3	G/L Integration – Acq. Cost	G/L Integration – Acq. Cost	Normal	Boolean	4	G_L Integration – Acq_ Cost	tinyint
4	G/L Integration – Depreciation	G/L Integration – Depreciation	Normal	Boolean	4	G_L Integration – Depreciation	tinyint
5	G/L Integration – Write-Down	G/L Integration – Write-Down	Normal	Boolean	4	G_L Integration – Write-Down	tinyint
6	G/L Integration – Appreciation	G/L Integration – Appreciation	Normal	Boolean	4	G_L Integration – Appreciation	tinyint
7	G/L Integration – Custom 1	G/L Integration – Custom 1	Normal	Boolean	4	G_L Integration – Custom 1	tinyint
8	G/L Integration – Custom 2	G/L Integration – Custom 2	Normal	Boolean	4	G_L Integration – Custom 2	tinyint
9	G/L Integration – Disposal	G/L Integration – Disposal	Normal	Boolean	4	G_L Integration – Disposal	tinyint
10	G/L Integration – Maintenance	G/L Integration – Maintenance	Normal	Boolean	4	G_L Integration – Maintenance	tinyint
11	Disposal Calculation Method	Disposal Calculation Method	Normal	Option	4	Disposal Calculation Method	int
	Available options are: “Net” “Gross”
12	Use Custom 1 Depreciation	Use Custom 1 Depreciation	Normal	Boolean	4	Use Custom 1 Depreciation	tinyint
13	Allow Depr. below Zero	Allow Depr. below Zero	Normal	Boolean	4	Allow Depr_ below Zero	tinyint
14	Use FA Exch. Rate in Duplic.	Use FA Exch. Rate in Duplic.	Normal	Boolean	4	Use FA Exch_ Rate in Duplic_	tinyint
15	Part of Duplication List	Part of Duplication List	Normal	Boolean	4	Part of Duplication List	tinyint
17	Last Date Modified	Last Date Modified	Normal	Date	4	Last Date Modified	datetime
18	Allow Indexation	Allow Indexation	Normal	Boolean	4	Allow Indexation	tinyint
19	Use Same FA+G/L Posting Dates	Use Same FA+G/L Posting Dates	Normal	Boolean	4	Use Same FA+G_L Posting Dates	tinyint
20	Default Exchange Rate	Default Exchange Rate	Normal	Decimal	12	Default Exchange Rate	decimal(38,38)
23	Use FA Ledger Check	Use FA Ledger Check	Normal	Boolean	4	Use FA Ledger Check	tinyint
24	Use Rounding in Periodic Depr.	Use Rounding in Periodic Depr.	Normal	Boolean	4	Use Rounding in Periodic Depr_	tinyint
25	New Fiscal Year Starting Date	New Fiscal Year Starting Date	Normal	Date	4	New Fiscal Year Starting Date	datetime
26	No. of Days in Fiscal Year	No. of Days in Fiscal Year	Normal	Integer	4	No_ of Days in Fiscal Year	int
27	Allow Changes in Depr. Fields	Allow Changes in Depr. Fields	Normal	Boolean	4	Allow Changes in Depr_ Fields	tinyint
28	Default Final Rounding Amount	Default Final Rounding Amount	Normal	Decimal	12	Default Final Rounding Amount	decimal(38,38)
29	Default Ending Book Value	Default Ending Book Value	Normal	Decimal	12	Default Ending Book Value	decimal(38,38)
32	Periodic Depr. Date Calc.	Periodic Depr. Date Calc.	Normal	Option	4	Periodic Depr_ Date Calc_	int
	Available options are: “Last Entry” “Last Depr. Entry”
33	Mark Errors as Corrections	Mark Errors as Corrections	Normal	Boolean	4	Mark Errors as Corrections	tinyint
34	Add-Curr Exch Rate – Acq. Cost	Add-Curr Exch Rate – Acq. Cost	Normal	Boolean	4	Add-Curr Exch Rate – Acq_ Cost	tinyint
35	Add.-Curr. Exch. Rate – Depr.	Add.-Curr. Exch. Rate – Depr.	Normal	Boolean	4	Add_-Curr_ Exch_ Rate – Depr_	tinyint
36	Add-Curr Exch Rate -Write-Down	Add-Curr Exch Rate -Write-Down	Normal	Boolean	4	Add-Curr Exch Rate -Write-Down	tinyint
37	Add-Curr. Exch. Rate – Apprec.	Add-Curr. Exch. Rate – Apprec.	Normal	Boolean	4	Add-Curr_ Exch_ Rate – Apprec_	tinyint
38	Add-Curr. Exch Rate – Custom 1	Add-Curr. Exch Rate – Custom 1	Normal	Boolean	4	Add-Curr_ Exch Rate – Custom 1	tinyint
39	Add-Curr. Exch Rate – Custom 2	Add-Curr. Exch Rate – Custom 2	Normal	Boolean	4	Add-Curr_ Exch Rate – Custom 2	tinyint
40	Add.-Curr. Exch. Rate – Disp.	Add.-Curr. Exch. Rate – Disp.	Normal	Boolean	4	Add_-Curr_ Exch_ Rate – Disp_	tinyint
41	Add.-Curr. Exch. Rate – Maint.	Add.-Curr. Exch. Rate – Maint.	Normal	Boolean	4	Add_-Curr_ Exch_ Rate – Maint_	tinyint
42	Use Default Dimension	Use Default Dimension	Normal	Boolean	4	Use Default Dimension	tinyint
43	Subtract Disc. in Purch. Inv.	Subtract Disc. in Purch. Inv.	Normal	Boolean	4	Subtract Disc_ in Purch_ Inv_	tinyint
44	Allow Correction of Disposal	Allow Correction of Disposal	Normal	Boolean	4	Allow Correction of Disposal	tinyint
45	Allow more than 360/365 Days	Allow more than 360/365 Days	Normal	Boolean	4	Allow more than 360_365 Days	tinyint
46	VAT on Net Disposal Entries	Tax on Net Disposal Entries	Normal	Boolean	4	VAT on Net Disposal Entries	tinyint
47	Allow Acq. Cost below Zero	Allow Acq. Cost below Zero	Normal	Boolean	4	Allow Acq_ Cost below Zero	tinyint
48	Allow Identical Document No.	Allow Identical Document No.	Normal	Boolean	4	Allow Identical Document No_	tinyint
49	Fiscal Year 365 Days	Fiscal Year 365 Days	Normal	Boolean	4	Fiscal Year 365 Days	tinyint
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Depreciation Book].[$systemModifiedBy] ,[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].[$systemModifiedBy] = [User].[User Security ID]