Diagrams

Table

Office Contact Associations

DynamicsDocs.comOffice Contact Associations«Table 1625»Office Contact AssociationsContact No. [PK]Business Relation CodeAssociated Table; [,Customer,Vendor,Ba...No.Business Relation DescriptionContact NameType; [Company,Contact Person] [PK]«Table 5053»Business RelationCode [PK,NN]DescriptionNo. of Contacts«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«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 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...<Business Relation Code><No.><No.><No.><Bill-to Customer 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 Contact No. (Contact No.) Code20
2 Business Relation Code (Business Relation Code) Code10
3 Associated Table (Associated Table) Option
4 No. (No.) Code20
5 Business Relation Description (Business Relation Description) Text50 Editable: No
6 Contact Name (Contact Name) Text50
7 Type (Type) Option

Keys

# Fields
0 Contact No.,Type,Associated Table (Contact No.,Type,Associated Table) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
No. (No.) Bank Account No. (No.) 1..n
Business Relation Code (Business Relation Code) Business Relation Code (Code) 1..n
No. (No.) Customer No. (No.) 1..n
No. (No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field