tableFixed Assetsofficial - Microsoftderived - from the source, no model text

Table 5612 "FA Depreciation Book"

Base Application · Microsoft.FixedAssets.Depreciation

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC25-27unchanged
  4. BC2854 fields changed, 11 procedures added
  5. BC29-30unchanged

Neighbourhood 24 connected objects and pages

Table 5601 "FA Ledger Entry" (relates to, 13 links)FA Ledger EntryTable 5600 "Fixed Asset" (relates to, 2 links)Fixed AssetTable 5606 "FA Posting Group" (relates to)FA Posting GroupTable 5611 "Depreciation Book" (relates to)Depreciation BookTable 5625 "Maintenance Ledger Entry" (relates to)Table 5626 "Maintenance" (relates to)MaintenanceTable 5642 "Depreciation Table Header" (relates to)Depreciation Table HeaderPage 5602 "Fixed Asset Statistics" (pages and codeunits on it)Fixed Asset StatisticsPage 5603 "Main Asset Statistics" (pages and codeunits on it)Main Asset StatisticsPage 5619 "FA Depreciation Books" (pages and codeunits on it)FA Depreciation BooksPage 5666 "FA Depreciation Books Subform" (pages and codeunits on it)FA Depreciation Books SubformPage 9277 "FA Posting Types Overv. Matrix" (pages and codeunits on it)FA Posting Types Overv. MatrixTable extension 6266 "Sust. FA Depreciation Book" (extended by)Sust. FA Depreciation BookCodeunit 5616 "Depreciation Calculation" (calls, 3 links)Depreciation CalculationCodeunit 5617 "FA Date Calculation" (calls)FA Date CalculationCodeunit 5623 "FA MoveEntries" (calls)Codeunit 8703 "Feature Telemetry" (calls)Table 5600 "Fixed Asset" (referenced by)Table 5851 "Invt. Document Line" (referenced by)Table 5855 "Invt. Shipment Line" (referenced by)Depreciate or amortize FA (Learn pages)Manage fixed assets (Learn pages)Set Up General Fixed Assets (FA) Information (Learn pages)Straight-Line Depreciation of Fixed Assets in the UK (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.FixedAssets.Depreciation · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5619 “FA Depreciation Books” (2 Learn pages), Page 5602 “Fixed Asset Statistics” (1), Page 5603 “Main Asset Statistics” (1), Page 5666 “FA Depreciation Books Subform” (1), Page 9277 “FA Posting Types Overv. Matrix” (1).

Properties

Property Value
Caption FA Depreciation Book
DataClassification CustomerContent
Permissions TableData “FA Ledger Entry” = r, TableData “Maintenance Ledger Entry” = r

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 FA No. Δ BC28 Code[20] Specifies the number of the related fixed asset. TableRelation Table 5600 “Fixed Asset” (Fixed Asset); NotBlank
2 Depreciation Book Code Δ BC28 Code[10] Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line. TableRelation Table 5611 “Depreciation Book” (Depreciation Book); NotBlank
3 Depreciation Method Δ BC28 Enum “FA Depreciation Method” Specifies how depreciation is calculated for the depreciation book. enum Enum 5610 “FA Depreciation Method”
4 Depreciation Starting Date Δ BC28 Date Specifies the date on which depreciation of the fixed asset starts.
5 Straight-Line % Δ BC28 Decimal Specifies the percentage to depreciate the fixed asset by the straight-line principle, but with a fixed yearly percentage.
6 No. of Depreciation Years Δ BC28 Decimal Specifies the length of the depreciation period, expressed in years.
7 No. of Depreciation Months Δ BC28 Decimal Specifies the length of the depreciation period, expressed in months.
8 Fixed Depr. Amount Δ BC28 Decimal Specifies an amount to depreciate the fixed asset, by a fixed yearly amount.
9 Declining-Balance % Δ BC28 Decimal Specifies the percentage to depreciate the fixed asset by the declining-balance principle, but with a fixed yearly percentage.
10 Depreciation Table Code Δ BC28 Code[10] Specifies the code of the depreciation table to use if you have selected the User-Defined option in the Depreciation Method field. TableRelation Table 5642 “Depreciation Table Header” (Depreciation Table Header)
11 Final Rounding Amount Δ BC28 Decimal Specifies the final rounding amount to use.
12 Ending Book Value Δ BC28 Decimal Specifies the amount to use as the ending book value.
13 FA Posting Group Δ BC28 Code[20] Specifies which posting group is used for the depreciation book when posting fixed asset transactions. TableRelation Table 5606 “FA Posting Group” (FA Posting Group)
14 Depreciation Ending Date Δ BC28 Date Specifies the date on which depreciation of the fixed asset ends.
15 Acquisition Cost Δ BC28 Decimal Specifies the total acquisition cost for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Acquisition Cost”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
16 Depreciation Δ BC28 Decimal Specifies the total depreciation for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(Depreciation), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
17 Book Value Δ BC28 Decimal Specifies the book value for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “Part of Book Value” = const(true), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
18 Proceeds on Disposal Δ BC28 Decimal Specifies the total proceeds on disposal for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Proceeds on Disposal”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
19 Gain/Loss Δ BC28 Decimal Specifies the total gain (credit) or loss (debit) for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Gain/Loss”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
20 Write-Down Δ BC28 Decimal Specifies the total LCY amount of write-down entries for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Write-Down”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
21 Appreciation Δ BC28 Decimal Specifies the total appreciation for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(Appreciation), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
22 Custom 1 Δ BC28 Decimal Specifies the total LCY amount for custom 1 entries for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Custom 1”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
23 Custom 2 Δ BC28 Decimal Specifies the total LCY amount for custom 2 entries for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Custom 2”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
24 Depreciable Basis Δ BC28 Decimal Specifies the depreciable basis amount for the fixed asset. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “Part of Depreciable Basis” = const(true), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
25 Salvage Value Δ BC28 Decimal Specifies the estimated residual value of a fixed asset when it can no longer be used. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“Salvage Value”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
26 Book Value on Disposal Δ BC28 Decimal Specifies the total LCY amount of entries posted with the Book Value on Disposal posting type. Entries of this kind are created when you post disposal of a fixed asset to a depreciation book where the Gross method has been selected in the Disposal Calculation Method field. FlowField: sum(“FA Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(Disposal), “FA Posting Type” = const(“Book Value on Disposal”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
27 Maintenance Δ BC28 Decimal Specifies the total maintenance cost for the fixed asset. FlowField: sum(“Maintenance Ledger Entry”.Amount where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “Maintenance Code” = field(“Maintenance Code Filter”), “FA Posting Date” = field(“FA Posting Date Filter”))); not editable
28 Maintenance Code Filter Code[10] — TableRelation Table 5626 “Maintenance”; FlowFilter
29 FA Posting Date Filter Date — FlowFilter
30 Acquisition Date Δ BC28 Date Specifies the FA posting date of the first posted acquisition cost. not editable
31 G/L Acquisition Date Δ BC28 Date Specifies the G/L posting date of the first posted acquisition cost. not editable
32 Disposal Date Δ BC28 Date Specifies the FA posting date of the first posted disposal amount. not editable
33 Last Acquisition Cost Date Δ BC28 Date Specifies the total percentage of acquisition cost that can be allocated when acquisition cost is posted. not editable
34 Last Depreciation Date Δ BC28 Date Specifies the FA posting date of the last posted depreciation. not editable
35 Last Write-Down Date Δ BC28 Date Specifies the FA posting date of the last posted write-down. not editable
36 Last Appreciation Date Δ BC28 Date Specifies the sum that applies to appreciations. not editable
37 Last Custom 1 Date Δ BC28 Date Specifies the FA posting date of the last posted custom 1 entry. not editable
38 Last Custom 2 Date Δ BC28 Date Specifies the FA posting date of the last posted custom 2 entry. not editable
39 Last Salvage Value Date Δ BC28 Date Specifies if related salvage value entries are included in the batch job . not editable
40 FA Exchange Rate Δ BC28 Decimal Specifies a decimal number, which will be used as an exchange rate when duplicating journal lines to this depreciation book.
41 Fixed Depr. Amount below Zero Δ BC28 Decimal Specifies a positive amount if you have selected the Allow Depr. below Zero field in the depreciation book.
42 Last Date Modified Date — not editable
43 First User-Defined Depr. Date Δ BC28 Date Specifies the starting date for the user-defined depreciation table if you have entered a code in the Depreciation Table Code field.
44 Use FA Ledger Check Δ BC28 Boolean Specifies which checks to perform before posting a journal line.
45 Last Maintenance Date Date — not editable
46 Depr. below Zero % Δ BC28 Decimal Specifies a percentage if you have selected the Allow Depr. below Zero field in the depreciation book.
47 Projected Disposal Date Δ BC28 Date Specifies the date on which you want to dispose of the fixed asset.
48 Projected Proceeds on Disposal Δ BC28 Decimal Specifies the expected proceeds from disposal of the fixed asset.
50 Depr. Starting Date (Custom 1) Date Specifies the starting date for depreciation of custom 1 entries. via Page 5619 “FA Depreciation Books”
51 Depr. Ending Date (Custom 1) Date Specifies the ending date for depreciation of custom 1 entries. via Page 5619 “FA Depreciation Books”
52 Accum. Depr. % (Custom 1) Δ BC28 Decimal Specifies the total percentage for depreciation of custom 1 entries. via Page 5619 “FA Depreciation Books”
53 Depr. This Year % (Custom 1) Δ BC28 Decimal Specifies the percentage for depreciation of custom 1 entries for the current year. via Page 5619 “FA Depreciation Books”
54 Property Class (Custom 1) Option Specifies the property class of the asset. via Page 5619 “FA Depreciation Books” OptionCaption: ,Personal Property,Real Property
55 Description Δ BC28 Text[100] Specifies the value in the Description field on the fixed asset card. not editable
56 Main Asset/Component Enum “FA Component Type” — enum Enum 5619 “FA Component Type”; not editable
57 Component of Main Asset Code[20] — TableRelation Table 5600 “Fixed Asset” (Fixed Asset); not editable
58 FA Add.-Currency Factor Δ BC28 Decimal —
59 Use Half-Year Convention Δ BC28 Boolean Specifies that the Half-Year Convention is to be applied to the selected depreciation method.
60 Use DB% First Fiscal Year Δ BC28 Boolean Specifies that the depreciation methods DB1/SL and DB2/SL use the declining balance depreciation amount in the first fiscal year.
61 Temp. Ending Date Δ BC28 Date Specifies the ending date of the period during which a temporary fixed depreciation amount will be used.
62 Temp. Fixed Depr. Amount Δ BC28 Decimal Specifies a temporary fixed depreciation amount.
63 Ignore Def. Ending Book Value Δ BC28 Boolean Specifies that the default ending book value is ignored, and the value in the Ending Book Value is used.
64 Use Bonus Depreciation + BC28 Boolean Specifies if the bonus depreciation should be used in this book.
65 Bonus Depr. Applied Amount + BC28 Decimal Specifies the amount of bonus depreciation that has been applied to the fixed asset. FlowField: sum(“FA Ledger Entry”.“Amount” where(“FA No.” = field(“FA No.”), “Depreciation Book Code” = field(“Depreciation Book Code”), “FA Posting Category” = const(” “), “FA Posting Type” = const(“FA Ledger Entry FA Posting Type”::“Bonus Depreciation”), “FA Posting Date” = field(“FA Posting Date Filter”)))
66 Bonus Depreciation % + BC28 Decimal Specifies the bonus depreciation percentage for this fixed asset.
70 Default FA Depreciation Book Δ BC28 Boolean Specifies the depreciation book that is used by default on documents and journals when a fixed asset has more than one depreciation book. A fixed asset can have only one default depreciation book. If a depreciation book is not specified for a fixed asset, the default depreciation book from the fixed…

Keys

  • Key1: FA No., Depreciation Book Code (clustered)
  • Key2: Depreciation Book Code, FA No.
  • Key3: Depreciation Book Code, Component of Main Asset, Main Asset/Component
  • Key4: Main Asset/Component, Depreciation Book Code

Events published

  • OnAfterCalcDeprPeriod(var FADepreciationBook: Record "FA Depreciation Book") (integration)
  • OnAfterLinearMethod(var FADepreciationBook: Record "FA Depreciation Book"; var Result: Boolean) (integration)
  • OnAfterCalcEndingDate(FADepreciationBook: Record "FA Depreciation Book"; var EndingDate: Date) (integration)
  • OnAfterUserDefinedMethod(FADepreciationBook: Record "FA Depreciation Book"; var Result: Boolean) (integration)
  • OnBeforeOnDelete(var FADeprecBook: Record "FA Depreciation Book"; xFADeprecBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeAdjustLinearMethod(var FADepreciationBook: Record "FA Depreciation Book"; var Amount1: Decimal; var Amount2: Decimal; var IsHandled: Boolean) (integration)
  • OnAfterSetBookValueFiltersOnFALedgerEntry(var FALedgerEntry: Record "FA Ledger Entry") (integration)
  • OnBeforeShowBookValueAfterDisposal(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeCalcDeprPeriod(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeCalcBookValue(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeUpdateBookValue(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeModifyDeprFields(FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeDrillDownOnBookValue(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeValidateNoOfDepreYears(FANo: Code[20]; DeprecBook: Record "Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeValidateNoOfDeprMonths(FANo: Code[20]; DeprecBook: Record "Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeCalculateDepreEndingDate(var FADeprBook: Record "FA Depreciation Book"; DeprEndDate: Date; var IsHandled: Boolean) (integration)
  • OnBeforeModifyFADeprBook(FADepreBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnValidateNoofDepreciationYearsOnAfterCalcShowDeprMethodError(var FADepreciationBook: Record "FA Depreciation Book"; var ShowDeprMethodError: Boolean) (integration)
  • OnValidateDepreciationEndingDateOnAfterCalcShowDeprMethodError(var FADepreciationBook: Record "FA Depreciation Book"; var ShowDeprMethodError: Boolean) (integration)
  • OnValidateNoofDepreciationMonthsOnAfterCalcShowDeprMethodError(var FADepreciationBook: Record "FA Depreciation Book"; var ShowDeprMethodError: Boolean) (integration)
  • OnBeforeInsertFADeprBook(FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnBeforeCheckApplyDeprBookDefaults(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnValidateDepreciationEndingDateOnBeforeTestFieldDeprStartingDate(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnValidateNoofDepreciationYearsOnBeforeTestFieldDeprStartingDate(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnValidateNoofDepreciationMonthsOnBeforeTestFieldDeprStartingDate(var FADepreciationBook: Record "FA Depreciation Book"; var IsHandled: Boolean) (integration)
  • OnAfterModifyDeprFields(var FADepreciationBook: Record "FA Depreciation Book") (integration)

Procedures

  • EligibleForBonusDepreciation(FASetup: Record "FA Setup"): Boolean + BC28
  • BonusDepreciationApplied(): Boolean + BC28 (internal)
  • CalcDeprPeriod()
  • CalcEndingDate(): Date
  • GetExchangeRate(): Decimal
  • LinearMethod(): Boolean (protected)
  • DecliningMethod(): Boolean (protected)
  • UserDefinedMethod(): Boolean (protected)
  • TestHalfYearConventionMethod() (protected)
  • Caption(): Text
  • DrillDownOnBookValue()
  • DrillDownOnAcquisitionCost() + BC28 (internal)
  • DrillDownOnBonusDeprAppliedAmount() + BC28 (internal)
  • ShowBookValueAfterDisposal()
  • CalcBookValue()
  • SetBookValueFiltersOnFALedgerEntry(var FALedgerEntry: Record "FA Ledger Entry")
  • SetAcquisitionCostFiltersOnFALedgerEntry(var FALedgerEntry: Record "FA Ledger Entry") + BC28 (internal)
  • SetBonusDepreciationFiltersOnFALedgerEntry(var FALedgerEntry: Record "FA Ledger Entry") + BC28 (internal)
  • LineIsReadyForAcquisition(FANo: Code[20]): Boolean
  • RecIsReadyForAcquisition(): Boolean
  • UpdateBookValue()
  • BonusDepreciationAmount(): Decimal + BC28 (internal)
  • GetCurrencyCode(): Code[10] + BC28 (internal)

Plus 8 local procedures.

Triggers

OnDelete, OnInsert, OnModify, OnRename

Relations

Referenced by

3 fields in 3 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Extended by

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Countries that replace it

AT, CH, DE, FR, GB, RU

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "FA Depreciation Book"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources