Diagrams

Table

Item Vendor

DynamicsDocs.comItem Vendor«Table 99»Item VendorItem No. [PK,NN]Vendor No. [PK,NN]Lead Time CalculationVendor Item No.Variant 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 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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2<Item No.><Vendor No.><Variant Code><Vendor No.><Alternative Item No.><Variant Filter><Item No.><Pay-to Vendor 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 Vendor No. (Vendor No.) Code20 NotBlank: Yes
6 Lead Time Calculation (Lead Time Calculation) DateFormula
7 Vendor Item No. (Vendor Item No.) Text20
5700 Variant Code (Variant Code) Code10

Keys

# Fields
0 Vendor No.,Item No.,Variant Code (Vendor No.,Item No.,Variant Code) Clustered: Yes
1 Item No.,Variant Code,Vendor No. (Item No.,Variant Code,Vendor No.)
2 Vendor No.,Vendor Item No. (Vendor No.,Vendor Item No.)

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
Vendor No. (Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field