Diagrams


Table

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 GroupAcquiredImage...«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 IDIdLast Modified Date Time«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

Fields

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

Keys

# Fields
0 Journal Template Name,Journal Batch Name,Line No. Clustered: Yes
1 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 Depreciation Book Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
Journal Batch Name FA Journal Batch Name 1..n
Journal Template Name FA Journal Template Name 1..n
FA Error Entry No. FA Ledger Entry Entry No. 1..n
FA Posting Group FA Posting Group Code 1..n
Budgeted FA No. Fixed Asset No. 1..n
Insurance No. Insurance No. 1..n
Maintenance Code Maintenance Code 1..n
Posting No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n

Table Relations From Other Tables

From Table From Field