Diagrams

Table

Item Translation

DynamicsDocs.comItem Translation«Table 30»Item TranslationItem No. [PK,NN]Language Code [PK,NN]DescriptionDescription 2Variant Code [PK]«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 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name«Table 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Item No.><Language Code><Variant Code><Alternative Item No.><Variant Filter><Item No.>

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

Fields

# Name Type
1 Item No. (Item No.) Code20 NotBlank: Yes
2 Language Code (Language Code) Code10 NotBlank: Yes
3 Description (Description) Text50
4 Description 2 (Description 2) Text50
5400 Variant Code (Variant Code) Code10

Keys

# Fields
0 Item No.,Variant Code,Language Code (Item No.,Variant Code,Language Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Item No. (Item No.) Item No. (No.) 1..n
Variant Code (Variant Code) Item Variant Code (Code) 1..n
Language Code (Language Code) Language Code (Code) 1..n

Table Relations From Other Tables

From Table From Field