Diagrams

Table

Production Order

DynamicsDocs.comProduction Order«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 5407»Prod. Order ComponentStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Prod. Order Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityRemaining QuantityAct. Consumption [Qty]Flushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeItem Low-Level CodeLengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 5411»Prod. Order Routing ToolRouting No. [PK,NN]Line No. [PK]No.DescriptionOperation No. [PK]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 5412»Prod. Order Routing PersonnelRouting No. [PK,NN]Line No. [PK]No.DescriptionOperation No. [PK,NN]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«Table 5413»Prod. Order Rtng Qlty Meas.Routing No. [PK,NN]Line No. [PK]Qlty Measure CodeDescriptionMin. ValueMax. ValueMean ToleranceOperation No. [PK,NN]Status; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Routing Reference No. [PK]«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 7325»Whse. Pick RequestDocument Type; [Shipment,Internal Pick...Document Subtype; [0,1,2,3,4,5,6,7,8,9...Document No. [PK,NN]Location Code [PK]Zone CodeBin CodeStatus; [Open,Released]Completely PickedShipment Method CodeShipping Agent CodeShipping Agent Service Code«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 99000773»FamilyNo. [PK,NN]DescriptionDescription 2Search NameBlockedLast Date ModifiedRouting No.«Table 94»Inventory Posting GroupCode [PK,NN]Description«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«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 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 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Source No.><Source No.><Inventory Posting Group><Gen. Prod. Posting Group><Gen. Bus. Posting Group><Location Code><Bin Code><Work Center Filter><Capacity No. Filter><Capacity No. Filter><Assigned User ID><Prod. Order No.><Prod. Order No.><Prod. Order No.><Prod. Order No.><Source No.><Document No.><Item No.><Original Item No.><Location Code><Bin Code><Location Code><Destination No.><Destination No.><Destination No.><Location Code><Bin Code><Inventory Posting Group><Alternative Item No.><Location Filter><Gen. Prod. Posting Group><Bin Filter><Item Filter><Item Filter><Gen. Prod. Posting Group><Gen. Prod. Posting Group><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 Code><Location Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Alternate Work Center><Work Center No.><Approver ID><Substitute>

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

Fields

# Name Type
1 Status (Status) Option
2 No. (No.) Code20
3 Description (Description) Text50
4 Search Description (Search Description) Code50
5 Description 2 (Description 2) Text50
6 Creation Date (Creation Date) Date Editable: No
7 Last Date Modified (Last Date Modified) Date Editable: No
9 Source Type (Source Type) Option
10 Source No. (Source No.) Code20
11 Routing No. (Routing No.) Code20
15 Inventory Posting Group (Inventory Posting Group) Code10
16 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
17 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
19 Comment (Comment) Boolean Editable: No
FlowField
20 Starting Time (Starting Time) Time
21 Starting Date (Starting Date) Date
22 Ending Time (Ending Time) Time
23 Ending Date (Ending Date) Date
24 Due Date (Due Date) Date
25 Finished Date (Finished Date) Date Editable: No
28 Blocked (Blocked) Boolean
30 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
31 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
32 Location Code (Location Code) Code10
33 Bin Code (Bin Code) Code20
34 Replan Ref. No. (Replan Ref. No.) Code20 Editable: No
35 Replan Ref. Status (Replan Ref. Status) Option Editable: No
38 Low-Level Code (Low-Level Code) Integer Editable: No
40 Quantity (Quantity) Decimal (0:5)
41 Unit Cost (Unit Cost) Decimal (2:5)
42 Cost Amount (Cost Amount) Decimal (2:2)
47 Work Center Filter (Work Center Filter) Code20 FlowFilter
48 Capacity Type Filter (Capacity Type Filter) Option FlowFilter
49 Capacity No. Filter (Capacity No. Filter) Code20 FlowFilter
50 Date Filter (Date Filter) Date FlowFilter
51 Expected Operation Cost Amt. (Expected Operation Cost Amt.) Decimal Editable: No
FlowField
52 Expected Component Cost Amt. (Expected Component Cost Amt.) Decimal Editable: No
FlowField
55 Actual Time Used (Actual Time Used) Decimal (0:5) Editable: No
FlowField
56 Allocated Capacity Need (Allocated Capacity Need) Decimal (0:5) Editable: No
FlowField
57 Expected Capacity Need (Expected Capacity Need) Decimal (0:5) Editable: No
FlowField
80 No. Series (No. Series) Code10 Editable: No
82 Planned Order No. (Planned Order No.) Code20
83 Firm Planned Order No. (Firm Planned Order No.) Code20
85 Simulated Order No. (Simulated Order No.) Code20
92 Expected Material Ovhd. Cost (Expected Material Ovhd. Cost) Decimal (2:2) Editable: No
FlowField
94 Expected Capacity Ovhd. Cost (Expected Capacity Ovhd. Cost) Decimal Editable: No
FlowField
98 Starting Date-Time (Starting Date-Time) DateTime
99 Ending Date-Time (Ending Date-Time) DateTime
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
7300 Completely Picked (Completely Picked) Boolean FlowField
9000 Assigned User ID (Assigned User ID) Code50

Keys

# Fields
0 Status,No. (Status,No.) Clustered: Yes
1 No.,Status (No.,Status)
2 Search Description (Search Description)
3 Low-Level Code,Replan Ref. No.,Replan Ref. Status (Low-Level Code,Replan Ref. No.,Replan Ref. Status)
4 Source Type,Source No. (Source Type,Source No.)
5 Description (Description)
6 Source No. (Source No.)

Table Relations To Other Tables

Field Related Table Related Field
Bin Code (Bin Code) Bin Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value Code (Code) 1..n
Source No. (Source No.) Family No. (No.) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Gen. Prod. Posting Group (Gen. Prod. Posting Group) Gen. Product Posting Group Code (Code) 1..n
Inventory Posting Group (Inventory Posting Group) Inventory Posting Group Code (Code) 1..n
Source No. (Source No.) Item () 1..n
Location Code (Location Code) Location () 1..n
Capacity No. Filter (Capacity No. Filter) Machine Center No. (No.) 1..n
No. Series (No. Series) No. Series Code (Code) 1..n
Routing No. (Routing No.) Routing Header No. (No.) 1..n
Source No. (Source No.) Sales Header No. (No.) 1..n
Assigned User ID (Assigned User ID) User Setup User ID (User ID) 1..n
Capacity No. Filter (Capacity No. Filter) Work Center No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Capacity Ledger Entry Order No. (Order No.) 1..n
Item Journal Line Order No. (Order No.) 1..n
Posted Invt. Pick Header Source No. (Source No.) 1..n
Posted Invt. Put-away Header Source No. (Source No.) 1..n
Prod. Order Comment Line Prod. Order No. (Prod. Order No.) 1..n
Prod. Order Comp. Cmt Line Prod. Order No. (Prod. Order No.) 1..n
Prod. Order Component Prod. Order No. (Prod. Order No.) 1..n
Prod. Order Line Prod. Order No. (Prod. Order No.) 1..n
Prod. Order Routing Line Prod. Order No. (Prod. Order No.) 1..n
Prod. Order Routing Personnel Prod. Order No. (Prod. Order No.) 1..n
Prod. Order Routing Tool Prod. Order No. (Prod. Order No.) 1..n
Prod. Order Rtng Comment Line Prod. Order No. (Prod. Order No.) 1..n
Prod. Order Rtng Qlty Meas. Prod. Order No. (Prod. Order No.) 1..n
Registered Invt. Movement Hdr. Source No. (Source No.) 1..n
Registered Whse. Activity Line Whse. Document No. (Whse. Document No.) 1..n
Warehouse Activity Line Whse. Document No. (Whse. Document No.) 1..n
Warehouse Request Source No. (Source No.) 1..n
Whse. Pick Request Document No. (Document No.) 1..n
Whse. Worksheet Line Whse. Document No. (Whse. Document No.) 1..n