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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

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