Table 5621 "FA Journal Line"
Base Application · Microsoft.FixedAssets.Journal
- 40fields
- 25procedures
- 12events
- 9Learn pages
- 1countries replace it
- 1fields reference it
- 2event subscribers
- 2objects it calls
Across versions
- BC23present
- BC24declaration changed
- BC25-27unchanged
- BC2829 fields changed
- BC29-30unchanged
Neighbourhood 33 connected objects and pages
Base Application · Microsoft.FixedAssets.Journal · BC23-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 5629 “Fixed Asset Journal” (9 Learn pages), Page 5634 “Recurring Fixed Asset Journal” (1).
Properties
| Property | Value |
|---|---|
| Caption | FA Journal Line |
| 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 | Journal Template Name | Code[10] | — | TableRelation Table 5619 “FA Journal Template” (FA Journal Template) |
| 2 | Journal Batch Name | Code[10] | — | TableRelation Table 5620 “FA Journal Batch” (“FA Journal Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”))) |
| 3 | Line No. | Integer | — | |
| 4 | 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) |
| 5 | FA Posting Type Δ BC28 | Enum “FA Journal Line FA Posting Type” | Specifies the posting type, if Account Type field contains Fixed Asset. | enum Enum 5602 “FA Journal Line FA Posting Type” |
| 6 | FA No. Δ BC28 | Code[20] | Specifies the number of the related fixed asset. | TableRelation Table 5600 “Fixed Asset” (Fixed Asset) |
| 7 | FA Posting Date Δ BC28 | Date | Specifies the posting date of the related fixed asset transaction, such as a depreciation. | |
| 8 | Posting Date Δ BC28 | Date | Specifies the same date as the FA Posting Date field when the line is posted. | |
| 9 | Document Type Δ BC28 | Enum “FA Journal Line Document Type” | Specifies the appropriate document type for the amount you want to post. | enum Enum 5605 “FA Journal Line Document Type” |
| 10 | Document Date | Date | — | |
| 11 | Document No. Δ BC28 | Code[20] | Specifies a document number for the journal line. | |
| 12 | External Document No. | Code[35] | — | |
| 13 | Description Δ BC28 | Text[100] | Specifies a description of the fixed asset. | |
| 14 | Amount Δ BC28 | Decimal | Specifies the total amount the journal line consists of. | |
| 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 | Salvage Value Δ BC28 | Decimal | Specifies the estimated residual value of a fixed asset when it can no longer be used. | |
| 18 | Quantity Δ BC28 | Decimal | — | |
| 19 | Correction | Boolean | — | |
| 20 | No. of Depreciation Days Δ BC28 | Integer | Specifies the number of depreciation days if you have selected the Depreciation or Custom 1 option in the FA Posting Type field. | |
| 21 | Depr. until FA Posting Date Δ BC28 | Boolean | Specifies if depreciation was calculated until the FA posting date of the line. | |
| 22 | Depr. Acquisition Cost Δ BC28 | Boolean | Specifies if, when this line was posted, the additional acquisition cost posted on the line was depreciated in proportion to the amount by which the fixed asset had already been depreciated. | |
| 24 | FA Posting Group | Code[20] | — | TableRelation Table 5606 “FA Posting Group” (FA Posting Group) |
| 26 | Maintenance Code Δ BC28 | Code[10] | Specifies a maintenance code. | TableRelation Table 5626 “Maintenance” |
| 27 | Shortcut Dimension 1 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false))) |
| 28 | Shortcut Dimension 2 Code Δ BC28 | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. | TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false))) |
| 30 | Insurance No. Δ BC28 | Code[20] | Specifies an insurance code if you have selected the Acquisition Cost option in the FA Posting Type field. | TableRelation Table 5628 “Insurance” |
| 31 | Budgeted FA No. Δ BC28 | Code[20] | Specifies the number of a fixed asset with the Budgeted Asset check box selected. When you post the journal or document line, an additional entry is created for the budgeted fixed asset where the amount has the opposite sign. | TableRelation Table 5600 “Fixed Asset” (Fixed Asset) |
| 32 | Use Duplication List Δ BC28 | Boolean | Specifies whether the line is to be posted to all depreciation books, using different journal batches and with a check mark in the Part of Duplication List field. | |
| 33 | Duplicate in Depreciation Book Δ BC28 | Code[10] | Specifies a depreciation book code if you want the journal line to be posted to that depreciation book, as well as to the depreciation book in the Depreciation Book Code field. | TableRelation Table 5611 “Depreciation Book” (Depreciation Book) |
| 34 | FA Reclassification Entry Δ BC28 | Boolean | Specifies if the entry was generated from a fixed asset reclassification journal. | |
| 35 | FA Error Entry No. Δ BC28 | Integer | Specifies the number of a posted FA ledger entry to mark as an error entry. | TableRelation Table 5601 “FA Ledger Entry” (FA Ledger Entry) |
| 36 | Reason Code | Code[10] | — | TableRelation Table 231 “Reason Code” (Reason Code) |
| 37 | Source Code | Code[10] | — | TableRelation Table 230 “Source Code” (Source Code) |
| 38 | Recurring Method Δ BC28 | Option | Specifies a recurring method, if you have indicated that the journal is recurring. | OptionCaption: ,F Fixed,V Variable |
| 39 | Recurring Frequency Δ BC28 | DateFormula | Specifies a recurring frequency if you indicated that the journal is a recurring. | |
| 41 | Expiration Date Δ BC28 | Date | Specifies the last date on which the recurring journal will be posted. | |
| 42 | Index Entry Δ BC28 | Boolean | Specifies whether to post an indexation. | |
| 43 | Posting No. Series | Code[20] | — | TableRelation Table 308 “No. Series” (No. Series) |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry); not editable |
Keys
- Key1: Journal Template Name, Journal Batch Name, Line No. (clustered)
- Key2: Journal Template Name, Journal Batch Name, FA Posting Date
Events published
OnAfterInitDefaultDimensionSources(var FAJournalLine: Record "FA Journal Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)OnBeforeCreateDim(var FAJournalLine: Record "FA Journal Line"; var IsHandled: Boolean; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)OnAfterCreateDim(var FAJournalLine: Record "FA Journal Line"; CurrFieldNo: Integer; xFAJournalLine: Record "FA Journal Line"; OldDimSetID: Integer; DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])(integration)- subscribers: Codeunit 6283 “Sust. FA Journal Subscriber” OnValidateItemNoOnAfterCreateDimInitial
OnAfterSetUpNewLine(var FAJournalLine: Record "FA Journal Line"; FAJnlTemplate: Record "FA Journal Template"; FAJnlBatch: Record "FA Journal Batch"; LastFAJnlLine: Record "FA Journal Line")(integration)OnAfterShowDimensions(var FAJournalLine: Record "FA Journal Line")(integration)OnAfterValidateShortcutDimCode(var FAJournalLine: Record "FA Journal Line"; var xFAJournalLine: Record "FA Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20])(integration)OnBeforeCheckInsuranceFAPostingType(var FAJournalLine: Record "FA Journal Line"; var IsHandled: Boolean)(integration)OnBeforeValidateShortcutDimCode(var FAJournalLine: Record "FA Journal Line"; var xFAJournalLine: Record "FA Journal Line"; FieldNumber: Integer; var ShortcutDimCode: Code[20]; var IsHandled: Boolean)(integration)OnConvertToLedgEntryCase(var FALedgerEntry: Record "FA Ledger Entry"; FAJournalLine: Record "FA Journal Line")(integration)OnValidateFANoOnAfterInitFields(var FAJournalLine: Record "FA Journal Line")(integration)- subscribers: Codeunit 6283 “Sust. FA Journal Subscriber” OnValidateFANoOnAfterInitFields
OnBeforeValidateFAPostingType(var FAJournalLine: Record "FA Journal Line"; var IsHandled: Boolean; FieldNumber: Integer)(integration)OnAfterIsAcquisitionCost(var FAJournalLine: Record "FA Journal Line"; var AcquisitionCost: Boolean)(integration)
Procedures
ConvertToLedgEntry(var FAJnlLine: Record "FA Journal Line"): OptionSetUpNewLine(LastFAJnlLine: Record "FA Journal Line")CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])ValidateShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])LookupShortcutDimCode(FieldNumber: Integer; var ShortcutDimCode: Code[20])ShowShortcutDimCode(var ShortcutDimCode: array[8] of Code[20])ShowDimensions()IsOpenedFromBatch(): BooleanCreateDimFromDefaultDim()IsAcquisitionCost(): Boolean
Plus 3 local procedures.
Triggers
OnInsert
Relations
- Source Code: TableRelation Table 230 “Source Code”
- Reason Code: TableRelation Table 231 “Reason Code”
- Posting No. Series: TableRelation Table 308 “No. Series”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Budgeted FA No.: TableRelation Table 5600 “Fixed Asset”
- FA No.: TableRelation Table 5600 “Fixed Asset”
- FA Error Entry No.: TableRelation Table 5601 “FA Ledger Entry”
- FA Posting Group: TableRelation Table 5606 “FA Posting Group”
- Depreciation Book Code: TableRelation Table 5611 “Depreciation Book”
- Duplicate in Depreciation Book: TableRelation Table 5611 “Depreciation Book”
- Journal Template Name: TableRelation Table 5619 “FA Journal Template”
- Journal Batch Name: TableRelation Table 5620 “FA Journal Batch”
- Maintenance Code: TableRelation Table 5626 “Maintenance”
- Insurance No.: TableRelation Table 5628 “Insurance”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 5620 “FA Journal Batch”: No. of Lines
Pages and codeunits on this table
- Page 5629 “Fixed Asset Journal” (source table)
- Page 5634 “Recurring Fixed Asset Journal” (source table)
- Codeunit 5633 “FA Jnl.-Post Batch” (codeunit runs on it)
- Codeunit 5634 “FA Jnl.-Show Entries” (codeunit runs on it)
- Codeunit 5636 “FA. Jnl.-Post” (codeunit runs on it)
- Codeunit 5670 “FA. Jnl.-Post+Print” (codeunit runs on it)
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.
- Codeunit 408 “DimensionManagement” (7 calls:
CreateDim → GetRecDefaultDimID,InitDefaultDimensionSources → AddDimSource,LookupShortcutDimCode → LookupDimValueCode, …) - Page 456 “No. Series” (1 call:
SetUpNewLine → (object))
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: "FA Journal Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.