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 | ||
2 | Description (Description) | Text50 | ||
3 | Search Description (Search Description) | Code50 | ||
4 | Description 2 (Description 2) | Text50 | ||
5 | FA Class Code (FA Class Code) | Code10 |
|
|
6 | FA Subclass Code (FA Subclass Code) | Code10 |
|
|
7 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
8 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
9 | Location Code (Location Code) | Code10 |
|
|
10 | FA Location Code (FA Location Code) | Code10 |
|
|
11 | Vendor No. (Vendor No.) | Code20 |
|
|
12 | Main Asset/Component (Main Asset/Component) | Option | [ ,Main Asset,Component] | Editable: No |
13 | Component of Main Asset (Component of Main Asset) | Code20 |
|
Editable: No |
14 | Budgeted Asset (Budgeted Asset) | Boolean | ||
15 | Warranty Date (Warranty Date) | Date | ||
16 | Responsible Employee (Responsible Employee) | Code20 |
|
|
17 | Serial No. (Serial No.) | Text30 | ||
18 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
19 | Insured (Insured) | Boolean |
|
Editable: No FlowField |
20 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
21 | Blocked (Blocked) | Boolean | ||
22 | Picture (Picture) | BLOB [Bitmap] | ||
23 | Maintenance Vendor No. (Maintenance Vendor No.) | Code20 |
|
|
24 | Under Maintenance (Under Maintenance) | Boolean | ||
25 | Next Service Date (Next Service Date) | Date | ||
26 | Inactive (Inactive) | Boolean | ||
27 | FA Posting Date Filter (FA Posting Date Filter) | Date | FlowFilter | |
28 | No. Series (No. Series) | Code20 |
|
Editable: No |
29 | FA Posting Group (FA Posting Group) | Code20 |
|
|
30 | Acquired (Acquired) | Boolean |
|
FlowField |
140 | Image (Image) | Media |
Keys
# | Fields | ||
---|---|---|---|
0 | No. (No.) | Clustered: Yes | |
1 | Search Description (Search Description) | ||
2 | FA Class Code (FA Class Code) | ||
3 | FA Subclass Code (FA Subclass Code) | ||
4 | Component of Main Asset,Main Asset/Component (Component of Main Asset,Main Asset/Component) | ||
5 | FA Location Code (FA Location Code) | ||
6 | Global Dimension 1 Code (Global Dimension 1 Code) | ||
7 | Global Dimension 2 Code (Global Dimension 2 Code) | ||
8 | FA Posting Group (FA Posting Group) | ||
9 | Description (Description) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
Responsible Employee (Responsible Employee) | Employee | No. (No.) |
|
1..n |
FA Class Code (FA Class Code) | FA Class | Code (Code) |
|
1..n |
FA Location Code (FA Location Code) | FA Location | Code (Code) |
|
1..n |
FA Posting Group (FA Posting Group) | FA Posting Group | Code (Code) |
|
1..n |
FA Subclass Code (FA Subclass Code) | FA Subclass | Code (Code) |
|
1..n |
Component of Main Asset (Component of Main Asset) | Fixed Asset | No. (No.) |
|
1..n |
Location Code (Location Code) | Location | () |
|
1..n |
No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
Maintenance Vendor No. (Maintenance Vendor No.) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Applied Payment Entry | Account No. (Account No.) |
|
1..n |
Bank Acc. Reconciliation Line | Account No. (Account No.) |
|
1..n |
Bank Account Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
CV Ledger Entry Buffer | Bal. Account No. (Bal. Account No.) |
|
1..n |
Cash Flow Forecast Entry | Source No. (Source No.) |
|
1..n |
Check Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Comment Line | No. (No.) |
|
1..n |
Cust. Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Default Dimension | No. (No.) |
|
1..n |
Employee Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
FA Depreciation Book | Component of Main Asset (Component of Main Asset) |
|
1..n |
FA Journal Line | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
FA Ledger Entry | Canceled from FA No. (Canceled from FA No.) |
|
1..n |
FA Reclass. Journal Line | New FA No. (New FA No.) |
|
1..n |
Fixed Asset | Component of Main Asset (Component of Main Asset) |
|
1..n |
G/L Entry | Source No. (Source No.) |
|
1..n |
Gen. Journal Batch | Bal. Account No. (Bal. Account No.) |
|
1..n |
Gen. Journal Line | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
Gen. Journal Template | Bal. Account No. (Bal. Account No.) |
|
1..n |
Ins. Coverage Ledger Entry | FA No. (FA No.) |
|
1..n |
Insurance Journal Line | FA No. (FA No.) |
|
1..n |
Invoice Post. Buffer | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
Main Asset Component | FA No. (FA No.) |
|
1..n |
Maintenance Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Maintenance Registration | FA No. (FA No.) |
|
1..n |
Payment Application Proposal | Account No. (Account No.) |
|
1..n |
Posted Payment Recon. Line | Account No. (Account No.) |
|
1..n |
Purch. Cr. Memo Line | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
Purch. Inv. Line | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
Purch. Rcpt. Line | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
Purchase Line | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
Purchase Line Archive | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
Return Receipt Line | No. (No.) |
|
1..n |
Return Shipment Line | Budgeted FA No. (Budgeted FA No.) |
|
1..n |
Reversal Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |
Sales Cr.Memo Line | No. (No.) |
|
1..n |
Sales Invoice Line | No. (No.) |
|
1..n |
Sales Line Archive | No. (No.) |
|
1..n |
Sales Shipment Buffer | No. (No.) |
|
1..n |
Sales Shipment Line | No. (No.) |
|
1..n |
Service Shipment Buffer | No. (No.) |
|
1..n |
Standard General Journal Line | Source No. (Source No.) |
|
1..n |
Standard Purchase Line | No. (No.) |
|
1..n |
Standard Sales Line | No. (No.) |
|
1..n |
Total Value Insured | FA No. (FA No.) |
|
1..n |
Vendor Ledger Entry | Bal. Account No. (Bal. Account No.) |
|
1..n |