Diagrams


Table

Item Journal Batch

DynamicsDocs.comItem Journal Batch«Table 233»Item Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesPosting No. SeriesTemplate Type; [Item,Transfer,Phys. In...Recurring«Table 46»Item RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch NameFrom Phys. Inventory Entry No.To Phys. Inventory Entry No.From Value Entry No.To Value Entry No.From Capacity Entry No.To Capacity Entry No.«Table 7313»Warehouse RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«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 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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Journal Template Name><Reason Code><No. Series><Posting No. Series><Journal Batch Name><Journal Batch Name><Journal Batch Name><Journal Template 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 Journal Template Name Code10 NotBlank: Yes
2 Name Code10 NotBlank: Yes
3 Description Text50
4 Reason Code Code10
5 No. Series Code10
6 Posting No. Series Code10
21 Template Type Option Editable: No
FlowField
22 Recurring Boolean Editable: No
FlowField

Keys

# Fields
0 Journal Template Name,Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Journal Template Name Item Journal Template Name 1..n
Posting No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n

Table Relations From Other Tables

From Table From Field
Item Journal Line Journal Batch Name 1..n
Item Register Journal Batch Name 1..n
Warehouse Register Journal Batch Name 1..n