Diagrams


Table

Reminder Header

DynamicsDocs.comReminder Header«Table 295»Reminder HeaderNo. [PK]Customer No.NameName 2AddressAddress 2Post CodeCityCountyCountry/Region CodeLanguage CodeCurrency CodeContactYour ReferenceShortcut Dimension 1 CodeShortcut Dimension 2 CodeCustomer Posting GroupGen. Bus. Posting GroupVAT Registration No.Reason CodePosting DateDocument DateDue DateReminder Terms CodeFin. Charge Terms CodePost InterestPost Additional FeeReminder LevelPosting DescriptionCommentRemaining Amount...«Table 296»Reminder LineReminder No. [PK]Line No. [PK,NN]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.No. of RemindersPosting DateDocument DateDue DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionOriginal AmountRemaining AmountNo.AmountInterest RateGen. Prod. Posting GroupVAT %VAT Calculation Type; [Normal VAT,Reve...VAT AmountTax Group CodeVAT Prod. Posting GroupVAT IdentifierLine Type; [Reminder Line,Not Due,Begi...VAT Clause CodeApplies-to Document Type; [,Payment,In...Applies-to Document No.System-Created Entry«Table 299»Reminder Comment LineType; [Reminder,Issued Reminder] [PK]No. [PK,NN]Line No. [PK]DateCodeComment«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 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 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 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«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 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 231»Reason CodeCode [PK,NN]DescriptionDate FilterContract Gain/Loss Amount«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 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 293»Reminder LevelReminder Terms Code [PK,NN]No. [PK,NN]Grace PeriodAdditional Fee [LCY]Calculate InterestDue Date CalculationAdd. Fee per Line Amount [LCY]Add. Fee per Line DescriptionAdd. Fee Calculation Type; [Fixed,Sing...«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 318»Tax AreaCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 480»Dimension Set EntryDimension Set ID [PK]Dimension Code [PK,NN]Dimension Value Code [NN]Dimension Value IDDimension NameDimension Value Name«Table 91»User SetupUser ID [PK,NN]Allow Posting FromAllow Posting ToRegister TimeSalespers./Purch. CodeApprover IDSales Amount Approval LimitPurchase Amount Approval LimitUnlimited Sales ApprovalUnlimited Purchase ApprovalSubstituteE-MailRequest Amount Approval LimitUnlimited Request ApprovalApproval AdministratorLicense Type; [Full User,Limited User,...Time Sheet Admin.Allow FA Posting FromAllow FA Posting ToSales Resp. Ctr. FilterPurchase Resp. Ctr. FilterService Resp. Ctr. Filter<Customer No.><Country/Region Code><Language Code><Currency Code><Shortcut Dimension 1 Code><Shortcut Dimension 2 Code><Customer Posting Group><Gen. Bus. Posting Group><Reason Code><Reminder Terms Code><Fin. Charge Terms Code><Reminder Level><No. Series><Issuing No. Series><Tax Area Code><VAT Bus. Posting Group><Dimension Set ID><Assigned User ID><Reminder No.><No.><Attached to Line No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Customer Posting Group><Currency Code><Currency Filter><Customer Filter><Language Code><Fin. Charge Terms Code><Country/Region Code><Bill-to Customer No.><Gen. Bus. Posting Group><Reminder Terms Code><No. Series><Tax Area Code><VAT Bus. Posting Group><Global Dimension 1 Filter><Global Dimension 2 Filter><Dimension Value Code><Def. VAT Bus. Posting Group><Reminder Terms Code><Approver ID><Substitute>

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

Fields

# Name Type
1 No. (No.) Code20
2 Customer No. (Customer No.) Code20
3 Name (Name) Text50
4 Name 2 (Name 2) Text50
5 Address (Address) Text50
6 Address 2 (Address 2) Text50
7 Post Code (Post Code) Code20
8 City (City) Text30
9 County (County) Text30
10 Country/Region Code (Country/Region Code) Code10
11 Language Code (Language Code) Code10
12 Currency Code (Currency Code) Code10
13 Contact (Contact) Text50
14 Your Reference (Your Reference) Text30
15 Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) Code20
16 Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Code20
17 Customer Posting Group (Customer Posting Group) Code10 Editable: No
18 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10 Editable: No
19 VAT Registration No. (VAT Registration No.) Text20
20 Reason Code (Reason Code) Code10
21 Posting Date (Posting Date) Date
22 Document Date (Document Date) Date
23 Due Date (Due Date) Date
24 Reminder Terms Code (Reminder Terms Code) Code10
25 Fin. Charge Terms Code (Fin. Charge Terms Code) Code10
26 Post Interest (Post Interest) Boolean
27 Post Additional Fee (Post Additional Fee) Boolean
28 Reminder Level (Reminder Level) Integer
29 Posting Description (Posting Description) Text50
30 Comment (Comment) Boolean Editable: No
FlowField
31 Remaining Amount (Remaining Amount) Decimal (2:2) Editable: No
FlowField
32 Interest Amount (Interest Amount) Decimal Editable: No
FlowField
33 Additional Fee (Additional Fee) Decimal Editable: No
FlowField
34 VAT Amount (VAT Amount) Decimal Editable: No
FlowField
37 No. Series (No. Series) Code10 Editable: No
38 Issuing No. Series (Issuing No. Series) Code10
39 Issuing No. (Issuing No.) Code20
41 Tax Area Code (Tax Area Code) Code20
42 Tax Liable (Tax Liable) Boolean
43 VAT Bus. Posting Group (VAT Bus. Posting Group) Code10
44 Use Header Level (Use Header Level) Boolean
45 Add. Fee per Line (Add. Fee per Line) Decimal FlowField
46 Post Add. Fee per Line (Post Add. Fee per Line) Boolean
480 Dimension Set ID (Dimension Set ID) Integer Editable: No
9000 Assigned User ID (Assigned User ID) Code50

Keys

# Fields
0 No. (No.) Clustered: Yes
1 Customer No.,Currency Code (Customer No.,Currency Code)

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 No. (Customer No.) Customer No. (No.) 1..n
Customer Posting Group (Customer Posting Group) Customer Posting Group Code (Code) 1..n
Dimension Set ID (Dimension Set ID) Dimension Set Entry () 1..n
Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) Dimension Value 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
Issuing No. Series (Issuing No. Series) No. Series Code (Code) 1..n
Reason Code (Reason Code) Reason Code Code (Code) 1..n
Reminder Level (Reminder Level) Reminder Level No. (No.) 1..n
Reminder Terms Code (Reminder Terms Code) Reminder Terms Code (Code) 1..n
Tax Area Code (Tax Area Code) Tax Area Code (Code) 1..n
Assigned User ID (Assigned User ID) User Setup User ID (User ID) 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
Reminder Comment Line No. (No.) 1..n
Reminder Line Reminder No. (Reminder No.) 1..n