Diagrams


Table

Item Analysis View Entry

DynamicsDocs.comItem Analysis View Entry«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 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 27»ItemNo. [PK]No. 2DescriptionSearch DescriptionDescription 2Assembly BOMBase Unit of MeasurePrice Unit ConversionType; [Inventory,Service]Inventory Posting GroupShelf No.Item Disc. GroupAllow Invoice Disc.Statistics GroupCommission GroupUnit PricePrice/Profit Calculation; [Profit=Pric...Profit %Costing Method; [FIFO,LIFO,Specific,Av...Unit CostStandard CostLast Direct CostIndirect Cost %Cost is AdjustedAllow Online AdjustmentVendor No.Vendor Item No.Lead Time CalculationReorder PointMaximum InventoryReorder Quantity...«Table 18»CustomerNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Document Sending ProfileOur Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeChain NameBudgeted AmountCredit Limit [LCY]Customer Posting GroupCurrency CodeCustomer Price GroupLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodeSalesperson CodeShipment Method CodeShipping Agent CodePlace of ExportInvoice Disc. CodeCustomer Disc. Group...«Table 23»VendorNo. [PK]NameSearch NameName 2AddressAddress 2CityContactPhone No.Telex No.Our Account No.Territory CodeGlobal Dimension 1 CodeGlobal Dimension 2 CodeBudgeted AmountVendor Posting GroupCurrency CodeLanguage CodeStatistics GroupPayment Terms CodeFin. Charge Terms CodePurchaser CodeShipment Method CodeShipping Agent CodeInvoice Disc. CodeCountry/Region CodeCommentBlocked; [,Payment,All]Pay-to Vendor No.PriorityPayment Method Code...«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...<Analysis View Code><Item No.><Source No.><Source No.><Source No.><Location Code><Vendor No.><Alternative Item No.><Location Filter><Bill-to Customer No.><Location Code><Pay-to Vendor No.><Location 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 Analysis View Code Code10 NotBlank: Yes
3 Item No. Code20
4 Source Type Option
5 Source No. Code20
8 Location Code Code10
9 Dimension 1 Value Code Code20
10 Dimension 2 Value Code Code20
11 Dimension 3 Value Code Code20
12 Posting Date Date
13 Entry No. Integer
14 Item Ledger Entry Type Option
15 Entry Type Option
21 Invoiced Quantity Decimal
22 Sales Amount (Actual) Decimal
23 Cost Amount (Actual) Decimal
24 Cost Amount (Non-Invtbl.) Decimal
31 Quantity Decimal
32 Sales Amount (Expected) Decimal
33 Cost Amount (Expected) Decimal

Keys

# Fields
0 Analysis Area,Analysis View Code,Item No.,Item Ledger Entry Type,Entry Type,Source Type,Source No.,Dimension 1 Value Code,Dimension 2 Value Code,Dimension 3 Value Code,Location Code,Posting Date,Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Source No. Customer No. 1..n
Source No. Item No. 1..n
Analysis View Code Item Analysis View Code 1..n
Location Code Location Code 1..n
Source No. Vendor No. 1..n

Table Relations From Other Tables

From Table From Field