Diagrams


Table

Product Group

DynamicsDocs.comProduct Group«Table 5723»Product GroupItem Category Code [PK]Code [PK]DescriptionWarehouse Class Code«Table 111»Sales Shipment LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No....«Table 113»Sales Invoice LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeShipment No....«Table 115»Sales Cr.Memo LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeBill-to Customer No....«Table 121»Purch. Rcpt. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Qty. Rcd. Not InvoicedQuantity InvoicedOrder No....«Table 123»Purch. Inv. LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Receipt No....«Table 125»Purch. Cr. Memo LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Pay-to Vendor No....«Table 246»Requisition LineWorksheet Template Name [PK]Journal Batch Name [PK]Line No. [PK]Type; [,G/L Account,Item]No.DescriptionDescription 2QuantityVendor No.Direct Unit CostDue DateRequester IDConfirmedShortcut Dimension 1 CodeShortcut Dimension 2 CodeLocation CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyOrder DateVendor Item No.Sales Order No.Sales Order Line No.Sell-to Customer No.Ship-to CodeOrder Address CodeCurrency CodeCurrency FactorReserved QuantityDimension Set IDProd. Order No....«Table 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 32»Item Ledger EntryEntry No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeQuantityRemaining QuantityInvoiced QuantityApplies-to EntryOpenGlobal Dimension 1 CodeGlobal Dimension 2 CodePositiveSource Type; [,Customer,Vendor,Item]Drop ShipmentTransaction TypeTransport MethodCountry/Region CodeEntry/Exit PointDocument DateExternal Document No.AreaTransaction SpecificationNo. SeriesReserved QuantityDocument Type; [,Sales Shipment,Sales...Document Line No.Order Type; [,Production,Transfer,Serv......«Table 37»Sales LineDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 Code...«Table 39»Purchase LineDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 Code...«Table 5108»Sales Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Sell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupQuantity Disc. CodeShipment DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5110»Purchase Line ArchiveDocument Type; [Quote,Order,Invoice,Cr...Buy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupExpected Receipt DateDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ReceiveDirect Unit CostUnit Cost [LCY]VAT %Quantity Disc. %Line Discount %Line Discount AmountAmountAmount Including VATUnit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item Entry...«Table 5718»Nonstock ItemEntry No. [PK]Manufacturer CodeVendor No.Vendor Item No.DescriptionUnit of MeasurePublished CostNegotiated CostUnit PriceGross WeightNet WeightItem Category CodeProduct Group CodeLast Date ModifiedBar CodeItem No.CommentNo. Series«Table 5741»Transfer LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureQty. to ShipQty. to ReceiveQuantity ShippedQuantity ReceivedStatus; [Open,Released]Shortcut Dimension 1 CodeShortcut Dimension 2 CodeDescriptionGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Outstanding Qty. [Base]Qty. to Ship [Base]Qty. Shipped [Base]Qty. to Receive [Base]Qty. Received [Base]Qty. per Unit of MeasureUnit of Measure CodeOutstanding QuantityGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2In-Transit Code...«Table 5745»Transfer Shipment LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureDescriptionShortcut Dimension 1 CodeShortcut Dimension 2 CodeGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Qty. per Unit of MeasureUnit of Measure CodeGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2Transfer Order No.Shipment DateShipping Agent CodeShipping Agent Service CodeIn-Transit CodeTransfer-from CodeTransfer-to CodeItem Shpt. Entry No.Shipping TimeDimension Set IDItem Category CodeProduct Group Code...«Table 5747»Transfer Receipt LineDocument No. [PK]Line No. [PK]Item No.QuantityUnit of MeasureDescriptionShortcut Dimension 1 CodeShortcut Dimension 2 CodeGen. Prod. Posting GroupInventory Posting GroupQuantity [Base]Qty. per Unit of MeasureUnit of Measure CodeGross WeightNet WeightUnit VolumeVariant CodeUnits per ParcelDescription 2Transfer Order No.Receipt DateShipping Agent CodeShipping Agent Service CodeIn-Transit CodeTransfer-from CodeTransfer-to CodeItem Rcpt. Entry No.Shipping TimeDimension Set IDItem Category CodeProduct Group Code...«Table 5902»Service LineDocument Type; [Quote,Order,Invoice,Cr...Customer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityOutstanding QuantityQty. to InvoiceQty. to ShipUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price Group...«Table 5991»Service Shipment LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeQty. Shipped Not InvoicedQuantity InvoicedOrder No.Order Line No.Bill-to Customer No....«Table 5993»Service Invoice LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Shipment Line No.Bill-to Customer No....«Table 5995»Service Cr.Memo LineCustomer No.Document No. [PK]Line No. [PK]Type; [,Item,Resource,Cost,G/L Account...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Line Discount AmountAmountAmount Including VATAllow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupWork Type CodeShipment No.Bill-to Customer No.Inv. Discount AmountGen. Bus. Posting Group...«Table 6651»Return Shipment LineBuy-from Vendor No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,,Fixed Asset,...No.Location CodePosting GroupDescriptionDescription 2Unit of MeasureQuantityDirect Unit CostUnit Cost [LCY]VAT %Line Discount %Unit Price [LCY]Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeJob No.Indirect Cost %Quantity InvoicedPay-to Vendor No.Vendor Item No.Gen. Bus. Posting Group...«Table 6661»Return Receipt LineSell-to Customer No.Document No. [PK]Line No. [PK]Type; [,G/L Account,Item,Resource,Fixe...No.Location CodePosting GroupShipment DateDescriptionDescription 2Unit of MeasureQuantityUnit PriceUnit Cost [LCY]VAT %Line Discount %Allow Invoice Disc.Gross WeightNet WeightUnits per ParcelUnit VolumeAppl.-to Item EntryItem Rcpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Price GroupJob No.Work Type CodeQuantity InvoicedBill-to Customer No.Gen. Bus. Posting Group...«Table 753»Standard Item Journal LineJournal Template Name [PK,NN]Line No. [PK,NN]Item No.Entry Type; [Purchase,Sale,Positive Ad...DescriptionLocation CodeInventory Posting GroupQuantityUnit AmountUnit CostAmountSalespers./Purch. CodeSource CodeShortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Standard Journal Code [PK]Reason CodeTransaction TypeTransport MethodCountry/Region CodeQty. [Calculated]Qty. [Phys. Inventory]Phys. InventoryGen. Bus. Posting GroupGen. Prod. Posting GroupEntry/Exit PointAreaTransaction SpecificationPosting No. SeriesDimension Set ID...«Table 83»Item Journal LineJournal Template Name [PK]Line No. [PK]Item No.Posting DateEntry Type; [Purchase,Sale,Positive Ad...Source No.Document No.DescriptionLocation CodeInventory Posting GroupSource Posting GroupQuantityInvoiced QuantityUnit AmountUnit CostAmountDiscount AmountSalespers./Purch. CodeSource CodeApplies-to EntryItem Shpt. Entry No.Shortcut Dimension 1 CodeShortcut Dimension 2 CodeIndirect Cost %Source Type; [,Customer,Vendor,Item]Journal Batch Name [PK]Reason CodeRecurring Method; [,Fixed,Variable]Expiration DateRecurring FrequencyDrop Shipment...«Table 5722»Item CategoryCode [PK,NN]DescriptionDef. Gen. Prod. Posting GroupDef. Inventory Posting GroupDef. Tax Group CodeDef. Costing Method; [FIFO,LIFO,Specif...Def. VAT Prod. Posting Group«Table 7304»Warehouse ClassCode [PK,NN]Description<Item Category Code><Warehouse Class Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><Product Group Code><No.><Attached to Line No.><Blanket Order Line No.><Item Category Code><No.><Attached to Line No.><Blanket Order Line No.><Item Category Code><No.><Attached to Line No.><Blanket Order Line No.><Item Category Code><No.><Attached to Line No.><Blanket Order Line No.><Item Category Code><No.><Attached to Line No.><Blanket Order Line No.><Item Category Code><No.><Attached to Line No.><Blanket Order Line No.><Item Category Code><No.><Original Item No.><Item Category Code><Alternative Item No.><Item Category Code><Item No.><Source No.><Originally Ordered No.><No.><Originally Ordered No.><BOM Item No.><No.><No.><Originally Ordered No.><BOM Item No.><No.><Item No.><Item No.><Item No.><Item No.><No.><Replaced Item No.><No.><Replaced Item No.><No.><Replaced Item No.><No.><Replaced Item No.><No.><No.><Item No.><Originally Ordered No.><Item No.><Source No.><Originally Ordered No.><Item Category Code><Last Item Ledger Entry No.><Purch. Order Line No.><Special Order Purch. Line No.><Sales Order Line No.><Special Order Sales Line No.><Attached to Line No.><Blanket Order Line No.><Item Category Code><Blanket Order Line No.><Sales Order Line No.><Special Order Sales Line No.><Blanket Order Line No.><Blanket Order Line No.><Attached to Line No.><Blanket Order Line No.><Item Category Code><Purch. Order Line No.><Special Order Purch. Line No.><Blanket Order Line No.><Attached to Line No.><Item Category Code><Attached to Line No.><Item Category Code><Item Category Code><Derived From Line No.><Item Category Code><Item Category Code><Item Category Code><Attached to Line No.><Item Category Code><Item Category Code><Attached to Line No.><Item Category Code><Attached to Line No.><Item Category Code><Attached to Line No.><Item Category Code><Attached to Line No.><Item Category Code><Item Category Code><Item Category Code>

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

Fields

# Name Type
1 Item Category Code Code10
2 Code Code10
3 Description Text50
7300 Warehouse Class Code Code10

Keys

# Fields
0 Item Category Code,Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Item Category Code Item Category Code 1..n
Warehouse Class Code Warehouse Class Code 1..n

Table Relations From Other Tables

From Table From Field
Item Product Group Code 1..n
Item Journal Line Product Group Code 1..n
Item Ledger Entry Product Group Code 1..n
Nonstock Item Product Group Code 1..n
Purch. Cr. Memo Line Product Group Code 1..n
Purch. Inv. Line Product Group Code 1..n
Purch. Rcpt. Line Product Group Code 1..n
Purchase Line Product Group Code 1..n
Purchase Line Archive Product Group Code 1..n
Requisition Line Product Group Code 1..n
Return Receipt Line Product Group Code 1..n
Return Shipment Line Product Group Code 1..n
Sales Cr.Memo Line Product Group Code 1..n
Sales Invoice Line Product Group Code 1..n
Sales Line Product Group Code 1..n
Sales Line Archive Product Group Code 1..n
Sales Shipment Line Product Group Code 1..n
Service Cr.Memo Line Product Group Code 1..n
Service Invoice Line Product Group Code 1..n
Service Line Product Group Code 1..n
Service Shipment Line Product Group Code 1..n
Standard Item Journal Line Product Group Code 1..n
Transfer Line Product Group Code 1..n
Transfer Receipt Line Product Group Code 1..n
Transfer Shipment Line Product Group Code 1..n