Diagrams


Table

Payment Registration Buffer

DynamicsDocs.comPayment Registration Buffer«Table 981»Payment Registration BufferLedger Entry No. [PK]Source No.Document Type; [,Payment,Invoice,Credi...Document No.DescriptionDue DateNameRemaining AmountPayment MadeDate ReceivedAmount ReceivedOriginal Remaining AmountRem. Amt. after DiscountPmt. Discount DateLimit Amount ReceivedPayment Method CodeBal. Account Type; [G/L Account,Bank A...Bal. Account No.«Table 289»Payment MethodCode [PK,NN]DescriptionBal. Account Type; [G/L Account,Bank A...Bal. Account No.Direct DebitDirect Debit Pmt. Terms CodePmt. Export Line DefinitionBank Data Conversion Pmt. TypeUse for InvoicingLast Modified Date TimeId«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 Modified Date TimeLast Date ModifiedDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudget at DateConsol. Translation Method; [Average R...Consol. Debit Acc....«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...<Payment Method Code><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.>

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

Fields

# Name Type
1 Ledger Entry No. Integer
2 Source No. Code20
3 Document Type Option
4 Document No. Code20
5 Description Text50
6 Due Date Date
7 Name Text50
8 Remaining Amount Decimal
9 Payment Made Boolean
10 Date Received Date
11 Amount Received Decimal
12 Original Remaining Amount Decimal
13 Rem. Amt. after Discount Decimal
14 Pmt. Discount Date Date
15 Limit Amount Received Boolean
16 Payment Method Code Code10
17 Bal. Account Type Option
18 Bal. Account No. Code20

Keys

# Fields
0 Ledger Entry No. Clustered: Yes
1 Due Date

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. Bank Account No. 1..n
Bal. Account No. G/L Account No. 1..n
Payment Method Code Payment Method 1..n

Table Relations From Other Tables

From Table From Field