Diagrams

Table

Whse. Item Entry Relation

DynamicsDocs.comWhse. Item Entry Relation«Table 6509»Whse. Item Entry RelationItem Entry No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source IDSource Batch NameSource Prod. Order LineSource Ref. No.Serial No.Lot No.Order No.Order Line No.«Table 32»Item Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeQuantityRemaining QuantityInvoiced QuantityApplies-to EntryOpenGlobal Dimension 1 CodeGlobal Dimension 2 CodePositiveSource Type; [,Customer,Vendor,Item]Drop ShipmentTransaction TypeTransport MethodCountry/Region CodeEntry/Exit PointDocument DateExternal Document No.AreaTransaction SpecificationNo. SeriesReserved QuantityDocument Type; [,Sales Shipment,Sales...Document Line No.Order Type; [,Production,Transfer,Serv......<Item Entry No.>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Item Entry No. (Item Entry No.) Integer
10 Source Type (Source Type) Integer
11 Source Subtype (Source Subtype) Option
12 Source ID (Source ID) Code20
13 Source Batch Name (Source Batch Name) Code10
14 Source Prod. Order Line (Source Prod. Order Line) Integer
15 Source Ref. No. (Source Ref. No.) Integer
20 Serial No. (Serial No.) Code20
21 Lot No. (Lot No.) Code20
30 Order No. (Order No.) Code20
31 Order Line No. (Order Line No.) Integer

Keys

# Fields
0 Item Entry No. (Item Entry No.) Clustered: Yes
1 Source ID,Source Type,Source Subtype,Source Ref. No.,Source Prod. Order Line,Source Batch Name (Source ID,Source Type,Source Subtype,Source Ref. No.,Source Prod. Order Line,Source Batch Name)
2 Order No.,Order Line No. (Order No.,Order Line No.)

Table Relations To Other Tables

Field Related Table Related Field
Item Entry No. (Item Entry No.) Item Ledger Entry Entry No. (Entry No.) 1..1

Table Relations From Other Tables

From Table From Field