Insurance #5628

Fixed Assets table in Microsoft Dynamics 365 Business Central. 27 fields, 4 records in Cronus demo.

27
Fields
4
Records
1
Primary key
2
FlowFields
11
Relations
Open in Data Explorer →

Primary key

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

All fields (27)

Insurance — FIELDS
NO.FIELDTYPECLASSRELATION
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

Related tables (9)

Tables referenced by fields on the Insurance table through TableRelation properties.

Insurance Type
#5630 · Fixed Assets · via Insurance Type
Vendor
#23 · Purchasing · via Insurance Vendor No.
FA Class
#5607 · Fixed Assets · via FA Class Code
FA Subclass
#5608 · Fixed Assets · via FA Subclass Code
FA Location
#5609 · Fixed Assets · via FA Location Code
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Location
#14 · General Ledger · via Location Code
No. Series
#308 · Other · via No. Series