tableFixed Assetsofficial - Microsoftderived - from the source, no model text

Table 5601 "FA Ledger Entry"

Base Application · Microsoft.FixedAssets.Ledger

Across versions

  1. BC23present
  2. BC24declaration changed
  3. BC251 fields added
  4. BC2623 fields changed, 1 procedures changed
  5. BC27unchanged
  6. BC2828 fields changed, 1 procedures added
  7. BC29-30unchanged

Neighbourhood 53 connected objects and pages

Table 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 5600 "Fixed Asset" (relates to, 3 links)Fixed AssetTable 349 "Dimension Value" (relates to, 2 links)Table 14 "Location" (relates to)Table 15 "G/L Account" (relates to)G/L AccountTable 17 "G/L Entry" (relates to)G/L EntryTable 18 "Customer" (relates to)Table 23 "Vendor" (relates to)VendorTable 230 "Source Code" (relates to)Table 231 "Reason Code" (relates to)Reason CodeTable 250 "Gen. Business Posting Group" (relates to)Table 251 "Gen. Product Posting Group" (relates to)Gen. Product Posting GroupTable 270 "Bank Account" (relates to)Bank AccountTable 308 "No. Series" (relates to)Table 318 "Tax Area" (relates to)Tax AreaTable 321 "Tax Group" (relates to)Table 323 "VAT Business Posting Group" (relates to)VAT Business Posting GroupTable 324 "VAT Product Posting Group" (relates to)Table 5606 "FA Posting Group" (relates to)Page 5604 "FA Ledger Entries" (pages and codeunits on it, 3 links)FA Ledger EntriesCodeunit 5600 "FA Insert Ledger Entry" (pages and codeunits on it)Codeunit 5601 "FA Insert G/L Account" (pages and codeunits on it)Codeunit 5606 "FA Check Consistency" (pages and codeunits on it)Page 5605 "FA Error Ledger Entries" (pages and codeunits on it)Page 5606 "FA Ledger Entries Preview" (pages and codeunits on it)Table extension 6263 "Sust. FA Ledger Entry" (extended by)Table extension 7416 "Excise FA Ledger Entry Ext" (extended by)Codeunit 20 "Posting Preview Event Handler" (event subscribers, 2 links)Posting Preview Event HandlerCodeunit 408 "DimensionManagement" (calls)Codeunit 703 "Find Record Management" (calls)Table 5612 "FA Depreciation Book" (referenced by, 13 links)FA Depreciation BookTable extension 6266 "Sust. FA Depreciation Book" (referenced by, 3 links)Table 5617 "FA Register" (referenced by, 2 links)FA RegisterTable 1570 "G/L Entry Posting Preview" (referenced by)Table 17 "G/L Entry" (referenced by)Table 181 "Posted Gen. Journal Line" (referenced by)Table 4812 "Intrastat Report Line" (referenced by)Acquire fixed assets (Learn pages)Ad-hoc analysis of fixed assets data (Learn pages)Manage fixed assets (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.FixedAssets.Ledger · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 5604 “FA Ledger Entries” (3 Learn pages), Page 5605 “FA Error Ledger Entries” (1), Page 5606 “FA Ledger Entries Preview” (1).

Properties

Property Value
Caption FA 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 entry number of the corresponding G/L entry that was created in the general ledger for this fixed asset transaction. TableRelation Table 17 “G/L Entry” (G/L Entry)
3 FA No. Δ BC26 Code[20] Specifies the number of the related fixed asset. TableRelation Table 5600 “Fixed Asset” (Fixed Asset)
4 FA Posting Date Δ BC26 Date Specifies the posting date of the related fixed asset transaction, such as a depreciation.
5 Posting Date Δ BC26 Date Specifies the entry’s posting date.
6 Document Type Δ BC26 Enum “Gen. Journal Document Type” Specifies the entry document type. enum Enum 6 “Gen. Journal Document Type”
7 Document Date Δ BC26 Date Specifies the entry document date.
8 Document No. Δ BC26 Code[20] Specifies the document number on the entry.
9 External Document No. Code[35] —
10 Description Δ BC26 Text[100] Specifies a description of the entry.
11 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)
12 FA Posting Category Δ BC26 Enum “FA Ledger Posting Category” Specifies the posting category assigned to the entry when it was posted. enum Enum 5631 “FA Ledger Posting Category”
13 FA Posting Type Δ BC26 Enum “FA Ledger Entry FA Posting Type” Specifies the posting type, if Account Type field contains Fixed Asset. enum Enum 5601 “FA Ledger Entry FA Posting Type”
14 Amount Δ BC26 Δ BC28 Decimal Specifies the entry amount in currency.
15 Debit Amount Δ BC28 Decimal Specifies the total of the ledger entries that represent debits.
16 Credit Amount Δ BC28 Decimal Specifies the total of the ledger entries that represent credits.
17 Reclassification Entry Δ BC26 Boolean Specifies whether the entry was made to reclassify a fixed asset, for example, to change the dimension the fixed asset is linked to.
18 Part of Book Value Boolean —
19 Part of Depreciable Basis Boolean —
20 Disposal Calculation Method Option — OptionCaption: ,Net,Gross
21 Disposal Entry No. Integer —
22 No. of Depreciation Days Δ BC28 Integer Specifies the number of depreciation days that were used for calculating depreciation for the fixed asset entry.
23 Quantity Δ BC28 Decimal —
24 FA No./Budgeted FA No. Code[20] — TableRelation Table 5600 “Fixed Asset” (Fixed Asset)
25 FA Subclass Code Code[10] — TableRelation Table 5608 “FA Subclass” (FA Subclass)
26 FA Location Code Code[10] — TableRelation Table 5609 “FA Location” (FA Location)
27 FA Posting Group Δ BC26 Code[20] Specifies the FA posting group of the related fixed asset transaction. TableRelation Table 5606 “FA Posting Group” (FA Posting Group)
28 Global Dimension 1 Code Δ BC26 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)))
29 Global Dimension 2 Code Δ BC26 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)))
30 Location Code Code[10] — TableRelation Table 14 “Location” (Location where(“Use As In-Transit” = const(false)))
32 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
33 Depreciation Method Δ BC26 Enum “FA Depreciation Method” Specifies how depreciation is calculated for the depreciation book. enum Enum 5610 “FA Depreciation Method”
34 Depreciation Starting Date Δ BC26 Date Specifies the date on which depreciation of the fixed asset starts.
35 Straight-Line % Δ BC28 Decimal —
36 No. of Depreciation Years Δ BC28 Decimal —
37 Fixed Depr. Amount Δ BC28 Decimal —
38 Declining-Balance % Δ BC28 Decimal —
39 Depreciation Table Code Code[10] — TableRelation Table 5642 “Depreciation Table Header” (Depreciation Table Header)
40 Journal Batch Name Code[10] —
41 Source Code Δ BC28 Code[10] Specifies the source code that specifies where the entry was created. TableRelation Table 230 “Source Code” (Source Code)
42 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)
43 Transaction No. Integer —
44 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”
45 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…)
46 VAT Amount Δ BC28 Decimal —
47 Gen. Posting Type Enum “General Posting Type” — enum Enum 57 “General Posting Type”
48 Gen. Bus. Posting Group Code[20] — TableRelation Table 250 “Gen. Business Posting Group” (Gen. Business Posting Group)
49 Gen. Prod. Posting Group Code[20] — TableRelation Table 251 “Gen. Product Posting Group” (Gen. Product Posting Group)
50 FA Class Code Code[10] — TableRelation Table 5607 “FA Class” (FA Class)
51 FA Exchange Rate Δ BC28 Decimal —
52 Amount (LCY) Δ BC28 Decimal —
53 Result on Disposal Option — OptionCaption: ,Gain,Loss
54 Correction Boolean —
55 Index Entry Δ BC28 Boolean Specifies this entry is an index entry.
56 Canceled from FA No. Δ BC28 Code[20] Specifies the number of the fixed asset linked to the original entry, from which this fixed asset error ledger entry was created. TableRelation Table 5600 “Fixed Asset” (Fixed Asset)
57 Depreciation Ending Date Δ BC26 Date Specifies the date on which depreciation of the fixed asset ends.
58 Use FA Ledger Check Boolean —
59 Automatic Entry Boolean —
60 Depr. Starting Date (Custom 1) Date —
61 Depr. Ending Date (Custom 1) Date —
62 Accum. Depr. % (Custom 1) Δ BC28 Decimal —
63 Depr. % this year (Custom 1) Δ BC28 Decimal —
64 Property Class (Custom 1) Option — OptionCaption: ,Personal Property,Real Property
65 No. Series Code[20] — TableRelation Table 308 “No. Series” (No. Series)
66 Tax Area Code Code[20] — TableRelation Table 318 “Tax Area” (Tax Area)
67 Tax Liable Boolean —
68 Tax Group Code Code[20] — TableRelation Table 321 “Tax Group” (Tax Group)
69 Use Tax Boolean —
70 VAT Bus. Posting Group Code[20] — TableRelation Table 323 “VAT Business Posting Group” (VAT Business Posting Group)
71 VAT Prod. Posting Group Code[20] — TableRelation Table 324 “VAT Product Posting Group” (VAT Product Posting Group)
72 Reversed Δ BC28 Boolean Specifies whether the entry has been part of a reverse transaction (correction) made by the Reverse function.
73 Reversed by Entry No. Δ BC28 Integer Specifies the number of the correcting entry. TableRelation Table 5601 “FA Ledger Entry” (FA Ledger Entry)
74 Reversed Entry No. Δ BC28 Integer Specifies the number of the original entry that was undone by the reverse transaction. TableRelation Table 5601 “FA Ledger Entry” (FA 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 Δ BC26 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 Δ BC26 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 Δ BC26 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 Δ BC26 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 Δ BC26 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 Δ BC26 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
6210 Non-Ded. VAT FA Cost + BC25 Boolean Non-Deductible VAT FA Cost caption

Keys

  • Key1: Entry No. (clustered)
  • Key2: FA No., Depreciation Book Code, FA Posting Date
  • Key3: FA No., Depreciation Book Code, FA Posting Category, FA Posting Type, FA Posting Date, Part of Book Value, Reclassification Entry
  • Key4: FA No., Depreciation Book Code, Part of Book Value, FA Posting Date
  • Key5: FA No., Depreciation Book Code, Part of Depreciable Basis, FA Posting Date
  • Key6: FA No., Depreciation Book Code, FA Posting Category, FA Posting Type, Posting Date
  • Key7: Canceled from FA No., Depreciation Book Code, FA Posting Date
  • Key8: Document No., Posting Date
  • Key9: G/L Entry No.
  • Key10: Document Type, Document No.
  • Key11: Transaction No.
  • Key12: FA No., Depreciation Book Code, FA Posting Category, FA Posting Type, Document No.

Events published

  • OnAfterConvertPostingTypeElse(var FAJournalLine: Record "FA Journal Line"; var FALedgerEntry: Record "FA Ledger Entry") (integration)
  • OnAfterMoveToGenJnlLine(var GenJournalLine: Record "Gen. Journal Line"; FALedgerEntry: Record "FA Ledger Entry") (integration)
  • OnAfterMoveToFAJnlLine(var FAJournalLine: Record "FA Journal Line"; FALedgerEntry: Record "FA Ledger Entry") (integration)
  • OnAfterIsAcquisitionCost(var FALedgerEntry: Record "FA Ledger Entry"; var AcquisitionCost: Boolean) (integration)
  • OnMoveToGenJnlLineOnAfterInit(var GenJournalLine: Record "Gen. Journal Line"; var FALedgerEntry: Record "FA Ledger Entry"; var IsHandled: Boolean) (integration)
  • OnMoveToFAJnlLineOnAfterInit(var FAJournalLine: Record "FA Journal Line"; Rec: Record "FA Ledger Entry"; var IsHandled: Boolean) (integration)

Trigger event subscribers

Procedures

  • GetLastEntryNo(): Integer Δ BC26
  • MoveToGenJnl(var GenJnlLine: Record "Gen. Journal Line")
  • MoveToFAJnl(var FAJnlLine: Record "FA Journal Line")
  • ConvertPostingType(): Option
  • ShowDimensions()
  • IsAcquisitionCost(): Boolean

Plus 1 local procedures.

Relations

Referenced by

31 fields in 15 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Extended by

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.

Countries that replace it

FI, FR, RU

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: "FA Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources