Table 5612 "FA Depreciation Book"
Base Application · Microsoft.FixedAssets.Depreciation
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC2854 fields changed, 11 procedures added
- BC29-30unchanged
Neighbourhood 24 connected objects and pages
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+ BC28BonusDepreciationApplied(): Boolean+ BC28 (internal)CalcDeprPeriod()CalcEndingDate(): DateGetExchangeRate(): DecimalLinearMethod(): Boolean(protected)DecliningMethod(): Boolean(protected)UserDefinedMethod(): Boolean(protected)TestHalfYearConventionMethod()(protected)Caption(): TextDrillDownOnBookValue()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]): BooleanRecIsReadyForAcquisition(): BooleanUpdateBookValue()BonusDepreciationAmount(): Decimal+ BC28 (internal)GetCurrencyCode(): Code[10]+ BC28 (internal)
Plus 8 local procedures.
Triggers
OnDelete, OnInsert, OnModify, OnRename
Relations
- Component of Main Asset: TableRelation Table 5600 “Fixed Asset”
- FA No.: TableRelation Table 5600 “Fixed Asset”
- Acquisition Cost: CalcFormula Table 5601 “FA Ledger Entry”
- Appreciation: CalcFormula Table 5601 “FA Ledger Entry”
- Bonus Depr. Applied Amount: CalcFormula Table 5601 “FA Ledger Entry”
- Book Value: CalcFormula Table 5601 “FA Ledger Entry”
- Book Value on Disposal: CalcFormula Table 5601 “FA Ledger Entry”
- Custom 1: CalcFormula Table 5601 “FA Ledger Entry”
- Custom 2: CalcFormula Table 5601 “FA Ledger Entry”
- Depreciable Basis: CalcFormula Table 5601 “FA Ledger Entry”
- Depreciation: CalcFormula Table 5601 “FA Ledger Entry”
- Gain/Loss: CalcFormula Table 5601 “FA Ledger Entry”
- Proceeds on Disposal: CalcFormula Table 5601 “FA Ledger Entry”
- Salvage Value: CalcFormula Table 5601 “FA Ledger Entry”
- Write-Down: CalcFormula Table 5601 “FA Ledger Entry”
- FA Posting Group: TableRelation Table 5606 “FA Posting Group”
- Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
- Maintenance: CalcFormula Table 5625 “Maintenance Ledger Entry”
- Maintenance Code Filter: TableRelation Table 5626 “Maintenance”
- Depreciation Table Code: TableRelation Table 5642 “Depreciation Table Header”
Referenced by
3 fields in 3 objects relate to this table (TableRelation or CalcFormula).
- Table 5600 “Fixed Asset”: Acquired
- Table 5851 “Invt. Document Line”: Depreciation Book Code
- Table 5855 “Invt. Shipment Line”: Depreciation Book Code
Pages and codeunits on this table
- Page 5602 “Fixed Asset Statistics” (source table)
- Page 5603 “Main Asset Statistics” (source table)
- Page 5619 “FA Depreciation Books” (source table)
- Page 5666 “FA Depreciation Books Subform” (source table)
- Page 9277 “FA Posting Types Overv. Matrix” (source 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.
- Codeunit 5616 “Depreciation Calculation” (3 calls:
CalcDeprPeriod → DeprDays,CalcEndingDate → Yesterday,ShowBookValueAfterDisposal → SetFAFilter) - Codeunit 5617 “FA Date Calculation” (1 call:
CalcEndingDate → CalculateDate) - Codeunit 5623 “FA MoveEntries” (1 call:
OnDelete → MoveFAEntries) - Codeunit 8703 “Feature Telemetry” (1 call:
ToggleUseBonusDepreciationOnChangingDepreciationStartingDate → LogUsage)
Countries that replace it
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.