Fixed Asset #5600

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

The Fixed Asset master table in Business Central. Every fixed asset — machinery, vehicles, furniture, IT equipment — has a record here with its description, FA class, subclass, location, responsible employee, and maintenance vendor. It is the parent record that all FA ledger entries, depreciation books, and maintenance logs reference.

COMMON USE CASES
51
Fields
9
Records
1
Primary key
3
FlowFields
23
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: No..

All fields (51)

Fixed Asset — FIELDS
NO.FIELDTYPECLASSRELATION
1 No. PK Code Normal
2 Description Text Normal
3 Search Description Code Normal
4 Description 2 Text Normal
5 FA Class Code Code Normal → FA Class #5607
6 FA Subclass Code Code Normal → FA Subclass #5608
7 Global Dimension 1 Code Code Normal → Dimension Value #349
8 Global Dimension 2 Code Code Normal → Dimension Value #349
9 Location Code Code Normal → Location #14
10 FA Location Code Code Normal → FA Location #5609
11 Vendor No. Code Normal → Vendor #23
12 Main Asset/Component Option Normal
13 Component of Main Asset Code Normal → Fixed Asset #5600
14 Budgeted Asset Boolean Normal
15 Warranty Date Date Normal
16 Responsible Employee Code Normal → Employee #5200
17 Serial No. Text Normal
18 Last Date Modified Date Normal
19 Insured ⚡ FLOW Boolean FlowField
20 Comment ⚡ FLOW Boolean FlowField
21 Blocked Boolean Normal
23 Maintenance Vendor No. Code Normal → Vendor #23
24 Under Maintenance Boolean Normal
25 Next Service Date Date Normal
26 Inactive Boolean Normal
27 FA Posting Date Filter Date FlowFilter
28 No. Series Code Normal → No. Series #308
29 FA Posting Group Code Normal → FA Posting Group #5606
30 Acquired ⚡ FLOW Boolean FlowField
140 Image Media Normal
4810 Exclude from Intrastat Report Boolean Normal
4811 Tariff No. Code Normal → Tariff Number #260
4812 Country/Region of Origin Code Code Normal → Country/Region #9
4813 Gross Weight Decimal Normal
4814 Net Weight Decimal Normal
4815 Supplementary Unit of Measure Code Normal → Unit of Measure #204
6210 Default Sust. Account Code Normal → Sustainability Account #6210
6211 Default CO2 Emission Decimal Normal
6212 Default CH4 Emission Decimal Normal
6213 Default N2O Emission Decimal Normal
6784 Withholding Tax Prod. Post. Group Code Normal
7412 Excise Tax Type Code Normal → Excise Tax Type #7412
7413 Quantity for Excise Tax Decimal Normal
7414 Excise Tax Unit of Measure Code Normal → Unit of Measure #204
9001 FA Location Id GUID Normal → FA Location #5609
9002 Responsible Employee GUID Normal → Employee #5200
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 (17)

Tables referenced by fields on the Fixed Asset table through TableRelation properties.

FA Class
#5607 · Fixed Assets · via FA Class Code
FA Subclass
#5608 · Fixed Assets · via FA Subclass Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Location
#14 · General Ledger · via Location Code
FA Location
#5609 · Fixed Assets · via FA Location Code, FA Location Id
Vendor
#23 · Purchasing · via Vendor No., Maintenance Vendor No.
Fixed Asset
#5600 · Fixed Assets · via Component of Main Asset
Employee
#5200 · Human Resources · via Responsible Employee, Responsible Employee
No. Series
#308 · Other · via No. Series
FA Posting Group
#5606 · Fixed Assets · via FA Posting Group
Tariff Number
#260 · Other · via Tariff No.
Country/Region
#9 · General Ledger · via Country/Region of Origin Code
Unit of Measure
#204 · Other · via Supplementary Unit of Measure, Excise Tax Unit of Measure
Sustainability Account
#6210 · Other · via Default Sust. Account
Excise Tax Type
#7412 · Other · via Excise Tax Type