Diagrams

Table

Warehouse Entry

DynamicsDocs.comWarehouse Entry«Table 7312»Warehouse EntryEntry No. [PK]Journal Batch NameLine No.Registering DateLocation CodeZone CodeBin CodeDescriptionItem No.QuantityQty. [Base]Source 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 CodeReason CodeNo. SeriesBin Type CodeCubageWeightJournal Template NameWhse. Document No.Whse. Document Type; [Whse. Journal,Re...Whse. Document Line No.Entry Type; [Negative Adjmt.,Positive...Reference Document; [,Posted Rcpt.,Pos...Reference No.User ID...«Table 7313»Warehouse RegisterNo. [PK]From Entry No.To Entry No.Creation DateSource CodeUser IDJournal Batch Name«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 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 EmailExchange IdentifierApplication ID«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]<Location Code><Zone Code><Bin Code><Item No.><Source Code><Reason Code><No. Series><Bin Type Code><User ID><Variant Code><Unit of Measure Code><Phys Invt Counting Period Code><From Entry No.><To Entry No.><Source Code><User ID><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><Bin Type Code><Zone Code><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 Entry No. (Entry No.) Integer
2 Journal Batch Name (Journal Batch Name) Code10
3 Line No. (Line No.) Integer BlankZero: Yes
4 Registering Date (Registering Date) Date
5 Location Code (Location Code) Code10
6 Zone Code (Zone Code) Code10
7 Bin Code (Bin Code) Code20
8 Description (Description) Text50
9 Item No. (Item No.) Code20
10 Quantity (Quantity) Decimal (0:5)
11 Qty. (Base) (Qty. (Base)) Decimal (0:5)
20 Source Type (Source Type) Integer
21 Source Subtype (Source Subtype) Option
22 Source No. (Source No.) Code20
23 Source Line No. (Source Line No.) Integer BlankZero: Yes
24 Source Subline No. (Source Subline No.) Integer
25 Source Document (Source Document) Option BlankZero: Yes
26 Source Code (Source Code) Code10
29 Reason Code (Reason Code) Code10
33 No. Series (No. Series) Code10
35 Bin Type Code (Bin Type Code) Code10
40 Cubage (Cubage) Decimal (0:5)
41 Weight (Weight) Decimal (0:5)
45 Journal Template Name (Journal Template Name) Code10
50 Whse. Document No. (Whse. Document No.) Code20
51 Whse. Document Type (Whse. Document Type) Option
52 Whse. Document Line No. (Whse. Document Line No.) Integer BlankZero: Yes
55 Entry Type (Entry Type) Option
60 Reference Document (Reference Document) Option
61 Reference No. (Reference No.) Code20
67 User ID (User ID) Code50
5402 Variant Code (Variant Code) Code10
5404 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)
5407 Unit of Measure Code (Unit of Measure Code) Code10
6500 Serial No. (Serial No.) Code20
6501 Lot No. (Lot No.) Code20
6502 Warranty Date (Warranty Date) Date
6503 Expiration Date (Expiration Date) Date
7380 Phys Invt Counting Period Code (Phys Invt Counting Period Code) Code10 Editable: No
7381 Phys Invt Counting Period Type (Phys Invt Counting Period Type) Option Editable: No
7382 Dedicated (Dedicated) Boolean Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Reference No.,Registering Date (Reference No.,Registering Date)
2 Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No.,Source Document,Bin Code (Source Type,Source Subtype,Source No.,Source Line No.,Source Subline No.,Source Document,Bin Code)
3 Serial No.,Item No.,Variant Code,Location Code,Bin Code (Serial No.,Item No.,Variant Code,Location Code,Bin Code)
4 Item No.,Bin Code,Location Code,Variant Code,Unit of Measure Code,Lot No.,Serial No.,Entry Type,Dedicated (Item No.,Bin Code,Location Code,Variant Code,Unit of Measure Code,Lot No.,Serial No.,Entry Type,Dedicated)
5 Item No.,Location Code,Variant Code,Bin Type Code,Unit of Measure Code,Lot No.,Serial No.,Dedicated (Item No.,Location Code,Variant Code,Bin Type Code,Unit of Measure Code,Lot No.,Serial No.,Dedicated)
6 Bin Code,Location Code,Item No. (Bin Code,Location Code,Item No.)
7 Location Code,Item No.,Variant Code,Zone Code,Bin Code,Lot No. (Location Code,Item No.,Variant Code,Zone Code,Bin Code,Lot No.)
8 Location Code (Location Code) MaintainSQLIndex: No
MaintainSIFTIndex: No
9 Lot No. (Lot No.)
10 Serial No. (Serial No.)

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Bin Type Code (Bin Type Code) Bin Type Code (Code) 1..n
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Location Code (Location Code) Location Code (Code) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Phys Invt Counting Period Code (Phys Invt Counting Period Code) Phys. Invt. Counting Period Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Source Code (Source Code) Source Code Code (Code) 1..n
User ID (User ID) User User Name (User Name) 1..n
Zone Code (Zone Code) Zone Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Warehouse Register To Entry No. (To Entry No.) 1..n