Diagrams

Table

FA Ledger Entry

DynamicsDocs.comFA Ledger Entry«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 179»Reversal EntryLine No. [PK]Entry Type; [,G/L Account,Customer,Ven...Entry No.G/L Register No.Source CodeJournal Batch NameTransaction No.Source Type; [,Customer,Vendor,Bank Ac...Source No.Currency CodeDescriptionAmountDebit AmountCredit AmountAmount [LCY]Debit Amount [LCY]Credit Amount [LCY]VAT AmountPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.Account No.Account NameBal. Account Type; [G/L Account,Custom...Bal. Account No.FA Posting Category; [,Disposal,Bal. D...FA Posting Type; [,Acquisition Cost,De...Reversal Type; [Transaction,Register]«Table 17»G/L EntryEntry No. [PK]G/L Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionBal. Account No.AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeSystem-Created EntryPrior-Year EntryJob No.QuantityVAT AmountBusiness Unit CodeJournal Batch NameReason CodeGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupBal. Account Type; [G/L Account,Custom...Transaction No.Debit AmountCredit AmountDocument DateExternal Document No.Source Type; [,Customer,Vendor,Bank Ac...Source No....«Table 5617»FA RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameJournal Type; [G/L,Fixed Asset]G/L Register No.From Maintenance Entry No.To Maintenance Entry No.«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 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«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 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 5608»FA SubclassCode [PK,NN]NameFA Class CodeDefault FA Posting Group«Table 5609»FA LocationCode [PK,NN]Name«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 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 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 5642»Depreciation Table HeaderCode [PK,NN]DescriptionPeriod Length; [Month,Period,Quarter,Y...Total No. of Units«Table 230»Source CodeCode [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 5607»FA ClassCode [PK,NN]Name«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 318»Tax AreaCode [PK,NN]DescriptionLast Modified Date TimeId«Table 321»Tax GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<G/L Entry No.><FA Entry No.><FA No.><FA No./Budgeted FA No.><Bal. Account No.><Canceled from FA No.><Depreciation Book Code><FA Subclass Code><FA Location Code><FA Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Location Code><User ID><Depreciation Table Code><Source Code><Reason Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Gen. Bus. Posting Group><Gen. Prod. Posting Group><FA Class Code><No. Series><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Reversed by Entry No.><Reversed Entry No.><Dimension Set ID><Entry No.><From Entry No.><To Entry No.><FA Error Entry No.><FA Error Entry No.><Entry No.><Source Code><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Bal. Account No.><G/L Account No.><Bal. Account No.><Account Id><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Bal. Account No.><Source No.><Global Dimension 1 Code><Global Dimension 2 Code><Source Code><Reason Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><No. Series><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Reversed by Entry No.><Reversed Entry No.><Dimension Set ID><Source Code><User ID><Depreciation Book Code><Duplicate in Depreciation Book><FA No.><Budgeted FA No.><FA Posting Group><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Reason Code><Source Code><Posting No. Series><Dimension Set ID><Account No.><Bal. Account No.><Account Id><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Customer Id><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Account No.><Bal. Account No.><Source No.><Account No.><Bal. Account No.><Source No.><Budgeted FA No.><Posting Group><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Source Code><Reason Code><Gen. Bus. Posting Group><Bal. Gen. Bus. Posting Group><Gen. Prod. Posting Group><Bal. Gen. Prod. Posting Group><Posting No. Series><Tax Area Code><Bal. Tax Area Code><Tax Group Code><Bal. Tax Group Code><VAT Bus. Posting Group><Bal. VAT Bus. Posting Group><VAT Prod. Posting Group><Bal. VAT Prod. Posting Group><Dimension Set ID><Depreciation Book Code><Duplicate in Depreciation Book><FA Class Code><FA Subclass Code><Global Dimension 1 Code><Global Dimension 2 Code><Location Code><FA Location Code><Vendor No.><Maintenance Vendor No.><Component of Main Asset><No. Series><FA Posting Group><FA Class Code><Default FA Posting Group><Acquisition Cost Account><Accum. Depreciation Account><Write-Down Account><Appreciation Account><Custom 1 Account><Custom 2 Account><Acq. Cost Acc. on Disposal><Accum. Depr. Acc. on Disposal><Write-Down Acc. on Disposal><Appreciation Acc. on Disposal><Custom 1 Account on Disposal><Custom 2 Account on Disposal><Gains Acc. on Disposal><Losses Acc. on Disposal><Book 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 Disposal><Custom 2 Bal. Acc. on Disposal><Maintenance Expense Account><Maintenance Bal. Acc.><Acquisition Cost Bal. Acc.><Depreciation Expense Acc.><Write-Down Expense Acc.><Appreciation Bal. Account><Custom 1 Expense Acc.><Custom 2 Expense Acc.><Sales Bal. Acc.><Sales Acc. on Disp. (Loss)><Book Val. Acc. on Disp. (Loss)><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code><Location Code><Location Code><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Bill-to Customer No.><Gen. Bus. Posting Group><No. Series><Tax Area Code><VAT Bus. Posting Group><Pay-to Vendor No.><Gen. Bus. Posting Group><No. Series><Tax Area Code><VAT Bus. Posting Group><No. Series><Credit Transfer Msg. Nos.><Direct Debit Msg. Nos.><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group>

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

Fields

# Name Type
1 Entry No. Integer
2 G/L Entry No. Integer BlankZero: Yes
3 FA No. Code20
4 FA Posting Date Date
5 Posting Date Date
6 Document Type Option
7 Document Date Date
8 Document No. Code20
9 External Document No. Code35
10 Description Text50
11 Depreciation Book Code Code10
12 FA Posting Category Option
13 FA Posting Type Option
14 Amount Decimal
15 Debit Amount Decimal
16 Credit Amount Decimal
17 Reclassification Entry Boolean
18 Part of Book Value Boolean
19 Part of Depreciable Basis Boolean
20 Disposal Calculation Method Option
21 Disposal Entry No. Integer BlankZero: Yes
22 No. of Depreciation Days Integer
23 Quantity Decimal (0:5)
24 FA No./Budgeted FA No. Code20
25 FA Subclass Code Code10
26 FA Location Code Code10
27 FA Posting Group Code20
28 Global Dimension 1 Code Code20
29 Global Dimension 2 Code Code20
30 Location Code Code10
32 User ID Code50
33 Depreciation Method Option
34 Depreciation Starting Date Date
35 Straight-Line % Decimal (1:1)
36 No. of Depreciation Years Decimal (0:3)
37 Fixed Depr. Amount Decimal
38 Declining-Balance % Decimal (1:1)
39 Depreciation Table Code Code10
40 Journal Batch Name Code10
41 Source Code Code10
42 Reason Code Code10
43 Transaction No. Integer
44 Bal. Account Type Option
45 Bal. Account No. Code20
46 VAT Amount Decimal
47 Gen. Posting Type Option
48 Gen. Bus. Posting Group Code20
49 Gen. Prod. Posting Group Code20
50 FA Class Code Code10
51 FA Exchange Rate Decimal
52 Amount (LCY) Decimal
53 Result on Disposal Option
54 Correction Boolean
55 Index Entry Boolean
56 Canceled from FA No. Code20
57 Depreciation Ending Date Date
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) Decimal (1:1)
63 Depr. % this year (Custom 1) Decimal (1:1)
64 Property Class (Custom 1) Option
65 No. Series Code20
66 Tax Area Code Code20
67 Tax Liable Boolean
68 Tax Group Code Code20
69 Use Tax Boolean
70 VAT Bus. Posting Group Code20
71 VAT Prod. Posting Group Code20
72 Reversed Boolean
73 Reversed by Entry No. Integer BlankZero: Yes
74 Reversed Entry No. Integer BlankZero: Yes
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Entry No. Clustered: Yes
1 FA No.,Depreciation Book Code,FA Posting Date
2 FA No.,Depreciation Book Code,FA Posting Category,FA Posting Type,FA Posting Date,Part of Book Value,Reclassification Entry
3 FA No.,Depreciation Book Code,Part of Book Value,FA Posting Date
4 FA No.,Depreciation Book Code,Part of Depreciable Basis,FA Posting Date
5 FA No.,Depreciation Book Code,FA Posting Category,FA Posting Type,Posting Date
6 Canceled from FA No.,Depreciation Book Code,FA Posting Date
7 Document No.,Posting Date
8 G/L Entry No.
9 Document Type,Document No.
10 Transaction No.
11 FA No.,Depreciation Book Code,FA Posting Category,FA Posting Type,Document No.

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. Bank Account No. 1..n
Bal. Account No. Customer No. 1..n
Depreciation Book Code Depreciation Book Code 1..n
Depreciation Table Code Depreciation Table Header Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Global Dimension 2 Code Dimension Value Code 1..n
FA Class Code FA Class Code 1..n
Reversed Entry No. FA Ledger Entry Entry No. 1..n
FA Location Code FA Location Code 1..n
FA Posting Group FA Posting Group Code 1..n
FA Subclass Code FA Subclass Code 1..n
Canceled from FA No. Fixed Asset No. 1..n
Bal. Account No. G/L Account No. 1..n
G/L Entry No. G/L Entry Entry No. 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Location Code Location 1..n
No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n
Tax Area Code Tax Area Code 1..n
Tax Group Code Tax Group Code 1..n
User ID User User Name 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n
Bal. Account No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field
FA Journal Line FA Error Entry No. 1..n
FA Ledger Entry Reversed Entry No. 1..n
FA Register To Entry No. 1..n
G/L Entry FA Entry No. 1..n
Gen. Journal Line FA Error Entry No. 1..n
Reversal Entry Entry No. 1..n