Diagrams


Table

Insurance Journal Line

DynamicsDocs.comInsurance Journal Line«Table 5635»Insurance Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Insurance No.FA No.FA DescriptionPosting DateDocument Type; [,,Invoice,Credit Memo]Document DateDocument No.External Document No.AmountDescriptionShortcut Dimension 1 CodeShortcut Dimension 2 CodeReason CodeSource CodeIndex EntryPosting No. SeriesDimension Set ID«Table 5633»Insurance Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«Table 5634»Insurance Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. Series«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 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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 230»Source CodeCode [PK,NN]Description«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<Journal Template Name><Journal Batch Name><Insurance No.><FA No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Reason Code><Source Code><Posting No. Series><Dimension Set ID><Source Code><Reason Code><No. Series><Posting No. Series><Journal Template Name><Reason Code><No. Series><Posting No. Series><Global Dimension 1 Code><Global Dimension 2 Code><No. Series><Global Dimension 1 Code><Global Dimension 2 Code><Component of Main Asset><No. Series><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 Journal Template Name Code10
2 Journal Batch Name Code10
3 Line No. Integer
4 Insurance No. Code20
6 FA No. Code20
7 FA Description Text50
8 Posting Date Date
9 Document Type Option
10 Document Date Date
11 Document No. Code20
12 External Document No. Code35
13 Amount Decimal
14 Description Text50
15 Shortcut Dimension 1 Code Code20
16 Shortcut Dimension 2 Code Code20
17 Reason Code Code10
18 Source Code Code10
20 Index Entry Boolean
21 Posting No. Series Code10
480 Dimension Set ID Integer Editable: No

Keys

# Fields
0 Journal Template Name,Journal Batch Name,Line No. Clustered: Yes
1 Journal Template Name,Journal Batch Name,Posting Date MaintainSQLIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value Code 1..n
FA No. Fixed Asset No. 1..n
Insurance No. Insurance No. 1..n
Journal Batch Name Insurance Journal Batch Name 1..n
Journal Template Name Insurance Journal Template Name 1..n
Posting No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n

Table Relations From Other Tables

From Table From Field