Diagrams

Table

Prod. Order Comp. Cmt Line

DynamicsDocs.comProd. Order Comp. Cmt Line«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 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 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...<Prod. Order BOM Line No.><Prod. Order No.><Prod. Order Line No.><Prod. Order No.><Prod. Order Line No.><Supplied-by Line No.><Prod. Order No.>

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

Fields

# Name Type
2 Prod. Order BOM Line No. (Prod. Order BOM Line No.) Integer NotBlank: Yes
3 Line No. (Line No.) Integer
10 Date (Date) Date
12 Comment (Comment) Text80
13 Code (Code) Code10
22 Status (Status) Option
23 Prod. Order No. (Prod. Order No.) Code20 NotBlank: Yes
24 Prod. Order Line No. (Prod. Order Line No.) Integer NotBlank: Yes

Keys

# Fields
0 Status,Prod. Order No.,Prod. Order Line No.,Prod. Order BOM Line No.,Line No. (Status,Prod. Order No.,Prod. Order Line No.,Prod. Order BOM Line No.,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Prod. Order BOM Line No. (Prod. Order BOM Line No.) Prod. Order Component Line No. (Line No.) 1..n
Prod. Order Line No. (Prod. Order Line No.) Prod. Order Line Line No. (Line No.) 1..n
Prod. Order No. (Prod. Order No.) Production Order No. (No.) 1..n

Table Relations From Other Tables

From Table From Field