Diagrams

Table

Ins. Coverage Ledger Entry

DynamicsDocs.comIns. Coverage Ledger Entry«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 5636»Insurance RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«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 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 5607»FA ClassCode [PK,NN]Name«Table 5608»FA SubclassCode [PK,NN]NameFA Class CodeDefault FA Posting Group«Table 5609»FA LocationCode [PK,NN]Name«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID«Table 230»Source CodeCode [PK,NN]Description«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Insurance No.><FA No.><FA Class Code><FA Subclass Code><FA Location Code><Global Dimension 1 Code><Global Dimension 2 Code><Location Code><User ID><Source Code><Reason Code><No. Series><Dimension Set ID><From Entry No.><To Entry No.><Source Code><User ID><FA Class Code><FA Subclass Code><FA Location Code><Global Dimension 1 Code><Global Dimension 2 Code><Location Code><No. Series><FA Class Code><FA Subclass Code><Global Dimension 1 Code><Global Dimension 2 Code><Location Code><FA Location Code><Component of Main Asset><No. Series><FA Class Code><Dimension Value Code>

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

Fields

# Name Type
1 Entry No. (Entry No.) Integer
2 Insurance No. (Insurance No.) Code20
3 Disposed FA (Disposed FA) Boolean
4 FA No. (FA No.) Code20
5 FA Description (FA Description) Text50
6 Posting Date (Posting Date) Date
7 Document Type (Document Type) Option
8 Document Date (Document Date) Date
9 Document No. (Document No.) Code20
10 External Document No. (External Document No.) Code35
14 Amount (Amount) Decimal
16 Description (Description) Text50
17 FA Class Code (FA Class Code) Code10
18 FA Subclass Code (FA Subclass Code) Code10
19 FA Location Code (FA Location Code) Code10
20 Global Dimension 1 Code (Global Dimension 1 Code) Code20
21 Global Dimension 2 Code (Global Dimension 2 Code) Code20
22 Location Code (Location Code) Code10
23 User ID (User ID) Code50
24 Source Code (Source Code) Code10
25 Journal Batch Name (Journal Batch Name) Code10
26 Reason Code (Reason Code) Code10
27 Index Entry (Index Entry) Boolean
28 No. Series (No. Series) Code10
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Insurance No.,Posting Date (Insurance No.,Posting Date)
2 Insurance No.,Disposed FA,Posting Date (Insurance No.,Disposed FA,Posting Date)
3 FA No.,Insurance No.,Disposed FA,Posting Date (FA No.,Insurance No.,Disposed FA,Posting Date)
4 FA No.,Disposed FA,Posting Date (FA No.,Disposed FA,Posting Date)
5 Document No.,Posting Date (Document No.,Posting Date)

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Global Dimension 2 Code (Global Dimension 2 Code) Dimension Value Code (Code) 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 Subclass Code (FA Subclass Code) FA Subclass Code (Code) 1..n
FA No. (FA No.) Fixed Asset No. (No.) 1..n
Insurance No. (Insurance No.) Insurance No. (No.) 1..n
Location Code (Location Code) Location () 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 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
Insurance Register To Entry No. (To Entry No.) 1..n