FA Journal Line

DynamicsDocs.comFA Journal Line«Table 5621»FA Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Depreciation Book CodeFA Posting Type; [Acquisition Cost,Dep...FA No.FA Posting DatePosting DateDocument Type; [,,Invoice,Credit Memo]Document DateDocument No.External Document No.DescriptionAmountDebit AmountCredit AmountSalvage ValueQuantityCorrectionNo. of Depreciation DaysDepr. until FA Posting DateDepr. Acquisition CostFA Posting GroupMaintenance CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeInsurance No.Budgeted FA No.Use Duplication ListDuplicate in Depreciation BookFA Reclassification Entry...«Table 5619»FA Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionMaint. Posting Report IDMaint. Posting Report CaptionNo. SeriesPosting No. Series«Table 5620»FA Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«Table 5611»Depreciation BookCode [PK,NN]DescriptionG/L Integration - Acq. CostG/L Integration - DepreciationG/L Integration - Write-DownG/L Integration - AppreciationG/L Integration - Custom 1G/L Integration - Custom 2G/L Integration - DisposalG/L Integration - MaintenanceDisposal Calculation Method; [Net,Gros...Use Custom 1 DepreciationAllow Depr. below ZeroUse FA Exch. Rate in Duplic.Part of Duplication ListLast Date ModifiedAllow IndexationUse Same FA+G/L Posting DatesDefault Exchange RateUse FA Ledger CheckUse Rounding in Periodic Depr.New Fiscal Year Starting DateNo. of Days in Fiscal YearAllow Changes in Depr. FieldsDefault Final Rounding AmountDefault Ending Book ValuePeriodic Depr. Date Calc.; [Last Entry...Mark Errors as CorrectionsAdd-Curr Exch Rate - Acq. CostAdd.-Curr. Exch. Rate - Depr.Add-Curr Exch Rate -Write-Down...«Table 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting Group«Table 5606»FA Posting GroupCode [PK,NN]Acquisition Cost AccountAccum. Depreciation AccountWrite-Down AccountAppreciation AccountCustom 1 AccountCustom 2 AccountAcq. Cost Acc. on DisposalAccum. Depr. Acc. on DisposalWrite-Down Acc. on DisposalAppreciation Acc. on DisposalCustom 1 Account on DisposalCustom 2 Account on DisposalGains Acc. on DisposalLosses Acc. on DisposalBook Val. Acc. on Disp. [Gain]Sales Acc. on Disp. [Gain]Write-Down Bal. Acc. on Disp.Apprec. Bal. Acc. on Disp.Custom 1 Bal. Acc. on DisposalCustom 2 Bal. Acc. on DisposalMaintenance Expense AccountMaintenance Bal. Acc.Acquisition Cost Bal. Acc.Depreciation Expense Acc.Write-Down Expense Acc.Appreciation Bal. AccountCustom 1 Expense Acc.Custom 2 Expense Acc.Sales Bal. Acc.Allocated Acquisition Cost %...«Table 5626»MaintenanceCode [PK,NN]Description«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 5628»InsuranceNo. [PK]Effective DateExpiration DatePolicy No.Annual PremiumPolicy CoverageTotal Value InsuredCommentInsurance TypeLast Date ModifiedInsurance Vendor No.FA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeBlockedDescriptionSearch DescriptionDate FilterNo. Series«Table 5601»FA Ledger EntryEntry No. [PK]G/L Entry No.FA No.FA Posting DatePosting DateDocument Type; [,Payment,Invoice,Credi...Document DateDocument No.External Document No.DescriptionDepreciation Book CodeFA Posting Category; [,Disposal,Bal. D...FA Posting Type; [Acquisition Cost,Dep...AmountDebit AmountCredit AmountReclassification EntryPart of Book ValuePart of Depreciable BasisDisposal Calculation Method; [,Net,Gro...Disposal Entry No.No. of Depreciation DaysQuantityFA No./Budgeted FA No.FA Subclass CodeFA Location CodeFA Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeUser ID...«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 230»Source CodeCode [PK,NN]Description«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Journal Template Name><Journal Batch Name><Depreciation Book Code><Duplicate in Depreciation Book><FA No.><Budgeted FA No.><FA Posting Group><Maintenance Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Insurance No.><FA Error Entry No.><Reason Code><Source Code><Posting No. Series><Dimension Set ID><Source Code><Reason Code><No. Series><Posting No. Series><Journal Template Name><Reason Code><No. Series><Posting No. Series><Depreciation Book Code><Global Dimension 1 Code><Global Dimension 2 Code><Component of Main Asset><No. Series><FA Posting Group><FA No.><FA No./Budgeted FA No.><Bal. Account No.><Canceled from FA No.><FA Posting Group><Dimension Value Code><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Code><Global Dimension 2 Code><No. Series><Source Code><Reason Code><No. Series><Reversed by Entry No.><Reversed Entry No.><Dimension Set ID>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback


# Name Type
1 Journal Template Name (Journal Template Name) Code10
2 Journal Batch Name (Journal Batch Name) Code10
3 Line No. (Line No.) Integer
4 Depreciation Book Code (Depreciation Book Code) Code10
5 FA Posting Type (FA Posting Type) Option
6 FA No. (FA No.) Code20
7 FA Posting Date (FA Posting Date) Date
8 Posting Date (Posting Date) Date
9 Document Type (Document Type) Option
10 Document Date (Document Date) Date
11 Document No. (Document No.) Code20
12 External Document No. (External Document No.) Code35
13 Description (Description) Text50
14 Amount (Amount) Decimal
15 Debit Amount (Debit Amount) Decimal
16 Credit Amount (Credit Amount) Decimal
17 Salvage Value (Salvage Value) Decimal
18 Quantity (Quantity) Decimal (0:5)
19 Correction (Correction) Boolean
20 No. of Depreciation Days (No. of Depreciation Days) Integer BlankZero: Yes
21 Depr. until FA Posting Date (Depr. until FA Posting Date) Boolean
22 Depr. Acquisition Cost (Depr. Acquisition Cost) Boolean
24 FA Posting Group (FA Posting Group) Code10
26 Maintenance Code (Maintenance Code) Code10
27 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
28 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
30 Insurance No. (Insurance No.) Code20
31 Budgeted FA No. (Budgeted FA No.) Code20
32 Use Duplication List (Use Duplication List) Boolean
33 Duplicate in Depreciation Book (Duplicate in Depreciation Book) Code10
34 FA Reclassification Entry (FA Reclassification Entry) Boolean
35 FA Error Entry No. (FA Error Entry No.) Integer BlankZero: Yes
36 Reason Code (Reason Code) Code10
37 Source Code (Source Code) Code10
38 Recurring Method (Recurring Method) Option
39 Recurring Frequency (Recurring Frequency) DateFormula
41 Expiration Date (Expiration Date) Date
42 Index Entry (Index Entry) Boolean
43 Posting No. Series (Posting No. Series) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No


# Fields
0 Journal Template Name,Journal Batch Name,Line No. (Journal Template Name,Journal Batch Name,Line No.) Clustered: Yes
1 Journal Template Name,Journal Batch Name,FA Posting Date (Journal Template Name,Journal Batch Name,FA Posting Date) MaintainSQLIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Duplicate in Depreciation Book (Duplicate in Depreciation Book) Depreciation Book Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n
Journal Batch Name (Journal Batch Name) FA Journal Batch Name (Name) 1..n
Journal Template Name (Journal Template Name) FA Journal Template Name (Name) 1..n
FA Error Entry No. (FA Error Entry No.) FA Ledger Entry Entry No. (Entry No.) 1..n
FA Posting Group (FA Posting Group) FA Posting Group Code (Code) 1..n
Budgeted FA No. (Budgeted FA No.) Fixed Asset No. (No.) 1..n
Insurance No. (Insurance No.) Insurance No. (No.) 1..n
Maintenance Code (Maintenance Code) Maintenance Code (Code) 1..n
Posting No. Series (Posting No. Series) No. Series Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n

Table Relations From Other Tables

From Table From Field