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.Validate EU Vat Reg. No.«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 AccountDescriptionUsed in CustomersUsed in Ledger Entries«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. MemosLast Modified Date TimeId«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 SchemeLast Modified Date TimeId«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. TypeUse for InvoicingLast Modified Date TimeId«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]DescriptionLast Modified Date TimeId<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 Integer AutoIncrement: Yes
2 Code Code10 NotBlank: Yes
3 Template Name Text50 NotBlank: Yes
7 City Text30
11 Document Sending Profile Code20
20 Credit Limit (LCY) Decimal
21 Customer Posting Group Code20
22 Currency Code Code10
23 Customer Price Group Code10
24 Language Code Code10
27 Payment Terms Code Code10
28 Fin. Charge Terms Code Code10
34 Customer Disc. Group Code20
35 Country/Region Code Code10
42 Print Statements Boolean
47 Payment Method Code Code10
80 Application Method Option
82 Prices Including VAT Boolean
88 Gen. Bus. Posting Group Code20
91 Post Code Code20
92 County Text30
104 Reminder Terms Code Code10
110 VAT Bus. Posting Group Code20
116 Block Payment Tolerance Boolean
7001 Allow Line Disc. Boolean
7602 Validate EU Vat Reg. No. Boolean

Keys

# Fields
0 Key Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field