Diagrams

Table

Production BOM Version

DynamicsDocs.comProduction BOM Version«Table 99000779»Production BOM VersionProduction BOM No. [PK,NN]Version Code [PK]DescriptionStarting DateUnit of Measure CodeLast Date ModifiedStatus; [New,Certified,Under Developme...No. Series«Table 246»Requisition LineWorksheet Template Name [PK]Journal Batch Name [PK]Line No. [PK]Type; [,G/L Account,Item]No.DescriptionDescription 2QuantityVendor No.Direct Unit CostDue DateRequester IDConfirmedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyOrder DateVendor Item No.Sales Order No.Sales Order Line No.Sell-to Customer No.Ship-to CodeOrder Address CodeCurrency CodeCurrency FactorReserved QuantityDimension Set IDProd. Order No....«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 99000772»Production BOM LineProduction BOM No. [PK,NN]Line No. [PK]Version Code [PK]Type; [,Item,Production BOM]No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeCommentStarting DateEnding DateLengthWidthWeightDepthCalculation Formula; [,Length,Length *...Quantity per«Table 99000776»Production BOM Comment LineProduction BOM No. [PK,NN]BOM Line No. [PK,NN]Line No. [PK]Version Code [PK]DateCommentCode«Table 99000771»Production BOM HeaderNo. [PK]DescriptionDescription 2Search NameUnit of Measure CodeLow-Level CodeCommentCreation DateLast Date ModifiedStatus; [New,Certified,Under Developme...Version Nos.No. Series«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard Code«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Production BOM No.><Unit of Measure Code><No. Series><Production BOM Version Code><Production BOM Version Code><Version Code><Version Code><Unit of Measure Code><Prod. Order Line No.><Production BOM No.><No. Series><Production BOM No.><Production BOM No.><No.><Unit of Measure Code><BOM Line No.><Production BOM No.><Unit of Measure Code><Version Nos.><No. Series>

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

Fields

# Name Type
1 Production BOM No. (Production BOM No.) Code20 NotBlank: Yes
2 Version Code (Version Code) Code20
3 Description (Description) Text50
10 Starting Date (Starting Date) Date
21 Unit of Measure Code (Unit of Measure Code) Code10
22 Last Date Modified (Last Date Modified) Date Editable: No
45 Status (Status) Option
50 No. Series (No. Series) Code10 Editable: No

Keys

# Fields
0 Production BOM No.,Version Code (Production BOM No.,Version Code) Clustered: Yes
1 Production BOM No.,Starting Date (Production BOM No.,Starting Date)

Table Relations To Other Tables

Field Related Table Related Field
No. Series (No. Series) No. Series Code (Code) 1..n
Production BOM No. (Production BOM No.) Production BOM Header No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Prod. Order Line Production BOM Version Code (Production BOM Version Code) 1..n
Production BOM Comment Line Version Code (Version Code) 1..n
Production BOM Line Version Code (Version Code) 1..n
Requisition Line Production BOM Version Code (Production BOM Version Code) 1..n