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 EmailExchange IdentifierApplication ID«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. (No.) Code20 NotBlank: Yes
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) Text35
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
18 Gen. Bus. Posting Group (Gen. Bus. Posting Group) Code10
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 Interest Posted (Interest Posted) Boolean
27 Additional Fee Posted (Additional Fee Posted) 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 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
35 No. Printed (No. Printed) Integer
36 User ID (User ID) Code50
37 No. Series (No. Series) Code10 Editable: No
38 Pre-Assigned No. Series (Pre-Assigned No. Series) Code10
39 Pre-Assigned No. (Pre-Assigned No.) Code20
40 Source Code (Source Code) Code10
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 Add. Fee per Line (Add. Fee per Line) Decimal FlowField
480 Dimension Set ID (Dimension Set ID) Integer Editable: No

Keys

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

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
Pre-Assigned No. Series (Pre-Assigned 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
Source Code (Source Code) Source Code Code (Code) 1..n
Tax Area Code (Tax Area Code) Tax Area Code (Code) 1..n
User ID (User ID) User User Name (User Name) 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
Issued Reminder Line Reminder No. (Reminder No.) 1..n
Reminder Comment Line No. (No.) 1..n
Reminder/Fin. Charge Entry No. (No.) 1..n