Maintenance Ledger Entry #5625

Fixed Assets table in Microsoft Dynamics 365 Business Central. 62 fields, 0 records in Cronus demo.

62
Fields
0
Records
1
Primary key
6
FlowFields
27
Relations
Open in Data Explorer →

Primary key

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

All fields (62)

Maintenance Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Entry No. PK Integer Normal
2 G/L Entry No. Integer Normal → G/L Entry #17
3 FA No. Code Normal → Fixed Asset #5600
4 FA Posting Date Date Normal
5 Posting Date Date Normal
6 Document Type Option Normal
7 Document Date Date Normal
8 Document No. Code Normal
9 External Document No. Code Normal
10 Description Text Normal
12 Amount Decimal Normal
13 Debit Amount Decimal Normal
14 Credit Amount Decimal Normal
15 Quantity Decimal Normal
16 FA No./Budgeted FA No. Code Normal → Fixed Asset #5600
17 FA Subclass Code Code Normal → FA Subclass #5608
18 FA Location Code Code Normal → FA Location #5609
19 FA Posting Group Code Normal → FA Posting Group #5606
20 Global Dimension 1 Code Code Normal → Dimension Value #349
21 Global Dimension 2 Code Code Normal → Dimension Value #349
22 Location Code Code Normal → Location #14
24 User ID Code Normal
25 Journal Batch Name Code Normal
26 Source Code Code Normal → Source Code #230
27 Reason Code Code Normal → Reason Code #231
28 Transaction No. Integer Normal
29 Bal. Account Type Option Normal
30 Bal. Account No. Code Normal
31 VAT Amount Decimal Normal
32 Gen. Posting Type Option Normal
33 Gen. Bus. Posting Group Code Normal → Gen. Business Posting Group #250
34 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
35 FA Class Code Code Normal → FA Class #5607
36 Depreciation Book Code Code Normal → Depreciation Book #5611
37 FA Exchange Rate Decimal Normal
38 Amount (LCY) Decimal Normal
39 Maintenance Code Code Normal → Maintenance #5626
40 Correction Boolean Normal
41 Index Entry Boolean Normal
42 Automatic Entry Boolean Normal
43 No. Series Code Normal → No. Series #308
44 Tax Area Code Code Normal → Tax Area #318
45 Tax Liable Boolean Normal
46 Tax Group Code Code Normal → Tax Group #321
47 Use Tax Boolean Normal
48 VAT Bus. Posting Group Code Normal → VAT Business Posting Group #323
49 VAT Prod. Posting Group Code Normal → VAT Product Posting Group #324
50 Reversed Boolean Normal
51 Reversed by Entry No. Integer Normal → Maintenance Ledger Entry #5625
52 Reversed Entry No. Integer Normal → Maintenance Ledger Entry #5625
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
481 Shortcut Dimension 3 Code ⚡ FLOW Code FlowField
482 Shortcut Dimension 4 Code ⚡ FLOW Code FlowField
483 Shortcut Dimension 5 Code ⚡ FLOW Code FlowField
484 Shortcut Dimension 6 Code ⚡ FLOW Code FlowField
485 Shortcut Dimension 7 Code ⚡ FLOW Code FlowField
486 Shortcut Dimension 8 Code ⚡ FLOW Code FlowField
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 (22)

Tables referenced by fields on the Maintenance Ledger Entry table through TableRelation properties.

G/L Entry
#17 · Ledger Entries · via G/L Entry No.
Fixed Asset
#5600 · Fixed Assets · via FA No., FA No./Budgeted FA No.
FA Subclass
#5608 · Fixed Assets · via FA Subclass Code
FA Location
#5609 · Fixed Assets · via FA Location Code
FA Posting Group
#5606 · Fixed Assets · via FA Posting Group
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Location
#14 · General Ledger · via Location Code
Source Code
#230 · Other · via Source Code
Reason Code
#231 · Other · via Reason Code
Gen. Business Posting Group
#250 · Other · via Gen. Bus. Posting Group
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
FA Class
#5607 · Fixed Assets · via FA Class Code
Depreciation Book
#5611 · Fixed Assets · via Depreciation Book Code
Maintenance
#5626 · Fixed Assets · via Maintenance Code
No. Series
#308 · Other · via No. Series
Tax Area
#318 · Other · via Tax Area Code
Tax Group
#321 · Other · via Tax Group Code
VAT Business Posting Group
#323 · Other · via VAT Bus. Posting Group
VAT Product Posting Group
#324 · Other · via VAT Prod. Posting Group
Maintenance Ledger Entry
#5625 · Fixed Assets · via Reversed by Entry No., Reversed Entry No.
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID