Diagrams

Table

Customer Bank Account

DynamicsDocs.comCustomer Bank Account«Table 287»Customer Bank AccountCustomer 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 1230»SEPA Direct Debit MandateID [PK]Customer No. [NN]Customer Bank Account Code [NN]Valid FromValid ToDate of Signature [NN]Type of Payment; [OneOff,Recurrent]BlockedExpected Number of DebitsDebit CounterNo. SeriesClosed«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 21»Cust. Ledger EntryEntry No. [PK]Customer No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Sales [LCY]Profit [LCY]Inv. Discount [LCY]Sell-to Customer No.Customer Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalesperson CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Given [LCY]Positive...«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<Customer No.><Preferred Bank Account Code><Currency Code><Country/Region Code><Language Code><Bank Clearing Standard><Customer Bank Account Code><Recipient Bank Account><Recipient Bank Account><Customer No.><Direct Debit Mandate ID><Direct Debit Mandate ID><Currency Code><Currency Filter><Customer Filter><Language Code><Country/Region Code><Bill-to Customer No.><Customer No.><Sell-to Customer 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 Customer No. (Customer 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 Customer No.,Code (Customer 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
Customer No. (Customer No.) Customer No. (No.) 1..n
Language Code (Language Code) Language Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Cust. Ledger Entry Recipient Bank Account (Recipient Bank Account) 1..n
Customer Preferred Bank Account Code (Preferred Bank Account Code) 1..n
Gen. Journal Line Recipient Bank Account (Recipient Bank Account) 1..n
SEPA Direct Debit Mandate Customer Bank Account Code (Customer Bank Account Code) 1..n