Diagrams

Table

Finance Charge Memo Line

DynamicsDocs.comFinance Charge Memo Line«Table 303»Finance Charge Memo LineFinance Charge Memo No. [PK]Line No. [PK,NN]Attached to Line No.Type; [,G/L Account,Customer Ledger En...Entry No.Posting 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; [Finance Charge Memo Line,B...VAT Clause CodeSystem-Created Entry«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 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 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc.Consol. Credit Acc.Business Unit Filter...«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 321»Tax GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 560»VAT ClauseCode [PK,NN]DescriptionDescription 2<Finance Charge Memo 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 Finance Charge Memo No. (Finance Charge Memo No.) Code20
2 Line No. (Line No.) Integer NotBlank: Yes
3 Attached to Line No. (Attached to Line No.) Integer Editable: No
4 Type (Type) Option
5 Entry No. (Entry No.) Integer BlankZero: Yes
7 Posting Date (Posting Date) Date Editable: No
8 Document Date (Document Date) Date Editable: No
9 Due Date (Due Date) Date Editable: No
10 Document Type (Document Type) Option
11 Document No. (Document No.) Code20
12 Description (Description) Text100
13 Original Amount (Original Amount) Decimal BlankZero: Yes
Editable: No
14 Remaining Amount (Remaining Amount) Decimal BlankZero: Yes
Editable: No
15 No. (No.) Code20
16 Amount (Amount) Decimal BlankZero: Yes
17 Interest Rate (Interest Rate) Decimal (0:5)
18 Gen. Prod. Posting Group (Gen. Prod. Posting Group) Code10
19 VAT % (VAT %) Decimal (0:5) Editable: No
20 VAT Calculation Type (VAT Calculation Type) Option Editable: No
21 VAT Amount (VAT Amount) Decimal BlankZero: Yes
Editable: No
22 Tax Group Code (Tax Group Code) Code10
23 VAT Prod. Posting Group (VAT Prod. Posting Group) Code10
24 VAT Identifier (VAT Identifier) Code10 Editable: No
25 Line Type (Line Type) Option
26 VAT Clause Code (VAT Clause Code) Code10
101 System-Created Entry (System-Created Entry) Boolean Editable: No

Keys

# Fields
0 Finance Charge Memo No.,Line No. (Finance Charge Memo No.,Line No.) Clustered: Yes
MaintainSIFTIndex: No
1 Finance Charge Memo No.,Type (Finance Charge Memo No.,Type) MaintainSQLIndex: No
MaintainSIFTIndex: No

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Finance Charge Memo Line Attached to Line No. (Attached to Line No.) 1..n