Diagrams

Table

Finance Charge Terms

DynamicsDocs.comFinance Charge Terms«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 1300»Mini Customer TemplateKey [PK]Code [NN]Template Name [NN]CityDocument Sending ProfileCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodePayment Terms CodeFin. Charge Terms CodeCustomer Disc. GroupCountry/Region CodePrint StatementsPayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyReminder Terms CodeVAT Bus. Posting GroupBlock Payment ToleranceAllow Line Disc.«Table 1303»Mini Vendor TemplateKey [PK]Code [NN]Template Name [NN]CityVendor Posting GroupCurrency CodeLanguage CodePayment Terms CodeFin. Charge Terms CodeInvoice Disc. CodeCountry/Region CodePayment Method CodeApplication Method; [Manual,Apply to O...Prices Including VATGen. Bus. Posting GroupPost CodeCountyVAT Bus. Posting GroupBlock Payment Tolerance«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 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«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 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 301»Finance Charge TextFin. Charge Terms Code [PK,NN]Position; [Beginning,Ending] [PK]Line No. [PK]Text«Table 302»Finance Charge Memo 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 DateFin. Charge Terms CodePost InterestPost Additional FeePosting DescriptionCommentRemaining AmountInterest AmountAdditional Fee...«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 328»Currency for Fin. Charge TermsFin. Charge Terms Code [PK,NN]Currency Code [PK,NN]Additional Fee<Fin. Charge Terms Code><Fin. Charge Terms Code><Fin. Charge Terms Code><Fin. Charge Terms Code><Fin. Charge Terms Code><Fin. Charge Terms Code><Fin. Charge Terms Code><Fin. Charge Terms Code><Fin. Charge Terms Code><Fin. Charge Terms Code><Invoice Disc. Code><Bill-to Customer No.><Customer No.><Customer No.><Customer No.><Customer No.><Pay-to Vendor No.>

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

Fields

# Name Type
1 Code (Code) Code10 NotBlank: Yes
2 Interest Rate (Interest Rate) Decimal (0:5)
3 Minimum Amount (LCY) (Minimum Amount (LCY)) Decimal
5 Additional Fee (LCY) (Additional Fee (LCY)) Decimal
7 Description (Description) Text50
8 Interest Calculation Method (Interest Calculation Method) Option
9 Interest Period (Days) (Interest Period (Days)) Integer
10 Grace Period (Grace Period) DateFormula
11 Due Date Calculation (Due Date Calculation) DateFormula
12 Interest Calculation (Interest Calculation) Option
13 Post Interest (Post Interest) Boolean
14 Post Additional Fee (Post Additional Fee) Boolean
15 Line Description (Line Description) Text50
16 Add. Line Fee in Interest (Add. Line Fee in Interest) Boolean

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Currency for Fin. Charge Terms Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Customer Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Finance Charge Memo Header Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Finance Charge Text Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Issued Fin. Charge Memo Header Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Issued Reminder Header Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Mini Customer Template Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Mini Vendor Template Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Reminder Header Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n
Vendor Fin. Charge Terms Code (Fin. Charge Terms Code) 1..n