Diagrams

Table

Analysis Line

DynamicsDocs.comAnalysis Line«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 771»Analysis Report Chart LineUser ID [PK]Name [PK]Analysis Line Line No. [PK]Analysis Column Line No. [PK]Analysis Area; [Sales,Purchase,Invento...Analysis Line Template NameAnalysis Column Template NameOriginal Measure NameMeasure NameMeasure ValueChart Type; [,Line,StepLine,Column,Sta...«Table 7112»Analysis Line TemplateAnalysis Area; [Sales,Purchase,Invento...Name [PK,NN]DescriptionDefault Column Template NameItem Analysis View Code«Table 7132»Item Budget NameAnalysis Area; [Sales,Purchase] [PK]Name [PK,NN]DescriptionBlockedBudget Dimension 1 CodeBudget Dimension 2 CodeBudget Dimension 3 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...«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 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 348»DimensionCode [PK,NN]NameCode CaptionFilter CaptionDescriptionBlockedConsolidation CodeMap-to IC Dimension CodeIdLast Modified Date Time<Analysis Line Template Name><Item Budget Filter><Location Filter><Source No. Filter><Source No. Filter><Source No. Filter><Group Dimension Code><Analysis Line Line No.><Budget Dimension 1 Code><Budget Dimension 2 Code><Budget Dimension 3 Code><Location Code><Location Code><Location Filter><Bill-to Customer No.><Pay-to Vendor No.><Vendor No.><Alternative Item No.>

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 Analysis Line Template Name (Analysis Line Template Name) Code10
3 Line No. (Line No.) Integer
4 Row Ref. No. (Row Ref. No.) Code20
5 Description (Description) Text80
6 Type (Type) Option
7 Range (Range) Text250
8 New Page (New Page) Boolean
9 Show (Show) Option
10 Bold (Bold) Boolean
11 Italic (Italic) Boolean
12 Underline (Underline) Boolean
13 Show Opposite Sign (Show Opposite Sign) Boolean
14 Source Type Filter (Source Type Filter) Option FlowFilter
15 Date Filter (Date Filter) Date FlowFilter
16 Item Budget Filter (Item Budget Filter) Code10 FlowFilter
17 Location Filter (Location Filter) Code10 FlowFilter
18 Dimension 1 Filter (Dimension 1 Filter) Code20 FlowFilter
19 Dimension 2 Filter (Dimension 2 Filter) Code20 FlowFilter
20 Dimension 3 Filter (Dimension 3 Filter) Code20 FlowFilter
21 Dimension 1 Totaling (Dimension 1 Totaling) Text80
22 Dimension 2 Totaling (Dimension 2 Totaling) Text80
23 Dimension 3 Totaling (Dimension 3 Totaling) Text80
24 Source No. Filter (Source No. Filter) Code20 FlowFilter
25 Group Dimension Code (Group Dimension Code) Code20
26 Indentation (Indentation) Integer

Keys

# Fields
0 Analysis Area,Analysis Line Template Name,Line No. (Analysis Area,Analysis Line Template Name,Line No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Analysis Line Template Name (Analysis Line Template Name) Analysis Line Template Name (Name) 1..n
Source No. Filter (Source No. Filter) Customer No. (No.) 1..n
Group Dimension Code (Group Dimension Code) Dimension Code (Code) 1..n
Source No. Filter (Source No. Filter) Item No. (No.) 1..n
Item Budget Filter (Item Budget Filter) Item Budget Name Name (Name) 1..n
Location Filter (Location Filter) Location Code (Code) 1..n
Source No. Filter (Source No. Filter) Vendor No. (No.) 1..n

Table Relations From Other Tables

From Table From Field
Analysis Report Chart Line Analysis Line Line No. (Analysis Line Line No.) 1..n