Diagrams

Table

Standard Item Journal

DynamicsDocs.comStandard Item Journal«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 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<Journal Template Name><Standard Journal Code><Journal Template Name>

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 (Journal Template Name) Code10 NotBlank: Yes
Editable: No
2 Code (Code) Code10 NotBlank: Yes
3 Description (Description) Text50

Keys

# Fields
0 Journal Template Name,Code (Journal Template Name,Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Journal Template Name (Journal Template Name) Item Journal Template Name (Name) 1..n

Table Relations From Other Tables

From Table From Field
Standard Item Journal Line Standard Journal Code (Standard Journal Code) 1..n