Diagrams


Table

FA Depreciation Book

DynamicsDocs.comFA Depreciation Book«Table 5612»FA Depreciation BookFA No. [PK,NN]Depreciation Book Code [PK,NN]Depreciation Method; [Straight-Line,De...Depreciation Starting DateStraight-Line %No. of Depreciation YearsNo. of Depreciation MonthsFixed Depr. AmountDeclining-Balance %Depreciation Table CodeFinal Rounding AmountEnding Book ValueFA Posting GroupDepreciation Ending DateAcquisition CostDepreciationBook ValueProceeds on DisposalGain/LossWrite-DownAppreciationCustom 1Custom 2Depreciable BasisSalvage ValueBook Value on DisposalMaintenanceMaintenance Code FilterFA Posting Date FilterAcquisition DateG/L Acquisition Date...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 5611»Depreciation BookCode [PK,NN]DescriptionG/L Integration - Acq. CostG/L Integration - DepreciationG/L Integration - Write-DownG/L Integration - AppreciationG/L Integration - Custom 1G/L Integration - Custom 2G/L Integration - DisposalG/L Integration - MaintenanceDisposal Calculation Method; [Net,Gros...Use Custom 1 DepreciationAllow Depr. below ZeroUse FA Exch. Rate in Duplic.Part of Duplication ListLast Date ModifiedAllow IndexationUse Same FA+G/L Posting DatesDefault Exchange RateUse FA Ledger CheckUse Rounding in Periodic Depr.New Fiscal Year Starting DateNo. of Days in Fiscal YearAllow Changes in Depr. FieldsDefault Final Rounding AmountDefault Ending Book ValuePeriodic Depr. Date Calc.; [Last Entry...Mark Errors as CorrectionsAdd-Curr Exch Rate - Acq. CostAdd.-Curr. Exch. Rate - Depr.Add-Curr Exch Rate -Write-Down...«Table 5642»Depreciation Table HeaderCode [PK,NN]DescriptionPeriod Length; [Month,Period,Quarter,Y...Total No. of Units«Table 5606»FA Posting GroupCode [PK,NN]Acquisition Cost AccountAccum. Depreciation AccountWrite-Down AccountAppreciation AccountCustom 1 AccountCustom 2 AccountAcq. Cost Acc. on DisposalAccum. Depr. Acc. on DisposalWrite-Down Acc. on DisposalAppreciation Acc. on DisposalCustom 1 Account on DisposalCustom 2 Account on DisposalGains Acc. on DisposalLosses Acc. on DisposalBook Val. Acc. on Disp. [Gain]Sales Acc. on Disp. [Gain]Write-Down Bal. Acc. on Disp.Apprec. Bal. Acc. on Disp.Custom 1 Bal. Acc. on DisposalCustom 2 Bal. Acc. on DisposalMaintenance Expense AccountMaintenance Bal. Acc.Acquisition Cost Bal. Acc.Depreciation Expense Acc.Write-Down Expense Acc.Appreciation Bal. AccountCustom 1 Expense Acc.Custom 2 Expense Acc.Sales Bal. Acc.Allocated Acquisition Cost %...«Table 5626»MaintenanceCode [PK,NN]Description<FA No.><Component of Main Asset><Depreciation Book Code><Depreciation Table Code><FA Posting Group><Maintenance Code Filter><Component of Main Asset><FA Posting Group>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 FA No. Code20 NotBlank: Yes
2 Depreciation Book Code Code10 NotBlank: Yes
3 Depreciation Method Option
4 Depreciation Starting Date Date Editable: Yes
5 Straight-Line % Decimal (2:8)
6 No. of Depreciation Years Decimal (2:8) BlankZero: Yes
7 No. of Depreciation Months Decimal (2:8) BlankZero: Yes
8 Fixed Depr. Amount Decimal
9 Declining-Balance % Decimal (2:8)
10 Depreciation Table Code Code10
11 Final Rounding Amount Decimal
12 Ending Book Value Decimal
13 FA Posting Group Code20
14 Depreciation Ending Date Date
15 Acquisition Cost Decimal Editable: No
FlowField
16 Depreciation Decimal Editable: No
FlowField
17 Book Value Decimal Editable: No
FlowField
18 Proceeds on Disposal Decimal Editable: No
FlowField
19 Gain/Loss Decimal Editable: No
FlowField
20 Write-Down Decimal Editable: No
FlowField
21 Appreciation Decimal Editable: No
FlowField
22 Custom 1 Decimal Editable: No
FlowField
23 Custom 2 Decimal Editable: No
FlowField
24 Depreciable Basis Decimal Editable: No
FlowField
25 Salvage Value Decimal Editable: No
FlowField
26 Book Value on Disposal Decimal Editable: No
FlowField
27 Maintenance Decimal Editable: No
FlowField
28 Maintenance Code Filter Code10 FlowFilter
29 FA Posting Date Filter Date FlowFilter
30 Acquisition Date Date Editable: No
31 G/L Acquisition Date Date Editable: No
32 Disposal Date Date Editable: No
33 Last Acquisition Cost Date Date Editable: No
34 Last Depreciation Date Date Editable: No
35 Last Write-Down Date Date Editable: No
36 Last Appreciation Date Date Editable: No
37 Last Custom 1 Date Date Editable: No
38 Last Custom 2 Date Date Editable: No
39 Last Salvage Value Date Date Editable: No
40 FA Exchange Rate Decimal (4:4)
41 Fixed Depr. Amount below Zero Decimal BlankZero: Yes
42 Last Date Modified Date Editable: No
43 First User-Defined Depr. Date Date
44 Use FA Ledger Check Boolean
45 Last Maintenance Date Date Editable: No
46 Depr. below Zero % Decimal (2:8) BlankZero: Yes
47 Projected Disposal Date Date
48 Projected Proceeds on Disposal Decimal BlankZero: Yes
50 Depr. Starting Date (Custom 1) Date
51 Depr. Ending Date (Custom 1) Date
52 Accum. Depr. % (Custom 1) Decimal (2:8) BlankZero: Yes
53 Depr. This Year % (Custom 1) Decimal (2:8) BlankZero: Yes
54 Property Class (Custom 1) Option
55 Description Text50 Editable: No
56 Main Asset/Component Option Editable: No
57 Component of Main Asset Code20 Editable: No
58 FA Add.-Currency Factor Decimal (0:15)
59 Use Half-Year Convention Boolean
60 Use DB% First Fiscal Year Boolean
61 Temp. Ending Date Date
62 Temp. Fixed Depr. Amount Decimal
63 Ignore Def. Ending Book Value Boolean
70 Default FA Depreciation Book Boolean

Keys

# Fields
0 FA No.,Depreciation Book Code Clustered: Yes
1 Depreciation Book Code,FA No.
2 Depreciation Book Code,Component of Main Asset,Main Asset/Component
3 Main Asset/Component,Depreciation Book Code

Table Relations To Other Tables

Field Related Table Related Field
Depreciation Book Code Depreciation Book Code 1..n
Depreciation Table Code Depreciation Table Header Code 1..n
FA Posting Group FA Posting Group Code 1..n
Component of Main Asset Fixed Asset No. 1..n
Maintenance Code Filter Maintenance Code 1..n

Table Relations From Other Tables

From Table From Field