Diagrams


Table

Item Statistics Buffer

DynamicsDocs.comItem Statistics Buffer«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 5401»Item VariantCode [PK,NN]Item No. [PK,NN]DescriptionDescription 2«Table 14»LocationCode [PK,NN]NameDefault Bin CodeName 2AddressAddress 2CityPhone No.Phone No. 2Telex No.Fax No.ContactPost CodeCountyE-MailHome PageCountry/Region CodeUse As In-TransitRequire Put-awayRequire PickCross-Dock Due Date Calc.Use Cross-DockingRequire ReceiveRequire ShipmentBin MandatoryDirected Put-away and PickDefault Bin Selection; [,Fixed Bin,Las...Outbound Whse. Handling TimeInbound Whse. Handling TimePut-away Template CodeUse Put-away Worksheet...«Table 7132»Item Budget NameAnalysis Area; [Sales,Purchase] [PK]Name [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 Code«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 5800»Item ChargeNo. [PK,NN]DescriptionGen. Prod. Posting GroupTax Group CodeVAT Prod. Posting GroupSearch DescriptionGlobal Dimension 1 CodeGlobal Dimension 2 Code«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<Variant Filter><Location Filter><Budget Filter><Global Dimension 1 Filter><Global Dimension 2 Filter><Item Charge No. Filter><Analysis View Filter><Global Dimension 1 Code><Global Dimension 2 Code>

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

Fields

# Name Type
1 Code Code20 NotBlank: Yes
2 Item Filter Code20 FlowFilter
3 Variant Filter Code10 FlowFilter
4 Location Filter Code10 FlowFilter
5 Budget Filter Code10 FlowFilter
6 Global Dimension 1 Filter Code20 FlowFilter
7 Global Dimension 2 Filter Code20 FlowFilter
9 Date Filter Date [ClosingDates:Yes] FlowFilter
10 Entry Type Filter Option FlowFilter
11 Item Ledger Entry Type Filter Option FlowFilter
12 Item Charge No. Filter Code20 FlowFilter
13 Source Type Filter Option FlowFilter
14 Source No. Filter Code20 FlowFilter
15 Invoiced Quantity Decimal (0:5) Editable: No
FlowField
16 Sales Amount (Actual) Decimal Editable: No
FlowField
17 Cost Amount (Actual) Decimal Editable: No
FlowField
18 Cost Amount (Non-Invtbl.) Decimal Editable: No
FlowField
19 Variance Type Filter Option FlowFilter
20 Sales (LCY) Integer
21 COGS (LCY) Integer
22 Profit (LCY) Integer
23 Profit % Integer
24 Inventoriable Costs Integer
25 Direct Cost (LCY) Integer
26 Revaluation (LCY) Integer
27 Rounding (LCY) Integer
28 Indirect Cost (LCY) Integer
29 Variance (LCY) Integer
30 Inventoriable Costs, Total Integer
31 Inventory (LCY) Integer
34 Non-Invtbl. Costs (LCY) Integer
40 Line Option Option
41 Column Option Option
42 Analysis Area Filter Option FlowFilter
45 Quantity Decimal (0:5) Editable: No
FlowField
46 Sales Amount (Expected) Decimal Editable: No
FlowField
47 Cost Amount (Expected) Decimal Editable: No
FlowField
50 Budgeted Quantity Decimal (0:5) Editable: No
FlowField
51 Budgeted Sales Amount Decimal Editable: No
FlowField
52 Budgeted Cost Amount Decimal Editable: No
FlowField
70 Analysis View Filter Code10 FlowFilter
71 Dimension 1 Filter Code20 FlowFilter
72 Dimension 2 Filter Code20 FlowFilter
73 Dimension 3 Filter Code20 FlowFilter
80 Analysis - Quantity Decimal (0:5) Editable: No
FlowField
81 Analysis - Invoiced Quantity Decimal (0:5) Editable: No
FlowField
82 Analysis - Sales Amt. (Actual) Decimal Editable: No
FlowField
83 Analysis - Sales Amt. (Exp) Decimal Editable: No
FlowField
84 Analysis - Cost Amt. (Actual) Decimal Editable: No
FlowField
85 Analysis - Cost Amt. (Exp) Decimal Editable: No
FlowField
86 Analysis CostAmt.(Non-Invtbl.) Decimal Editable: No
FlowField
91 Analysis - Budgeted Quantity Decimal (0:5) Editable: No
FlowField
92 Analysis - Budgeted Sales Amt. Decimal Editable: No
FlowField
93 Analysis - Budgeted Cost Amt. Decimal Editable: No
FlowField

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Global Dimension 2 Filter Dimension Value Code 1..n
Analysis View Filter Item Analysis View Code 1..n
Budget Filter Item Budget Name Name 1..n
Item Charge No. Filter Item Charge No. 1..n
Variant Filter Item Variant Code 1..n
Location Filter Location Code 1..n

Table Relations From Other Tables

From Table From Field