| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | ACD1 | Credit Memo - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
2 | ACD2 | Credit Memo - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
3 | ACD3 | Credit Memo - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
4 | ACQ1 | Capitalization - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
5 | ACQ2 | Capitalization - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
6 | ACQ3 | Capitalization - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
7 | AFA1 | Asset Document - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
8 | AFA2 | Asset Document - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
9 | AFAD | Asset Document - History | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
10 | FAC1 | Fixed Asset Parameter Change - Rows | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
11 | FAC2 | Fixed Asset Parameter Change - Period Control Change | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
12 | FAD1 | Asset Document - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
13 | FAD2 | Asset Document - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
14 | FAD3 | Asset Document - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
15 | FIX1 | Fixed Asset Transaction - Rows | 4 | DprArea | Depreciation Area ID | nVarChar | 15 | 0 | | |
16 | FTR1 | Transfer - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
17 | FTR2 | Transfer - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
18 | FTR3 | Transfer - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
19 | MDP1 | Manual Depreciation - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
20 | MDP2 | Manual Depreciation - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
21 | MDP3 | Manual Depreciation - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
22 | OACD | Credit Memo | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
23 | OACQ | Capitalization | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
24 | ODPV | Fixed Assets Depreciation Value | 3 | DprArea | Depreciation Area ID | nVarChar | 15 | 0 | | |
25 | ODRN | Depreciation Run | 4 | DprArea | Depreciation Area ID | nVarChar | 15 | 0 | | |
26 | OFAD | Asset Document | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
27 | OFAM | Fixed Asset Data Migration | 5 | DprArea | Migrate Depreciation Areas | VarChar | 1 | 0 | Y | N=No, Y=Yes |
28 | OFAR | Fixed Asset Revaluation | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
29 | OFTR | Transfer | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
30 | OMDP | Manual Depreciation | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
31 | ORTI | Retirement | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
32 | RTI1 | Retirement - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
33 | RTI2 | Retirement - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
34 | RTI3 | Retirement - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
TOPGeneral |
35 | OFDV | Asset Item Values | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
36 | OFEV | Fixed Asset End Balances | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
TOPInventory and Production |
37 | AIT11 | Asset Item Period Control | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
38 | AIT7 | Asset Item Depreciation Params - History | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
39 | AIT8 | Asset Item Balances - History | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
40 | ITM11 | Asset Item Period Control | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
41 | ITM7 | Asset Item Depreciation Params | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
42 | ITM8 | Asset Item Balances | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |