Diagrams


Table

FA Register

DynamicsDocs.comFA Register«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 87»Date Compr. RegisterNo. [PK]Creation DateTable CaptionPeriod Length; [Day,Week,Month,Quarter...Ending DateNo. of New RecordsNo. Records DeletedUser IDFilterStarting DateTable IDRegister No.Source CodeRetain Field ContentsRetain Totals«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 230»Source CodeCode [PK,NN]Description«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 45»G/L RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom VAT Entry No.To VAT Entry No.Reversed«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...<From Entry No.><To Entry No.><Source Code><User ID><G/L Register No.><From Maintenance Entry No.><To Maintenance Entry No.><Register No.><User ID><Register No.><Source Code><User ID><Source Code><Reversed by Entry No.><Reversed Entry No.><Source Code><Source Code><User ID><User ID><Reversed by Entry No.><Reversed Entry No.>

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

Fields

# Name Type
1 No. Integer
2 From Entry No. Integer
3 To Entry No. Integer
4 Creation Date Date
5 Source Code Code10
6 User ID Code50
7 Journal Batch Name Code10
8 Journal Type Option
9 G/L Register No. Integer BlankZero: Yes
10 From Maintenance Entry No. Integer
11 To Maintenance Entry No. Integer

Keys

# Fields
0 No. Clustered: Yes
1 Creation Date
2 Source Code,Journal Batch Name,Creation Date

Table Relations To Other Tables

Field Related Table Related Field
To Entry No. FA Ledger Entry Entry No. 1..n
G/L Register No. G/L Register No. 1..n
To Maintenance Entry No. Maintenance Ledger Entry Entry No. 1..n
Source Code Source Code Code 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field
Date Compr. Register Register No. 1..n