FA Depreciation Book #5612

Fixed Assets table in Microsoft Dynamics 365 Business Central. 68 fields, 9 records in Cronus demo.

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: FA No., Depreciation Book Code.

All fields (68)

FA Depreciation Book — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	FA No. PK	Code	Normal	→ Fixed Asset #5600
2	Depreciation Book Code PK	Code	Normal	→ Depreciation Book #5611
3	Depreciation Method	Option	Normal
4	Depreciation Starting Date	Date	Normal
5	Straight-Line %	Decimal	Normal
6	No. of Depreciation Years	Decimal	Normal
7	No. of Depreciation Months	Decimal	Normal
8	Fixed Depr. Amount	Decimal	Normal
9	Declining-Balance %	Decimal	Normal
10	Depreciation Table Code	Code	Normal	→ Depreciation Table Header #5642
11	Final Rounding Amount	Decimal	Normal
12	Ending Book Value	Decimal	Normal
13	FA Posting Group	Code	Normal	→ FA Posting Group #5606
14	Depreciation Ending Date	Date	Normal
15	Acquisition Cost ⚡ FLOW	Decimal	FlowField
16	Depreciation ⚡ FLOW	Decimal	FlowField
17	Book Value ⚡ FLOW	Decimal	FlowField
18	Proceeds on Disposal ⚡ FLOW	Decimal	FlowField
19	Gain/Loss ⚡ FLOW	Decimal	FlowField
20	Write-Down ⚡ FLOW	Decimal	FlowField
21	Appreciation ⚡ FLOW	Decimal	FlowField
22	Custom 1 ⚡ FLOW	Decimal	FlowField
23	Custom 2 ⚡ FLOW	Decimal	FlowField
24	Depreciable Basis ⚡ FLOW	Decimal	FlowField
25	Salvage Value ⚡ FLOW	Decimal	FlowField
26	Book Value on Disposal ⚡ FLOW	Decimal	FlowField
27	Maintenance ⚡ FLOW	Decimal	FlowField
28	Maintenance Code Filter	Code	FlowFilter	→ Maintenance #5626
29	FA Posting Date Filter	Date	FlowFilter
30	Acquisition Date	Date	Normal
31	G/L Acquisition Date	Date	Normal
32	Disposal Date	Date	Normal
33	Last Acquisition Cost Date	Date	Normal
34	Last Depreciation Date	Date	Normal
35	Last Write-Down Date	Date	Normal
36	Last Appreciation Date	Date	Normal
37	Last Custom 1 Date	Date	Normal
38	Last Custom 2 Date	Date	Normal
39	Last Salvage Value Date	Date	Normal
40	FA Exchange Rate	Decimal	Normal
41	Fixed Depr. Amount below Zero	Decimal	Normal
42	Last Date Modified	Date	Normal
43	First User-Defined Depr. Date	Date	Normal
44	Use FA Ledger Check	Boolean	Normal
45	Last Maintenance Date	Date	Normal
46	Depr. below Zero %	Decimal	Normal
47	Projected Disposal Date	Date	Normal
48	Projected Proceeds on Disposal	Decimal	Normal
50	Depr. Starting Date (Custom 1)	Date	Normal
51	Depr. Ending Date (Custom 1)	Date	Normal
52	Accum. Depr. % (Custom 1)	Decimal	Normal
53	Depr. This Year % (Custom 1)	Decimal	Normal
54	Property Class (Custom 1)	Option	Normal
55	Description	Text	Normal
56	Main Asset/Component	Option	Normal
57	Component of Main Asset	Code	Normal	→ Fixed Asset #5600
58	FA Add.-Currency Factor	Decimal	Normal
59	Use Half-Year Convention	Boolean	Normal
60	Use DB% First Fiscal Year	Boolean	Normal
61	Temp. Ending Date	Date	Normal
62	Temp. Fixed Depr. Amount	Decimal	Normal
63	Ignore Def. Ending Book Value	Boolean	Normal
70	Default FA Depreciation Book	Boolean	Normal
2000000000	System ID	GUID	Normal
2000000001	Created At	DateTime	Normal
2000000002	Created By	GUID	Normal
2000000003	Modified At	DateTime	Normal
2000000004	Modified By	GUID	Normal

Related tables (6)

Tables referenced by fields on the FA Depreciation Book table through TableRelation properties.

Fixed Asset

#5600 · Fixed Assets · via FA No., Component of Main Asset

Depreciation Book

#5611 · Fixed Assets · via Depreciation Book Code

Depreciation Table Header

#5642 · Other · via Depreciation Table Code

FA Posting Group

#5606 · Fixed Assets · via FA Posting Group

Maintenance

#5626 · Fixed Assets · via Maintenance Code Filter