Diagrams

Table

Item Identifier

DynamicsDocs.comItem Identifier«Table 7704»Item IdentifierCode [PK,NN]Item No.Variant CodeUnit of Measure Code«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 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<Item No.><Variant Code><Unit of Measure Code><Alternative Item No.><Variant Filter><Item No.><Sales Unit of Measure><Purch. Unit of Measure><Put-away Unit of Measure Code><Item No.>

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

Fields

# Name Type
1 Code (Code) Code20 NotBlank: Yes
2 Item No. (Item No.) Code20
3 Variant Code (Variant Code) Code10
4 Unit of Measure Code (Unit of Measure Code) Code10

Keys

# Fields
0 Code (Code) Clustered: Yes
1 Item No.,Variant Code,Unit of Measure Code (Item No.,Variant Code,Unit of Measure Code)

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Unit of Measure Code (Unit of Measure Code) Item Unit of Measure Code (Code) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n

Table Relations From Other Tables

From Table From Field