Diagrams


Table

FA Location

DynamicsDocs.comFA Location«Table 5609»FA LocationCode [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 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 Location Code><FA Location Code><FA Location Code><FA Location Code><FA Location 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.><Reversed by Entry No.><Reversed Entry No.><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 Location Code 1..n
Fixed Asset FA Location Code 1..n
Ins. Coverage Ledger Entry FA Location Code 1..n
Insurance FA Location Code 1..n
Maintenance Ledger Entry FA Location Code 1..n