Diagrams


Table

Item Budget Name

DynamicsDocs.comItem Budget Name«Table 7132»Item Budget NameAnalysis Area; [Sales,Purchase] [PK]Name [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 Code«Table 5821»Item Statistics BufferCode [PK,NN]Item FilterVariant FilterLocation FilterBudget FilterGlobal Dimension 1 FilterGlobal Dimension 2 FilterDate FilterEntry Type Filter; [Direct Cost,Revalu...Item Ledger Entry Type Filter; [Purcha...Item Charge No. FilterSource Type Filter; [,Customer,Vendor,...Source No. FilterInvoiced QuantitySales Amount [Actual]Cost Amount [Actual]Cost Amount [Non-Invtbl.]Variance Type Filter; [,Purchase,Mater...Sales [LCY]COGS [LCY]Profit [LCY]Profit %Inventoriable CostsDirect Cost [LCY]Revaluation [LCY]Rounding [LCY]Indirect Cost [LCY]Variance [LCY]Inventoriable Costs, TotalInventory [LCY]Non-Invtbl. Costs [LCY]...«Table 7114»Analysis LineAnalysis Area; [Sales,Purchase,Invento...Analysis Line Template Name [PK]Line No. [PK]Row Ref. No.DescriptionType; [Item,Item Group,Customer,Custom...RangeNew PageShow; [Yes,No,If Any Column Not Zero]BoldItalicUnderlineShow Opposite SignSource Type Filter; [,Customer,Vendor,...Date FilterItem Budget FilterLocation FilterDimension 1 FilterDimension 2 FilterDimension 3 FilterDimension 1 TotalingDimension 2 TotalingDimension 3 TotalingSource No. FilterGroup Dimension CodeIndentation«Table 7134»Item Budget EntryEntry No. [PK]Analysis Area; [Sales,Purchase] [NN]Budget NameDateItem No.Source Type; [,Customer,Vendor,Item]Source No.DescriptionQuantityCost AmountSales AmountUser IDLocation CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 CodeDimension Set ID«Table 7156»Item Analysis View Budg. EntryAnalysis Area; [Sales,Purchase] [PK]Analysis View Code [PK,NN]Budget Name [PK]Item No. [PK]Source Type; [,Customer,Vendor,Item] [...Source No. [PK]Location Code [PK]Dimension 1 Value Code [PK]Dimension 2 Value Code [PK]Dimension 3 Value Code [PK]Posting Date [PK]Entry No. [PK]QuantitySales AmountCost Amount«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 Filter><Item Budget Filter><Budget Name><Budget Name><Group Dimension Code>

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

Fields

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

Keys

# Fields
0 Analysis Area,Name Clustered: Yes

Table Relations To Other Tables

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

Table Relations From Other Tables

From Table From Field
Analysis Line Item Budget Filter 1..n
Item Analysis View Budg. Entry Budget Name 1..n
Item Budget Entry Budget Name 1..n
Item Statistics Buffer Budget Filter 1..n