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 Email«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. (No.) Integer
2 From Entry No. (From Entry No.) Integer
3 To Entry No. (To Entry No.) Integer
4 Creation Date (Creation Date) Date
5 Source Code (Source Code) Code10
6 User ID (User ID) Code50
7 Journal Batch Name (Journal Batch Name) Code10
8 Journal Type (Journal Type) Option
9 G/L Register No. (G/L Register No.) Integer BlankZero: Yes
10 From Maintenance Entry No. (From Maintenance Entry No.) Integer
11 To Maintenance Entry No. (To Maintenance Entry No.) Integer

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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