Diagrams


Table

Job Journal Template

DynamicsDocs.comJob Journal Template«Table 209»Job Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportSource CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. Series«Table 1615»Office Job JournalJob No. [PK]Job Task No. [PK]Job Planning Line No. [PK]Job Journal Template NameJob Journal Batch Name«Table 210»Job Journal LineJournal Template Name [PK]Line No. [PK]Job No.Posting DateDocument No.Type; [Resource,Item,G/L Account]No.DescriptionQuantityDirect Unit Cost [LCY]Unit Cost [LCY]Total Cost [LCY]Unit Price [LCY]Total Price [LCY]Resource Group No.Unit of Measure CodeLocation CodeChargeablePosting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeWork Type CodeCustomer Price GroupApplies-to EntryEntry Type; [Usage,Sale]Source CodeJournal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring Frequency...«Table 237»Job Journal BatchJournal Template Name [PK,NN]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><Job Journal Template Name><Journal Template Name><Journal Template Name><Job Journal Batch 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) Code20
17 Posting No. Series (Posting No. Series) Code20

Keys

# Fields
0 Name (Name) Clustered: Yes
1 Page ID,Recurring (Page ID,Recurring)

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
Job Journal Batch Journal Template Name (Journal Template Name) 1..n
Job Journal Line Journal Template Name (Journal Template Name) 1..n
Office Job Journal Job Journal Template Name (Job Journal Template Name) 1..n