Fixed Assets table in Microsoft Dynamics 365 Business Central. 27 fields, 4 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 | Effective Date | Date | Normal | |
| 3 | Expiration Date | Date | Normal | |
| 4 | Policy No. | Text | Normal | |
| 6 | Annual Premium | Decimal | Normal | |
| 7 | Policy Coverage | Decimal | Normal | |
| 10 | Total Value Insured ⚡ FLOW | Decimal | FlowField | |
| 11 | Comment ⚡ FLOW | Boolean | FlowField | |
| 12 | Insurance Type | Code | Normal | → Insurance Type #5630 |
| 13 | Last Date Modified | Date | Normal | |
| 14 | Insurance Vendor No. | Code | Normal | → Vendor #23 |
| 15 | FA Class Code | Code | Normal | → FA Class #5607 |
| 16 | FA Subclass Code | Code | Normal | → FA Subclass #5608 |
| 17 | FA Location Code | Code | Normal | → FA Location #5609 |
| 18 | Global Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 19 | Global Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 20 | Location Code | Code | Normal | → Location #14 |
| 32 | Blocked | Boolean | Normal | |
| 33 | Description | Text | Normal | |
| 34 | Search Description | Code | Normal | |
| 35 | Date Filter | Date | FlowFilter | |
| 36 | No. Series | Code | Normal | → No. Series #308 |
| 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 Insurance table through TableRelation properties.