Diagrams

Table

G/L Account (Analysis View)

DynamicsDocs.comG/L Account (Analysis View)«Table 376»G/L Account (Analysis View)No. [PK,NN]NameSearch NameAccount Type; [Posting,Heading,Total,B...Account Source; [G/L Account,Cash Flow...Global Dimension 1 CodeGlobal Dimension 2 CodeIncome/Balance; [Income Statement,Bala...Debit/Credit; [Both,Debit,Credit]No. 2CommentBlockedDirect PostingReconciliation AccountNew PageNo. of Blank LinesIndentationLast Date ModifiedCash Flow Forecast FilterDate FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBalance at DateNet ChangeBudgeted AmountTotalingBudget FilterBalanceBudgeted at DateConsol. Debit Acc.Consol. Credit Acc....«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 841»Cash Flow AccountNo. [PK,NN]NameSearch NameAccount Type; [Entry,Heading,Total,Beg...CommentBlockedNew PageNo. of Blank LinesIndentationLast Date ModifiedDate FilterCash Flow Forecast FilterAmountGlobal Dimension 1 FilterGlobal Dimension 2 FilterTotalingSource Type; [,Receivables,Payables,Li...G/L Integration; [,Balance,Budget,Both...G/L Account Filter«Table 349»Dimension ValueDimension Code [PK,NN]Code [PK,NN]NameDimension Value Type; [Standard,Headin...TotalingBlockedConsolidation CodeIndentationGlobal Dimension No.Map-to IC Dimension CodeMap-to IC Dimension Value CodeDimension Value ID«Table 840»Cash Flow ForecastNo. [PK]Search NameDescriptionDescription 2Consider DiscountCreation DateCreated ByManual Payments ToCommentNo. SeriesManual Payments FromG/L Budget FromG/L Budget ToConsider CF Payment TermsConsider Pmt. Disc. Tol. DateConsider Pmt. Tol. AmountAccount No. FilterSource Type Filter; [,Receivables,Paya...Cash Flow Date FilterAmount [LCY]Positive FilterOverdue CF Dates to Work DateDefault G/L Budget Name«Table 95»G/L Budget NameName [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 Code«Table 220»Business UnitCode [PK,NN]ConsolidateConsolidation %Starting DateEnding DateIncome Currency FactorBalance Currency FactorExch. Rate Losses Acc.Exch. Rate Gains Acc.Residual AccountLast Balance Currency FactorNameCompany NameCurrency CodeComp. Exch. Rate Gains Acc.Comp. Exch. Rate Losses Acc.Equity Exch. Rate Gains Acc.Equity Exch. Rate Losses Acc.Minority Exch. Rate Gains Acc.Minority Exch. Rate Losses AccCurrency Exchange Rate Table; [Local,B...Data Source; [Local Curr. <LCY>,Add. R...File Format; [Version 4.00 or Later <....«Table 250»Gen. Business Posting GroupCode [PK,NN]DescriptionDef. VAT Bus. Posting GroupAuto Insert Default«Table 251»Gen. Product Posting GroupCode [PK,NN]DescriptionDef. VAT Prod. Posting GroupAuto Insert Default«Table 318»Tax AreaCode [PK,NN]Description«Table 321»Tax GroupCode [PK,NN]Description«Table 323»VAT Business Posting GroupCode [PK,NN]Description«Table 324»VAT Product Posting GroupCode [PK,NN]Description«Table 363»Analysis ViewCode [PK,NN]NameAccount Source; [G/L Account,Cash Flow...Last Entry No.Last Budget Entry No.Last Date UpdatedUpdate on PostingBlockedAccount FilterBusiness Unit FilterStarting DateDate Compression; [None,Day,Week,Month...Dimension 1 CodeDimension 2 CodeDimension 3 CodeDimension 4 CodeInclude BudgetsRefresh When Unblocked<No.><No.><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Cash Flow Forecast Filter><Budget Filter><Business Unit Filter><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Analysis View Filter><Global Dimension 1 Code><Global Dimension 2 Code><Global Dimension 1 Filter><Global Dimension 2 Filter><Budget Filter><Business Unit Filter><Exch. Rate Losses Acc.><Exch. Rate Gains Acc.><Residual Account><Comp. Exch. Rate Gains Acc.><Comp. Exch. Rate Losses Acc.><Equity Exch. Rate Gains Acc.><Equity Exch. Rate Losses Acc.><Minority Exch. Rate Gains Acc.><Minority Exch. Rate Losses Acc><Gen. Bus. Posting Group><Gen. Prod. Posting Group><Tax Area Code><Tax Group Code><VAT Bus. Posting Group><VAT Prod. Posting Group><Cash Flow Forecast Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><Default G/L Budget Name><Def. VAT Bus. Posting Group><Def. VAT Prod. Posting Group>

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

Fields

# Name Type
1 No. Code20 NotBlank: Yes
2 Name Text50
3 Search Name Code50
4 Account Type Option
5 Account Source Option
6 Global Dimension 1 Code Code20
7 Global Dimension 2 Code Code20
9 Income/Balance Option
10 Debit/Credit Option
11 No. 2 Code20
12 Comment Boolean Editable: No
FlowField
13 Blocked Boolean
14 Direct Posting Boolean
16 Reconciliation Account Boolean
17 New Page Boolean
18 No. of Blank Lines Integer
19 Indentation Integer
26 Last Date Modified Date Editable: No
27 Cash Flow Forecast Filter Code20 FlowFilter
28 Date Filter Date FlowFilter
29 Global Dimension 1 Filter Code20 FlowFilter
30 Global Dimension 2 Filter Code20 FlowFilter
31 Balance at Date Decimal BlankZero: Yes
Editable: No
FlowField
32 Net Change Decimal BlankZero: Yes
Editable: No
FlowField
33 Budgeted Amount Decimal BlankZero: Yes
FlowField
34 Totaling Text250
35 Budget Filter Code10 FlowFilter
36 Balance Decimal BlankZero: Yes
Editable: No
FlowField
37 Budgeted at Date Decimal BlankZero: Yes
FlowField
40 Consol. Debit Acc. Code20
41 Consol. Credit Acc. Code20
42 Business Unit Filter Code20 FlowFilter
43 Gen. Posting Type Option
44 Gen. Bus. Posting Group Code10
45 Gen. Prod. Posting Group Code10
47 Debit Amount Decimal BlankZero: Yes
Editable: No
FlowField
48 Credit Amount Decimal BlankZero: Yes
Editable: No
FlowField
49 Automatic Ext. Texts Boolean
52 Budgeted Debit Amount Decimal BlankNumbers: BlankNegAndZero
BlankZero: Yes
FlowField
53 Budgeted Credit Amount Decimal BlankNumbers: BlankZeroAndPos
BlankZero: Yes
FlowField
54 Tax Area Code Code20
55 Tax Liable Boolean
56 Tax Group Code Code10
57 VAT Bus. Posting Group Code10
58 VAT Prod. Posting Group Code10
60 Additional-Currency Net Change Decimal BlankZero: Yes
Editable: No
FlowField
61 Add.-Currency Balance at Date Decimal BlankZero: Yes
Editable: No
FlowField
62 Additional-Currency Balance Decimal BlankZero: Yes
Editable: No
FlowField
63 Exchange Rate Adjustment Option
64 Add.-Currency Debit Amount Decimal BlankZero: Yes
Editable: No
FlowField
65 Add.-Currency Credit Amount Decimal BlankZero: Yes
Editable: No
FlowField
66 Analysis View Filter Code10 FlowFilter
67 Dimension 1 Filter Code20 FlowFilter
68 Dimension 2 Filter Code20 FlowFilter
69 Dimension 3 Filter Code20 FlowFilter
70 Dimension 4 Filter Code20 FlowFilter

Keys

# Fields
0 No.,Account Source Clustered: Yes
1 Search Name
2 Reconciliation Account
3 Gen. Bus. Posting Group
4 Gen. Prod. Posting Group

Table Relations To Other Tables

Field Related Table Related Field
Analysis View Filter Analysis View Code 1..n
Business Unit Filter Business Unit Code 1..n
No. Cash Flow Account No. 1..n
Cash Flow Forecast Filter Cash Flow Forecast No. 1..n
Global Dimension 2 Filter Dimension Value Code 1..n
No. G/L Account No. 1..n
Budget Filter G/L Budget Name Name 1..n
Gen. Bus. Posting Group Gen. Business Posting Group Code 1..n
Gen. Prod. Posting Group Gen. Product Posting Group Code 1..n
Tax Area Code Tax Area Code 1..n
Tax Group Code Tax Group Code 1..n
VAT Bus. Posting Group VAT Business Posting Group Code 1..n
VAT Prod. Posting Group VAT Product Posting Group Code 1..n

Table Relations From Other Tables

From Table From Field