Diagrams


Table

Issued Reminder Header

DynamicsDocs.comIssued Reminder Header«Table 297»Issued Reminder HeaderNo. [PK,NN]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 CodeInterest PostedAdditional Fee PostedReminder LevelPosting DescriptionCommentRemaining Amount...«Table 298»Issued Reminder LineReminder No. [PK]Line No. [PK]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 300»Reminder/Fin. Charge EntryEntry No. [PK,NN]Type; [Reminder,Finance Charge Memo]No.Reminder LevelPosting DateDocument DateInterest PostedInterest AmountCustomer Entry No.Document Type; [,Payment,Invoice,Credi...Document No.Remaining AmountCustomer No.User IDDue Date«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 2000000120»UserUser Security ID [PK]User NameFull NameState; [Enabled,Disabled]Expiry DateWindows Security IDChange PasswordLicense Type; [Full User,Limited User,...Authentication EmailContact Email«Table 308»No. SeriesCode [PK,NN]DescriptionDefault Nos.Manual Nos.Date Order«Table 230»Source CodeCode [PK,NN]Description«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<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><User ID><No. Series><Pre-Assigned No. Series><Source Code><Tax Area Code><VAT Bus. Posting Group><Dimension Set ID><Reminder No.><No.><No.><Attached to Line No.><Customer No.><User ID><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>

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

Fields

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

Keys

# Fields
0 No. Clustered: Yes
1 Customer No.,Posting Date

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 No. Customer No. 1..n
Customer Posting Group Customer Posting Group Code 1..n
Dimension Set ID Dimension Set Entry 1..n
Shortcut Dimension 2 Code Dimension Value 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
Pre-Assigned No. Series No. Series Code 1..n
Reason Code Reason Code Code 1..n
Reminder Level Reminder Level No. 1..n
Reminder Terms Code Reminder Terms Code 1..n
Source Code Source Code Code 1..n
Tax Area Code Tax Area Code 1..n
User ID User User Name 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Issued Reminder Line Reminder No. 1..n
Reminder Comment Line No. 1..n
Reminder/Fin. Charge Entry No. 1..n