Diagrams

Table

Item

DynamicsDocs.comItem«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 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 268»Item AmountItem No. [PK]Amount [PK]Amount 2 [PK]«Table 30»Item TranslationItem No. [PK,NN]Language Code [PK,NN]DescriptionDescription 2Variant Code [PK]«Table 311»Sales & Receivables SetupPrimary Key [PK]Discount Posting; [No Discounts,Invoic...Credit Warnings; [Both Warnings,Credit...Stockout WarningShipment on InvoiceInvoice RoundingExt. Doc. No. MandatoryCustomer Nos.Quote Nos.Order Nos.Invoice Nos.Posted Invoice Nos.Credit Memo Nos.Posted Credit Memo Nos.Posted Shipment Nos.Reminder Nos.Issued Reminder Nos.Fin. Chrg. Memo Nos.Issued Fin. Chrg. M. Nos.Posted Prepmt. Inv. Nos.Posted Prepmt. Cr. Memo Nos.Blanket Order Nos.Calc. Inv. DiscountAppln. between Currencies; [None,EMU,A...Copy Comments Blanket to OrderCopy Comments Order to InvoiceCopy Comments Order to Shpt.Allow VAT DifferenceCalc. Inv. Disc. per VAT IDLogo Position on Documents; [No Logo,L...Check Prepmt. when Posting...«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 459»Sales Prepayment %Item No. [PK,NN]Sales Type; [Customer,Customer Price G...Sales Code [PK]Starting Date [PK]Ending DatePrepayment %«Table 460»Purchase Prepayment %Item No. [PK,NN]Vendor No. [PK]Starting Date [PK]Ending DatePrepayment %«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 5404»Item Unit of MeasureItem No. [PK,NN]Code [PK,NN]Qty. per Unit of MeasureLengthWidthHeightCubageWeight«Table 5405»Production OrderStatus; [Simulated,Planned,Firm Planne...No. [PK]DescriptionSearch DescriptionDescription 2Creation DateLast Date ModifiedSource Type; [Item,Family,Sales Header...Source No.Routing No.Inventory Posting GroupGen. Prod. Posting GroupGen. Bus. Posting GroupCommentStarting TimeStarting DateEnding TimeEnding DateDue DateFinished DateBlockedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeBin CodeReplan Ref. No.Replan Ref. Status; [Simulated,Planned...Low-Level CodeQuantityUnit CostCost Amount...«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 5430»Planning Error LogWorksheet Template Name [PK]Journal Batch Name [PK]Entry No. [PK]Item No.Error DescriptionTable IDTable Position«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 5718»Nonstock ItemEntry No. [PK]Manufacturer CodeVendor No.Vendor Item No.DescriptionUnit of MeasurePublished CostNegotiated CostUnit PriceGross WeightNet WeightItem Template CodeProduct Group CodeLast Date ModifiedBar CodeItem No.CommentNo. Series«Table 5765»Warehouse RequestSource Type [PK]Source Subtype; [0,1,2,3,4,5,6,7,8,9,1...Source No. [PK]Source Document; [,Sales Order,,,Sales...Document Status; [Open,Released]Location Code [PK]Shipment Method CodeShipping Agent CodeShipping Advice; [Partial,Complete]Destination Type; [,Customer,Vendor,Lo...Destination No.External Document No.Expected Receipt DateShipment DateType; [Inbound,Outbound] [PK]Put-away / Pick No.Completely Handled«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 5805»Item Charge Assignment (Purch)Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Document Line No. [PK]Line No. [PK]Item Charge No. [NN]Item No.DescriptionQty. to AssignQty. AssignedUnit CostAmount to AssignApplies-to Doc. Type; [Quote,Order,Inv...Applies-to Doc. No.Applies-to Doc. Line No.Applies-to Doc. Line Amount«Table 5809»Item Charge Assignment (Sales)Document Type; [Quote,Order,Invoice,Cr...Document No. [PK]Document Line No. [PK]Line No. [PK]Item Charge No. [NN]Item No.DescriptionQty. to AssignQty. AssignedUnit CostAmount to AssignApplies-to Doc. Type; [Quote,Order,Inv...Applies-to Doc. No.Applies-to Doc. Line No.Applies-to Doc. Line Amount«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 5841»Standard Cost WorksheetStandard Cost Worksheet Name [PK]Type; [Item,Work Center,Machine Center...No. [PK,NN]DescriptionImplementedReplenishment System; [Purchase,Prod....Standard CostNew Standard CostIndirect Cost %New Indirect Cost %Overhead RateNew Overhead RateSingle-Lvl Material CostNew Single-Lvl Material CostSingle-Lvl Cap. CostNew Single-Lvl Cap. CostSingle-Lvl Subcontrd CostNew Single-Lvl Subcontrd CostSingle-Lvl Cap. Ovhd CostNew Single-Lvl Cap. Ovhd CostSingle-Lvl Mfg. Ovhd CostNew Single-Lvl Mfg. Ovhd CostRolled-up Material CostNew Rolled-up Material CostRolled-up Cap. CostNew Rolled-up Cap. CostRolled-up Subcontrd CostNew Rolled-up Subcontrd CostRolled-up Cap. Ovhd CostNew Rolled-up Cap. Ovhd CostRolled-up Mfg. Ovhd Cost...«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 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 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 5945»Troubleshooting SetupType; [Service Item Group,Item,Service...No. [PK]Troubleshooting No. [PK,NN]Troubleshooting Description«Table 5956»Resource SkillType; [Resource,Service Item Group,Ite...No. [PK,NN]Skill Code [PK,NN]Assigned From; [,Service Item Group,It...Source Type; [,Service Item Group,Item...Source Code«Table 6083»Serv. Price Adjustment DetailServ. Price Adjmt. Gr. Code [PK,NN]Type; [Item,Resource,Resource Group,Se...No. [PK]Work Type [PK]Gen. Prod. Posting Group [PK]Description«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 7354»BinLocation Code [PK,NN]Code [PK,NN]DescriptionZone CodeAdjustment BinBin Type CodeWarehouse Class CodeBlock Movement; [,Inbound,Outbound,All...Special Equipment CodeBin RankingMaximum CubageMaximum WeightEmptyItem FilterVariant FilterDefaultCross-Dock BinDedicated«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 871»Social Listening Search TopicSource Type; [,Item,Vendor,Customer] [...Source No. [PK]Search Topic«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 9152»My ItemUser ID [PK]Item No. [PK,NN]DescriptionUnit PriceInventory«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 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]«Table 94»Inventory Posting GroupCode [PK,NN]DescriptionUsed in ItemsUsed in Value Entries«Table 341»Item Discount GroupCode [PK,NN]Description«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«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 323»VAT Business Posting GroupCode [PK,NN]DescriptionLast Modified Date TimeId«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 321»Tax GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 1700»Deferral TemplateDeferral Code [PK,NN]DescriptionDeferral Account [NN]Deferral %Calc. Method; [Straight-Line,Equal per...Start Date; [Posting Date,Beginning of...No. of PeriodsPeriod Description«Table 204»Unit of MeasureCode [PK,NN]DescriptionInternational Standard CodeSymbolLast Modified Date TimeId«Table 5720»ManufacturerCode [PK]Name«Table 5722»Item CategoryCode [PK,NN]Parent CategoryDescriptionIndentationPresentation OrderHas ChildrenLast Modified Date TimeId«Table 5904»Service Item GroupCode [PK,NN]DescriptionCreate Service ItemDefault Contract Discount %Default Serv. Price Group CodeDefault Response Time [Hours]«Table 6502»Item Tracking CodeCode [PK,NN]DescriptionWarranty Date FormulaMan. Warranty Date Entry Reqd.Man. Expir. Date Entry Reqd.Strict Expiration PostingSN Specific TrackingSN Info. Inbound Must ExistSN Info. Outbound Must ExistSN Warehouse TrackingSN Purchase Inbound TrackingSN Purchase Outbound TrackingSN Sales Inbound TrackingSN Sales Outbound TrackingSN Pos. Adjmt. Inb. TrackingSN Pos. Adjmt. Outb. TrackingSN Neg. Adjmt. Inb. TrackingSN Neg. Adjmt. Outb. TrackingSN Transfer TrackingSN Manuf. Inbound TrackingSN Manuf. Outbound TrackingSN Assembly Inbound TrackingSN Assembly Outbound TrackingLot Specific TrackingLot Info. Inbound Must ExistLot Info. Outbound Must ExistLot Warehouse TrackingLot Purchase Inbound TrackingLot Purchase Outbound TrackingLot Sales Inbound TrackingLot Sales Outbound Tracking...«Table 7304»Warehouse ClassCode [PK,NN]Description«Table 7305»Special EquipmentCode [PK,NN]Description«Table 7381»Phys. Invt. Counting PeriodCode [PK,NN]DescriptionCount Frequency per Year [NN]«Table 99000851»Production Forecast NameName [PK,NN]Description<Inventory Posting Group><Item Disc. Group><Vendor No.><Alternative Item No.><Location Filter><VAT Bus. Posting Gr. (Price)><Gen. Prod. Posting Group><Tax Group Code><Tax Group Id><VAT Prod. Posting Group><Default Deferral Template Code><Bin Filter><Item Filter><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Unit of Measure Id><Manufacturer Code><Item Category Code><Service Item Group><Item Tracking Code><Warehouse Class Code><Special Equipment Code><Phys Invt Counting Period Code><Production Forecast Name><Item No.><Item No.><Item No.><Write-in Product No.><Item No.><Item No.><Item No.><Source No.><Item No.><Original Item No.><Item No.><Item No.><Item No.><No.><Substitute No.><Item No.><Item No.><Destination No.><Item No.><Item No.><Item No.><Item No.><No.><Item No.><Item No.><Item No.><No.><No.><No.><No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Item No.><Source No.><Parent Item No.><No.><Installed in Item No.><Item No.><Item Filter><Item No.><Item No.><Item No.><Item No.><Item No.><Unit of Measure Code><Variant Code><Variant Code><VAT Bus. Posting Gr. (Price)><Location Code><Variant Code><Bin Code><Vendor No.><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><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><Inventory Posting Group><Gen. Prod. Posting Group><Location Code><Bin Code><Capacity No. Filter><Prod. Order No.><Source No.><Location Code><Bin Code><Location Code><Location Code><Components at Location><Transfer-from Code><Vendor No.><Bin Filter><Variant Filter><Special Equipment Code><Phys Invt Counting Period Code><No.><Substitute No.><Location Filter><Cross-Reference Type No.><Manufacturer Code><Vendor No.><Unit of Measure><Location Code><Destination No.><Destination No.><Location Code><Location Code><No.><Location Code><Unit of Measure Code><Service Item Group Code><Unit of Measure Code><Vendor No.><Parent Service Item No.><No.><No.><No.><No.><No.><Gen. Prod. Posting Group><Location Filter><Bin Filter><Location Filter><Bin Filter><VAT Bus. Posting Gr. (Price)><Vendor No.><VAT Bus. Posting Gr. (Price)><Location Code><Bin Code><Warehouse Class Code><Location Code><Default Bin Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Adjustment Bin Code><Receipt Bin Code><Shipment Bin Code><Cross-Dock Bin Code><To-Assembly Bin Code><From-Assembly Bin Code><Asm.-to-Order Shpt. Bin Code><Warehouse Class Code><Special Equipment Code><Open Shop Floor Bin Code><To-Production Bin Code><From-Production Bin Code><Bin Code><Bin Code><Location Code><Phys Invt Counting Period Code><Source No.><Gen. Prod. Posting Group><Location Code><Location Code><Location Code><Location Code><Location Code><Vendor No.><Pay-to Vendor No.><VAT Bus. Posting Group><Location Code><Def. VAT Prod. Posting Group><Parent Category>

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

Fields

# Name Type
1 No. Code20
2 No. 2 Code20
3 Description Text50
4 Search Description Code50
5 Description 2 Text50
6 Assembly BOM Boolean Editable: No
FlowField
8 Base Unit of Measure Code10
9 Price Unit Conversion Integer
10 Type Option
11 Inventory Posting Group Code20
12 Shelf No. Code10
14 Item Disc. Group Code20
15 Allow Invoice Disc. Boolean
16 Statistics Group Integer
17 Commission Group Integer
18 Unit Price Decimal
19 Price/Profit Calculation Option
20 Profit % Decimal (0:5)
21 Costing Method Option
22 Unit Cost Decimal
24 Standard Cost Decimal
25 Last Direct Cost Decimal
28 Indirect Cost % Decimal (0:5)
29 Cost is Adjusted Boolean Editable: No
30 Allow Online Adjustment Boolean Editable: No
31 Vendor No. Code20
32 Vendor Item No. Text20
33 Lead Time Calculation DateFormula
34 Reorder Point Decimal (0:5)
35 Maximum Inventory Decimal (0:5)
36 Reorder Quantity Decimal (0:5)
37 Alternative Item No. Code20
38 Unit List Price Decimal
39 Duty Due % Decimal (0:5)
40 Duty Code Code10
41 Gross Weight Decimal (0:5)
42 Net Weight Decimal (0:5)
43 Units per Parcel Decimal (0:5)
44 Unit Volume Decimal (0:5)
45 Durability Code10
46 Freight Type Code10
47 Tariff No. Code20
48 Duty Unit Conversion Decimal (0:5)
49 Country/Region Purchased Code Code10
50 Budget Quantity Decimal (0:5)
51 Budgeted Amount Decimal
52 Budget Profit Decimal
53 Comment Boolean Editable: No
FlowField
54 Blocked Boolean
55 Cost is Posted to G/L Boolean Editable: No
FlowField
56 Block Reason Text250
61 Last DateTime Modified DateTime Editable: No
62 Last Date Modified Date Editable: No
63 Last Time Modified Time Editable: No
64 Date Filter Date FlowFilter
65 Global Dimension 1 Filter Code20 FlowFilter
66 Global Dimension 2 Filter Code20 FlowFilter
67 Location Filter Code10 FlowFilter
68 Inventory Decimal (0:5) Editable: No
FlowField
69 Net Invoiced Qty. Decimal (0:5) Editable: No
FlowField
70 Net Change Decimal (0:5) Editable: No
FlowField
71 Purchases (Qty.) Decimal (0:5) Editable: No
FlowField
72 Sales (Qty.) Decimal (0:5) Editable: No
FlowField
73 Positive Adjmt. (Qty.) Decimal (0:5) Editable: No
FlowField
74 Negative Adjmt. (Qty.) Decimal (0:5) Editable: No
FlowField
77 Purchases (LCY) Decimal Editable: No
FlowField
78 Sales (LCY) Decimal Editable: No
FlowField
79 Positive Adjmt. (LCY) Decimal Editable: No
FlowField
80 Negative Adjmt. (LCY) Decimal Editable: No
FlowField
83 COGS (LCY) Decimal Editable: No
FlowField
84 Qty. on Purch. Order Decimal (0:5) Editable: No
FlowField
85 Qty. on Sales Order Decimal (0:5) Editable: No
FlowField
87 Price Includes VAT Boolean
89 Drop Shipment Filter Boolean FlowFilter
90 VAT Bus. Posting Gr. (Price) Code20
91 Gen. Prod. Posting Group Code20
92 Picture MediaSet
93 Transferred (Qty.) Decimal (0:5) Editable: No
FlowField
94 Transferred (LCY) Decimal Editable: No
FlowField
95 Country/Region of Origin Code Code10
96 Automatic Ext. Texts Boolean
97 No. Series Code20 Editable: No
98 Tax Group Code Code20
99 VAT Prod. Posting Group Code20
100 Reserve Option
101 Reserved Qty. on Inventory Decimal (0:5) Editable: No
FlowField
102 Reserved Qty. on Purch. Orders Decimal (0:5) Editable: No
FlowField
103 Reserved Qty. on Sales Orders Decimal (0:5) Editable: No
FlowField
105 Global Dimension 1 Code Code20
106 Global Dimension 2 Code Code20
107 Res. Qty. on Outbound Transfer Decimal (0:5) Editable: No
FlowField
108 Res. Qty. on Inbound Transfer Decimal (0:5) Editable: No
FlowField
109 Res. Qty. on Sales Returns Decimal (0:5) Editable: No
FlowField
110 Res. Qty. on Purch. Returns Decimal (0:5) Editable: No
FlowField
120 Stockout Warning Option
121 Prevent Negative Inventory Option
200 Cost of Open Production Orders Decimal FlowField
521 Application Wksh. User ID Code128
910 Assembly Policy Option
929 Res. Qty. on Assembly Order Decimal (0:5) Editable: No
FlowField
930 Res. Qty. on Asm. Comp. Decimal (0:5) Editable: No
FlowField
977 Qty. on Assembly Order Decimal (0:5) Editable: No
FlowField
978 Qty. on Asm. Component Decimal (0:5) Editable: No
FlowField
1001 Qty. on Job Order Decimal (0:5) Editable: No
FlowField
1002 Res. Qty. on Job Order Decimal (0:5) Editable: No
FlowField
1217 GTIN Code14 [Numeric:Yes]
1700 Default Deferral Template Code Code10
5400 Low-Level Code Integer Editable: No
5401 Lot Size Decimal (0:5)
5402 Serial Nos. Code20
5403 Last Unit Cost Calc. Date Date Editable: No
5404 Rolled-up Material Cost Decimal (2:5) Editable: No
5405 Rolled-up Capacity Cost Decimal (2:5) Editable: No
5407 Scrap % Decimal (0:2)
5409 Inventory Value Zero Boolean
5410 Discrete Order Quantity Integer
5411 Minimum Order Quantity Decimal (0:5)
5412 Maximum Order Quantity Decimal (0:5)
5413 Safety Stock Quantity Decimal (0:5)
5414 Order Multiple Decimal (0:5)
5415 Safety Lead Time DateFormula
5417 Flushing Method Option
5419 Replenishment System Option
5420 Scheduled Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
5421 Scheduled Need (Qty.) Decimal (0:5) Editable: No
FlowField
5422 Rounding Precision Decimal (0:5)
5423 Bin Filter Code20 FlowFilter
5424 Variant Filter Code10 FlowFilter
5425 Sales Unit of Measure Code10
5426 Purch. Unit of Measure Code10
5428 Time Bucket DateFormula
5429 Reserved Qty. on Prod. Order Decimal (0:5) Editable: No
FlowField
5430 Res. Qty. on Prod. Order Comp. Decimal (0:5) Editable: No
FlowField
5431 Res. Qty. on Req. Line Decimal (0:5) Editable: No
FlowField
5440 Reordering Policy Option
5441 Include Inventory Boolean
5442 Manufacturing Policy Option
5443 Rescheduling Period DateFormula
5444 Lot Accumulation Period DateFormula
5445 Dampener Period DateFormula
5446 Dampener Quantity Decimal (0:5)
5447 Overflow Level Decimal (0:5)
5449 Planning Transfer Ship. (Qty). Decimal Editable: No
FlowField
5450 Planning Worksheet (Qty.) Decimal Editable: No
FlowField
5700 Stockkeeping Unit Exists Boolean Editable: No
FlowField
5701 Manufacturer Code Code10
5702 Item Category Code Code20
5703 Created From Nonstock Item Boolean Editable: No
5704 Product Group Code Code10
5706 Substitutes Exist Boolean Editable: No
FlowField
5707 Qty. in Transit Decimal (0:5) Editable: No
FlowField
5708 Trans. Ord. Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
5709 Trans. Ord. Shipment (Qty.) Decimal (0:5) Editable: No
FlowField
5776 Qty. Assigned to ship Decimal (0:5) Editable: No
FlowField
5777 Qty. Picked Decimal (0:5) Editable: No
FlowField
5900 Service Item Group Code10
5901 Qty. on Service Order Decimal (0:5) Editable: No
FlowField
5902 Res. Qty. on Service Orders Decimal (0:5) Editable: No
FlowField
6500 Item Tracking Code Code10
6501 Lot Nos. Code20
6502 Expiration Calculation DateFormula
6503 Lot No. Filter Code20 FlowFilter
6504 Serial No. Filter Code20 FlowFilter
6650 Qty. on Purch. Return Decimal (0:5) Editable: No
FlowField
6660 Qty. on Sales Return Decimal (0:5) Editable: No
FlowField
7171 No. of Substitutes Integer Editable: No
FlowField
7300 Warehouse Class Code Code10
7301 Special Equipment Code Code10
7302 Put-away Template Code Code10
7307 Put-away Unit of Measure Code Code10
7380 Phys Invt Counting Period Code Code10
7381 Last Counting Period Update Date Editable: No
7383 Last Phys. Invt. Date Date Editable: No
FlowField
7384 Use Cross-Docking Boolean
7385 Next Counting Start Date Date Editable: No
7386 Next Counting End Date Date Editable: No
7700 Identifier Code Code20 Editable: No
FlowField
8000 Id GUID
8001 Unit of Measure Id GUID
8002 Tax Group Id GUID
99000750 Routing No. Code20
99000751 Production BOM No. Code20
99000752 Single-Level Material Cost Decimal Editable: No
99000753 Single-Level Capacity Cost Decimal Editable: No
99000754 Single-Level Subcontrd. Cost Decimal Editable: No
99000755 Single-Level Cap. Ovhd Cost Decimal Editable: No
99000756 Single-Level Mfg. Ovhd Cost Decimal Editable: No
99000757 Overhead Rate Decimal
99000758 Rolled-up Subcontracted Cost Decimal Editable: No
99000759 Rolled-up Mfg. Ovhd Cost Decimal Editable: No
99000760 Rolled-up Cap. Overhead Cost Decimal Editable: No
99000761 Planning Issues (Qty.) Decimal (0:5) Editable: No
FlowField
99000762 Planning Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
99000765 Planned Order Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
99000766 FP Order Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
99000767 Rel. Order Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
99000768 Planning Release (Qty.) Decimal (0:5) Editable: No
FlowField
99000769 Planned Order Release (Qty.) Decimal (0:5) Editable: No
FlowField
99000770 Purch. Req. Receipt (Qty.) Decimal (0:5) Editable: No
FlowField
99000771 Purch. Req. Release (Qty.) Decimal (0:5) Editable: No
FlowField
99000773 Order Tracking Policy Option
99000774 Prod. Forecast Quantity (Base) Decimal (0:5) FlowField
99000775 Production Forecast Name Code10 FlowFilter
99000776 Component Forecast Boolean FlowFilter
99000777 Qty. on Prod. Order Decimal (0:5) Editable: No
FlowField
99000778 Qty. on Component Lines Decimal (0:5) Editable: No
FlowField
99000875 Critical Boolean
99008500 Common Item No. Code20

Keys

# Fields
0 No. Clustered: Yes
1 Search Description
2 Inventory Posting Group
3 Shelf No.
4 Vendor No.
5 Gen. Prod. Posting Group
6 Low-Level Code
7 Production BOM No.
8 Routing No.
9 Vendor Item No.,Vendor No.
10 Common Item No.
11 Service Item Group
12 Cost is Adjusted,Allow Online Adjustment
13 Description
14 Base Unit of Measure
15 Type

Table Relations To Other Tables

Field Related Table Related Field
Bin Filter Bin Code 1..n
Country/Region of Origin Code Country/Region Code 1..n
Default Deferral Template Code Deferral Template Deferral Code 1..n
Global Dimension 2 Code Dimension Value Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Inventory Posting Group Inventory Posting Group Code 1..n
Alternative Item No. Item No. 1..n
Item Category Code Item Category Code 1..n
Item Disc. Group Item Discount Group Code 1..n
Item Tracking Code Item Tracking Code Code 1..n
Put-away Unit of Measure Code Item Unit of Measure Code 1..n
Variant Filter Item Variant Code 1..n
Location Filter Location Code 1..n
Manufacturer Code Manufacturer Code 1..n
Lot Nos. No. Series Code 1..n
Phys Invt Counting Period Code Phys. Invt. Counting Period Code 1..n
Production BOM No. Production BOM Header No. 1..n
Production Forecast Name Production Forecast Name Name 1..n
Put-away Template Code Put-away Template Header Code 1..n
Routing No. Routing Header No. 1..n
Service Item Group Service Item Group Code 1..n
Special Equipment Code Special Equipment Code 1..n
Tax Group Id Tax Group Id 1..n
Unit of Measure Id Unit of Measure Id 1..n
VAT Bus. Posting Gr. (Price) VAT Business Posting Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n
Vendor No. Vendor No. 1..n
Warehouse Class Code Warehouse Class Code 1..n

Table Relations From Other Tables

From Table From Field
Action Message Entry Item No. 1..n
Analysis Dim. Selection Buffer New Dimension Value Code 1..n
Analysis Line Source No. Filter 1..n
Assembly Header Item No. 1..n
Assembly Line No. 1..n
Availability Calc. Overview Item No. 1..n
Average Cost Calc. Overview Item No. 1..n
Avg. Cost Adjmt. Entry Point Item No. 1..n
BOM Buffer No. 1..n
BOM Component Installed in Item No. 1..n
Bin Item Filter 1..n
Bin Content Item No. 1..n
Bin Content Buffer Item No. 1..n
Bin Creation Worksheet Line Item No. 1..n
Capacity Ledger Entry Item No. 1..n
Comment Line No. 1..n
Default Dimension No. 1..n
Extended Text Header No. 1..n
Extended Text Line No. 1..n
Family Line Item No. 1..n
Filed Contract Line Item No. 1..n
Handled IC Inbox Purch. Line IC Partner Reference 1..n
Handled IC Inbox Sales Line IC Partner Reference 1..n
Handled IC Outbox Purch. Line IC Partner Reference 1..n
Handled IC Outbox Sales Line IC Partner Reference 1..n
IC Inbox Purchase Line IC Partner Reference 1..n
IC Inbox Sales Line IC Partner Reference 1..n
IC Outbox Purchase Line IC Partner Reference 1..n
IC Outbox Sales Line IC Partner Reference 1..n
Intrastat Jnl. Line Item No. 1..n
Inventory Adjmt. Entry (Order) Item No. 1..n
Inventory Adjustment Buffer Item No. 1..n
Inventory Buffer Item No. 1..n
Inventory Event Buffer Item No. 1..n
Inventory Page Data Item No. 1..n
Inventory Profile Item No. 1..n
Item Alternative Item No. 1..n
Item Amount Item No. 1..n
Item Analysis View Budg. Entry Source No. 1..n
Item Analysis View Entry Source No. 1..n
Item Budget Buffer Source No. 1..n
Item Budget Entry Source No. 1..n
Item Charge Assignment (Purch) Item No. 1..n
Item Charge Assignment (Sales) Item No. 1..n
Item Cross Reference Item No. 1..n
Item Identifier Item No. 1..n
Item Journal Buffer Item No. 1..n
Item Journal Line Originally Ordered No. 1..n
Item Ledger Entry Originally Ordered No. 1..n
Item Substitution Substitute No. 1..n
Item Tracing Buffer Source No. 1..n
Item Tracking Comment Item No. 1..n
Item Translation Item No. 1..n
Item Unit of Measure Item No. 1..n
Item Variant Item No. 1..n
Item Vendor Item No. 1..n
Job Item Price Item No. 1..n
Job Journal Line No. 1..n
Job Ledger Entry No. 1..n
Job Planning Line No. 1..n
Loaner Item No. 1..n
Lot No. Information Item No. 1..n
Machine Center Item Filter 1..n
My Item Item No. 1..n
Nonstock Item Item No. 1..n
Order Promising Line Item No. 1..n
Order Tracking Entry Item No. 1..n
Phys. Inventory Ledger Entry Item No. 1..n
Phys. Invt. Item Selection Item No. 1..n
Planning Assignment Item No. 1..n
Planning Buffer Item No. 1..n
Planning Component Item No. 1..n
Planning Error Log Item No. 1..n
Post Value Entry to G/L Item No. 1..n
Posted Assembly Header Item No. 1..n
Posted Assembly Line No. 1..n
Posted Invt. Pick Header Destination No. 1..n
Posted Invt. Pick Line Destination No. 1..n
Posted Invt. Put-away Header Destination No. 1..n
Posted Invt. Put-away Line Destination No. 1..n
Posted Whse. Receipt Line Item No. 1..n
Posted Whse. Shipment Line Item No. 1..n
Prod. Order Component Original Item No. 1..n
Prod. Order Line Item No. 1..n
Production BOM Line No. 1..n
Production Forecast Entry Item No. 1..n
Production Matrix BOM Entry Item No. 1..n
Production Matrix BOM Line Item No. 1..n
Production Order Source No. 1..n
Purch. Cr. Memo Line No. 1..n
Purch. Inv. Line No. 1..n
Purch. Rcpt. Line No. 1..n
Purchase Line Archive No. 1..n
Purchase Line Discount Item No. 1..n
Purchase Prepayment % Item No. 1..n
Purchase Price Item No. 1..n
Record Buffer Item No. 1..n
Registered Invt. Movement Hdr. Destination No. 1..n
Registered Invt. Movement Line Destination No.