Diagrams


Table

Contact Business Relation

DynamicsDocs.comContact Business Relation«Table 5054»Contact Business RelationContact No. [PK,NN]Business Relation Code [PK,NN]Link to Table; [,Customer,Vendor,Bank...No.Business Relation DescriptionContact Name«Table 5050»ContactNo. [PK]NameSearch NameName 2AddressAddress 2CityPhone No.Telex No.Territory CodeCurrency CodeLanguage CodeSalesperson CodeCountry/Region CodeCommentLast Date ModifiedFax No.Telex Answer BackVAT Registration No.PicturePost CodeCountyE-MailHome PageNo. SeriesType; [Company,Person]Company No.Company NameLookup Contact No.First NameMiddle Name...«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...<Contact No.><Business Relation Code><No.><No.><No.><Company No.><Lookup Contact No.><Primary Contact No.><Primary Contact 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. Code20 NotBlank: Yes
2 Business Relation Code Code10 NotBlank: Yes
3 Link to Table Option
4 No. Code20
5 Business Relation Description Text50 Editable: No
FlowField
6 Contact Name Text50 Editable: No
FlowField

Keys

# Fields
0 Contact No.,Business Relation Code Clustered: Yes
1 Link to Table,No.
2 Link to Table,Contact No.
3 Business Relation Code

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field