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 Code10 NotBlank: Yes
2 Description Text80
5 Test Report ID Integer
6 Page ID Integer
7 Posting Report ID Integer
8 Force Posting Report Boolean
10 Source Code Code10
11 Reason Code Code10
12 Recurring Boolean
13 Test Report Caption Text250 Editable: No
FlowField
14 Page Caption Text250 Editable: No
FlowField
15 Posting Report Caption Text250 Editable: No
FlowField
16 No. Series Code10
17 Posting No. Series Code10

Keys

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

Table Relations To Other Tables

Field Related Table Related Field
Posting Report ID AllObjWithCaption Object ID 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
Job Journal Batch Journal Template Name 1..n
Job Journal Line Journal Template Name 1..n
Office Job Journal Job Journal Template Name 1..n