Diagrams


Table

Reminder/Fin. Charge Entry

DynamicsDocs.comReminder/Fin. Charge Entry«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 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 304»Issued Fin. Charge Memo 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 DateFin. Charge Terms CodeInterest PostedAdditional Fee PostedPosting DescriptionCommentRemaining AmountInterest AmountAdditional Fee...«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 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 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<No.><No.><Customer Entry No.><Customer No.><User ID><Customer No.><User ID><Customer No.><User ID><Customer No.><Sell-to Customer No.><Bal. Account No.><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Bill-to Customer No.>

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

Fields

# Name Type
1 Entry No. Integer NotBlank: Yes
2 Type Option
3 No. Code20
4 Reminder Level Integer
5 Posting Date Date
6 Document Date Date
7 Interest Posted Boolean
8 Interest Amount Decimal
9 Customer Entry No. Integer
10 Document Type Option
11 Document No. Code20
12 Remaining Amount Decimal
13 Customer No. Code20
14 User ID Code50
15 Due Date Date

Keys

# Fields
0 Entry No. Clustered: Yes
1 Customer No.
2 Customer Entry No.,Type
3 Type,No.
4 Document No.,Posting Date

Table Relations To Other Tables

Field Related Table Related Field
Customer Entry No. Cust. Ledger Entry Entry No. 1..n
Customer No. Customer No. 1..n
No. Issued Fin. Charge Memo Header No. 1..n
No. Issued Reminder Header No. 1..n
User ID User User Name 1..n

Table Relations From Other Tables

From Table From Field