Diagrams

Table

Item Unit of Measure

DynamicsDocs.comItem Unit of Measure«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 1013»Job Item PriceJob No. [PK,NN]Job Task No. [PK]Item No. [PK]Unit of Measure Code [PK]Unit PriceCurrency Code [PK]Unit Cost FactorLine Discount %DescriptionVariant Code [PK]Apply Job PriceApply Job Discount«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 5407»Prod. Order ComponentStatus; [Simulated,Planned,Firm Planne...Prod. Order No. [PK]Prod. Order Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityRemaining QuantityAct. Consumption [Qty]Flushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeItem Low-Level CodeLengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 5520»Unplanned DemandDemand Type; [,Production,Sales,Servic...Demand SubType; [0,1,2,3,4,5,6,7,8,9]...Demand Order No. [PK]Demand Line No. [PK]Demand Ref. No. [PK]Sell-to Customer No.DescriptionDemand DateStatus; [0,1,2,3,4,5,6,7,8,9,10]Item No.Variant CodeLocation CodeQuantity [Base]LevelBin CodeQty. per Unit of MeasureUnit of Measure CodeReserveNeeded Qty. [Base]Special OrderPurchasing Code«Table 5700»Stockkeeping UnitItem No. [PK,NN]Variant Code [PK]Location Code [PK]DescriptionDescription 2Assembly BOMShelf No.Unit CostStandard CostLast Direct CostVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder QuantityCommentLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterInventoryQty. on Purch. OrderQty. on Sales OrderDrop Shipment FilterAssembly Policy; [Assemble-to-Stock,As...Qty. on Assembly OrderQty. on Asm. ComponentQty. on Job OrderTransfer-Level CodeLot Size...«Table 5717»Item Cross ReferenceItem No. [PK]Variant Code [PK]Unit of Measure [PK]Cross-Reference Type; [,Customer,Vendo...Cross-Reference Type No. [PK]Cross-Reference No. [PK,NN]DescriptionDiscontinue Bar Code«Table 5768»Whse. Cross-Dock OpportunitySource Template Name [PK]Source Name/No. [PK]Source Line No. [PK]Line No. [PK]From Source TypeFrom Source Subtype; [0,1,2,3,4,5,6,7,...From Source No.From Source Line No.From Source Subline No.From Source Document; [,Sales Order,Sa...To Source TypeTo Source Subtype; [0,1,2,3,4,5,6,7,8,...To Source No.To Source Line No.To Source Subline No.To Source Document; [,Sales Order,,,,,...Item No.Variant CodeUnit of Measure CodeQty. per Unit of MeasureLocation CodeQty. NeededQty. Needed [Base]Qty. to Cross-DockQty. to Cross-Dock [Base]Qty. Cross-Docked [Base]Total Qty. Needed [Base]Reserved QuantityReserved Qty. [Base]To-Src. Unit of Measure CodeTo-Src. Qty. per Unit of Meas....«Table 5913»LoanerNo. [PK]DescriptionDescription 2Unit of Measure CodeItem No.Last Date ModifiedCommentBlockedNo. SeriesDocument No.LentSerial No.Document Type; [,Quote,Order]«Table 5940»Service ItemNo. [PK]Serial No.Service Item Group CodeDescriptionDescription 2Status; [,Own Service Item,Installed,T...Priority; [Low,Medium,High]Customer No.Ship-to CodeItem No.Unit of Measure CodeLocation of Service ItemSales Unit PriceSales Unit CostWarranty Starting Date [Labor]Warranty Ending Date [Labor]Warranty Starting Date [Parts]Warranty Ending Date [Parts]Warranty % [Parts]Warranty % [Labor]Response Time [Hours]Installation DateSales DateLast Service DateDefault Contract ValueDefault Contract Discount %No. of Active ContractsVendor No.Vendor Item No.No. SeriesItem Description...«Table 7002»Sales PriceItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending DateUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 7012»Purchase PriceItem No. [PK,NN]Vendor No. [PK,NN]Currency Code [PK]Starting Date [PK]Direct Unit CostMinimum Quantity [PK]Ending DateUnit of Measure Code [PK]Variant Code [PK]«Table 7023»Sales Price WorksheetItem No. [PK,NN]Sales Code [PK]Currency Code [PK]Starting Date [PK]Current Unit PriceNew Unit PricePrice Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]Sales Type; [Customer,Customer Price G...Minimum Quantity [PK]Ending Date [PK]Item DescriptionSales DescriptionUnit of Measure Code [PK]Variant Code [PK]Allow Line Disc.«Table 7302»Bin ContentLocation Code [PK,NN]Zone Code [NN]Bin Code [PK,NN]Item No. [PK,NN]Bin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Min. Qty.Max. Qty.Bin RankingQuantityPick Qty.Neg. Adjmt. Qty.Put-away Qty.Pos. Adjmt. Qty.FixedCross-Dock BinDefaultQuantity [Base]Pick Quantity [Base]Negative Adjmt. Qty. [Base]Put-away Quantity [Base]Positive Adjmt. Qty. [Base]ATO Components Pick Qty.ATO Components Pick Qty [Base]Variant Code [PK]Qty. per Unit of MeasureUnit of Measure Code [PK,NN]Lot No. FilterSerial No. FilterDedicated...«Table 7704»Item IdentifierCode [PK,NN]Item No.Variant CodeUnit of Measure Code«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 99000829»Planning ComponentWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [PK]Line No. [PK]Item No.DescriptionUnit of Measure CodeQuantityPositionPosition 2Position 3Lead-Time OffsetRouting Link CodeScrap %Variant CodeExpected QuantityFlushing Method; [Manual,Forward,Backw...Location CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeBin CodeSupplied-by Line No.Planning Level CodeRef. Order Status; [Simulated,Planned,...Ref. Order No.Ref. Order Line No.LengthWidthWeightDepthCalculation Formula; [,Length,Length *......«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId<Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Put-away Unit of Measure Code><Unit of Measure><Unit of Measure Code><To-Src. Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Unit of Measure Filter><Unit of Measure Code><Unit of Measure Code><Unit of Measure Code><Item No.><Alternative Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Unit of Measure Id><Item No.><Original Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Parent Item No.><No.><Installed in Item No.><Item No.><Unit of Measure Code><Unit of Measure Code>

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

Fields

# Name Type
1 Item No. (Item No.) Code20 NotBlank: Yes
2 Code (Code) Code10 NotBlank: Yes
3 Qty. per Unit of Measure (Qty. per Unit of Measure) Decimal (0:5)
7300 Length (Length) Decimal (0:5)
7301 Width (Width) Decimal (0:5)
7302 Height (Height) Decimal (0:5)
7303 Cubage (Cubage) Decimal (0:5)
7304 Weight (Weight) Decimal (0:5)

Keys

# Fields
0 Item No.,Code (Item No.,Code) Clustered: Yes
1 Item No.,Qty. per Unit of Measure (Item No.,Qty. per Unit of Measure)
2 Code (Code)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Code (Code) Unit of Measure Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Assembly Header Unit of Measure Code (Unit of Measure Code) 1..n
Assembly Line Unit of Measure Code (Unit of Measure Code) 1..n
BOM Buffer BOM Unit of Measure Code (BOM Unit of Measure Code) 1..n
BOM Component Unit of Measure Code (Unit of Measure Code) 1..n
Bin Content Unit of Measure Filter (Unit of Measure Filter) 1..n
Bin Content Buffer Base Unit of Measure (Base Unit of Measure) 1..n
Bin Creation Worksheet Line Unit of Measure Code (Unit of Measure Code) 1..n
Capacity Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Family Line Unit of Measure Code (Unit of Measure Code) 1..n
Filed Contract Line Unit of Measure Code (Unit of Measure Code) 1..n
Item Put-away Unit of Measure Code (Put-away Unit of Measure Code) 1..n
Item Cross Reference Unit of Measure (Unit of Measure) 1..n
Item Identifier Unit of Measure Code (Unit of Measure Code) 1..n
Item Journal Line Unit of Measure Code (Unit of Measure Code) 1..n
Item Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Job Item Price Unit of Measure Code (Unit of Measure Code) 1..n
Job Journal Line Unit of Measure Code (Unit of Measure Code) 1..n
Job Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Job Planning Line Unit of Measure Code (Unit of Measure Code) 1..n
Loaner Unit of Measure Code (Unit of Measure Code) 1..n
Order Promising Line Unit of Measure Code (Unit of Measure Code) 1..n
Phys. Inventory Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Planning Component Unit of Measure Code (Unit of Measure Code) 1..n
Posted Assembly Header Unit of Measure Code (Unit of Measure Code) 1..n
Posted Assembly Line Unit of Measure Code (Unit of Measure Code) 1..n
Posted Invt. Pick Line Unit of Measure Code (Unit of Measure Code) 1..n
Posted Invt. Put-away Line Unit of Measure Code (Unit of Measure Code) 1..n
Posted Whse. Receipt Line Unit of Measure Code (Unit of Measure Code) 1..n
Posted Whse. Shipment Line Unit of Measure Code (Unit of Measure Code) 1..n
Prod. Order Component Unit of Measure Code (Unit of Measure Code) 1..n
Prod. Order Line Unit of Measure Code (Unit of Measure Code) 1..n
Production BOM Line Unit of Measure Code (Unit of Measure Code) 1..n
Production Forecast Entry Unit of Measure Code (Unit of Measure Code) 1..n
Production Matrix BOM Line Unit of Measure Code (Unit of Measure Code) 1..n
Purch. Cr. Memo Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Purch. Inv. Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Purch. Inv. Line Aggregate Unit of Measure Code (Unit of Measure Code) 1..n
Purch. Price Line Disc. Buff. Unit of Measure Code (Unit of Measure Code) 1..n
Purch. Rcpt. Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Purchase Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Purchase Line Archive Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Purchase Line Discount Unit of Measure Code (Unit of Measure Code) 1..n
Purchase Price Unit of Measure Code (Unit of Measure Code) 1..n
Registered Invt. Movement Line Unit of Measure Code (Unit of Measure Code) 1..n
Registered Whse. Activity Line Unit of Measure Code (Unit of Measure Code) 1..n
Requisition Line Unit Of Measure Code (Demand) (Unit Of Measure Code (Demand)) 1..n
Return Receipt Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Return Shipment Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Sales Cr.Memo Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Sales Invoice Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Sales Invoice Line Aggregate Unit of Measure Code (Unit of Measure Code) 1..n
Sales Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Sales Line Archive Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Sales Line Discount Unit of Measure Code (Unit of Measure Code) 1..n
Sales Price Unit of Measure Code (Unit of Measure Code) 1..n
Sales Price Worksheet Unit of Measure Code (Unit of Measure Code) 1..n
Sales Price and Line Disc Buff Unit of Measure Code (Unit of Measure Code) 1..n
Sales Shipment Line Unit of Measure (Cross Ref.) (Unit of Measure (Cross Ref.)) 1..n
Service Contract Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Cr.Memo Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Invoice Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Item Unit of Measure Code (Unit of Measure Code) 1..n
Service Line Unit of Measure Code (Unit of Measure Code) 1..n
Service Shipment Line Unit of Measure Code (Unit of Measure Code) 1..n
Standard Item Journal Line Unit of Measure Code (Unit of Measure Code) 1..n
Standard Purchase Line Unit of Measure Code (Unit of Measure Code) 1..n
Standard Sales Line Unit of Measure Code (Unit of Measure Code) 1..n
Standard Service Line Unit of Measure Code (Unit of Measure Code) 1..n
Stockkeeping Unit Put-away Unit of Measure Code (Put-away Unit of Measure Code) 1..n
Transfer Line Unit of Measure Code (Unit of Measure Code) 1..n
Transfer Receipt Line Unit of Measure Code (Unit of Measure Code) 1..n
Transfer Shipment Line Unit of Measure Code (Unit of Measure Code) 1..n
Unplanned Demand Unit of Measure Code (Unit of Measure Code) 1..n
Warehouse Activity Line Unit of Measure Code (Unit of Measure Code) 1..n
Warehouse Entry Unit of Measure Code (Unit of Measure Code) 1..n
Warehouse Journal Line Unit of Measure Code (Unit of Measure Code) 1..n
Warehouse Receipt Line Unit of Measure Code (Unit of Measure Code) 1..n
Warehouse Shipment Line Unit of Measure Code (Unit of Measure Code) 1..n
Warranty Ledger Entry Unit of Measure Code (Unit of Measure Code) 1..n
Whse. Cross-Dock Opportunity To-Src. Unit of Measure Code (To-Src. Unit of Measure Code) 1..n
Whse. Internal Pick Line Unit of Measure Code (Unit of Measure Code) 1..n
Whse. Worksheet Line Unit of Measure Code (Unit of Measure Code) 1..n