Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Code (Code) | Code20 | NotBlank: Yes | |
| 2 | Item Filter (Item Filter) | Code20 |
|
FlowFilter |
| 3 | Variant Filter (Variant Filter) | Code10 |
|
FlowFilter |
| 4 | Location Filter (Location Filter) | Code10 |
|
FlowFilter |
| 5 | Budget Filter (Budget Filter) | Code10 |
|
FlowFilter |
| 6 | Global Dimension 1 Filter (Global Dimension 1 Filter) | Code20 | CaptionClass: '1,3,1'
|
FlowFilter |
| 7 | Global Dimension 2 Filter (Global Dimension 2 Filter) | Code20 | CaptionClass: '1,3,2'
|
FlowFilter |
| 9 | Date Filter (Date Filter) | Date [ClosingDates:Yes] | FlowFilter | |
| 10 | Entry Type Filter (Entry Type Filter) | Option | [Direct Cost,Revaluation,Rounding,Indirect Cost,Variance] | FlowFilter |
| 11 | Item Ledger Entry Type Filter (Item Ledger Entry Type Filter) | Option | [Purchase,Sale,Positive Adjmt.,Negative Adjmt.,Transfer,Consumption,Output, ,Assembly Consumption,Assembly Output] | FlowFilter |
| 12 | Item Charge No. Filter (Item Charge No. Filter) | Code20 |
|
FlowFilter |
| 13 | Source Type Filter (Source Type Filter) | Option | [ ,Customer,Vendor,Salesperson/Purchaser,Item] | FlowFilter |
| 14 | Source No. Filter (Source No. Filter) | Code20 |
|
FlowFilter |
| 15 | Invoiced Quantity (Invoiced Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 16 | Sales Amount (Actual) (Sales Amount (Actual)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 17 | Cost Amount (Actual) (Cost Amount (Actual)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 18 | Cost Amount (Non-Invtbl.) (Cost Amount (Non-Invtbl.)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 19 | Variance Type Filter (Variance Type Filter) | Option | [ ,Purchase,Material,Capacity,Capacity Overhead,Manufacturing Overhead,Subcontracted] | FlowFilter |
| 20 | Sales (LCY) (Sales (LCY)) | Integer | ||
| 21 | COGS (LCY) (COGS (LCY)) | Integer | ||
| 22 | Profit (LCY) (Profit (LCY)) | Integer | ||
| 23 | Profit % (Profit %) | Integer | ||
| 24 | Inventoriable Costs (Inventoriable Costs) | Integer | ||
| 25 | Direct Cost (LCY) (Direct Cost (LCY)) | Integer | ||
| 26 | Revaluation (LCY) (Revaluation (LCY)) | Integer | ||
| 27 | Rounding (LCY) (Rounding (LCY)) | Integer | ||
| 28 | Indirect Cost (LCY) (Indirect Cost (LCY)) | Integer | ||
| 29 | Variance (LCY) (Variance (LCY)) | Integer | ||
| 30 | Inventoriable Costs, Total (Inventoriable Costs, Total) | Integer | ||
| 31 | Inventory (LCY) (Inventory (LCY)) | Integer | ||
| 34 | Non-Invtbl. Costs (LCY) (Non-Invtbl. Costs (LCY)) | Integer | ||
| 40 | Line Option (Line Option) | Option | [Profit Calculation,Cost Specification,Purch. Item Charge Spec.,Sales Item Charge Spec.,Period,Location] | |
| 41 | Column Option (Column Option) | Option | [Profit Calculation,Cost Specification,Purch. Item Charge Spec.,Sales Item Charge Spec.,Period,Location] | |
| 42 | Analysis Area Filter (Analysis Area Filter) | Option | [Sale,Purchase,Inventory] | FlowFilter |
| 45 | Quantity (Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 46 | Sales Amount (Expected) (Sales Amount (Expected)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 47 | Cost Amount (Expected) (Cost Amount (Expected)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 50 | Budgeted Quantity (Budgeted Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 51 | Budgeted Sales Amount (Budgeted Sales Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 52 | Budgeted Cost Amount (Budgeted Cost Amount) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 70 | Analysis View Filter (Analysis View Filter) | Code10 |
|
FlowFilter |
| 71 | Dimension 1 Filter (Dimension 1 Filter) | Code20 | FlowFilter | |
| 72 | Dimension 2 Filter (Dimension 2 Filter) | Code20 | FlowFilter | |
| 73 | Dimension 3 Filter (Dimension 3 Filter) | Code20 | FlowFilter | |
| 80 | Analysis - Quantity (Analysis - Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 81 | Analysis - Invoiced Quantity (Analysis - Invoiced Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 82 | Analysis - Sales Amt. (Actual) (Analysis - Sales Amt. (Actual)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 83 | Analysis - Sales Amt. (Exp) (Analysis - Sales Amt. (Exp)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 84 | Analysis - Cost Amt. (Actual) (Analysis - Cost Amt. (Actual)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 85 | Analysis - Cost Amt. (Exp) (Analysis - Cost Amt. (Exp)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 86 | Analysis CostAmt.(Non-Invtbl.) (Analysis CostAmt.(Non-Invtbl.)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 91 | Analysis - Budgeted Quantity (Analysis - Budgeted Quantity) | Decimal (0:5) |
|
Editable: No FlowField |
| 92 | Analysis - Budgeted Sales Amt. (Analysis - Budgeted Sales Amt.) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 93 | Analysis - Budgeted Cost Amt. (Analysis - Budgeted Cost Amt.) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Code (Code) | Clustered: Yes |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Global Dimension 2 Filter (Global Dimension 2 Filter) | Dimension Value | Code (Code) |
|
1..n |
| Analysis View Filter (Analysis View Filter) | Item Analysis View | Code (Code) |
|
1..n |
| Budget Filter (Budget Filter) | Item Budget Name | Name (Name) |
|
1..n |
| Item Charge No. Filter (Item Charge No. Filter) | Item Charge | No. (No.) |
|
1..n |
| Variant Filter (Variant Filter) | Item Variant | Code (Code) |
|
1..n |
| Location Filter (Location Filter) | Location | Code (Code) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field |
|---|