Diagrams


Table

BOM Buffer

DynamicsDocs.comBOM Buffer«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 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 99000758»Machine CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeWork Center No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyBlockedDate FilterWork Shift FilterCapacity [Total]Capacity [Effective]Prod. Order Need [Qty.]Prod. Order Need AmountProd. Order Status Filter; [Simulated,...Setup TimeWait TimeMove Time...«Table 99000754»Work CenterNo. [PK]NameSearch NameName 2AddressAddress 2CityPost CodeAlternate Work CenterWork Center Group CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeSubcontractor No.Direct Unit CostIndirect Cost %Unit CostQueue TimeQueue Time Unit of Meas. CodeLast Date ModifiedCommentUnit of Measure CodeCapacityEfficiencyMaximum EfficiencyMinimum EfficiencyCalendar Rounding Precision [NN]Simulation Type; [Moves,Moves When Nec...Shop Calendar CodeBlockedDate FilterWork Shift Filter...«Table 156»ResourceNo. [PK]Type; [Person,Machine]NameSearch NameName 2AddressAddress 2CitySocial Security No.Job TitleEducationContract ClassEmployment DateResource Group No.Global Dimension 1 CodeGlobal Dimension 2 CodeBase Unit of MeasureDirect Unit CostIndirect Cost %Unit CostProfit %Price/Profit Calculation; [Profit=Pric...Unit PriceVendor No.Last Date ModifiedCommentBlockedDate FilterUnit of Measure FilterCapacityQty. on Order [Job]...«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 205»Resource Unit of MeasureResource No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureRelated to Base Unit of Meas.«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 99000763»Routing HeaderNo. [PK]DescriptionDescription 2Search DescriptionLast Date ModifiedCommentStatus; [New,Certified,Under Developme...Type; [Serial,Parallel]Version Nos.No. Series«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<No.><No.><No.><No.><Unit of Measure Code><BOM Unit of Measure Code><Unit of Measure Code><BOM Unit of Measure Code><Variant Code><Location Code><Routing No.><Production BOM No.><Alternative Item No.><Location Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Routing No.><Production BOM No.><Item Filter><Work Center No.><Location Code><Alternate Work Center><Location Code><Resource No.>

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

Fields

# Name Type
1 Entry No. Integer AutoIncrement: Yes
2 Type Option
3 No. Code20
5 Description Text50
6 Unit of Measure Code Code10
7 Variant Code Code10
8 Location Code Code10
9 Replenishment System Option
10 Indentation Integer
11 Is Leaf Boolean
13 Bottleneck Boolean
15 Routing No. Code20
16 Production BOM No. Code20
20 Lot Size Decimal (0:5)
21 Low-Level Code Integer Editable: No
22 Rounding Precision Decimal (0:5)
30 Qty. per Parent Decimal (0:5)
31 Qty. per Top Item Decimal (0:5)
32 Able to Make Top Item Decimal (0:5)
33 Able to Make Parent Decimal (0:5)
35 Available Quantity Decimal (0:5)
36 Gross Requirement Decimal (0:5)
37 Scheduled Receipts Decimal (0:5)
38 Unused Quantity Decimal (0:5)
40 Lead Time Calculation DateFormula
41 Lead-Time Offset DateFormula
42 Rolled-up Lead-Time Offset Integer
43 Needed by Date Date
45 Safety Lead Time DateFormula
50 Unit Cost Decimal
52 Indirect Cost % Decimal (0:5)
54 Overhead Rate Decimal
55 Scrap % Decimal BlankZero: Yes
56 Scrap Qty. per Parent Decimal (0:5)
57 Scrap Qty. per Top Item Decimal (0:5)
59 Resource Usage Type Option
61 Single-Level Material Cost Decimal (2:5) BlankZero: Yes
62 Single-Level Capacity Cost Decimal (2:5) BlankZero: Yes
63 Single-Level Subcontrd. Cost Decimal (2:5) BlankZero: Yes
64 Single-Level Cap. Ovhd Cost Decimal (2:5) BlankZero: Yes
65 Single-Level Mfg. Ovhd Cost Decimal (2:5) BlankZero: Yes
66 Single-Level Scrap Cost Decimal (2:5) BlankZero: Yes
71 Rolled-up Material Cost Decimal (2:5) BlankZero: Yes
Editable: No
72 Rolled-up Capacity Cost Decimal (2:5) BlankZero: Yes
Editable: No
73 Rolled-up Subcontracted Cost Decimal BlankZero: Yes
Editable: No
74 Rolled-up Capacity Ovhd. Cost Decimal BlankZero: Yes
Editable: No
75 Rolled-up Mfg. Ovhd Cost Decimal BlankZero: Yes
Editable: No
76 Rolled-up Scrap Cost Decimal (2:5) BlankZero: Yes
81 Total Cost Decimal (2:5) BlankZero: Yes
82 BOM Unit of Measure Code Code10
83 Qty. per BOM Line Decimal (0:5)

Keys

# Fields
0 Entry No. Clustered: Yes
1 Low-Level Code
2 Type,No.,Indentation
3 Total Cost

Table Relations To Other Tables

Field Related Table Related Field
No. Item No. 1..n
BOM Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
Location Code Location Code 1..n
No. Machine Center No. 1..n
Production BOM No. Production BOM Header No. 1..n
No. Resource No. 1..n
BOM Unit of Measure Code Resource Unit of Measure Code 1..n
Routing No. Routing Header No. 1..n
No. Work Center No. 1..n

Table Relations From Other Tables

From Table From Field