Diagrams


Table

Posted Payment Recon. Line

DynamicsDocs.comPosted Payment Recon. Line«Table 1296»Posted Payment Recon. LineBank Account No. [PK]Statement No. [PK]Statement Line No. [PK]Document No.Transaction DateDescriptionStatement AmountDifferenceApplied AmountType; [Bank Account Ledger Entry,Check...Applied EntriesValue DateCheck No.Related-Party NameAdditional Transaction InfoData Exch. Entry No.Data Exch. Line No.Account Type; [G/L Account,Customer,Ve...Account No.Applied Document No.Applied Entry No.Transaction IDReconciled«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 1220»Data Exch.Entry No. [PK]File NameFile ContentData Exch. Def CodeData Exch. Line Def CodeTable FiltersIncoming Entry No.Related Record«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<Bank Account No.><Account No.><Statement No.><Data Exch. Entry No.><Account No.><Account No.><Account No.><Account No.><Account No.><Bank Account No.><Receivables Account><Payables Account><Bill-to Customer No.><IC Partner Code><Customer No.><Pay-to Vendor No.><IC Partner Code><Vendor No.><Vendor No.><Maintenance Vendor No.><Component of Main Asset>

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
4 Document No. Code20
5 Transaction Date Date
6 Description Text50
7 Statement Amount Decimal
8 Difference Decimal
9 Applied Amount Decimal Editable: No
10 Type Option
11 Applied Entries Integer Editable: No
12 Value Date Date
14 Check No. Code20
15 Related-Party Name Text250
16 Additional Transaction Info Text100
17 Data Exch. Entry No. Integer Editable: No
18 Data Exch. Line No. Integer Editable: No
21 Account Type Option
22 Account No. Code20
23 Applied Document No. Text250
24 Applied Entry No. Text250
70 Transaction ID Text250
71 Reconciled Boolean

Keys

# Fields
0 Bank Account No.,Statement No.,Statement Line No. Clustered: Yes
MaintainSIFTIndex: No

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
Account No. Customer No. 1..n
Data Exch. Entry No. Data Exch. Entry No. 1..n
Account No. Fixed Asset No. 1..n
Account No. G/L Account 1..n
Account No. IC Partner Code 1..n
Account No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field