FA 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
   [timestamp]
   ,[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 columns in FA Depreciation Book table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2FA No_ Primary Key Searchnvarchar(40)
3Depreciation Book Code Primary Key Searchnvarchar(20)
4Depreciation Method Searchint
5Depreciation Starting Date Searchdatetime
6Straight-Line _ Searchdecimal(38,38)
7No_ of Depreciation Years Searchdecimal(38,38)
8No_ of Depreciation Months Searchdecimal(38,38)
9Fixed Depr_ Amount Searchdecimal(38,38)
10Declining-Balance _ Searchdecimal(38,38)
11Depreciation Table Code Searchnvarchar(20)
12Final Rounding Amount Searchdecimal(38,38)
13Ending Book Value Searchdecimal(38,38)
14FA Posting Group Searchnvarchar(40)
15Depreciation Ending Date Searchdatetime
16Acquisition Date Searchdatetime
17G_L Acquisition Date Searchdatetime
18Disposal Date Searchdatetime
19Last Acquisition Cost Date Searchdatetime
20Last Depreciation Date Searchdatetime
21Last Write-Down Date Searchdatetime
22Last Appreciation Date Searchdatetime
23Last Custom 1 Date Searchdatetime
24Last Custom 2 Date Searchdatetime
25Last Salvage Value Date Searchdatetime
26FA Exchange Rate Searchdecimal(38,38)
27Fixed Depr_ Amount below Zero Searchdecimal(38,38)
28Last Date Modified Searchdatetime
29First User-Defined Depr_ Date Searchdatetime
30Use FA Ledger Check Searchtinyint
31Last Maintenance Date Searchdatetime
32Depr_ below Zero _ Searchdecimal(38,38)
33Projected Disposal Date Searchdatetime
34Projected Proceeds on Disposal Searchdecimal(38,38)
35Depr_ Starting Date (Custom 1) Searchdatetime
36Depr_ Ending Date (Custom 1) Searchdatetime
37Accum_ Depr_ _ (Custom 1) Searchdecimal(38,38)
38Depr_ This Year _ (Custom 1) Searchdecimal(38,38)
39Property Class (Custom 1) Searchint
40Description Searchnvarchar(200)
41Main Asset_Component Searchint
42Component of Main Asset Searchnvarchar(40)
43FA Add_-Currency Factor Searchdecimal(38,38)
44Use Half-Year Convention Searchtinyint
45Use DB_ First Fiscal Year Searchtinyint
46Temp_ Ending Date Searchdatetime
47Temp_ Fixed Depr_ Amount Searchdecimal(38,38)
48Ignore Def_ Ending Book Value Searchtinyint
49Default FA Depreciation Book Searchtinyint
50$systemId Searchuniqueidentifier
51$systemCreatedAt Searchdatetime
52$systemCreatedBy Searchuniqueidentifier
53$systemModifiedAt Searchdatetime
54$systemModifiedBy Searchuniqueidentifier

Leave a Reply

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