Diagrams


Table

FA Class

DynamicsDocs.comFA Class«Table 5607»FA ClassCode [PK,NN]Name«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 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 5608»FA SubclassCode [PK,NN]NameFA Class CodeDefault FA Posting Group«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 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 5629»Ins. Coverage Ledger EntryEntry No. [PK]Insurance No.Disposed FAFA No.FA DescriptionPosting DateDocument Type; [,Payment,Invoice,Credi...Document DateDocument No.External Document No.AmountDescriptionFA Class CodeFA Subclass CodeFA Location CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeUser IDSource CodeJournal Batch NameReason CodeIndex EntryNo. SeriesDimension Set ID<FA Class Code><FA Class Code><FA Class Code><FA Class Code><FA Class Code><FA Class Code><FA Subclass Code><Component of Main Asset><FA No.><FA No./Budgeted FA No.><Bal. Account No.><Canceled from FA No.><FA No.><FA No./Budgeted FA No.><Bal. Account No.><FA No.><FA Subclass Code><Reversed by Entry No.><Reversed Entry No.><FA Subclass Code><FA Subclass Code><FA Subclass Code><Reversed by Entry No.><Reversed Entry No.><Insurance No.>

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

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Name Text50

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
FA Ledger Entry FA Class Code 1..n
FA Subclass FA Class Code 1..n
Fixed Asset FA Class Code 1..n
Ins. Coverage Ledger Entry FA Class Code 1..n
Insurance FA Class Code 1..n
Maintenance Ledger Entry FA Class Code 1..n