Diagrams


Table

Item Category

DynamicsDocs.comItem Category«Table 5722»Item CategoryCode [PK,NN]Parent CategoryDescriptionIndentationPresentation OrderHas Children«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 1301»Item TemplateKey [PK]Code [NN]Template Name [NN]Base Unit of MeasureType; [Inventory,Service]Inventory Posting GroupItem Disc. GroupAllow Invoice Disc.Price/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Indirect Cost %Price Includes VATGen. Prod. Posting GroupAutomatic Ext. TextsTax Group CodeVAT Prod. Posting GroupItem Category CodeService Item GroupWarehouse Class Code«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 5723»Product GroupItem Category Code [PK,NN]Code [PK,NN]DescriptionWarehouse Class Code«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...<Parent Category><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><Item Category Code><No.><Attached to Line No.><Blanket Order Line No.><No.><Attached to Line No.><Blanket Order Line No.><No.><Attached to Line No.><Blanket Order Line No.><No.><Attached to Line No.><Blanket Order Line No.><No.><Attached to Line No.><Blanket Order Line No.><No.><Attached to Line No.><Blanket Order Line No.><No.><Original Item No.><Alternative Item No.><Item No.><Source No.><Originally Ordered No.><Originally Ordered No.><BOM Item No.><No.><Originally Ordered No.><BOM Item No.><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.><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.><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.><Purch. Order Line No.><Special Order Purch. Line No.><Blanket Order Line No.><Attached to Line No.><Attached to Line No.><Derived From Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.><Attached to Line No.>

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

Fields

# Name Type
1 Code Code20 NotBlank: Yes
2 Parent Category Code20
3 Description Text50
9 Indentation Integer
10 Presentation Order Integer
11 Has Children Boolean

Keys

# Fields
0 Code Clustered: Yes
1 Parent Category

Table Relations To Other Tables

Field Related Table Related Field
Parent Category Item Category Code 1..n

Table Relations From Other Tables

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