Diagrams


Table

Warehouse Journal Batch

DynamicsDocs.comWarehouse Journal Batch«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 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 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 7301»Warehouse EmployeeUser ID [PK]Location Code [PK]DefaultADCS User<Journal Template Name><Reason Code><No. Series><Registering No. Series><Location Code><Assigned User ID><Journal Batch Name><Journal Template Name><Location Code><Reason Code><Registering No. Series><Reason Code><No. Series><Registering No. Series><Location Code>

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 Registering No. Series Code10
7 Location Code Code10 NotBlank: Yes
21 Template Type Option Editable: No
FlowField
7700 Assigned User ID Code50

Keys

# Fields
0 Journal Template Name,Name,Location Code Clustered: Yes
1 Location Code,Assigned User ID

Table Relations To Other Tables

Field Related Table Related Field
Location Code Location Code 1..n
Registering No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Assigned User ID Warehouse Employee User ID 1..n
Journal Template Name Warehouse Journal Template Name 1..n

Table Relations From Other Tables

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