Depreciation 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
   [timestamp]
   ,[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]
   ,[Use Accounting Period]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Depreciation Book table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Description Searchnvarchar(200)
4G_L Integration – Acq_ Cost Searchtinyint
5G_L Integration – Depreciation Searchtinyint
6G_L Integration – Write-Down Searchtinyint
7G_L Integration – Appreciation Searchtinyint
8G_L Integration – Custom 1 Searchtinyint
9G_L Integration – Custom 2 Searchtinyint
10G_L Integration – Disposal Searchtinyint
11G_L Integration – Maintenance Searchtinyint
12Disposal Calculation Method Searchint
13Use Custom 1 Depreciation Searchtinyint
14Allow Depr_ below Zero Searchtinyint
15Use FA Exch_ Rate in Duplic_ Searchtinyint
16Part of Duplication List Searchtinyint
17Last Date Modified Searchdatetime
18Allow Indexation Searchtinyint
19Use Same FA+G_L Posting Dates Searchtinyint
20Default Exchange Rate Searchdecimal(38,38)
21Use FA Ledger Check Searchtinyint
22Use Rounding in Periodic Depr_ Searchtinyint
23New Fiscal Year Starting Date Searchdatetime
24No_ of Days in Fiscal Year Searchint
25Allow Changes in Depr_ Fields Searchtinyint
26Default Final Rounding Amount Searchdecimal(38,38)
27Default Ending Book Value Searchdecimal(38,38)
28Periodic Depr_ Date Calc_ Searchint
29Mark Errors as Corrections Searchtinyint
30Add-Curr Exch Rate – Acq_ Cost Searchtinyint
31Add_-Curr_ Exch_ Rate – Depr_ Searchtinyint
32Add-Curr Exch Rate -Write-Down Searchtinyint
33Add-Curr_ Exch_ Rate – Apprec_ Searchtinyint
34Add-Curr_ Exch Rate – Custom 1 Searchtinyint
35Add-Curr_ Exch Rate – Custom 2 Searchtinyint
36Add_-Curr_ Exch_ Rate – Disp_ Searchtinyint
37Add_-Curr_ Exch_ Rate – Maint_ Searchtinyint
38Use Default Dimension Searchtinyint
39Subtract Disc_ in Purch_ Inv_ Searchtinyint
40Allow Correction of Disposal Searchtinyint
41Allow more than 360_365 Days Searchtinyint
42VAT on Net Disposal Entries Searchtinyint
43Allow Acq_ Cost below Zero Searchtinyint
44Allow Identical Document No_ Searchtinyint
45Fiscal Year 365 Days Searchtinyint
46Use Accounting Period Searchtinyint
47$systemId Searchuniqueidentifier
48$systemCreatedAt Searchdatetime
49$systemCreatedBy Searchuniqueidentifier
50$systemModifiedAt Searchdatetime
51$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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