Diagrams

Table

Fixed Asset

DynamicsDocs.comFixed Asset«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 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountType; [Bank Account Ledger Entry,Check...Sorting OrderStmt To Rem. Amount Difference«Table 5612»FA Depreciation BookFA No. [PK,NN]Depreciation Book Code [PK,NN]Depreciation Method; [Straight-Line,De...Depreciation Starting DateStraight-Line %No. of Depreciation YearsNo. of Depreciation MonthsFixed Depr. AmountDeclining-Balance %Depreciation Table CodeFinal Rounding AmountEnding Book ValueFA Posting GroupDepreciation Ending DateAcquisition CostDepreciationBook ValueProceeds on DisposalGain/LossWrite-DownAppreciationCustom 1Custom 2Depreciable BasisSalvage ValueBook Value on DisposalMaintenanceMaintenance Code FilterFA Posting Date FilterAcquisition DateG/L Acquisition Date...«Table 5616»Maintenance RegistrationFA No. [PK,NN]Line No. [PK]Service DateMaintenance Vendor No.CommentService Agent NameService Agent Phone No.Service Agent Mobile Phone«Table 5640»Main Asset ComponentMain Asset No. [PK,NN]FA No. [PK,NN]Description«Table 5650»Total Value InsuredFA No. [PK]Insurance No. [PK]DescriptionTotal Value Insured«Table 5607»FA ClassCode [PK,NN]Name«Table 5608»FA SubclassCode [PK,NN]NameFA Class CodeDefault FA Posting Group«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 5609»FA LocationCode [PK,NN]Name«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«Table 5200»EmployeeNo. [PK]First NameMiddle NameLast NameInitialsJob TitleSearch NameAddressAddress 2CityPost CodeCountyPhone No.Mobile Phone No.E-MailAlt. Address CodeAlt. Address Start DateAlt. Address End DatePictureBirth DateSocial Security No.Union CodeUnion Membership No.Gender; [,Female,Male]Country/Region CodeManager No.Emplymt. Contract CodeStatistics Group CodeEmployment DateStatus; [Active,Inactive,Terminated]Inactive Date...«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><FA Subclass Code><Location Code><FA Location Code><Vendor No.><Maintenance Vendor No.><Component of Main Asset><Responsible Employee><FA Posting Group><Account No.><FA No.><Component of Main Asset><FA No.><Main Asset No.><FA No.><FA No.><Account No.><FA Posting Group><Maintenance Vendor No.><FA Class Code><Default FA Posting Group><Location Code><Pay-to Vendor No.><Manager No.><Employee No. Filter>

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

Fields

# Name Type
1 No. (No.) Code20
2 Description (Description) Text50
3 Search Description (Search Description) Code50
4 Description 2 (Description 2) Text50
5 FA Class Code (FA Class Code) Code10
6 FA Subclass Code (FA Subclass Code) Code10
7 Global Dimension 1 Code (Global Dimension 1 Code) Code20
8 Global Dimension 2 Code (Global Dimension 2 Code) Code20
9 Location Code (Location Code) Code10
10 FA Location Code (FA Location Code) Code10
11 Vendor No. (Vendor No.) Code20
12 Main Asset/Component (Main Asset/Component) Option Editable: No
13 Component of Main Asset (Component of Main Asset) Code20 Editable: No
14 Budgeted Asset (Budgeted Asset) Boolean
15 Warranty Date (Warranty Date) Date
16 Responsible Employee (Responsible Employee) Code20
17 Serial No. (Serial No.) Text30
18 Last Date Modified (Last Date Modified) Date Editable: No
19 Insured (Insured) Boolean Editable: No
FlowField
20 Comment (Comment) Boolean Editable: No
FlowField
21 Blocked (Blocked) Boolean
22 Picture (Picture) BLOB [Bitmap]
23 Maintenance Vendor No. (Maintenance Vendor No.) Code20
24 Under Maintenance (Under Maintenance) Boolean
25 Next Service Date (Next Service Date) Date
26 Inactive (Inactive) Boolean
27 FA Posting Date Filter (FA Posting Date Filter) Date FlowFilter
28 No. Series (No. Series) Code20 Editable: No
29 FA Posting Group (FA Posting Group) Code20
30 Acquired (Acquired) Boolean FlowField
140 Image (Image) Media

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Search Description (Search Description)
2 FA Class Code (FA Class Code)
3 FA Subclass Code (FA Subclass Code)
4 Component of Main Asset,Main Asset/Component (Component of Main Asset,Main Asset/Component)
5 FA Location Code (FA Location Code)
6 Global Dimension 1 Code (Global Dimension 1 Code)
7 Global Dimension 2 Code (Global Dimension 2 Code)
8 FA Posting Group (FA Posting Group)
9 Description (Description)

Table Relations To Other Tables

Field Related Table Related Field
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 1..n
Responsible Employee (Responsible Employee) Employee No. (No.) 1..n
FA Class Code (FA Class Code) FA Class Code (Code) 1..n
FA Location Code (FA Location Code) FA Location Code (Code) 1..n
FA Posting Group (FA Posting Group) FA Posting Group Code (Code) 1..n
FA Subclass Code (FA Subclass Code) FA Subclass Code (Code) 1..n
Component of Main Asset (Component of Main Asset) Fixed Asset No. (No.) 1..n
Location Code (Location Code) Location () 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Maintenance Vendor No. (Maintenance Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Applied Payment Entry Account No. (Account No.) 1..n
Bank Acc. Reconciliation Line Account No. (Account No.) 1..n
Bank Account Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
CV Ledger Entry Buffer Bal. Account No. (Bal. Account No.) 1..n
Cash Flow Forecast Entry Source No. (Source No.) 1..n
Check Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Comment Line No. (No.) 1..n
Cust. Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Default Dimension No. (No.) 1..n
Employee Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
FA Depreciation Book Component of Main Asset (Component of Main Asset) 1..n
FA Journal Line Budgeted FA No. (Budgeted FA No.) 1..n
FA Ledger Entry Canceled from FA No. (Canceled from FA No.) 1..n
FA Reclass. Journal Line New FA No. (New FA No.) 1..n
Fixed Asset Component of Main Asset (Component of Main Asset) 1..n
G/L Entry Source No. (Source No.) 1..n
Gen. Journal Batch Bal. Account No. (Bal. Account No.) 1..n
Gen. Journal Line Budgeted FA No. (Budgeted FA No.) 1..n
Gen. Journal Template Bal. Account No. (Bal. Account No.) 1..n
Ins. Coverage Ledger Entry FA No. (FA No.) 1..n
Insurance Journal Line FA No. (FA No.) 1..n
Invoice Post. Buffer Budgeted FA No. (Budgeted FA No.) 1..n
Main Asset Component FA No. (FA No.) 1..n
Maintenance Ledger Entry Bal. Account No. (Bal. Account No.) 1..n
Maintenance Registration FA No. (FA No.) 1..n
Payment Application Proposal Account No. (Account No.) 1..n
Posted Payment Recon. Line Account No. (Account No.) 1..n
Purch. Cr. Memo Line Budgeted FA No. (Budgeted FA No.) 1..n
Purch. Inv. Line Budgeted FA No. (Budgeted FA No.) 1..n
Purch. Rcpt. Line Budgeted FA No. (Budgeted FA No.) 1..n
Purchase Line Budgeted FA No. (Budgeted FA No.) 1..n
Purchase Line Archive Budgeted FA No. (Budgeted FA No.) 1..n
Return Receipt Line No. (No.) 1..n
Return Shipment Line Budgeted FA No. (Budgeted FA No.) 1..n
Reversal Entry Bal. Account No. (Bal. Account No.) 1..n
Sales Cr.Memo Line No. (No.) 1..n
Sales Invoice Line No. (No.) 1..n
Sales Line Archive No. (No.) 1..n
Sales Shipment Buffer No. (No.) 1..n
Sales Shipment Line No. (No.) 1..n
Service Shipment Buffer No. (No.) 1..n
Standard General Journal Line Source No. (Source No.) 1..n
Standard Purchase Line No. (No.) 1..n
Standard Sales Line No. (No.) 1..n
Total Value Insured FA No. (FA No.) 1..n
Vendor Ledger Entry Bal. Account No. (Bal. Account No.) 1..n