Diagrams

Table

Res. Journal Template

DynamicsDocs.comRes. Journal Template«Table 206»Res. Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«Table 207»Res. Journal LineJournal Template Name [PK]Line No. [PK]Entry Type; [Usage,Sale]Document No.Posting DateResource No.Resource Group No.DescriptionWork Type CodeJob No.Unit of Measure CodeQuantityDirect Unit CostUnit CostTotal CostUnit PriceTotal PriceShortcut Dimension 1 CodeShortcut Dimension 2 CodeSource CodeJournal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyGen. Bus. Posting GroupGen. Prod. Posting GroupDocument DateExternal Document No.Posting No. SeriesSource Type; [,Customer]...«Table 236»Res. Journal BatchJournal Template Name [PK]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesRecurring«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<Source Code><Reason Code><No. Series><Posting No. Series><Journal Template Name><Journal Template Name><Source Code><Journal Batch Name><Reason Code><Posting No. Series><Reason Code><No. Series><Posting No. Series>

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

Fields

# Name Type
1 Name (Name) Code10 NotBlank: Yes
2 Description (Description) Text80
5 Test Report ID (Test Report ID) Integer
6 Page ID (Page ID) Integer
7 Posting Report ID (Posting Report ID) Integer
8 Force Posting Report (Force Posting Report) Boolean
10 Source Code (Source Code) Code10
11 Reason Code (Reason Code) Code10
12 Recurring (Recurring) Boolean
13 Test Report Caption (Test Report Caption) Text250 Editable: No
FlowField
14 Page Caption (Page Caption) Text250 Editable: No
FlowField
15 Posting Report Caption (Posting Report Caption) Text250 Editable: No
FlowField
16 No. Series (No. Series) Code10
17 Posting No. Series (Posting No. Series) Code10

Keys

# Fields
0 Name (Name) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Posting Report ID (Posting Report ID) AllObjWithCaption Object ID (Object ID) 1..n
Posting No. Series (Posting 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

Table Relations From Other Tables

From Table From Field
Res. Journal Batch Journal Template Name (Journal Template Name) 1..n
Res. Journal Line Journal Template Name (Journal Template Name) 1..n