Diagrams


Table

Bank Account Posting Group

DynamicsDocs.comBank Account Posting Group«Table 277»Bank Account Posting GroupCode [PK,NN]G/L Bank Account No.«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 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 86»Exch. Rate Adjmt. Reg.No. [PK]Creation DateAccount Type; [G/L Account,Customer,Ve...Posting GroupCurrency CodeCurrency FactorAdjusted BaseAdjusted Base [LCY]Adjusted Amt. [LCY]Adjusted Base [Add.-Curr.]Adjusted Amt. [Add.-Curr.]«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....<G/L Bank Account No.><Bank Acc. Posting Group><Bank Acc. Posting Group><Posting Group><Bank Account No.><Bal. Account No.><Closed by Entry No.><Reversed by Entry No.><Reversed Entry 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 Code Code10 NotBlank: Yes
2 G/L Bank Account No. Code20

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
G/L Bank Account No. G/L Account No. 1..n

Table Relations From Other Tables

From Table From Field
Bank Account Bank Acc. Posting Group 1..n
Bank Account Ledger Entry Bank Acc. Posting Group 1..n
Exch. Rate Adjmt. Reg. Posting Group 1..n