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 |
|---|