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

Keys

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

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field