Diagrams

Table

My Vendor

DynamicsDocs.comMy Vendor«Table 9151»My VendorUser ID [PK]Vendor No. [PK,NN]«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...<Vendor 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 User ID (User ID) Code50
2 Vendor No. (Vendor No.) Code20 NotBlank: Yes

Keys

# Fields
0 User ID,Vendor No. (User ID,Vendor No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Vendor No. (Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field