Table Abbreviation Description Module Activity code
TMP2855 TVS Temporary table Fisc. Stmt 2855 Fixed Assets  

Key Description Duplicates Activity code
T550 EDTNUM+CPY+IMPSTRDAT+AASREF No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AASDES1 Description   DCO          
AASREF Asset   VC9          
AUUID Single identifier   AUUID          
CPY Company   CPY     [CPY]CPY0=[TVS]CPY Delete  
CPYNAM Company name   NAM          
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
EDTNUM Processing number   L 8        
EXOENDDAT Exemption end date   D4          
FCY Site   FCY     [FCY]FCY0=[TVS]FCY Delete  
FIRICIDAT 1st use date   D4          
FUEL Fuel type   M 4 3167      
FUELDES Fuel   DCO          
IMPENDDAT End date   D4          
IMPSTRDAT Start date   D4          
ISSDAT Issue date   D4          
NBTRIM1E No. quart. half-rate   C 4        
NBTRIM1P No. quart.full rate   C 4        
NBTRIM1T Total no. q   C 4        
NBTRIM2 No. quarters   C 4        
NPL Registration no.   A 15        
PURDAT Purchase date   D4          
RGNDAT Registration date   D4          
RNTDUR Rent duration   DUR          
RNTENDDAT Lease end   D4          
RNTSTRDAT Lease start   D4          
T1STRDAT Start date Q1   D4          
T2STRDAT Start date Q2   D4          
T3STRDAT Start date Q3   D4          
T4STRDAT Start date Q4   D4          
TARIFAIR Tarif Air   MD1          
TARIFCO2 CO2 price list   MD1          
TARIFPWR Engine size rate   MD1          
TAXECOL1 Tax col 1   MD1          
TAXECOL2 Tax col 2   MD1          
TAXECOL3 Tax col 3   MD1          
TAXECOL4 Tax col 4   MD1          
TAXPLI Taxation rate   M   3164      
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VEHCO2 CO2 rate   C 4        
VEHCO2RAT CO2 emmission rate   ADI     [ADI]CODE=629;VEHCO2RAT Other  
VEHPWR Admin power   C 4        
VEHTAXRUL Tax rule   M 15 3165