Diagrams


Table

Reminder Line

DynamicsDocs.comReminder Line«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 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 21»Cust. Ledger EntryEntry No. [PK]Customer No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Sales [LCY]Profit [LCY]Inv. Discount [LCY]Sell-to Customer No.Customer Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeSalesperson CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Given [LCY]Positive...«Table 7»Standard TextCode [PK,NN]Description«Table 15»G/L AccountNo. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Global Dimension 1 CodeGlobal Dimension 2 CodeAccount Category; [,Assets,Liabilities...Income/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 321»Tax GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 324»VAT Product Posting GroupCode [PK,NN]DescriptionIdLast Modified DateTime«Table 560»VAT ClauseCode [PK,NN]DescriptionDescription 2Last Modified DateTimeId<Reminder No.><Attached to Line No.><Entry No.><No.><No.><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><VAT Clause Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bal. Account No.><Gen. Prod. Posting Group><Tax Group Code><VAT Prod. Posting Group><Def. VAT Prod. Posting Group>

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

Fields

# Name Type
1 Reminder No. Code20
2 Line No. Integer NotBlank: Yes
3 Attached to Line No. Integer Editable: No
4 Type Option
5 Entry No. Integer BlankZero: Yes
6 No. of Reminders Integer
7 Posting Date Date Editable: No
8 Document Date Date Editable: No
9 Due Date Date Editable: No
10 Document Type Option
11 Document No. Code20
12 Description Text100
13 Original Amount Decimal BlankZero: Yes
Editable: No
14 Remaining Amount Decimal BlankZero: Yes
Editable: No
15 No. Code20
16 Amount Decimal BlankZero: Yes
17 Interest Rate Decimal (0:5)
18 Gen. Prod. Posting Group Code20
19 VAT % Decimal (0:5) Editable: No
20 VAT Calculation Type Option Editable: No
21 VAT Amount Decimal BlankZero: Yes
Editable: No
22 Tax Group Code Code20
23 VAT Prod. Posting Group Code20
24 VAT Identifier Code20 Editable: No
25 Line Type Option
26 VAT Clause Code Code20
27 Applies-to Document Type Option
28 Applies-to Document No. Code20
101 System-Created Entry Boolean Editable: No

Keys

# Fields
0 Reminder No.,Line No. Clustered: Yes
MaintainSIFTIndex: No
1 Reminder No.,Type,Line Type MaintainSQLIndex: No
MaintainSIFTIndex: No

Table Relations To Other Tables

Field Related Table Related Field
Entry No. Cust. Ledger Entry Entry No. 1..n
No. G/L Account No. 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Reminder No. Reminder Header No. 1..n
Attached to Line No. Reminder Line Line No. 1..n
No. Standard Text Code 1..n
Tax Group Code Tax Group Code 1..n
VAT Clause Code VAT Clause Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field
Reminder Line Attached to Line No. 1..n