Fixed Assets table in Microsoft Dynamics 365 Business Central. 43 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.
The primary key uniquely identifies each record in this table. It consists of: No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
| 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 |
Tables referenced by fields on the Fixed Asset table through TableRelation properties.