Diagrams


Table

VAT Registration Log

DynamicsDocs.comVAT Registration Log«Table 249»VAT Registration LogEntry No. [PK]VAT Registration No. [NN]Account Type; [Customer,Vendor,Contact...Account No.Country/Region Code [NN]User IDStatus; [Not Verified,Valid,Invalid]Verified NameVerified AddressVerified DateRequest IdentifierVerified StreetVerified PostcodeVerified City«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 9»Country/RegionCode [PK,NN]NameEU Country/Region CodeIntrastat CodeAddress Format; [Post Code+City,City+P...Contact Address Format; [First,After C...VAT SchemeLast Modified Date TimeId«Table 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact EmailExchange IdentifierApplication ID<Account No.><Account No.><Country/Region Code><User ID><Country/Region Code><Bill-to Customer No.><Country/Region Code><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 Entry No. Integer AutoIncrement: Yes
2 VAT Registration No. Text20 NotBlank: Yes
3 Account Type Option
4 Account No. Code20
5 Country/Region Code Code10 NotBlank: Yes
6 User ID Code50
10 Status Option
11 Verified Name Text150
12 Verified Address Text150
13 Verified Date DateTime
14 Request Identifier Text200
15 Verified Street Text50
16 Verified Postcode Text20
17 Verified City Text30

Keys

# Fields
0 Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code Country/Region Code 1..n
Account No. Customer No. 1..n
User ID User User Name 1..n
Account No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field