Diagrams

Table

Vendor Bank Account

DynamicsDocs.comVendor Bank Account«Table 288»Vendor Bank AccountVendor No. [PK,NN]Code [PK,NN]NameName 2AddressAddress 2CityPost CodeContactPhone No.Telex No.Bank Branch No.Bank Account No.Transit No.Currency CodeCountry/Region CodeCountyFax No.Telex Answer BackLanguage CodeE-MailHome PageIBANSWIFT CodeBank Clearing CodeBank Clearing Standard«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 25»Vendor Ledger EntryEntry No. [PK]Vendor No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Purchase [LCY]Inv. Discount [LCY]Buy-from Vendor No.Vendor Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodePurchaser CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Rcd.[LCY]PositiveClosed by Entry No....«Table 81»Gen. Journal LineJournal Template Name [PK]Line No. [PK]Account Type; [G/L Account,Customer,Ve...Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionVAT %Bal. Account No.Currency CodeAmountDebit AmountCredit AmountAmount [LCY]Balance [LCY]Currency FactorSales/Purch. [LCY]Profit [LCY]Inv. Discount [LCY]Bill-to/Pay-to No.Posting GroupShortcut Dimension 1 CodeShortcut Dimension 2 CodeSalespers./Purch. CodeSource CodeSystem-Created EntryOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.Due Date...«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...«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 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name«Table 1280»Bank Clearing StandardCode [PK]Description<Vendor No.><Preferred Bank Account Code><Currency Code><Country/Region Code><Language Code><Bank Clearing Standard><Recipient Bank Account><Recipient Bank Account><Currency Code><Currency Filter><Vendor Filter><Language Code><Country/Region Code><Pay-to Vendor No.><Vendor No.><Buy-from Vendor No.><Bal. Account No.><Account No.><Bal. Account No.><Bill-to/Pay-to No.><Source No.><Sell-to/Buy-from No.><Currency Code><Closed by Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Currency Code><Source Currency Code><Country/Region Code>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Vendor No. (Vendor No.) Code20 NotBlank: Yes
2 Code (Code) Code10 NotBlank: Yes
3 Name (Name) Text50
5 Name 2 (Name 2) Text50
6 Address (Address) Text50
7 Address 2 (Address 2) Text50
8 City (City) Text30
9 Post Code (Post Code) Code20
10 Contact (Contact) Text50
11 Phone No. (Phone No.) Text30 [Phone No.]
12 Telex No. (Telex No.) Text20
13 Bank Branch No. (Bank Branch No.) Text20
14 Bank Account No. (Bank Account No.) Text30
15 Transit No. (Transit No.) Text20
16 Currency Code (Currency Code) Code10
17 Country/Region Code (Country/Region Code) Code10
18 County (County) Text30
19 Fax No. (Fax No.) Text30
20 Telex Answer Back (Telex Answer Back) Text20
21 Language Code (Language Code) Code10
22 E-Mail (E-Mail) Text80 [E-Mail]
23 Home Page (Home Page) Text80 [URL]
24 IBAN (IBAN) Code50
25 SWIFT Code (SWIFT Code) Code20
1211 Bank Clearing Code (Bank Clearing Code) Text50
1212 Bank Clearing Standard (Bank Clearing Standard) Text50

Keys

# Fields
0 Vendor No.,Code (Vendor No.,Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bank Clearing Standard (Bank Clearing Standard) Bank Clearing Standard Code (Code) 1..n
Country/Region Code (Country/Region Code) Country/Region Code (Code) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Language Code (Language Code) Language Code (Code) 1..n
Vendor No. (Vendor No.) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Gen. Journal Line Recipient Bank Account (Recipient Bank Account) 1..n
Vendor Preferred Bank Account Code (Preferred Bank Account Code) 1..n
Vendor Ledger Entry Recipient Bank Account (Recipient Bank Account) 1..n