Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Code (Code) | Code10 | NotBlank: Yes | |
2 | Acquisition Cost Account (Acquisition Cost Account) | Code20 |
|
|
3 | Accum. Depreciation Account (Accum. Depreciation Account) | Code20 |
|
|
4 | Write-Down Account (Write-Down Account) | Code20 |
|
|
5 | Appreciation Account (Appreciation Account) | Code20 |
|
|
6 | Custom 1 Account (Custom 1 Account) | Code20 |
|
|
7 | Custom 2 Account (Custom 2 Account) | Code20 |
|
|
8 | Acq. Cost Acc. on Disposal (Acq. Cost Acc. on Disposal) | Code20 |
|
|
9 | Accum. Depr. Acc. on Disposal (Accum. Depr. Acc. on Disposal) | Code20 |
|
|
10 | Write-Down Acc. on Disposal (Write-Down Acc. on Disposal) | Code20 |
|
|
11 | Appreciation Acc. on Disposal (Appreciation Acc. on Disposal) | Code20 |
|
|
12 | Custom 1 Account on Disposal (Custom 1 Account on Disposal) | Code20 |
|
|
13 | Custom 2 Account on Disposal (Custom 2 Account on Disposal) | Code20 |
|
|
14 | Gains Acc. on Disposal (Gains Acc. on Disposal) | Code20 |
|
|
15 | Losses Acc. on Disposal (Losses Acc. on Disposal) | Code20 |
|
|
16 | Book Val. Acc. on Disp. (Gain) (Book Val. Acc. on Disp. (Gain)) | Code20 |
|
|
17 | Sales Acc. on Disp. (Gain) (Sales Acc. on Disp. (Gain)) | Code20 |
|
|
18 | Write-Down Bal. Acc. on Disp. (Write-Down Bal. Acc. on Disp.) | Code20 |
|
|
19 | Apprec. Bal. Acc. on Disp. (Apprec. Bal. Acc. on Disp.) | Code20 |
|
|
20 | Custom 1 Bal. Acc. on Disposal (Custom 1 Bal. Acc. on Disposal) | Code20 |
|
|
21 | Custom 2 Bal. Acc. on Disposal (Custom 2 Bal. Acc. on Disposal) | Code20 |
|
|
22 | Maintenance Expense Account (Maintenance Expense Account) | Code20 |
|
|
23 | Maintenance Bal. Acc. (Maintenance Bal. Acc.) | Code20 |
|
|
24 | Acquisition Cost Bal. Acc. (Acquisition Cost Bal. Acc.) | Code20 |
|
|
25 | Depreciation Expense Acc. (Depreciation Expense Acc.) | Code20 |
|
|
26 | Write-Down Expense Acc. (Write-Down Expense Acc.) | Code20 |
|
|
27 | Appreciation Bal. Account (Appreciation Bal. Account) | Code20 |
|
|
28 | Custom 1 Expense Acc. (Custom 1 Expense Acc.) | Code20 |
|
|
29 | Custom 2 Expense Acc. (Custom 2 Expense Acc.) | Code20 |
|
|
30 | Sales Bal. Acc. (Sales Bal. Acc.) | Code20 |
|
|
31 | Allocated Acquisition Cost % (Allocated Acquisition Cost %) | Decimal (1:1) |
|
Editable: No FlowField |
32 | Allocated Depreciation % (Allocated Depreciation %) | Decimal (1:1) |
|
Editable: No FlowField |
33 | Allocated Write-Down % (Allocated Write-Down %) | Decimal (1:1) |
|
Editable: No FlowField |
34 | Allocated Appreciation % (Allocated Appreciation %) | Decimal (1:1) |
|
Editable: No FlowField |
35 | Allocated Custom 1 % (Allocated Custom 1 %) | Decimal (1:1) |
|
Editable: No FlowField |
36 | Allocated Custom 2 % (Allocated Custom 2 %) | Decimal (1:1) |
|
Editable: No FlowField |
37 | Allocated Sales Price % (Allocated Sales Price %) | Decimal (1:1) |
|
Editable: No FlowField |
38 | Allocated Maintenance % (Allocated Maintenance %) | Decimal (1:1) |
|
Editable: No FlowField |
39 | Allocated Gain % (Allocated Gain %) | Decimal (1:1) |
|
Editable: No FlowField |
40 | Allocated Loss % (Allocated Loss %) | Decimal (1:1) |
|
Editable: No FlowField |
41 | Allocated Book Value % (Gain) (Allocated Book Value % (Gain)) | Decimal (1:1) |
|
Editable: No FlowField |
42 | Allocated Book Value % (Loss) (Allocated Book Value % (Loss)) | Decimal (1:1) |
|
Editable: No FlowField |
43 | Sales Acc. on Disp. (Loss) (Sales Acc. on Disp. (Loss)) | Code20 |
|
|
44 | Book Val. Acc. on Disp. (Loss) (Book Val. Acc. on Disp. (Loss)) | Code20 |
|
Keys
# | Fields | ||
---|---|---|---|
0 | Code (Code) | Clustered: Yes |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Book Val. Acc. on Disp. (Loss) (Book Val. Acc. on Disp. (Loss)) | G/L Account | No. (No.) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
FA Allocation | Code (Code) |
|
1..n |
FA Depreciation Book | FA Posting Group (FA Posting Group) |
|
1..n |
FA G/L Posting Buffer | FA Posting Group (FA Posting Group) |
|
1..n |
FA Journal Line | FA Posting Group (FA Posting Group) |
|
1..n |
FA Ledger Entry | FA Posting Group (FA Posting Group) |
|
1..n |
FA Subclass | Default FA Posting Group (Default FA Posting Group) |
|
1..n |
Fixed Asset | FA Posting Group (FA Posting Group) |
|
1..n |
Gen. Journal Line | Posting Group (Posting Group) |
|
1..n |
Maintenance Ledger Entry | FA Posting Group (FA Posting Group) |
|
1..n |
Purch. Cr. Memo Line | Posting Group (Posting Group) |
|
1..n |
Purch. Inv. Line | Posting Group (Posting Group) |
|
1..n |
Purch. Rcpt. Line | Posting Group (Posting Group) |
|
1..n |
Purchase Line | Posting Group (Posting Group) |
|
1..n |
Purchase Line Archive | Posting Group (Posting Group) |
|
1..n |
Return Receipt Line | Posting Group (Posting Group) |
|
1..n |
Return Shipment Line | Posting Group (Posting Group) |
|
1..n |
Sales Cr.Memo Line | Posting Group (Posting Group) |
|
1..n |
Sales Invoice Line | Posting Group (Posting Group) |
|
1..n |
Sales Line | Posting Group (Posting Group) |
|
1..n |
Sales Line Archive | Posting Group (Posting Group) |
|
1..n |
Sales Shipment Line | Posting Group (Posting Group) |
|
1..n |
Standard General Journal Line | Posting Group (Posting Group) |
|
1..n |