Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | No. (No.) | Code20 |
|
NotBlank: Yes |
2 | Name (Name) | Text50 | ||
3 | Search Name (Search Name) | Code50 | ||
4 | Account Type (Account Type) | Option | [Posting,Heading,Total,Begin-Total,End-Total] | |
5 | Account Source (Account Source) | Option | [G/L Account,Cash Flow Account] | |
6 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
7 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
9 | Income/Balance (Income/Balance) | Option | [Income Statement,Balance Sheet] | |
10 | Debit/Credit (Debit/Credit) | Option | [Both,Debit,Credit] | |
11 | No. 2 (No. 2) | Code20 | ||
12 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
13 | Blocked (Blocked) | Boolean | ||
14 | Direct Posting (Direct Posting) | Boolean | InitValue: Yes | |
16 | Reconciliation Account (Reconciliation Account) | Boolean | ||
17 | New Page (New Page) | Boolean | ||
18 | No. of Blank Lines (No. of Blank Lines) | Integer | ||
19 | Indentation (Indentation) | Integer | ||
26 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
27 | Cash Flow Forecast Filter (Cash Flow Forecast Filter) | Code20 |
|
FlowFilter |
28 | Date Filter (Date Filter) | Date | FlowFilter | |
29 | Global Dimension 1 Filter (Global Dimension 1 Filter) | Code20 | CaptionClass: '1,3,1'
|
FlowFilter |
30 | Global Dimension 2 Filter (Global Dimension 2 Filter) | Code20 | CaptionClass: '1,3,2'
|
FlowFilter |
31 | Balance at Date (Balance at Date) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
32 | Net Change (Net Change) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
33 | Budgeted Amount (Budgeted Amount) | Decimal | AutoFormatType: 1
|
BlankZero: Yes FlowField |
34 | Totaling (Totaling) | Text250 |
|
|
35 | Budget Filter (Budget Filter) | Code10 |
|
FlowFilter |
36 | Balance (Balance) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
37 | Budgeted at Date (Budgeted at Date) | Decimal | AutoFormatType: 1
|
BlankZero: Yes FlowField |
40 | Consol. Debit Acc. (Consol. Debit Acc.) | Code20 | AccessByPermission: TableData 220=R | |
41 | Consol. Credit Acc. (Consol. Credit Acc.) | Code20 | AccessByPermission: TableData 220=R | |
42 | Business Unit Filter (Business Unit Filter) | Code20 |
|
FlowFilter |
43 | Gen. Posting Type (Gen. Posting Type) | Option | [ ,Purchase,Sale] | |
44 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Code10 |
|
|
45 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
47 | Debit Amount (Debit Amount) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
48 | Credit Amount (Credit Amount) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
49 | Automatic Ext. Texts (Automatic Ext. Texts) | Boolean | ||
52 | Budgeted Debit Amount (Budgeted Debit Amount) | Decimal | AutoFormatType: 1
|
BlankNumbers: BlankNegAndZero BlankZero: Yes FlowField |
53 | Budgeted Credit Amount (Budgeted Credit Amount) | Decimal | AutoFormatType: 1
|
BlankNumbers: BlankZeroAndPos BlankZero: Yes FlowField |
54 | Tax Area Code (Tax Area Code) | Code20 |
|
|
55 | Tax Liable (Tax Liable) | Boolean | ||
56 | Tax Group Code (Tax Group Code) | Code10 |
|
|
57 | VAT Bus. Posting Group (VAT Bus. Posting Group) | Code10 |
|
|
58 | VAT Prod. Posting Group (VAT Prod. Posting Group) | Code10 |
|
|
60 | Additional-Currency Net Change (Additional-Currency Net Change) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
61 | Add.-Currency Balance at Date (Add.-Currency Balance at Date) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
62 | Additional-Currency Balance (Additional-Currency Balance) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
63 | Exchange Rate Adjustment (Exchange Rate Adjustment) | Option | [No Adjustment,Adjust Amount,Adjust Additional-Currency Amount] | |
64 | Add.-Currency Debit Amount (Add.-Currency Debit Amount) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
65 | Add.-Currency Credit Amount (Add.-Currency Credit Amount) | Decimal | AutoFormatType: 1
|
BlankZero: Yes Editable: No FlowField |
66 | Analysis View Filter (Analysis View Filter) | Code10 |
|
FlowFilter |
67 | Dimension 1 Filter (Dimension 1 Filter) | Code20 | CaptionClass: GetCaptionClass(1) | FlowFilter |
68 | Dimension 2 Filter (Dimension 2 Filter) | Code20 | CaptionClass: GetCaptionClass(2) | FlowFilter |
69 | Dimension 3 Filter (Dimension 3 Filter) | Code20 | CaptionClass: GetCaptionClass(3) | FlowFilter |
70 | Dimension 4 Filter (Dimension 4 Filter) | Code20 | CaptionClass: GetCaptionClass(4) | FlowFilter |
Keys
# | Fields | ||
---|---|---|---|
0 | No.,Account Source (No.,Account Source) | Clustered: Yes | |
1 | Search Name (Search Name) | ||
2 | Reconciliation Account (Reconciliation Account) | ||
3 | Gen. Bus. Posting Group (Gen. Bus. Posting Group) | ||
4 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Analysis View Filter (Analysis View Filter) | Analysis View | Code (Code) |
|
1..n |
Business Unit Filter (Business Unit Filter) | Business Unit | Code (Code) |
|
1..n |
No. (No.) | Cash Flow Account | No. (No.) |
|
1..n |
Cash Flow Forecast Filter (Cash Flow Forecast Filter) | Cash Flow Forecast | No. (No.) |
|
1..n |
Global Dimension 2 Filter (Global Dimension 2 Filter) | Dimension Value | Code (Code) |
|
1..n |
No. (No.) | G/L Account | No. (No.) |
|
1..n |
Budget Filter (Budget Filter) | G/L Budget Name | Name (Name) |
|
1..n |
Gen. Bus. Posting Group (Gen. Bus. Posting Group) | Gen. Business Posting Group | Code (Code) |
|
1..n |
Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
Tax Area Code (Tax Area Code) | Tax Area | Code (Code) |
|
1..n |
Tax Group Code (Tax Group Code) | Tax Group | Code (Code) |
|
1..n |
VAT Bus. Posting Group (VAT Bus. Posting Group) | VAT Business Posting Group | Code (Code) |
|
1..n |
VAT Prod. Posting Group (VAT Prod. Posting Group) | VAT Product Posting Group | Code (Code) |
|
1..n |
Table Relations From Other Tables
From Table | From Field |
---|