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 (Name) Code10 NotBlank: Yes
2 Description (Description) Text80
5 Test Report ID (Test Report ID) Integer
6 Page ID (Page ID) Integer
7 Registering Report ID (Registering Report ID) Integer
8 Force Registering Report (Force Registering Report) Boolean
9 Type (Type) Option
10 Source Code (Source Code) Code10
11 Reason Code (Reason Code) Code10
15 Test Report Caption (Test Report Caption) Text250 Editable: No
FlowField
16 Page Caption (Page Caption) Text250 Editable: No
FlowField
17 Registering Report Caption (Registering Report Caption) Text250 Editable: No
FlowField
19 No. Series (No. Series) Code10
20 Registering No. Series (Registering No. Series) Code10

Keys

# Fields
0 Name (Name) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Registering Report ID (Registering Report ID) AllObjWithCaption Object ID (Object ID) 1..n
Registering No. Series (Registering No. Series) No. Series Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Warehouse Journal Batch Journal Template Name (Journal Template Name) 1..n
Warehouse Journal Line Journal Template Name (Journal Template Name) 1..n