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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Action Message Entry Item No. (Item No.) 1..n
Analysis Dim. Selection Buffer New Dimension Value Code (New Dimension Value Code) 1..n
Analysis Line Source No. Filter (Source No. Filter) 1..n
Assembly Header Item No. (Item No.) 1..n
Assembly Line No. (No.) 1..n
Availability Calc. Overview Item No. (Item No.) 1..n
Average Cost Calc. Overview Item No. (Item No.) 1..n
Avg. Cost Adjmt. Entry Point Item No. (Item No.) 1..n
BOM Buffer No. (No.) 1..n
BOM Component Installed in Item No. (Installed in Item No.) 1..n
Bin Item Filter (Item Filter) 1..n
Bin Content Item No. (Item No.) 1..n
Bin Content Buffer Item No. (Item No.) 1..n
Bin Creation Worksheet Line Item No. (Item No.) 1..n
Capacity Ledger Entry Item No. (Item No.) 1..n
Comment Line No. (No.) 1..n
Default Dimension No. (No.) 1..n
Extended Text Header No. (No.) 1..n
Extended Text Line No. (No.) 1..n
Family Line Item No. (Item No.) 1..n
Filed Contract Line Item No. (Item No.) 1..n
Handled IC Inbox Purch. Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Inbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Outbox Purch. Line IC Partner Reference (IC Partner Reference) 1..n
Handled IC Outbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
IC Inbox Purchase Line IC Partner Reference (IC Partner Reference) 1..n
IC Inbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
IC Outbox Purchase Line IC Partner Reference (IC Partner Reference) 1..n
IC Outbox Sales Line IC Partner Reference (IC Partner Reference) 1..n
Intrastat Jnl. Line Item No. (Item No.) 1..n
Inventory Adjmt. Entry (Order) Item No. (Item No.) 1..n
Inventory Adjustment Buffer Item No. (Item No.) 1..n
Inventory Buffer Item No. (Item No.) 1..n
Inventory Event Buffer Item No. (Item No.) 1..n
Inventory Page Data Item No. (Item No.) 1..n
Inventory Profile Item No. (Item No.) 1..n
Item Alternative Item No. (Alternative Item No.) 1..n
Item Amount Item No. (Item No.) 1..n
Item Analysis View Budg. Entry Source No. (Source No.) 1..n
Item Analysis View Entry Source No. (Source No.) 1..n
Item Budget Buffer Source No. (Source No.) 1..n
Item Budget Entry Source No. (Source No.) 1..n
Item Charge Assignment (Purch) Item No. (Item No.) 1..n
Item Charge Assignment (Sales) Item No. (Item No.) 1..n
Item Cross Reference Item No. (Item No.) 1..n
Item Identifier Item No. (Item No.) 1..n
Item Journal Buffer Item No. (Item No.) 1..n
Item Journal Line Originally Ordered No. (Originally Ordered No.) 1..n
Item Ledger Entry Originally Ordered No. (Originally Ordered No.) 1..n
Item Substitution Substitute No. (Substitute No.) 1..n
Item Tracing Buffer Source No. (Source No.) 1..n
Item Tracking Comment Item No. (Item No.) 1..n
Item Translation Item No. (Item No.) 1..n
Item Unit of Measure Item No. (Item No.) 1..n
Item Variant Item No. (Item No.) 1..n
Item Vendor Item No. (Item No.) 1..n
Job Item Price Item No. (Item No.) 1..n
Job Journal Line No. (No.) 1..n
Job Ledger Entry No. (No.) 1..n
Job Planning Line No. (No.) 1..n
Loaner Item No. (Item No.) 1..n
Lot No. Information Item No. (Item No.) 1..n
Machine Center Item Filter (Item Filter) 1..n
My Item Item No. (Item No.) 1..n
Nonstock Item Item No. (Item No.) 1..n
Order Promising Line Item No. (Item No.) 1..n
Order Tracking Entry Item No. (Item No.) 1..n
Phys. Inventory Ledger Entry Item No. (Item No.) 1..n
Phys. Invt. Item Selection Item No. (Item No.) 1..n
Planning Assignment Item No. (Item No.) 1..n
Planning Buffer Item No. (Item No.) 1..n
Planning Component Item No. (Item No.) 1..n
Planning Error Log Item No. (Item No.) 1..n
Post Value Entry to G/L Item No. (Item No.) 1..n
Posted Assembly Header Item No. (Item No.) 1..n
Posted Assembly Line No. (No.) 1..n
Posted Invt. Pick Header Destination No. (Destination No.) 1..n
Posted Invt. Pick Line Destination No. (Destination No.) 1..n
Posted Invt. Put-away Header Destination No. (Destination No.) 1..n
Posted Invt. Put-away Line Destination No. (Destination No.) 1..n
Posted Whse. Receipt Line Item No. (Item No.) 1..n
Posted Whse. Shipment Line Item No. (Item No.) 1..n
Prod. Order Component Original Item No. (Original Item No.) 1..n
Prod. Order Line Item No. (Item No.) 1..n
Production BOM Line No. (No.) 1..n
Production Forecast Entry Item No. (Item No.) 1..n
Production Matrix BOM Entry Item No. (Item No.) 1..n
Production Matrix BOM Line Item No. (Item No.) 1..n
Production Order Source No. (Source No.) 1..n
Purch. Cr. Memo Line No. (No.) 1..n
Purch. Inv. Line No. (No.) 1..n
Purch. Rcpt. Line No. (No.) 1..n
Purchase Line Archive No. (No.) 1..n
Purchase Line Discount Item No. (Item No.) 1..n
Purchase Prepayment % Item No. (Item No.) 1..n
Purchase Price Item No. (Item No.) 1..n
Record Buffer Item No. (Item No.) 1..n
Registered Invt. Movement Hdr. Destination No. (Destination No.) 1..n
Registered Invt. Movement Line Destination No. (Destination No.) 1..n
Registered Whse. Activity Line Destination No. (Destination No.) 1..n
Requisition Line Original Item No. (Original Item No.) 1..n
Reservation Entry Item No. (Item No.) 1..n
Resource Skill No. (No.) 1..n
Return Receipt Line No. (No.) 1..n
Return Shipment Line No. (No.) 1..n
Sales & Receivables Setup Write-in Product No. (Write-in Product No.) 1..n
Sales Cr.Memo Line No. (No.) 1..n
Sales Invoice Line No. (No.) 1..n
Sales Line BOM Item No. (BOM Item No.) 1..n
Sales Line Archive BOM Item No. (BOM Item No.) 1..n
Sales Line Discount Code (Code) 1..n
Sales Planning Line Item No. (Item No.) 1..n
Sales Prepayment % Item No. (Item No.) 1..n
Sales Price Item No. (Item No.) 1..n
Sales Price Worksheet Item No. (Item No.) 1..n
Sales Price and Line Disc Buff Code (Code) 1..n
Sales Shipment Buffer No. (No.) 1..n
Sales Shipment Line No. (No.) 1..n
Serial No. Information Item No. (Item No.) 1..n
Serv. Price Adjustment Detail No. (No.) 1..n
Service Contract Header Item Filter (Item Filter) 1..n
Service Contract Line Item No. (Item No.) 1..n
Service Cr.Memo Line Replaced Item No. (Replaced Item No.) 1..n
Service Invoice Line Replaced Item No. (Replaced Item No.) 1..n
Service Item Item No. (Item No.) 1..n
Service Item Component No. (No.) 1..n
Service Item Line Item No. (Item No.) 1..n
Service Ledger Entry No. (No.) 1..n
Service Line Replaced Item No. (Replaced Item No.) 1..n
Service Line Price Adjmt. No. (No.) 1..n
Service Shipment Buffer No. (No.) 1..n
Service Shipment Item Line Item No. (Item No.) 1..n
Service Shipment Line Replaced Item No. (Replaced Item No.) 1..n
Social Listening Search Topic Source No. (Source No.) 1..n
Standard Cost Worksheet No. (No.) 1..n
Standard Item Journal Line Originally Ordered No. (Originally Ordered No.) 1..n
Standard Purchase Line No. (No.) 1..n
Standard Sales Line No. (No.) 1..n
Standard Service Line No. (No.) 1..n
Stockkeeping Unit Item No. (Item No.) 1..n
Stockkeeping Unit Comment Line Item No. (Item No.) 1..n
Tracking Specification Item No. (Item No.) 1..n
Transfer Receipt Line Item No. (Item No.) 1..n
Transfer Shipment Line Item No. (Item No.) 1..n
Troubleshooting Setup No. (No.) 1..n
Untracked Planning Element Item No. (Item No.) 1..n
Value Entry Source No. (Source No.) 1..n
Warehouse Activity Header Destination No. (Destination No.) 1..n
Warehouse Activity Line Destination No. (Destination No.) 1..n
Warehouse Entry Item No. (Item No.) 1..n
Warehouse Journal Line Item No. (Item No.) 1..n
Warehouse Receipt Line Item No. (Item No.) 1..n
Warehouse Request Destination No. (Destination No.) 1..n
Warehouse Shipment Line Item No. (Item No.) 1..n
Warranty Ledger Entry No. (No.) 1..n
Where-Used Line Item No. (Item No.) 1..n
Whse. Cross-Dock Opportunity Item No. (Item No.) 1..n
Whse. Internal Pick Line Item No. (Item No.) 1..n
Whse. Item Tracking Line Item No. (Item No.) 1..n
Whse. Worksheet Line Item No. (Item No.) 1..n