Diagrams


Table

Maintenance Ledger Entry

DynamicsDocs.comMaintenance Ledger Entry«Table 5625»Maintenance Ledger EntryEntry No. [PK]G/L Entry No.FA No.FA Posting DatePosting DateDocument Type; [,Payment,Invoice,Credi...Document DateDocument No.External Document No.DescriptionAmountDebit AmountCredit AmountQuantityFA No./Budgeted FA No.FA Subclass CodeFA Location CodeFA Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeUser IDJournal Batch NameSource CodeReason CodeTransaction No.Bal. Account Type; [G/L Account,Custom...Bal. Account No.VAT AmountGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting Group...«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 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 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 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 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 5626»MaintenanceCode [PK,NN]Description«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.><FA Subclass Code><FA Location Code><FA Posting Group><Global Dimension 1 Code><Global Dimension 2 Code><Location Code><User ID><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><Depreciation Book Code><Maintenance 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 Maintenance Entry No.><To Maintenance 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><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
12 Amount Decimal
13 Debit Amount Decimal
14 Credit Amount Decimal
15 Quantity Decimal (0:5)
16 FA No./Budgeted FA No. Code20
17 FA Subclass Code Code10
18 FA Location Code Code10
19 FA Posting Group Code20
20 Global Dimension 1 Code Code20
21 Global Dimension 2 Code Code20
22 Location Code Code10
24 User ID Code50
25 Journal Batch Name Code10
26 Source Code Code10
27 Reason Code Code10
28 Transaction No. Integer
29 Bal. Account Type Option
30 Bal. Account No. Code20
31 VAT Amount Decimal
32 Gen. Posting Type Option
33 Gen. Bus. Posting Group Code20
34 Gen. Prod. Posting Group Code20
35 FA Class Code Code10
36 Depreciation Book Code Code10
37 FA Exchange Rate Decimal
38 Amount (LCY) Decimal
39 Maintenance Code Code10
40 Correction Boolean
41 Index Entry Boolean
42 Automatic Entry Boolean
43 No. Series Code20
44 Tax Area Code Code20
45 Tax Liable Boolean
46 Tax Group Code Code20
47 Use Tax Boolean
48 VAT Bus. Posting Group Code20
49 VAT Prod. Posting Group Code20
50 Reversed Boolean
51 Reversed by Entry No. Integer BlankZero: Yes
52 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,Posting Date
3 FA No.,Depreciation Book Code,Maintenance Code,FA Posting Date
4 FA No.,Depreciation Book Code,Maintenance Code,Posting Date
5 Document No.,Posting Date
6 G/L Entry No.
7 Transaction No.
8 FA No.,Depreciation Book Code,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
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
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
Bal. Account 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
Maintenance Code Maintenance Code 1..n
Reversed Entry No. Maintenance Ledger Entry Entry No. 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 Register To Maintenance Entry No. 1..n
G/L Entry FA Entry No. 1..n
Maintenance Ledger Entry Reversed Entry No. 1..n
Reversal Entry Entry No. 1..n