Diagrams

Table

G/L Acc. Budget Buffer

DynamicsDocs.comG/L Acc. Budget Buffer«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 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 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<Budget Filter><Business Unit Filter><Global Dimension 1 Filter><Global Dimension 2 Filter>

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

Fields

# Name Type
1 Code (Code) Code20 NotBlank: Yes
3 Budget Filter (Budget Filter) Code10 FlowFilter
4 G/L Account Filter (G/L Account Filter) Code20 FlowFilter
5 Business Unit Filter (Business Unit Filter) Code20 FlowFilter
6 Global Dimension 1 Filter (Global Dimension 1 Filter) Code20 FlowFilter
7 Global Dimension 2 Filter (Global Dimension 2 Filter) Code20 FlowFilter
8 Budget Dimension 1 Filter (Budget Dimension 1 Filter) Code20 FlowFilter
9 Budget Dimension 2 Filter (Budget Dimension 2 Filter) Code20 FlowFilter
10 Budget Dimension 3 Filter (Budget Dimension 3 Filter) Code20 FlowFilter
11 Budget Dimension 4 Filter (Budget Dimension 4 Filter) Code20 FlowFilter
12 Date Filter (Date Filter) Date [ClosingDates:Yes] FlowFilter
13 Budgeted Amount (Budgeted Amount) Decimal FlowField

Keys

# Fields
0 Code (Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Business Unit Filter (Business Unit Filter) Business Unit Code (Code) 1..n
Global Dimension 2 Filter (Global Dimension 2 Filter) Dimension Value Code (Code) 1..n
Budget Filter (Budget Filter) G/L Budget Name Name (Name) 1..n

Table Relations From Other Tables

From Table From Field