Diagrams


Table

Payment Application Proposal

DynamicsDocs.comPayment Application Proposal«Table 1293»Payment Application ProposalBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Statement Type; [Bank Reconciliation,P...Account Type; [G/L Account,Customer,Ve...Account No. [PK]Applies-to Entry No. [PK]Applied AmountAppliedApplied Pmt. DiscountQualityPosting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeDue DateExternal Document No.Match Confidence; [None,Low,Medium,Hig...Pmt. Disc. Due DateRemaining Pmt. Disc. PossiblePmt. Disc. Tolerance DateApplied Amt. Incl. DiscountRemaining AmountRemaining Amt. Incl. DiscountType; [Bank Account Ledger Entry,Check...Sorting OrderStmt To Rem. Amount Difference«Table 270»Bank AccountNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Bank Account No.Transit No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameMin. BalanceBank Acc. Posting GroupCurrency CodeLanguage CodeStatistics GroupOur Contact CodeCountry/Region CodeAmountCommentBlockedLast Statement No.Last Payment Statement No.Last Date ModifiedDate FilterGlobal Dimension 1 Filter...«Table 273»Bank Acc. ReconciliationBank Account No. [PK,NN]Statement No. [PK,NN]Statement Ending BalanceStatement DateBalance Last StatementBank StatementTotal Balance on Bank AccountTotal Applied AmountTotal Transaction AmountTotal Unposted Applied AmountTotal DifferenceStatement Type; [Bank Reconciliation,P...Shortcut Dimension 1 CodeShortcut Dimension 2 CodePost Payments OnlyImport Posted Transactions; [,Yes,No]Total Outstd Bank TransactionsTotal Outstd PaymentsTotal Applied Amount PaymentsBank Account Balance [LCY]Total Positive AdjustmentsTotal Negative AdjustmentsTotal Positive DifferenceTotal Negative DifferenceDimension Set ID«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 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....«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 5600»Fixed AssetNo. [PK]DescriptionSearch DescriptionDescription 2FA Class CodeFA Subclass CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeLocation CodeFA Location CodeVendor No.Main Asset/Component; [,Main Asset,Com...Component of Main AssetBudgeted AssetWarranty DateResponsible EmployeeSerial No.Last Date ModifiedInsuredCommentBlockedPictureMaintenance Vendor No.Under MaintenanceNext Service DateInactiveFA Posting Date FilterNo. SeriesFA Posting GroupAcquiredImage...«Table 413»IC PartnerCode [PK,NN]NameCurrency CodeInbox Type; [File Location,Database,Em...Inbox DetailsReceivables AccountPayables AccountBlockedCommentCustomer No.Vendor No.Outbound Sales Item No. Type; [Interna...Outbound Purch. Item No. Type; [Intern...Cost Distribution in LCY«Table 17»G/L EntryEntry No. [PK]G/L Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionBal. Account No.AmountGlobal Dimension 1 CodeGlobal Dimension 2 CodeUser IDSource CodeSystem-Created EntryPrior-Year EntryJob No.QuantityVAT AmountBusiness Unit CodeJournal Batch NameReason CodeGen. Posting Type; [,Purchase,Sale,Set...Gen. Bus. Posting GroupGen. Prod. Posting GroupBal. Account Type; [G/L Account,Custom...Transaction No.Debit AmountCredit AmountDocument DateExternal Document No.Source Type; [,Customer,Vendor,Bank Ac...Source No....«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 25»Vendor Ledger EntryEntry No. [PK]Vendor No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountOriginal Amt. [LCY]Remaining Amt. [LCY]Amount [LCY]Purchase [LCY]Inv. Discount [LCY]Buy-from Vendor No.Vendor Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodePurchaser CodeUser IDSource CodeOn HoldApplies-to Doc. Type; [,Payment,Invoic...Applies-to Doc. No.OpenDue DatePmt. Discount DateOriginal Pmt. Disc. PossiblePmt. Disc. Rcd.[LCY]PositiveClosed by Entry No....«Table 271»Bank Account Ledger EntryEntry No. [PK]Bank Account No.Posting DateDocument Type; [,Payment,Invoice,Credi...Document No.DescriptionCurrency CodeAmountRemaining AmountAmount [LCY]Bank Acc. Posting GroupGlobal Dimension 1 CodeGlobal Dimension 2 CodeOur Contact CodeUser IDSource CodeOpenPositiveClosed by Entry No.Closed at DateJournal Batch NameReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.Transaction No.Statement Status; [Open,Bank Acc. Entr...Statement No.Statement Line No.Debit AmountCredit AmountDebit Amount [LCY]...«Table 4»CurrencyCode [PK,NN]Last Date ModifiedLast Date AdjustedUnrealized Gains Acc.Realized Gains Acc.Unrealized Losses Acc.Realized Losses Acc.Invoice Rounding PrecisionInvoice Rounding Type; [Nearest,Up,Dow...Amount Rounding PrecisionUnit-Amount Rounding PrecisionDescriptionAmount Decimal Places [NN]Unit-Amount Decimal Places [NN]Customer FilterVendor FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterCust. Ledg. Entries in FilterCustomer BalanceCustomer Outstanding OrdersCustomer Shipped Not InvoicedCustomer Balance DueVendor Ledg. Entries in FilterVendor BalanceVendor Outstanding OrdersVendor Amt. Rcd. Not InvoicedVendor Balance DueCustomer Balance [LCY]Vendor Balance [LCY]...<Bank Account No.><Account No.><Statement No.><Account No.><Account No.><Account No.><Account No.><Account No.><Applies-to Entry No.><Applies-to Entry No.><Applies-to Entry No.><Applies-to Entry No.><Currency Code><Currency Code><Bal. Account No.><Source No.><Bal. Account No.><Bal. Account No.><Bank Account No.><Bal. Account No.><Bank Account No.><G/L Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Receivables Account><Payables Account><Unrealized Gains Acc.><Realized Gains Acc.><Unrealized Losses Acc.><Realized Losses Acc.><Realized G/L Gains Account><Realized G/L Losses Account><Residual Gains Account><Residual Losses Account><Conv. LCY Rndg. Debit Acc.><Conv. LCY Rndg. Credit Acc.><Currency Code><Currency Filter><Customer Filter><Bill-to Customer No.><IC Partner Code><Customer No.><Bal. Account No.><Source No.><Customer No.><Sell-to Customer No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Currency Code><Currency Filter><Vendor Filter><Pay-to Vendor No.><IC Partner Code><Vendor No.><Bal. Account No.><Source No.><Bal. Account No.><Vendor No.><Buy-from Vendor No.><Bal. Account No.><Bal. Account No.><Vendor No.><Maintenance Vendor No.><Component of Main Asset><Bal. Account No.><Source No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Currency Code><Bal. Account No.><IC Partner Code><IC Partner Code><IC Partner Code><Reversed by Entry No.><Reversed Entry No.><Currency Code><Closed by Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Currency Code><Closed by Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.><Currency Code><Closed by Entry No.><Reversed by Entry No.><Reversed Entry No.>

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

Fields

# Name Type
1 Bank Account No. Code20
2 Statement No. Code20
3 Statement Line No. Integer
20 Statement Type Option
21 Account Type Option
22 Account No. Code20
23 Applies-to Entry No. Integer
24 Applied Amount Decimal
25 Applied Boolean
29 Applied Pmt. Discount Decimal
30 Quality Integer
31 Posting Date Date
32 Document Type Option
33 Document No. Code20
34 Description Text50
35 Currency Code Code10 Editable: No
36 Due Date Date Editable: No
37 External Document No. Code35
50 Match Confidence Option Editable: No
51 Pmt. Disc. Due Date Date
52 Remaining Pmt. Disc. Possible Decimal
53 Pmt. Disc. Tolerance Date Date
60 Applied Amt. Incl. Discount Decimal
61 Remaining Amount Decimal Editable: No
62 Remaining Amt. Incl. Discount Decimal Editable: No
63 Type Option
100 Sorting Order Integer Editable: No
101 Stmt To Rem. Amount Difference Decimal Editable: No

Keys

# Fields
0 Statement Type,Bank Account No.,Statement No.,Statement Line No.,Account Type,Account No.,Applies-to Entry No. Clustered: Yes
1 Applied,Quality
2 Sorting Order
3 Applied,Account Type,Account No.,Type

Table Relations To Other Tables

Field Related Table Related Field
Statement No. Bank Acc. Reconciliation Statement No. 1..n
Account No. Bank Account No. 1..n
Applies-to Entry No. Bank Account Ledger Entry 1..n
Currency Code Currency Code 1..n
Applies-to Entry No. Cust. Ledger Entry 1..n
Account No. Customer No. 1..n
Account No. Fixed Asset No. 1..n
Account No. G/L Account 1..n
Applies-to Entry No. G/L Entry Entry No. 1..n
Account No. IC Partner Code 1..n
Account No. Vendor No. 1..n
Applies-to Entry No. Vendor Ledger Entry 1..n

Table Relations From Other Tables

From Table From Field