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