Diagrams


Table

FA Subclass

DynamicsDocs.comFA Subclass«Table 5608»FA SubclassCode [PK,NN]NameFA Class CodeDefault FA Posting Group«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 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«Table 5607»FA ClassCode [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 %...<FA Class Code><Default FA Posting Group><FA Subclass Code><FA Subclass Code><FA Subclass Code><FA Subclass Code><FA Subclass Code><FA Class Code><Component of Main Asset><FA Posting Group><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 Posting Group><FA Class Code><Reversed by Entry No.><Reversed Entry No.><FA Posting Group><FA Class Code><Reversed by Entry No.><Reversed Entry No.><FA Class Code><Insurance No.><FA Class Code>

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
3 FA Class Code Code10
4 Default FA Posting Group Code10

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
FA Class Code FA Class Code 1..n
Default FA Posting Group FA Posting Group Code 1..n

Table Relations From Other Tables

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