Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Table ID (Table ID) | Integer |
|
NotBlank: Yes |
| 2 | No. (No.) | Code20 |
|
|
| 3 | Dimension Code (Dimension Code) | Code20 |
|
NotBlank: Yes |
| 4 | Dimension Value Code (Dimension Value Code) | Code20 |
|
|
| 5 | Value Posting (Value Posting) | Option | [ ,Code Mandatory,Same Code,No Code] | |
| 6 | Table Caption (Table Caption) | Text250 |
|
Editable: No FlowField |
| 7 | Multi Selection Action (Multi Selection Action) | Option | [ ,Change,Delete] |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Table ID,No.,Dimension Code (Table ID,No.,Dimension Code) | Clustered: Yes | |
| 1 | Dimension Code (Dimension Code) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Table ID (Table ID) | AllObjWithCaption | Object ID (Object ID) |
|
1..n |
| No. (No.) | Bank Account | No. (No.) |
|
1..n |
| No. (No.) | Campaign | No. (No.) |
|
1..n |
| No. (No.) | Cash Flow Manual Expense | Code (Code) |
|
1..n |
| No. (No.) | Cash Flow Manual Revenue | Code (Code) |
|
1..n |
| No. (No.) | Customer | No. (No.) |
|
1..n |
| No. (No.) | Customer Template | Code (Code) |
|
1..n |
| Dimension Code (Dimension Code) | Dimension | Code (Code) |
|
1..n |
| Dimension Value Code (Dimension Value Code) | Dimension Value | Code (Code) |
|
1..n |
| No. (No.) | Employee | No. (No.) |
|
1..n |
| No. (No.) | Fixed Asset | No. (No.) |
|
1..n |
| No. (No.) | G/L Account | No. (No.) |
|
1..n |
| No. (No.) | IC Partner | Code (Code) |
|
1..n |
| No. (No.) | Insurance | No. (No.) |
|
1..n |
| No. (No.) | Item | No. (No.) |
|
1..n |
| No. (No.) | Item Charge | No. (No.) |
|
1..n |
| No. (No.) | Job | No. (No.) |
|
1..n |
| No. (No.) | Resource | No. (No.) |
|
1..n |
| No. (No.) | Resource Group | No. (No.) |
|
1..n |
| No. (No.) | Responsibility Center | Code (Code) |
|
1..n |
| No. (No.) | Salesperson/Purchaser | Code (Code) |
|
1..n |
| No. (No.) | Service Item | No. (No.) |
|
1..n |
| No. (No.) | Service Item Group | Code (Code) |
|
1..n |
| No. (No.) | Service Order Type | Code (Code) |
|
1..n |
| No. (No.) | Vendor | No. (No.) |
|
1..n |
| No. (No.) | Work Center | No. (No.) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field |
|---|