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. (Entry No.) Integer NotBlank: Yes
2 Type (Type) Option
3 No. (No.) Code20
4 Reminder Level (Reminder Level) Integer
5 Posting Date (Posting Date) Date
6 Document Date (Document Date) Date
7 Interest Posted (Interest Posted) Boolean
8 Interest Amount (Interest Amount) Decimal
9 Customer Entry No. (Customer Entry No.) Integer
10 Document Type (Document Type) Option
11 Document No. (Document No.) Code20
12 Remaining Amount (Remaining Amount) Decimal
13 Customer No. (Customer No.) Code20
14 User ID (User ID) Code50
15 Due Date (Due Date) Date

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field