Diagrams


Table

G/L Budget Name

DynamicsDocs.comG/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 135»Acc. Sched. KPI Web Srv. SetupPrimary Key [PK]Forecasted Values Start; [After Latest...G/L Budget NamePeriod; [Fiscal Year - Last Locked Per...View By; [Day,Week,Month,Quarter,Year,...Web Service NamePublished«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 366»Analysis View Budget EntryAnalysis View Code [PK,NN]Budget Name [PK]Business Unit Code [PK]G/L Account No. [PK]Dimension 1 Value Code [PK]Dimension 2 Value Code [PK]Dimension 3 Value Code [PK]Dimension 4 Value Code [PK]Posting Date [PK]Entry No. [PK]Amount«Table 374»G/L Acc. Budget BufferCode [PK,NN]Budget FilterG/L Account FilterBusiness Unit FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterBudget Dimension 1 FilterBudget Dimension 2 FilterBudget Dimension 3 FilterBudget Dimension 4 FilterDate FilterBudgeted Amount«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 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 846»Cash Flow Worksheet LineLine No. [PK]Cash Flow Forecast No.Cash Flow DateDocument No.Cash Flow Account No.Source Type; [,Receivables,Payables,Li...DescriptionDocument Type; [,Payment,Invoice,Credi...Document DatePmt. Discount DatePmt. Disc. Tolerance DatePayment Terms CodePayment DiscountAssociated Entry No.OverdueShortcut Dimension 2 CodeShortcut Dimension 1 CodeAmount [LCY]Source No.G/L Budget NameDimension Set ID«Table 847»Cash Flow Forecast EntryEntry No. [PK]User IDCash Flow Forecast No.Cash Flow DateDocument No.Cash Flow Account No.Source Type; [,Receivables,Payables,Li...DescriptionOverduePayment DiscountAssociated Entry No.Associated Document No.Global Dimension 2 CodeGlobal Dimension 1 CodeRecurring Method; [,Fixed,Variable]Amount [LCY]PositiveSource No.G/L Budget NameDimension Set ID«Table 85»Acc. Schedule LineSchedule Name [PK]Line No. [PK]Row No.DescriptionTotalingTotaling Type; [Posting Accounts,Total...New PageIndentationDate FilterDimension 1 FilterDimension 2 FilterG/L Budget FilterBusiness Unit FilterShow; [Yes,No,If Any Column Not Zero,W...Dimension 3 FilterDimension 4 FilterDimension 1 TotalingDimension 2 TotalingDimension 3 TotalingDimension 4 TotalingBoldItalicUnderlineShow Opposite SignRow Type; [Net Change,Balance at Date,...Amount Type; [Net Amount,Debit Amount,...Double UnderlineCash Flow Forecast FilterCost Center FilterCost Object FilterCost Center Totaling...«Table 96»G/L Budget EntryEntry No. [PK]Budget NameG/L Account No.DateGlobal Dimension 1 CodeGlobal Dimension 2 CodeAmountDescriptionBusiness Unit CodeUser IDBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeBudget Dimension 4 CodeLast Date ModifiedDimension Set ID«Table 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension Code<Budget Dimension 1 Code><Budget Dimension 2 Code><Budget Dimension 3 Code><Budget Dimension 4 Code><G/L Budget Name><Budget Filter><Budget Name><Budget Filter><Budget Filter><Default G/L Budget Name><G/L Budget Name><G/L Budget Name><G/L Budget Filter><Budget Name><G/L Account No.><No.><Source No.><G/L Account No.><Cash Flow Forecast Filter><Cash Flow Forecast No.><Cash Flow Forecast No.><Cash Flow Forecast Filter>

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

Fields

# Name Type
1 Name Code10 NotBlank: Yes
2 Description Text80
3 Blocked Boolean
4 Budget Dimension 1 Code Code20
5 Budget Dimension 2 Code Code20
6 Budget Dimension 3 Code Code20
7 Budget Dimension 4 Code Code20

Keys

# Fields
0 Name Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Budget Dimension 4 Code Dimension Code 1..n

Table Relations From Other Tables

From Table From Field
Acc. Sched. KPI Web Srv. Setup G/L Budget Name 1..n
Acc. Schedule Line G/L Budget Filter 1..n
Analysis View Budget Entry Budget Name 1..n
Cash Flow Forecast Default G/L Budget Name 1..n
Cash Flow Forecast Entry G/L Budget Name 1..n
Cash Flow Worksheet Line G/L Budget Name 1..n
G/L Acc. Budget Buffer Budget Filter 1..n
G/L Account Budget Filter 1..n
G/L Account (Analysis View) Budget Filter 1..n
G/L Budget Entry Budget Name 1..n