Diagrams


Table

Warehouse Journal Template

DynamicsDocs.comWarehouse Journal Template«Table 7309»Warehouse Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDRegistering Report IDForce Registering ReportType; [Item,Physical Inventory,Reclass...Source CodeReason CodeTest Report CaptionPage CaptionRegistering Report CaptionNo. SeriesRegistering No. Series«Table 7310»Warehouse Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeNo. SeriesRegistering No. SeriesLocation Code [PK,NN]Template Type; [Item,Physical Inventor...Assigned User ID«Table 7311»Warehouse Journal LineJournal Template Name [PK]Journal Batch Name [PK]Line No. [PK]Registering DateLocation Code [PK]From Zone CodeFrom Bin CodeDescriptionItem No.QuantityQty. [Base]Qty. [Absolute]Qty. [Absolute, Base]Zone CodeBin CodeSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,S. Order,S. Invoice...Source CodeTo Zone CodeTo Bin CodeReason CodeRegistering No. SeriesFrom Bin Type CodeCubageWeightWhse. Document No.Whse. Document Type; [Whse. Journal,Re......«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><Registering No. Series><Journal Template Name><Journal Template Name><Reason Code><No. Series><Registering No. Series><Journal Batch Name><Source Code><Reason Code><Registering 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 Registering Report ID Integer
8 Force Registering Report Boolean
9 Type Option
10 Source Code Code10
11 Reason Code Code10
15 Test Report Caption Text250 Editable: No
FlowField
16 Page Caption Text250 Editable: No
FlowField
17 Registering Report Caption Text250 Editable: No
FlowField
19 No. Series Code10
20 Registering No. Series Code10

Keys

# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

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