Diagrams

Table

Item Analysis View

DynamicsDocs.comItem Analysis View«Table 7152»Item Analysis ViewAnalysis Area; [Sales,Purchase,Invento...Code [PK,NN]NameLast Entry No.Last Budget Entry No.Last Date UpdatedUpdate on PostingBlockedItem FilterLocation FilterStarting DateDate Compression; [None,Day,Week,Month...Dimension 1 CodeDimension 2 CodeDimension 3 CodeInclude BudgetsRefresh When Unblocked«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 7112»Analysis Line TemplateAnalysis Area; [Sales,Purchase,Invento...Name [PK,NN]DescriptionDefault Column Template NameItem Analysis View Code«Table 7153»Item Analysis View FilterAnalysis Area; [Sales,Purchase,Invento...Analysis View Code [PK,NN]Dimension Code [PK,NN]Dimension Value Filter«Table 7154»Item Analysis View EntryAnalysis Area; [Sales,Purchase,Invento...Analysis View Code [PK,NN]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]Item Ledger Entry Type; [Purchase,Sale...Entry Type; [Direct Cost,Revaluation,R...Invoiced QuantitySales Amount [Actual]Cost Amount [Actual]Cost Amount [Non-Invtbl.]QuantitySales Amount [Expected]Cost Amount [Expected]«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 7159»Analysis Selected DimensionUser ID [PK]Object Type [PK]Object ID [PK]Dimension Code [PK]New Dimension Value CodeDimension Value FilterLevel; [,Level 1,Level 2,Level 3]Analysis View Code [PK]Analysis Area; [Sales,Purchase,Invento...«Table 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension CodeIdLast Modified Date Time<Dimension 1 Code><Dimension 2 Code><Dimension 3 Code><Analysis View Filter><Item Analysis View Code><Analysis View Code><Analysis View Code><Analysis View Code><Analysis View Code><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 (Analysis Area) Option
2 Code (Code) Code10 NotBlank: Yes
3 Name (Name) Text50
4 Last Entry No. (Last Entry No.) Integer Editable: No
5 Last Budget Entry No. (Last Budget Entry No.) Integer Editable: No
6 Last Date Updated (Last Date Updated) Date Editable: No
7 Update on Posting (Update on Posting) Boolean Editable: No
8 Blocked (Blocked) Boolean
9 Item Filter (Item Filter) Code250
10 Location Filter (Location Filter) Code250
11 Starting Date (Starting Date) Date
12 Date Compression (Date Compression) Option
13 Dimension 1 Code (Dimension 1 Code) Code20
14 Dimension 2 Code (Dimension 2 Code) Code20
15 Dimension 3 Code (Dimension 3 Code) Code20
17 Include Budgets (Include Budgets) Boolean
18 Refresh When Unblocked (Refresh When Unblocked) Boolean

Keys

# Fields
0 Analysis Area,Code (Analysis Area,Code) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Dimension 3 Code (Dimension 3 Code) Dimension Code (Code) 1..n

Table Relations From Other Tables

From Table From Field
Analysis Line Template Item Analysis View Code (Item Analysis View Code) 1..n
Analysis Selected Dimension Analysis View Code (Analysis View Code) 1..n
Item Analysis View Budg. Entry Analysis View Code (Analysis View Code) 1..n
Item Analysis View Entry Analysis View Code (Analysis View Code) 1..n
Item Analysis View Filter Analysis View Code (Analysis View Code) 1..n
Item Statistics Buffer Analysis View Filter (Analysis View Filter) 1..n