Diagrams


Table

Production BOM Header

DynamicsDocs.comProduction BOM Header«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 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 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 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 5870»BOM BufferEntry No. [PK]Type; [,Item,Machine Center,Work Cente...No.DescriptionUnit of Measure CodeVariant CodeLocation CodeReplenishment System; [Purchase,Prod....IndentationIs LeafBottleneckRouting No.Production BOM No.Lot SizeLow-Level CodeRounding PrecisionQty. per ParentQty. per Top ItemAble to Make Top ItemAble to Make ParentAvailable QuantityGross RequirementScheduled ReceiptsUnused QuantityLead Time CalculationLead-Time OffsetRolled-up Lead-Time OffsetNeeded by DateSafety Lead TimeUnit CostIndirect Cost %...«Table 99000770»Manufacturing Comment LineTable Name; [Work Center,Machine Cente...No. [PK,NN]Line No. [PK]DateCodeComment«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 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 99000790»Where-Used LineEntry No. [PK]Item No.Version CodeDescriptionQuantity NeededLevel CodeProduction BOM No.«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order<Unit of Measure Code><Version Nos.><No. Series><Production BOM No.><Production BOM No.><Production BOM No.><Production BOM No.><No.><Production BOM No.><No.><Production BOM No.><Production BOM No.><Production BOM No.><No.><Original Item No.><Unit of Measure Code><Prod. Order Line No.><Production BOM Version Code><No. Series><Alternative Item No.><No. Series><Serial Nos.><Lot Nos.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Unit of Measure Id><Item No.><No.><No.><Item No.><Production BOM Version Code><Version Code><Unit of Measure Code><BOM Line No.><Version Code><Unit of Measure Code><No. Series>

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

Fields

# Name Type
1 No. Code20
10 Description Text50
11 Description 2 Text50
12 Search Name Code50
21 Unit of Measure Code Code10
22 Low-Level Code Integer Editable: No
25 Comment Boolean Editable: No
FlowField
40 Creation Date Date Editable: No
43 Last Date Modified Date Editable: No
45 Status Option
50 Version Nos. Code20
51 No. Series Code20 Editable: No

Keys

# Fields
0 No. Clustered: Yes
1 Search Name
2 Description
3 Status

Table Relations To Other Tables

Field Related Table Related Field
No. Series No. Series Code 1..n
Unit of Measure Code Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field
BOM Buffer Production BOM No. 1..n
Item Production BOM No. 1..n
Manufacturing Comment Line No. 1..n
Prod. Order Line Production BOM No. 1..n
Production BOM Comment Line Production BOM No. 1..n
Production BOM Line No. 1..n
Production BOM Version Production BOM No. 1..n
Requisition Line Production BOM No. 1..n
Where-Used Line Production BOM No. 1..n