Diagrams

Table

Family

DynamicsDocs.comFamily«Table 99000773»FamilyNo. [PK,NN]DescriptionDescription 2Search NameBlockedLast Date ModifiedRouting No.«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«Table 5765»Warehouse RequestSource Type [PK]Source Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No. [PK]Source Document; [,Sales Order,,,Sales...Document Status; [Open,Released]Location Code [PK]Shipment Method CodeShipping Agent CodeShipping Advice; [Partial,Complete]Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment DateType; [Inbound,Outbound] [PK]Put-away / Pick No.Completely Handled«Table 5766»Warehouse Activity HeaderType; [,Put-away,Pick,Movement,Invt. P...No. [PK]Location CodeAssigned User IDAssignment DateAssignment TimeSorting Method; [,Item,Document,Shelf...No. SeriesCommentNo. PrintedNo. of LinesSource Type FilterSource Subtype Filter; [0,1,2,3,4,5,6,...Source No. FilterLocation FilterPosting DateRegistering No.Last Registering No.Registering No. SeriesDate of Last PrintingTime of Last PrintingBreakbulk FilterSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment Date...«Table 5767»Warehouse Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Qty. OutstandingQty. Outstanding [Base]Qty. to HandleQty. to Handle [Base]Qty. HandledQty. Handled [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Shipping Agent Code...«Table 5773»Registered Whse. Activity LineActivity Type; [,Put-away,Pick,Movemen...No. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeStarting DateSerial No.Lot No....«Table 7340»Posted Invt. Put-away HeaderNo. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Put-away No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateExternal Document No.2«Table 7341»Posted Invt. Put-away LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 7342»Posted Invt. Pick HeaderNo. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt Pick No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Shipment DateExternal Document No.2«Table 7343»Posted Invt. Pick LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 7344»Registered Invt. Movement Hdr.No. [PK]Location Code [NN]Assigned User IDAssignment DateAssignment TimeRegistering DateNo. SeriesCommentInvt. Movement No.No. PrintedPosting DateSource No.Source Document; [,Sales Order,,,Sales...Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Shipment DateExternal Document No.2«Table 7345»Registered Invt. Movement LineNo. [PK]Line No. [PK]Source TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No.Source Line No.Source Subline No.Source Document; [,Sales Order,,,Sales...Location CodeShelf No.Sorting Sequence No.Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureDescriptionDescription 2QuantityQty. [Base]Shipping Advice; [Partial,Complete]Due DateDestination Type; [,Customer,Vendor,Lo...Destination No.Whse. Activity No.Shipping Agent CodeShipping Agent Service CodeShipment Method CodeSerial No.Lot No.Warranty DateExpiration Date...«Table 99000774»Family LineFamily No. [PK,NN]Line No. [PK]Item No. [NN]DescriptionDescription 2Unit of Measure CodeQuantityLow-Level Code«Table 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series<Routing No.><Source No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Destination No.><Family No.><Routing No.><Source No.><Whse. Document No.><Whse. Document No.><Source No.><Source No.><Source No.>

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

Fields

# Name Type
1 No. (No.) Code20 NotBlank: Yes
10 Description (Description) Text50
11 Description 2 (Description 2) Text50
12 Search Name (Search Name) Code50
13 Blocked (Blocked) Boolean
14 Last Date Modified (Last Date Modified) Date Editable: No
20 Routing No. (Routing No.) Code20

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Search Name (Search Name)

Table Relations To Other Tables

Field Related Table Related Field
Routing No. (Routing No.) Routing Header No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Family Line Family No. (Family No.) 1..n
Posted Invt. Pick Header Destination No. (Destination No.) 1..n
Posted Invt. Pick Line Destination No. (Destination No.) 1..n
Posted Invt. Put-away Header Destination No. (Destination No.) 1..n
Posted Invt. Put-away Line Destination No. (Destination No.) 1..n
Production Order Source No. (Source No.) 1..n
Registered Invt. Movement Hdr. Destination No. (Destination No.) 1..n
Registered Invt. Movement Line Destination No. (Destination No.) 1..n
Registered Whse. Activity Line Destination No. (Destination No.) 1..n
Warehouse Activity Header Destination No. (Destination No.) 1..n
Warehouse Activity Line Destination No. (Destination No.) 1..n
Warehouse Request Destination No. (Destination No.) 1..n