Diagrams

Table

Mini Customer Template

DynamicsDocs.comMini Customer Template«Table 1300»Mini Customer TemplateKey [PK]Code [NN]Template Name [NN]CityDocument Sending ProfileCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodePayment Terms CodeFin. Charge Terms CodeCustomer Disc. GroupCountry/Region CodePrint StatementsPayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyReminder Terms CodeVAT Bus. Posting GroupBlock Payment ToleranceAllow Line Disc.«Table 60»Document Sending ProfileCode [PK,NN]DescriptionPrinter; [No,Yes <Prompt for Settings>...E-Mail; [No,Yes <Prompt for Settings>,...E-Mail Attachment; [PDF,Electronic Doc...E-Mail FormatDisk; [No,PDF,Electronic Document,PDF...Disk FormatElectronic Document; [No,Through Docum...Electronic FormatDefaultSend To; [Disk,Email,Print,Electronic...Usage; [Sales Invoice,Sales Credit Mem...One Related Party Selected«Table 92»Customer Posting GroupCode [PK,NN]Receivables AccountService Charge Acc.Payment Disc. Debit Acc.Invoice Rounding AccountAdditional Fee AccountInterest AccountDebit Curr. Appln. Rndg. Acc.Credit Curr. Appln. Rndg. Acc.Debit Rounding AccountCredit Rounding AccountPayment Disc. Credit Acc.Payment Tolerance Debit Acc.Payment Tolerance Credit Acc.Add. Fee per Line Account«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 6»Customer Price GroupCode [PK,NN]Price Includes VATAllow Invoice Disc.VAT Bus. Posting Gr. [Price]DescriptionAllow Line Disc.«Table 8»LanguageCode [PK,NN]NameWindows Language IDWindows Language Name«Table 3»Payment TermsCode [PK,NN]Due Date CalculationDiscount Date CalculationDiscount %DescriptionCalc. Pmt. Disc. on Cr. Memos«Table 5»Finance Charge TermsCode [PK,NN]Interest RateMinimum Amount [LCY]Additional Fee [LCY]DescriptionInterest Calculation Method; [Average...Interest Period [Days]Grace PeriodDue Date CalculationInterest Calculation; [Open Entries,Cl...Post InterestPost Additional FeeLine DescriptionAdd. Line Fee in Interest«Table 340»Customer Discount GroupCode [PK,NN]Description«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 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. Type«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 292»Reminder TermsCode [PK,NN]DescriptionPost InterestPost Additional FeeMax. No. of RemindersMinimum Amount [LCY]Post Add. Fee per LineNote About Line Fee on Report«Table 323»VAT Business Posting GroupCode [PK,NN]Description<Document Sending Profile><Customer Posting Group><Currency Code><Customer Price Group><Language Code><Payment Terms Code><Fin. Charge Terms Code><Customer Disc. Group><Country/Region Code><Payment Method Code><Gen. Bus. Posting Group><Reminder Terms Code><VAT Bus. Posting Group><VAT Bus. Posting Gr. (Price)><Direct Debit Pmt. Terms Code><Def. VAT Bus. Posting Group>

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

Fields

# Name Type
1 Key (Key) Integer AutoIncrement: Yes
2 Code (Code) Code10 NotBlank: Yes
3 Template Name (Template Name) Text50 NotBlank: Yes
7 City (City) Text30
11 Document Sending Profile (Document Sending Profile) Code20
20 Credit Limit (LCY) (Credit Limit (LCY)) Decimal
21 Customer Posting Group (Customer Posting Group) Code10
22 Currency Code (Currency Code) Code10
23 Customer Price Group (Customer Price Group) Code10
24 Language Code (Language Code) Code10
27 Payment Terms Code (Payment Terms Code) Code10
28 Fin. Charge Terms Code (Fin. Charge Terms Code) Code10
34 Customer Disc. Group (Customer Disc. Group) Code20
35 Country/Region Code (Country/Region Code) Code10
42 Print Statements (Print Statements) Boolean
47 Payment Method Code (Payment Method Code) Code10
80 Application Method (Application Method) Option
82 Prices Including VAT (Prices Including VAT) Boolean
88 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
91 Post Code (Post Code) Code20
92 County (County) Text30
104 Reminder Terms Code (Reminder Terms Code) Code10
110 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
116 Block Payment Tolerance (Block Payment Tolerance) Boolean
7001 Allow Line Disc. (Allow Line Disc.) Boolean

Keys

# Fields
0 Key (Key) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Country/Region Code (Country/Region Code) Country/Region Code (Code) 1..n
Currency Code (Currency Code) Currency Code (Code) 1..n
Customer Disc. Group (Customer Disc. Group) Customer Discount Group Code (Code) 1..n
Customer Posting Group (Customer Posting Group) Customer Posting Group Code (Code) 1..n
Customer Price Group (Customer Price Group) Customer Price Group Code (Code) 1..n
Document Sending Profile (Document Sending Profile) Document Sending Profile Code (Code) 1..n
Fin. Charge Terms Code (Fin. Charge Terms Code) Finance Charge Terms Code (Code) 1..n
Gen. Bus. Posting Group (Gen. Bus. Posting Group) Gen. Business Posting Group Code (Code) 1..n
Language Code (Language Code) Language Code (Code) 1..n
Payment Method Code (Payment Method Code) Payment Method Code (Code) 1..n
Payment Terms Code (Payment Terms Code) Payment Terms Code (Code) 1..n
Reminder Terms Code (Reminder Terms Code) Reminder Terms Code (Code) 1..n
VAT Bus. Posting Group (VAT Bus. Posting Group) VAT Business Posting Group Code (Code) 1..n

Table Relations From Other Tables

From Table From Field