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 Date«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 Scheme«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. (Entry No.) Integer AutoIncrement: Yes
2 VAT Registration No. (VAT Registration No.) Text20 NotBlank: Yes
3 Account Type (Account Type) Option
4 Account No. (Account No.) Code20
5 Country/Region Code (Country/Region Code) Code10 NotBlank: Yes
6 User ID (User ID) Code50
10 Status (Status) Option
11 Verified Name (Verified Name) Text150
12 Verified Address (Verified Address) Text150
13 Verified Date (Verified Date) DateTime

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field