Diagrams

Table

My Vendor

DynamicsDocs.comMy Vendor«Table 9151»My VendorUser ID [PK]Vendor No. [PK,NN]NamePhone No.Balance [LCY]«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
3 Name (Name) Text50 Editable: No
4 Phone No. (Phone No.) Text30 Editable: No
5 Balance (LCY) (Balance (LCY)) Decimal Editable: No
FlowField

Keys

# Fields
0 User ID,Vendor No. (User ID,Vendor No.) Clustered: Yes
1 Name (Name)
2 Phone No. (Phone No.)

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