Table 5625 "Maintenance Ledger Entry"
Base Application · Microsoft.FixedAssets.Maintenance
- 57fields
- 2procedures
- 1Learn pages
- 1countries replace it
- 7fields reference it
- 2event subscribers
- 2objects it calls
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC2834 fields changed
- BC29-30unchanged
Neighbourhood 34 connected objects and pages
Base Application · Microsoft.FixedAssets.Maintenance · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 5641 “Maintenance Ledger Entries” (1 Learn page), Page 5671 “Maint. Ledg. Entries Preview” (1).
Properties
| Property | Value |
|---|---|
| Caption | Maintenance Ledger Entry |
| DataClassification | CustomerContent |
Fields
Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.
| No. | Name | Type | Explanation | Notes |
|---|---|---|---|---|
| 1 | Entry No. Δ BC28 | Integer | Specifies the number of the entry, as assigned from the specified number series when the entry was created. | |
| 2 | G/L Entry No. Δ BC28 | Integer | Specifies the G/L number for the entry that was created for this maintenance transaction. | TableRelation Table 17 “G/L Entry” (G/L Entry) |
| 3 | FA No. Δ BC28 | Code[20] | Specifies the number of the related fixed asset. | TableRelation Table 5600 “Fixed Asset” (Fixed Asset) |
| 4 | FA Posting Date Δ BC28 | Date | Specifies the posting date of the related fixed asset transaction, such as a depreciation. | |
| 5 | Posting Date Δ BC28 | Date | Specifies the entry’s posting date. | |
| 6 | Document Type Δ BC28 | Enum “Gen. Journal Document Type” | Specifies the document type that the entry belongs to. | enum Enum 6 “Gen. Journal Document Type” |
| 7 | Document Date | Date | — | |
| 8 | Document No. Δ BC28 | Code[20] | Specifies the document number on the entry. | |
| 9 | External Document No. | Code[35] | — | |
| 10 | Description Δ BC28 | Text[100] | Specifies a description of the entry. | |
| 12 | Amount Δ BC28 | Decimal | Specifies the amount of the entry. | |
| 13 | Debit Amount Δ BC28 | Decimal | Specifies the total of the ledger entries that represent debits. | |
| 14 | Credit Amount Δ BC28 | Decimal | Specifies the total of the ledger entries that represent credits. | |
| 15 | Quantity Δ BC28 | Decimal | — | |
| 16 | FA No./Budgeted FA No. | Code[20] | — | TableRelation Table 5600 “Fixed Asset” (Fixed Asset) |
| 17 | FA Subclass Code | Code[10] | — | TableRelation Table 5608 “FA Subclass” (FA Subclass) |
| 18 | FA Location Code | Code[10] | — | TableRelation Table 5609 “FA Location” (FA Location) |
| 19 | FA Posting Group | Code[20] | — | TableRelation Table 5606 “FA Posting Group” (FA Posting Group) |
| 20 | Global Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))) |
| 21 | Global Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))) |
| 22 | Location Code | Code[10] | — | TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false))) |
| 24 | User ID Δ BC28 | Code[50] | Specifies the ID of the user who posted the entry, to be used, for example, in the change log. | TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation |
| 25 | Journal Batch Name | Code[10] | — | |
| 26 | Source Code Δ BC28 | Code[10] | Specifies the source code that specifies where the entry was created. | TableRelation Table 230 “Source Code” (Source Code) |
| 27 | Reason Code Δ BC28 | Code[10] | Specifies the reason code, a supplementary source code that enables you to trace the entry. | TableRelation Table 231 “Reason Code” (Reason Code) |
| 28 | Transaction No. | Integer | — | |
| 29 | Bal. Account Type Δ BC28 | enum “Gen. Journal Account Type” | Specifies the type of account that a balancing entry is posted to, such as BANK for a cash account. | enum Enum 81 “Gen. Journal Account Type” |
| 30 | Bal. Account No. Δ BC28 | Code[20] | Specifies the number of the general ledger, customer, vendor, or bank account that the balancing entry is posted to, such as a cash account for cash purchases. | TableRelation Table 15 “G/L Account”, Table 18 “Customer”, Table 23 “Vendor” (if (“Bal. Account Type” = const(“G/L Account”)) “G/L Account” else if (“Bal. Account Type” = const(Customer)) Customer else if (“Bal. Account Type” = const(Vendor)) Vendor else if (“Bal. Account Type” = const(“Bank Account”)) “Bank Account” else if (“Bal. Account Type” = const(“Fixed Asset”)) “Fixed…) |
| 31 | VAT Amount Δ BC28 | Decimal | — | |
| 32 | Gen. Posting Type | Enum “General Posting Type” | — | enum Enum 57 “General Posting Type” |
| 33 | Gen. Bus. Posting Group | Code[20] | — | TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group) |
| 34 | Gen. Prod. Posting Group | Code[20] | — | TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group) |
| 35 | FA Class Code | Code[10] | — | TableRelation Table 5607 “FA Class” (FA Class) |
| 36 | Depreciation Book Code Δ BC28 | Code[10] | Specifies the code for the depreciation book to which the line will be posted if you have selected Fixed Asset in the Type field for this line. | TableRelation Table 5611 “Depreciation Book” (Depreciation Book) |
| 37 | FA Exchange Rate Δ BC28 | Decimal | — | |
| 38 | Amount (LCY) Δ BC28 | Decimal | — | |
| 39 | Maintenance Code Δ BC28 | Code[10] | Specifies the maintenance code that the entry is linked to. | TableRelation Table 5626 “Maintenance” |
| 40 | Correction | Boolean | — | |
| 41 | Index Entry | Boolean | — | |
| 42 | Automatic Entry | Boolean | — | |
| 43 | No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 44 | Tax Area Code | Code[20] | — | TableRelation Table 318 “Tax Area” (Tax Area) |
| 45 | Tax Liable | Boolean | — | |
| 46 | Tax Group Code | Code[20] | — | TableRelation Table 321 “Tax Group” (Tax Group) |
| 47 | Use Tax | Boolean | — | |
| 48 | VAT Bus. Posting Group | Code[20] | — | TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group) |
| 49 | VAT Prod. Posting Group | Code[20] | — | TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group) |
| 50 | Reversed Δ BC28 | Boolean | Specifies whether the entry has been part of a reverse transaction (correction) made by the Reverse function. | |
| 51 | Reversed by Entry No. Δ BC28 | Integer | Specifies the number of the correcting entry. | TableRelation Table 5625 “Maintenance Ledger Entry” (Maintenance Ledger Entry) |
| 52 | Reversed Entry No. Δ BC28 | Integer | Specifies the number of the original entry that was undone by the reverse transaction. | TableRelation Table 5625 “Maintenance Ledger Entry” (Maintenance Ledger Entry) |
| 480 | Dimension Set ID Δ BC28 | Integer | Specifies a reference to a combination of dimension values. The actual values are stored in the Dimension Set Entry table. | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
| 481 | Shortcut Dimension 3 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3))); not editable |
| 482 | Shortcut Dimension 4 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4))); not editable |
| 483 | Shortcut Dimension 5 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5))); not editable |
| 484 | Shortcut Dimension 6 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6))); not editable |
| 485 | Shortcut Dimension 7 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7))); not editable |
| 486 | Shortcut Dimension 8 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. | FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8))); not editable |
Keys
- Key1: Entry No. (clustered)
- Key2: FA No., Depreciation Book Code, FA Posting Date
- Key3: FA No., Depreciation Book Code, Posting Date
- Key4: FA No., Depreciation Book Code, Maintenance Code, FA Posting Date
- Key5: FA No., Depreciation Book Code, Maintenance Code, Posting Date
- Key6: Document No., Posting Date
- Key7: G/L Entry No.
- Key8: Transaction No.
- Key9: FA No., Depreciation Book Code, Document No.
Trigger event subscribers
- OnAfterInsertEvent: Codeunit 20 “Posting Preview Event Handler” OnInsertMaintenanceLedgerEntry
- OnAfterModifyEvent: Codeunit 20 “Posting Preview Event Handler” OnModifyMaintenanceLedgerEntry
Procedures
GetLastEntryNo(): IntegerShowDimensions()
Relations
- drill-down page Page 5641 “Maintenance Ledger Entries”
- lookup page Page 5641 “Maintenance Ledger Entries”
- Location Code: TableRelation Table 14 “Location”
- Bal. Account No.: TableRelation Table 15 “G/L Account” (conditional)
- G/L Entry No.: TableRelation Table 17 “G/L Entry”
- Bal. Account No.: TableRelation Table 18 “Customer” (conditional)
- Bal. Account No.: TableRelation Table 23 “Vendor” (conditional)
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Gen. Bus. Posting Group: TableRelation Table 250 “Gen. Business Posting Group”
- Gen. Prod. Posting Group: TableRelation Table 251 “Gen. Product Posting Group”
- Bal. Account No.: TableRelation Table 270 “Bank Account” (conditional)
- No. Series: TableRelation Table 308 “No. Series”
- Tax Area Code: TableRelation Table 318 “Tax Area”
- Tax Group Code: TableRelation Table 321 “Tax Group”
- VAT Bus. Posting Group: TableRelation Table 323 “VAT Business Posting Group”
- VAT Prod. Posting Group: TableRelation Table 324 “VAT Product Posting Group”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- FA No.: TableRelation Table 5600 “Fixed Asset”
- FA No./Budgeted FA No.: TableRelation Table 5600 “Fixed Asset”
- FA Posting Group: TableRelation Table 5606 “FA Posting Group”
- FA Class Code: TableRelation Table 5607 “FA Class”
- FA Subclass Code: TableRelation Table 5608 “FA Subclass”
- FA Location Code: TableRelation Table 5609 “FA Location”
- Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
- Reversed by Entry No.: TableRelation Table 5625 “Maintenance Ledger Entry”
- Reversed Entry No.: TableRelation Table 5625 “Maintenance Ledger Entry”
- Maintenance Code: TableRelation Table 5626 “Maintenance”
Referenced by
7 fields in 5 objects relate to this table (TableRelation or CalcFormula).
- Table 5617 “FA Register”: From Maintenance Entry No., To Maintenance Entry No.
- Table 5625 “Maintenance Ledger Entry”: Reversed by Entry No., Reversed Entry No.
- Table 1570 “G/L Entry Posting Preview”: FA Entry No.
- Table 17 “G/L Entry”: FA Entry No.
- Table 5612 “FA Depreciation Book”: Maintenance
Pages and codeunits on this table
- Page 5641 “Maintenance Ledger Entries” (source table)
- Page 5671 “Maint. Ledg. Entries Preview” (source table)
Calls
From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.
- Codeunit 408 “DimensionManagement” (1 call:
ShowDimensions → ShowDimensionSet) - Codeunit 703 “Find Record Management” (1 call:
GetLastEntryNo → GetLastEntryIntFieldValue)
Countries that replace it
Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).
Ask your agent
Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Maintenance Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.