Diagrams


Table

Item Variant

DynamicsDocs.comItem Variant«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«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 30»Item TranslationItem No. [PK,NN]Language Code [PK,NN]DescriptionDescription 2Variant Code [PK]«Table 336»Tracking SpecificationEntry No. [PK]Item No.Location CodeQuantity [Base]DescriptionCreation DateSource TypeSource Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source IDSource Batch NameSource Prod. Order LineSource Ref. No.Item Ledger Entry No.Transfer Item Entry No.Serial No.PositiveQty. per Unit of MeasureAppl.-to Item EntryWarranty DateExpiration DateQty. to Handle [Base]Qty. to Invoice [Base]Quantity Handled [Base]Quantity Invoiced [Base]Qty. to HandleQty. to InvoiceBuffer Status; [,MODIFY,INSERT]Buffer Status2; [,ExpDate blocked]Buffer Value1Buffer Value2Buffer Value3...«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 5531»Inventory Page DataCodeLine No. [PK]Period Type; [Day,Week,Month,Quarter,Y...Period StartPeriod EndPeriod No.LevelSource Line IDItem No.Variant CodeLocation CodeDescriptionAvailability DateType; [,Purchase,Sale,Purch. Return,Sa...Document No.SourceRemaining Quantity [Base]PositiveGross RequirementScheduled ReceiptForecastRemaining ForecastAction Message Qty.Action Message; [,New,Change Qty.,Resc...Source Document IDAttached to Line No.Ref. Order No.Projected InventoryForecasted Projected InventorySuggested Projected InventoryReserved Requirement...«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 5715»Item SubstitutionNo. [PK,NN]Variant Code [PK]Substitute No. [PK,NN]Substitute Variant Code [PK]DescriptionInventoryInterchangeableConditionLocation FilterType; [Item,Nonstock Item] [PK]Substitute Type; [Item,Nonstock Item]...Sub. Item No.Relations LevelQuantity Avail. on Shpt. DateShipment Date«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 5830»Availability Calc. OverviewEntry No. [PK]Type; [Item,As of Date,Inventory,Suppl...DateItem No.Location CodeVariant CodeUnit of Measure CodeAttached to Entry No.LevelSource TypeSource Order StatusSource IDSource Batch NameSource Ref. No.Source Prod. Order LineDescriptionQuantityReserved QuantityInventory Running TotalSupply Running TotalDemand Running TotalRunning TotalMatches Criteria«Table 5847»Average Cost Calc. OverviewEntry No. [PK]Type; [Closing Entry,Increase,Applied...Valuation DateItem No.Location CodeVariant CodeCost is AdjustedAttached to Entry No.Attached to Valuation DateLevelItem Ledger Entry No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Document Type; [,Sales Shipment,Sales...Document No.Document Line No.DescriptionQuantityApplied QuantityCost Amount [Expected]Cost Amount [Actual]«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 5941»Service Item ComponentParent Service Item No. [PK]Line No. [PK]Active [PK]Type; [Service Item,Item]No.Date InstalledVariant CodeSerial No.DescriptionDescription 2Service Order No.From Line No.Last Date Modified«Table 6504»Serial No. InformationItem No. [PK,NN]Variant Code [PK]Serial No. [PK,NN]DescriptionBlockedCommentInventoryDate FilterLocation FilterBin FilterExpired Inventory«Table 6505»Lot No. InformationItem No. [PK,NN]Variant Code [PK]Lot No. [PK,NN]DescriptionTest Quality; [,Good,Average,Bad]Certificate NumberBlockedCommentInventoryDate FilterLocation FilterBin FilterExpired Inventory«Table 6506»Item Tracking CommentType; [,Serial No.,Lot No.] [PK]Item No. [PK,NN]Variant Code [PK]Serial/Lot No. [PK,NN]Line No. [PK]DateComment«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 7380»Phys. Invt. Item SelectionItem No. [PK,NN]Variant Code [PK]Location Code [PK]DescriptionShelf No.Phys Invt Counting Period Code [PK]Last Counting DateCount Frequency per YearSelectedPhys Invt Counting Period Type; [,Item...Next Counting Start DateNext Counting End Date«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 99000850»Planning AssignmentItem No. [PK]Variant Code [PK]Location Code [PK]Latest DateInactiveAction Msg. Response PlanningNet Change Planning«Table 99000853»Inventory ProfileLine No. [PK]Attribute PriorityOrder PriorityItem No.Variant CodeLocation CodeBin CodeIsSupplyOrder Relation; [Normal,Safety Stock,R...Source TypeSource Order StatusSource IDSource Batch NameSource Ref. No.Source Prod. Order LinePrimary Order StatusPrimary Order No.Primary Order LinePrimary Order TypeOriginal QuantityRemaining Quantity [Base]Untracked QuantityOriginal Due DateDue DatePlanning Flexibility; [Unlimited,None,...Fixed DateAction Message; [,New,Change Qty.,Resc...Binding; [,Order-to-Order]Quantity [Base]Min. QuantityStarting Date...«Table 99000855»Untracked Planning ElementWorksheet Template Name [PK]Worksheet Batch Name [PK]Worksheet Line No. [PK]Track Line No. [PK]Item No.Variant CodeLocation CodeSource TypeSource IDParameter ValueUntracked QuantityTrack Quantity FromTrack Quantity ToSourceWarning Level; [,Emergency,Exception,A...«Table 99»Item VendorItem No. [PK,NN]Vendor No. [PK,NN]Lead Time CalculationVendor Item No.Variant Code [PK]<Item No.><Variant Filter><Variant Code><Variant Code><Variant Code><Variant Code><Original Variant Code><Variant Code><Variant Code><Variant Code><Substitute Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Variant Code><Item No.><Alternative Item No.><Item No.><Item No.><Item No.><Original Item No.><Item No.><Item No.><No.><Substitute No.><Item No.><Item No.><Item No.><Item No.><Item No.><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.><Item No.><Item No.><Item No.><Item No.><Parent Service Item No.><No.>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Item No. (Item No.) Code20 NotBlank: Yes
3 Description (Description) Text50
4 Description 2 (Description 2) Text50

Keys

# Fields
0 Item No.,Code (Item No.,Code) Clustered: Yes
1 Code (Code)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Action Message Entry Variant Code (Variant Code) 1..n
Assembly Header Variant Code (Variant Code) 1..n
Assembly Line Variant Code (Variant Code) 1..n
Availability Calc. Overview Variant Code (Variant Code) 1..n
Average Cost Calc. Overview Variant Code (Variant Code) 1..n
Avg. Cost Adjmt. Entry Point Variant Code (Variant Code) 1..n
BOM Buffer Variant Code (Variant Code) 1..n
BOM Component Variant Code (Variant Code) 1..n
Bin Content Variant Code (Variant Code) 1..n
Bin Content Buffer Variant Code (Variant Code) 1..n
Bin Creation Worksheet Line Variant Code (Variant Code) 1..n
Capacity Ledger Entry Variant Code (Variant Code) 1..n
Filed Contract Line Variant Code (Variant Code) 1..n
Internal Movement Line Variant Code (Variant Code) 1..n
Inventory Adjustment Buffer Variant Code (Variant Code) 1..n
Inventory Buffer Variant Code (Variant Code) 1..n
Inventory Event Buffer Variant Code (Variant Code) 1..n
Inventory Page Data Variant Code (Variant Code) 1..n
Inventory Profile Variant Code (Variant Code) 1..n
Item Variant Filter (Variant Filter) 1..n
Item Cross Reference Variant Code (Variant Code) 1..n
Item Identifier Variant Code (Variant Code) 1..n
Item Journal Buffer Variant Code (Variant Code) 1..n
Item Journal Line Originally Ordered Var. Code (Originally Ordered Var. Code) 1..n
Item Ledger Entry Originally Ordered Var. Code (Originally Ordered Var. Code) 1..n
Item Statistics Buffer Variant Filter (Variant Filter) 1..n
Item Substitution Substitute Variant Code (Substitute Variant Code) 1..n
Item Tracing Buffer Variant Code (Variant Code) 1..n
Item Tracking Comment Variant Code (Variant Code) 1..n
Item Translation Variant Code (Variant Code) 1..n
Item Vendor Variant Code (Variant Code) 1..n
Job Item Price Variant Code (Variant Code) 1..n
Job Journal Line Variant Code (Variant Code) 1..n
Job Ledger Entry Variant Code (Variant Code) 1..n
Job Planning Line Variant Code (Variant Code) 1..n
Lot No. Information Variant Code (Variant Code) 1..n
Order Promising Line Variant Code (Variant Code) 1..n
Phys. Inventory Ledger Entry Variant Code (Variant Code) 1..n
Phys. Invt. Item Selection Variant Code (Variant Code) 1..n
Planning Assignment Variant Code (Variant Code) 1..n
Planning Component Variant Code (Variant Code) 1..n
Posted Assembly Header Variant Code (Variant Code) 1..n
Posted Assembly Line Variant Code (Variant Code) 1..n
Posted Invt. Pick Line Variant Code (Variant Code) 1..n
Posted Invt. Put-away Line Variant Code (Variant Code) 1..n
Posted Whse. Receipt Line Variant Code (Variant Code) 1..n
Posted Whse. Shipment Line Variant Code (Variant Code) 1..n
Prod. Order Component Original Variant Code (Original Variant Code) 1..n
Prod. Order Line Variant Code (Variant Code) 1..n
Production BOM Line Variant Code (Variant Code) 1..n
Production Matrix BOM Entry Variant Code (Variant Code) 1..n
Production Matrix BOM Line Variant Code (Variant Code) 1..1
Purch. Cr. Memo Line Variant Code (Variant Code) 1..n
Purch. Inv. Line Variant Code (Variant Code) 1..n
Purch. Rcpt. Line Variant Code (Variant Code) 1..n
Purchase Line Variant Code (Variant Code) 1..n
Purchase Line Archive Variant Code (Variant Code) 1..n
Purchase Line Discount Variant Code (Variant Code) 1..n
Purchase Price Variant Code (Variant Code) 1..n
Record Buffer Variant Code (Variant Code) 1..n
Registered Invt. Movement Line Variant Code (Variant Code) 1..n
Registered Whse. Activity Line Variant Code (Variant Code) 1..n
Requisition Line Original Variant Code (Original Variant Code) 1..n
Reservation Entry Variant Code (Variant Code) 1..n
Return Receipt Line Variant Code (Variant Code) 1..n
Return Shipment Line Variant Code (Variant Code) 1..n
Sales Cr.Memo Line Variant Code (Variant Code) 1..n
Sales Invoice Line Variant Code (Variant Code) 1..n
Sales Line Originally Ordered Var. Code (Originally Ordered Var. Code) 1..n
Sales Line Archive Originally Ordered Var. Code (Originally Ordered Var. Code) 1..n
Sales Line Discount Variant Code (Variant Code) 1..n
Sales Planning Line Variant Code (Variant Code) 1..n
Sales Price Variant Code (Variant Code) 1..n
Sales Price Worksheet Variant Code (Variant Code) 1..n
Sales Price and Line Disc Buff Variant Code (Variant Code) 1..n
Sales Shipment Line Variant Code (Variant Code) 1..n
Serial No. Information Variant Code (Variant Code) 1..n
Service Contract Line Variant Code (Variant Code) 1..n
Service Cr.Memo Line Variant Code (Variant Code) 1..n
Service Invoice Line Variant Code (Variant Code) 1..n
Service Item Variant Code (Variant Code) 1..n
Service Item Component Variant Code (Variant Code) 1..n
Service Item Line Variant Code (Variant Code) 1..n
Service Ledger Entry Variant Code (Variant Code) 1..n
Service Line Variant Code (Variant Code) 1..n
Service Shipment Item Line Variant Code (Variant Code) 1..n
Service Shipment Line Variant Code (Variant Code) 1..n
Standard Item Journal Line Originally Ordered Var. Code (Originally Ordered Var. Code) 1..n
Standard Purchase Line Variant Code (Variant Code) 1..n
Standard Sales Line Variant Code (Variant Code) 1..n
Standard Service Line Variant Code (Variant Code) 1..n
Stockkeeping Unit Variant Code (Variant Code) 1..n
Stockkeeping Unit Comment Line Variant Code (Variant Code) 1..n
Tracking Specification Variant Code (Variant Code) 1..n
Transfer Line Variant Code (Variant Code) 1..n
Transfer Receipt Line Variant Code (Variant Code) 1..n
Transfer Shipment Line Variant Code (Variant Code) 1..n
Untracked Planning Element Variant Code (Variant Code) 1..n
Value Entry Variant Code (Variant Code) 1..n
Warehouse Activity Line Variant Code (Variant Code) 1..n
Warehouse Entry Variant Code (Variant Code) 1..n
Warehouse Journal Line Variant Code (Variant Code) 1..n
Warehouse Receipt Line Variant Code (Variant Code) 1..n
Warehouse Shipment Line Variant Code (Variant Code) 1..n
Warranty Ledger Entry Variant Code (Variant Code) 1..n
Whse. Cross-Dock Opportunity Variant Code (Variant Code) 1..n
Whse. Internal Pick Line Variant Code (Variant Code) 1..n
Whse. Internal Put-away Line Variant Code (Variant Code) 1..n
Whse. Item Tracking Line Variant Code (Variant Code) 1..n
Whse. Worksheet Line Variant Code (Variant Code) 1..n