Fixed Assets table in Microsoft Dynamics 365 Business Central. 43 fields, 9 records in Cronus demo.
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.