Diagrams


Table

Warehouse Journal Line

DynamicsDocs.comWarehouse Journal Line«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 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 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 7300»ZoneLocation Code [PK,NN]Code [PK,NN]DescriptionBin Type CodeWarehouse Class CodeSpecial Equipment CodeZone RankingCross-Dock Bin Zone«Table 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«Table 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«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«Table 7303»Bin TypeCode [PK,NN]DescriptionReceiveShipPut AwayPick«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 7381»Phys. Invt. Counting PeriodCode [PK,NN]DescriptionCount Frequency per Year [NN]<Journal Template Name><Journal Batch Name><Location Code><From Zone Code><Zone Code><To Zone Code><From Bin Code><From Bin Code><Bin Code><To Bin Code><Item No.><Source Code><Reason Code><Registering No. Series><From Bin Type Code><User ID><Variant Code><Unit of Measure Code><Phys Invt Counting Period Code><Source Code><Reason Code><No. Series><Registering No. Series><Journal Template Name><Reason Code><No. Series><Registering No. Series><Location Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Location Code><Location Filter><Location Code><Location Code><Bin Type Code><Zone Code><Zone Code><Bin Code><Item No.><Bin Type Code><Variant Code><Unit of Measure Code><Unit of Measure Filter><Bin Type Code><Item Filter><Bin Filter><Alternative Item No.><No. Series><Serial Nos.><Lot Nos.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Phys Invt Counting Period 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
2 Journal Batch Name Code10
3 Line No. Integer
4 Registering Date Date
5 Location Code Code10
6 From Zone Code Code10
7 From Bin Code Code20
8 Description Text50
9 Item No. Code20
10 Quantity Decimal (0:5)
11 Qty. (Base) Decimal (0:5)
12 Qty. (Absolute) Decimal (0:5)
13 Qty. (Absolute, Base) Decimal (0:5)
14 Zone Code Code10
15 Bin Code Code20
20 Source Type Integer Editable: No
21 Source Subtype Option Editable: No
22 Source No. Code20 Editable: No
23 Source Line No. Integer BlankZero: Yes
Editable: No
24 Source Subline No. Integer BlankZero: Yes
Editable: No
25 Source Document Option BlankZero: Yes
Editable: No
26 Source Code Code10 Editable: No
27 To Zone Code Code10
28 To Bin Code Code20
29 Reason Code Code10
33 Registering No. Series Code10
35 From Bin Type Code Code10
40 Cubage Decimal (0:5) Editable: No
41 Weight Decimal (0:5) Editable: No
50 Whse. Document No. Code20
51 Whse. Document Type Option
52 Whse. Document Line No. Integer BlankZero: Yes
53 Qty. (Calculated) Decimal (0:5) Editable: No
54 Qty. (Phys. Inventory) Decimal (0:5)
55 Entry Type Option
56 Phys. Inventory Boolean Editable: No
60 Reference Document Option
61 Reference No. Code20
67 User ID Code50
68 Qty. (Calculated) (Base) Decimal (0:5) Editable: No
69 Qty. (Phys. Inventory) (Base) Decimal (0:5) Editable: No
5402 Variant Code Code10
5404 Qty. per Unit of Measure Decimal (0:5) Editable: No
5407 Unit of Measure Code Code10
6500 Serial No. Code20
6501 Lot No. Code20
6502 Warranty Date Date Editable: No
6503 Expiration Date Date Editable: No
6504 New Serial No. Code20 Editable: No
6505 New Lot No. Code20 Editable: No
6506 New Expiration Date Date Editable: No
7380 Phys Invt Counting Period Code Code10 Editable: No
7381 Phys Invt Counting Period Type Option Editable: No

Keys

# Fields
0 Journal Template Name,Journal Batch Name,Location Code,Line No. Clustered: Yes
1 Item No.,Location Code,Entry Type,From Bin Type Code,Variant Code,Unit of Measure Code MaintainSIFTIndex: No
2 Item No.,From Bin Code,Location Code,Entry Type,Variant Code,Unit of Measure Code,Lot No.,Serial No. MaintainSIFTIndex: No
3 Item No.,To Bin Code,Location Code,Variant Code,Unit of Measure Code,Lot No.,Serial No. MaintainSIFTIndex: No
4 To Bin Code,Location Code MaintainSIFTIndex: No
5 Location Code,Item No.,Variant Code
6 Location Code,Bin Code,Item No.,Variant Code

Table Relations To Other Tables

Field Related Table Related Field
To Bin Code Bin Code 1..n
From Bin Code Bin Content Bin Code 1..n
From Bin Type Code Bin Type Code 1..n
Item No. Item 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Location Code Location Code 1..n
Registering No. Series No. Series Code 1..n
Phys Invt Counting Period Code Phys. Invt. Counting Period Code 1..n
Reason Code Reason Code Code 1..n
Source Code Source Code Code 1..n
User ID User User Name 1..n
Journal Batch Name Warehouse Journal Batch Name 1..n
Journal Template Name Warehouse Journal Template Name 1..n
To Zone Code Zone Code 1..n

Table Relations From Other Tables

From Table From Field