Diagrams

Table

Prod. Order Comment Line

DynamicsDocs.comProd. Order Comment Line«Table 5414»Prod. Order Comment LineStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK,NN]Line No. [PK]DateCodeComment«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...<Prod. Order No.>

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 Prod. Order No. (Prod. Order No.) Code20 NotBlank: Yes
3 Line No. (Line No.) Integer
4 Date (Date) Date
5 Code (Code) Code10
6 Comment (Comment) Text80

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field