Diagrams


Table

Payment Registration Setup

DynamicsDocs.comPayment Registration Setup«Table 980»Payment Registration SetupUser ID [PK]Journal Template NameJournal Batch NameBal. Account Type; [,G/L Account,Bank...Bal. Account No.Use this Account as Def.Auto Fill Date Received«Table 80»Gen. Journal TemplateName [PK,NN]DescriptionTest Report IDPage IDPosting Report IDForce Posting ReportType; [General,Sales,Purchases,Cash Re...Source CodeReason CodeRecurringTest Report CaptionPage CaptionPosting Report CaptionForce Doc. BalanceBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceCust. Receipt Report IDCust. Receipt Report CaptionVendor Receipt Report IDVendor Receipt Report Caption«Table 232»Gen. Journal BatchJournal Template Name [PK,NN]Name [PK,NN]DescriptionReason CodeBal. Account Type; [G/L Account,Custom...Bal. Account No.No. SeriesPosting No. SeriesCopy VAT Setup to Jnl. LinesAllow VAT DifferenceAllow Payment ExportBank Statement Import FormatTemplate Type; [General,Sales,Purchase...RecurringSuggest Balancing Amount«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 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...<Journal Template Name><Journal Batch Name><Bal. Account No.><Bal. Account No.><Bal. Account No.><Bal. Account No.><Journal Template Name><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 User ID (User ID) Code50
2 Journal Template Name (Journal Template Name) Code10
3 Journal Batch Name (Journal Batch Name) Code10
4 Bal. Account Type (Bal. Account Type) Option
5 Bal. Account No. (Bal. Account No.) Code20
6 Use this Account as Def. (Use this Account as Def.) Boolean
7 Auto Fill Date Received (Auto Fill Date Received) Boolean

Keys

# Fields
0 User ID (User ID) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Bal. Account No. (Bal. Account No.) Bank Account No. (No.) 1..n
Bal. Account No. (Bal. Account No.) G/L Account No. (No.) 1..n
Journal Batch Name (Journal Batch Name) Gen. Journal Batch Name (Name) 1..n
Journal Template Name (Journal Template Name) Gen. Journal Template Name (Name) 1..n

Table Relations From Other Tables

From Table From Field