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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field