Diagrams


Table

BOM Component

DynamicsDocs.comBOM Component«Table 90»BOM ComponentParent Item No. [PK,NN]Line No. [PK]Type; [,Item,Resource]No.Assembly BOMDescriptionUnit of Measure CodeQuantity perPositionPosition 2Position 3Machine No.Lead-Time OffsetBOM DescriptionResource Usage Type; [Direct,Fixed]Variant CodeInstalled in Line No.Installed in Item 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 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<Parent Item No.><No.><Installed in Item No.><No.><Unit of Measure Code><Unit of Measure Code><Variant Code><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Resource No.>

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

Fields

# Name Type
1 Parent Item No. Code20 NotBlank: Yes
2 Line No. Integer
3 Type Option
4 No. Code20
5 Assembly BOM Boolean Editable: No
FlowField
6 Description Text50
7 Unit of Measure Code Code10
8 Quantity per Decimal (0:5)
9 Position Code10
10 Position 2 Code10
11 Position 3 Code10
12 Machine No. Code10
13 Lead-Time Offset DateFormula
14 BOM Description Text50 Editable: No
FlowField
20 Resource Usage Type Option
5402 Variant Code Code10
5900 Installed in Line No. Integer
5901 Installed in Item No. Code20

Keys

# Fields
0 Parent Item No.,Line No. Clustered: Yes
1 Type,No.

Table Relations To Other Tables

Field Related Table Related Field
Installed in Item No. Item No. 1..n
Unit of Measure Code Item Unit of Measure Code 1..n
Variant Code Item Variant Code 1..n
No. Resource No. 1..n
Unit of Measure Code Resource Unit of Measure Code 1..n

Table Relations From Other Tables

From Table From Field