| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPFinance |
1 | AACP | Periods Category-Log | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
2 | AFAD | Asset Document - History | 4 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
3 | AGAR | G/L Account Advanced Rules - History | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
4 | FAC2 | Fixed Asset Parameter Change - Period Control Change | 4 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
5 | FIX1 | Fixed Asset Transaction - Rows | 5 | PeriodCat | Period Category ID | nVarChar | 10 | 0 | | |
6 | OACD | Credit Memo | 4 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
7 | OACM | Accumulation | 4 | PeriodCat | Period Category | nVarChar | 20 | 0 | | |
8 | OACP | Periods Category | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
9 | OACQ | Capitalization | 4 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
10 | ODPV | Fixed Assets Depreciation Value | 4 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
11 | ODRN | Depreciation Run | 8 | PeriodCat | Period Category ID | nVarChar | 10 | 0 | | |
12 | OFPC | Fixed Assets Fiscal Year Change | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
13 | OFTR | Transfer | 4 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
14 | OGAR | G/L Account Advanced Rules | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
15 | OMDP | Manual Depreciation | 4 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
16 | ORTI | Retirement | 4 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
TOPGeneral |
17 | AGRS | G/L Account Advanced Rules for Resources - History | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
18 | OGRS | G/L Account Advanced Rules for Resources | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
TOPInventory and Production |
19 | AIT11 | Asset Item Period Control | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
20 | AIT7 | Asset Item Depreciation Params - History | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
21 | AIT8 | Asset Item Balances - History | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
22 | ITM11 | Asset Item Period Control | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
23 | ITM7 | Asset Item Depreciation Params | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |
24 | ITM8 | Asset Item Balances | 2 | PeriodCat | Period Category | nVarChar | 10 | 0 | | |