Diagrams


Table

Item Journal Template

DynamicsDocs.comItem Journal Template«Table 82»Item Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportType; [Item,Transfer,Phys. Inventory,R...Source CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionNo. SeriesPosting No. SeriesWhse. Register Report IDWhse. Register Report Caption«Table 233»Item Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesTemplate Type; [Item,Transfer,Phys. In...Recurring«Table 752»Standard Item JournalJournal Template Name [PK,NN]Code [PK,NN]Description«Table 753»Standard Item Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Item No.Entry Type; [Purchase,Sale,Positive Ad...DescriptionLocation CodeInventory Posting GroupQuantityUnit AmountUnit CostAmountSalespers./Purch. CodeSource CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Standard Journal Code [PK]Reason CodeTransaction TypeTransport MethodCountry/Region CodeQty. [Calculated]Qty. [Phys. Inventory]Phys. InventoryGen. Bus. Posting GroupGen. Prod. Posting GroupEntry/Exit PointAreaTransaction SpecificationPosting No. SeriesDimension Set ID...«Table 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...«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><Journal Template Name><Journal Template Name><Reason Code><No. Series><Posting No. Series><Journal Batch Name><Standard Journal Code><Source Code><Reason Code><Posting No. Series><Source Code><Reason Code><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
9 Type Option
10 Source Code Code10
11 Reason Code Code10
12 Recurring Boolean
15 Test Report Caption Text250 Editable: No
FlowField
16 Page Caption Text250 Editable: No
FlowField
17 Posting Report Caption Text250 Editable: No
FlowField
19 No. Series Code10
20 Posting No. Series Code10
21 Whse. Register Report ID Integer
22 Whse. Register Report Caption Text250 Editable: No
FlowField

Keys

# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Whse. Register 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
Item Journal Batch Journal Template Name 1..n
Item Journal Line Journal Template Name 1..n
Standard Item Journal Journal Template Name 1..n
Standard Item Journal Line Journal Template Name 1..n