| 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 | FIX1 | Fixed Asset Transaction - Rows | 4 | DprArea | Depreciation Area ID | nVarChar | 15 | 0 | | |
13 | FTR1 | Transfer - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
14 | FTR2 | Transfer - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
15 | FTR3 | Transfer - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
16 | MDP1 | Manual Depreciation - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
17 | MDP2 | Manual Depreciation - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
18 | MDP3 | Manual Depreciation - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
19 | OACD | Credit Memo | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
20 | OACQ | Capitalization | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
21 | ODPV | Fixed Assets Depreciation Value | 3 | DprArea | Depreciation Area ID | nVarChar | 15 | 0 | | |
22 | ODRN | Depreciation Run | 4 | DprArea | Depreciation Area ID | nVarChar | 15 | 0 | | |
23 | OFAM | Fixed Asset Data Migration | 5 | DprArea | Migrate Depreciation Areas | VarChar | 1 | 0 | Y | N=No, Y=Yes |
24 | OFAR | Fixed Asset Revaluation | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
25 | OFTR | Transfer | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
26 | OMDP | Manual Depreciation | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
27 | ORTI | Retirement | 37 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
28 | RTI1 | Retirement - Rows | 9 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
29 | RTI2 | Retirement - Area Journal Transactions | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
30 | RTI3 | Retirement - Item Areas | 4 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
TOPInventory and Production |
31 | AIT11 | Asset Item Period Control | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
32 | AIT7 | Asset Item Depreciation Params - History | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
33 | AIT8 | Asset Item Balances - History | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
34 | ITM11 | Asset Item Period Control | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
35 | ITM7 | Asset Item Depreciation Params | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |
36 | ITM8 | Asset Item Balances | 3 | DprArea | Depreciation Area | nVarChar | 15 | 0 | | |