Diagrams


Table

Prod. Order Component

DynamicsDocs.comProd. Order Component«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 5416»Prod. Order Comp. Cmt LineProd. Order BOM Line No. [PK,NN]Line No. [PK]DateCommentCodeStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Prod. Order Line No. [PK,NN]«Table 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...«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 5406»Prod. Order LineStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Line No. [PK]Item No.Variant CodeDescriptionDescription 2Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeQuantityFinished QuantityRemaining QuantityScrap %Due DateStarting DateStarting TimeEnding DateEnding TimePlanning Level CodePriorityProduction BOM No.Routing No.Inventory Posting GroupRouting Reference No.Unit CostCost AmountReserved QuantityCapacity Type Filter; [Work Center,Mac...Capacity No. Filter...«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 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 99000777»Routing LinkCode [PK,NN]Description«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value IDIdLast Modified Date Time«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 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name<Prod. Order No.><Prod. Order Line No.><Supplied-by Line No.><Item No.><Original Item No.><Unit of Measure Code><Routing Link Code><Variant Code><Original Variant Code><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Bin Code><Dimension Set ID><Prod. Order BOM Line No.><Prod. Order Comp. Line No.><Prod. Order No.><Prod. Order Line No.><Item No.><Source No.><Originally Ordered No.><Location Code><New Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><New Shortcut Dimension 1 Code><New Shortcut Dimension 2 Code><Order No.><Order Line No.><Dimension Set ID><New Dimension Set ID><Variant Code><Originally Ordered Var. Code><Bin Code><New Bin Code><Unit of Measure Code><Source No.><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Location Code><Bin Code><Dimension Set ID><Prod. Order No.><Item No.><Variant Code><Location Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Bin Code><Unit of Measure Code><Dimension Set ID><Alternative Item No.><Global Dimension 1 Filter><Global Dimension 2 Filter><Global Dimension 1 Code><Global Dimension 2 Code><Location Filter><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><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><Dimension Value Code>

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 Prod. Order No. Code20
3 Prod. Order Line No. Integer
4 Line No. Integer
11 Item No. Code20
12 Description Text50
13 Unit of Measure Code Code10
14 Quantity Decimal (0:5) Editable: No
15 Position Code10
16 Position 2 Code10
17 Position 3 Code10
18 Lead-Time Offset DateFormula
19 Routing Link Code Code10
20 Scrap % Decimal (0:5)
21 Variant Code Code10
25 Expected Quantity Decimal (0:5) Editable: No
26 Remaining Quantity Decimal (0:5) Editable: No
27 Act. Consumption (Qty) Decimal (0:5) Editable: No
FlowField
28 Flushing Method Option
30 Location Code Code10
31 Shortcut Dimension 1 Code Code20
32 Shortcut Dimension 2 Code Code20
33 Bin Code Code20
35 Supplied-by Line No. Integer
36 Planning Level Code Integer Editable: No
37 Item Low-Level Code Integer
40 Length Decimal (0:5)
41 Width Decimal (0:5)
42 Weight Decimal (0:5)
43 Depth Decimal (0:5)
44 Calculation Formula Option
45 Quantity per Decimal (0:5)
50 Unit Cost Decimal (2:5)
51 Cost Amount Decimal Editable: No
52 Due Date Date
53 Due Time Time
60 Qty. per Unit of Measure Decimal (0:5) Editable: No
61 Remaining Qty. (Base) Decimal (0:5) Editable: No
62 Quantity (Base) Decimal (0:5)
63 Reserved Qty. (Base) Decimal (0:5) Editable: Yes
FlowField
71 Reserved Quantity Decimal (0:5) Editable: No
FlowField
73 Expected Qty. (Base) Decimal (0:5) Editable: No
76 Due Date-Time DateTime
480 Dimension Set ID Integer Editable: No
5702 Substitution Available Boolean Editable: No
FlowField
5703 Original Item No. Code20 Editable: No
5704 Original Variant Code Code10 Editable: No
5750 Pick Qty. Decimal (0:5) Editable: No
FlowField
7300 Qty. Picked Decimal (0:5) Editable: No
7301 Qty. Picked (Base) Decimal (0:5) Editable: No
7302 Completely Picked Boolean Editable: No
7303 Pick Qty. (Base) Decimal (0:5) Editable: No
FlowField
99000754 Direct Unit Cost Decimal (2:5)
99000755 Indirect Cost % Decimal (0:5)
99000756 Overhead Rate Decimal (0:5)
99000757 Direct Cost Amount Decimal (2:2)
99000758 Overhead Amount Decimal (2:2)

Keys

# Fields
0 Status,Prod. Order No.,Prod. Order Line No.,Line No. Clustered: Yes
1 Prod. Order No.,Prod. Order Line No.,Line No.,Status
2 Status,Prod. Order No.,Prod. Order Line No.,Due Date
3 Status,Prod. Order No.,Prod. Order Line No.,Item No.,Line No. MaintainSQLIndex: No
4 Status,Item No.,Variant Code,Location Code,Due Date
5 Item No.,Variant Code,Location Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Due Date
6 Status,Prod. Order No.,Routing Link Code,Flushing Method
7 Status,Prod. Order No.,Location Code
8 Item No.,Variant Code,Location Code,Status,Due Date MaintainSIFTIndex: No
9 Status,Prod. Order No.,Prod. Order Line No.,Item Low-Level Code MaintainSQLIndex: 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
Original Item No. Item No. 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Original Variant Code Item Variant Code 1..n
Location Code Location 1..n
Supplied-by Line No. Prod. Order Line Line No. 1..n
Prod. Order No. Production Order No. 1..n
Routing Link Code Routing Link Code 1..n

Table Relations From Other Tables

From Table From Field
Item Journal Line Prod. Order Comp. Line No. 1..n
Prod. Order Comp. Cmt Line Prod. Order BOM Line No. 1..n