Table Abbreviation Description Module Activity code
FXDASSETS FAS Assets Fixed Assets  

Key Description Duplicates Activity code
FAS0 AASREF No  
FAS1 CPY+AASREF No  
FAS2 CPY+FCY+AASREF No  
FAS3 SET Yes  
FAS5 CMP Yes  
FAS4 PROPLN+AASREF Yes  
FAS7 CPY+ENAFAS Yes  
FAS8 CCNREF+RNWDAT+AASREF No CCN
FAS9 CCNACTCOD+CPY+AASREF No CCN
FAS10 KPSEPLN+CPY+AASREF No PSE
FAS11 CMPSTA+AASREF No  
FAS12 LEAREF Yes LEA

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AASBUS Activity   VC9          
AASCND Report   ADI     [ADI]CODE=511;AASCND Block  
AASDES1 Description   DCO          
AASDES2 Description 2   DCO          
AASIPTDAT Allocation date   D4          
AASORINBV NV IGS source asset   MD1          
AASQTY Quantity   QTY          
AASREF Asset   FAS     [FAS]FAS0=[FAS]AASREF Other  
AASREFORI Original reference   A 20        
AASRPB Supervisor   A 15        
AASTYP Type   M 15 3151      
AASUOM Unit   UOM     [TUN]TUN0=[FAS]AASUOM Block  
ACCCOD Accounting code   CAC     [CAC]CAC0=[V]GVML_COGIMMO;ACCCOD;[V]GSUPCLE Other  
ACGCPLDED Add deduc VAT CoA   MD1          
ACGCUR CoA curr.   CUR     [TCU]TCU0=[FAS]ACGCUR Block  
ACGETRNOT Receipt value ex-tax   MD1          
ACGGRP Family   FAM     [FAM]FAM0=ACGGRP Other  
ACGREVVAT CoA VAT repayment   MD1          
ADMCOE Admission coef.   RAT          
ADMCOEF Admission coef.   RAT          
ADMCOEFGLO Global adjust. index   M 4 1      
ADMCOER Admission coef.   RAT          
APRDAT Valuation date   D4          
ASJCOE Liability coef.   RAT          
ASJCOEF Liability coef.   RAT          
ASJCOEFGLO Global adjust. index   M 4 1      
ASJCOER Liability coef.   RAT          
AUUID Single identifier   AUUID          
BPR Supplier   BPR     [BPR]BPR0=[FAS]BPR Block  
BUDFIY Budget FY   C 4        
BUDREF Budget reference   ADI     [ADI]CODE=615;BUDREF Block  
BUY Buyer   BPR     [BPR]BPR0=[FAS]BUY Block  
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CCNAASTYP Asset type   M 4 3285     CCN
CCNACTCOD Update code   CCA         CCN
CCNCADDEV Amortization variance   MD1         CCN
CCNCADEXC Amortization excess   MD1         CCN
CCNETRNAT Contrib. origin   M 4 3287     CCN
CCNETRTYP Contrib. type   M 4 3286     CCN
CCNINICUM Initial fund   MD1         CCN
CCNREF Concession contract   CCN     [CCN]CCN0=[FAS]CCNREF Block CCN
CCNTRFCAD Forwarded amortization   MD1         CCN
CCNTRFCUM Forwarded funds   MD1         CCN
CCNTRFGRT Forwarded subsidy   MD1         CCN
CCNTRFRPR Forwarded provision   MD1         CCN
CIGCOD IGS reference   A 10        
CMP Main   AAS     [FAS]FAS0=[FAS]CMP Other  
CMPORI Main source   AAS     [FAS]FAS0=[FAS]CMPORI Block  
CMPSTA Status   M 15 3229      
CONNUM Market no   ADI     [ADI]CODE=620;CONNUM Block  
CPY Company   CPY     [CPY]CPY0=[FAS]CPY Delete  
CRBGRAAMT Reintegrtd amount   MD1          
CRBGRACUM Reintegration total   MD1          
CREDAT Date created   D4          
CREDATTIM Date time   ADATIM          
CREORI Entry origin   M 15 3162      
CREUSR Creation user   A 5        
CWKTYP Bodywork type   ADI     [ADI]CODE=535;CWKTYP Block  
DATISSPST Issue date   D4          
DEDCOE Deduction coef   RAT          
DEDCOEF Deduction coef   RAT          
DEDCOER Deduction coef   RAT          
DEDVATAMT VAT recovered   MD1          
DEDVATAMTI VAT recovered   MD1          
DEDVATFLG Forced rec VAT   MZS 4        
DEDVATFLGI Forced rec VAT   MZS 4        
DEDVATRAT Recovered VAT rate   RAT          
DEDVATRATI Recovered VAT rate   RAT          
DERRVEISS Book vs tax rev./disposal   MD1          
DIE Dimension type code   DIE     [DIE]DIE0=[FAS]DIE Block ANA
DSP Distribution   DSP     [DSP]DSP0=DSP;1 Block  
ENAFAS Active   M 4 1      
ETRNAT Recpt nature   M 15 3157      
EXEREN2857 Exemption reason CO2   ADI     [ADI]CODE=632;EXEREN2857 Block  
EXEREN2858 Exemption reason age   ADI     [ADI]CODE=633;EXEREN2858 Block  
EXPDAT Usage limit   D4          
EXTISSFLG Provisional disposal   M 4 1      
EXTSALAMT Expected sale amount   MD1          
FCY Financial site   FCY     [FCY]FCY0=[FAS]FCY Block  
FIRICIDAT 1st use date   D4          
FISOPETYP IGS fisc rule   M 15 3163      
FLGCLC Asset to calculate   M 4 1      
FLGCNXCLC Context to calculate 11 M 4 3281      
FLGCNXFLX Generated flows   A 11        
FLGPRV Legacy asset   M 4 1      
FLGRPRCLC Provision to calculate   M 4 1     CCN
FLGSPL Split   M 4 1      
FLGUPDISS Disposal modification   M 4 1      
FUEL Fuel type   M 4 3167      
GAC General account   GAC     [GAC]GAC0="";GAC Other  
GACACN CoA nature   M 15 2628      
GAL +/- value 15 MD1          
GALINIAMT Initial amt +/- value   MD1          
GALREFBAS Ref basis+/- value   MD1          
GALREFDAT Ref date +/- value   D4          
GEOFCY Geographic site   FCY     [FCY]FCY0=[FAS]GEOFCY Other  
GRAAMT Subsidy amount   MD1          
GRUEFFDAT Oper. effect. date   D4          
GRUINIAAS IGS initial asset ref   A 20        
GRUINICPY IGS initial company   CPY     [CPY]CPY0=[FAS]GRUINICPY Other  
GRUISSREF Intra-grp sale ref   A 41        
GRUORIAAS IGS source asset   A 20        
GRUORICPY IGS source company   CPY     [CPY]CPY0=[FAS]GRUORICPY Block  
GRUTAXBAS IGS tax basis   MD1          
IASACC IFRS allocation   GAC     [GAC]GAC0="";IASACC Other  
IASACN IFRS nature   M 15 2628      
IASCGU UGT   ADI     [ADI]CODE=613;IASCGU Block  
IASCPLDED IAS/IFRS add ded VAT   MD1          
IASCUR IFRS curr.   CUR     [TCU]TCU0=[FAS]IASCUR Block  
IASCURTYP Rate type   M 15 202      
IASETRNOT Receipt value ex-tax   MD1          
IASRATCUR Currency rate   RCU          
IASREGCUM VAT adj total   MD1          
IASREVVAT IFRS VAT repayment   MD1          
IASVATREG IAS/IFRS VAT adj   MD1          
IMLRVEISS Impair. rev./disposal 15 MD1          
INIDEDVAT Initial VAT rate   RAT          
INVPLN Project ref.   ADI     [ADI]CODE=614;INVPLN Block  
INVREQ Invest request   ADI     [ADI]CODE=616;INVREQ Block  
INVTYP Investment type   ADI     [ADI]CODE=515;INVTYP Other  
ISRCLCBAS Calculation basis   M 15 3154      
ISRCONREF Contract ref   A 20        
ISRTYP Insurance type   M 15 3153      
ISRVAL Insurance value   MD1          
ISRVALCOE Asset insurance disc coeff   COE          
ISRVALFLG Forcd ins val   MZS 4        
ISSAMT Disposal amount 15 MD1          
ISSDAT Issue date   D4          
ISSDATRUL Disposal date rule   M 30 3274      
ISSFIYPRE Prev FYR disposal   M 4 1      
ISSOPETYP IGS operation type   M 15 3172      
ISSTYP Disposal reason   M 15 3159      
ISSVATAMT VAT due on disposal   MD1          
ISSVATFLG Forced disposal VAT   MZS 4        
ISSVATRAT Disposal VAT rate   RAT          
ISSVATTRF Transferable VAT   MD1          
ISSVATTRFI Transferable VAT   MD1          
ITSDAT In service date   D4          
IVCSALISS Invoice reference   A 20        
IVCVATAMT VAT invoiced   MD1          
IVCVATAMTI VAT invoiced   MD1          
IVCVATFLG Invoiced VAT forced   MZS 4        
IVCVATFLGI Invoiced VAT forced   MZS 4        
IVCVATRAT Invd VAT rate   RAT          
IVCVATRATI Invd VAT rate   RAT          
KANOREAV Revaluation year 10 L 4       KPO
KANOUTIL Expected useful years 10 L 3       KPO
KAREAV Reval. deprec. total 10 DCB 9.2       KPO
KBONUS Bonus   DCB 19.8       KRU
KCOEF Reval. coefficient 10 DCB 3.4       KPO
KPSEPLN Seasonality plan   PSE         PSE
KSESFLG Seasonality flag   A 15       PSE
KVREAV Revalued value 10 DCB 9.2       KPO
LEAREF Lse contract ref.   LEA     [LEA]LEA0=[FAS]LEAREF RTZ LEA
LEAREFORI Src lease ct   LEA     [LEA]LEA0=[FAS]LEAREFORI Other LEA
LNGGAL Long term +/- value 15 MD1          
LOC Location   A 38        
NPL Registration no.   A 15        
OBYRNWCON CRO flag   M 4 1     CCN
ORDLIG Order line   C 4        
ORDREF Order ref   A 20        
ORIPURAMT IGS src asst purc amt   MD1          
ORIPURDAT IGS asset purch date   D4          
OWNTYP Holding type   M 15 3171      
PROPLN Production plan   VC9          
PURDAT Purchase date   D4          
PURNAT Purch nature   M 15 3152      
PYBVATTYP VAT repayment   M 15 3160      
R76COE Reval. coeff. 76   COE          
REFTAB1 Reference FF1   C 4        
REFTAB10 Reference FF10   C 4        
REFTAB2 Reference FF2   C 4        
REFTAB3 Reference FF3   C 4        
REFTAB4 Reference FF4   C 4        
REFTAB5 Reference FF5   C 4        
REFTAB6 Reference FF6   C 4        
REFTAB7 Reference FF7   C 4        
REFTAB8 Reference FF8   C 4        
REFTAB9 Reference FF9   C 4        
RGNDAT Registration date   D4          
RNTDAYDUR Rent dur. days   L 8        
RNTENDDAT Lease end   D4          
RNTMONDUR Rent dur. months   DCB 6.3        
RNTSTRDAT Lease start   D4          
RNWAASREF Renewal asset   VC9         CCN
RNWDAT Renewal date   D4         CCN
RNWDATFLG Forced renewal date   M 4 1     CCN
RNWDONFLG Renewal carried out   M 4 1     CCN
RNWFLG ERO flag   M 4 1     CCN
RNWVAL Renewal val.   MD1         CCN
RNWVALFLG Replacement amt end   MZS 4       CCN
RPLVAL New value   MD1          
RPLVALCOE New value coeff   COE          
RPLVALFLG New val   MZS 4        
RVAAPR Evaluator   ADI     [ADI]CODE=627;RVAAPR Block  
RVACMT Comment   DCO          
RVERPRVAL Prov. to reverse   MD1         CCN
SALCLSDAT Asset date for sale   D4          
SET Group No   A 20        
SHOGAL Short term +/- value 15 MD1          
SRLNBR Serial number   SRL          
STABILTYP Stability type   M 15 3156      
TAXBAS Tax basis   MD1          
TAXCOE Taxation coeff   RAT          
TAXCOEF Taxation coeff   RAT          
TAXCOEFGLO Global adjust. index   M 4 1      
TAXCOEFLG Forced taxation coef   M 4 1      
TAXCOER Taxation coeff   RAT          
TAXPLI Taxation rate   M   3164      
TAXTYP Tax type   M 15 3158      
THESLI Theo holding duratn   DUR          
TPAFLG Remittance with payment   M 4 1     CCN
TRFDAT Last transfer   D4          
UPDDAT Change date   D4          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USRFLDA1 Free field 1   ADI     [ADI]CODE=REFTAB1;USRFLDA1 Block  
USRFLDA10 Free field 10   ADI     [ADI]CODE=REFTAB10;USRFLDA10 Block  
USRFLDA2 Free field 2   ADI     [ADI]CODE=REFTAB2;USRFLDA2 Block  
USRFLDA3 Free field 3   ADI     [ADI]CODE=REFTAB3;USRFLDA3 Block  
USRFLDA4 Free field 4   ADI     [ADI]CODE=REFTAB4;USRFLDA4 Block  
USRFLDA5 Free field 5   ADI     [ADI]CODE=REFTAB5;USRFLDA5 Block  
USRFLDA6 Free field 6   ADI     [ADI]CODE=REFTAB6;USRFLDA6 Block  
USRFLDA7 Free field 7   ADI     [ADI]CODE=REFTAB7;USRFLDA7 Block  
USRFLDA8 Free field 8   ADI     [ADI]CODE=REFTAB8;USRFLDA8 Block  
USRFLDA9 Free field 9   ADI     [ADI]CODE=REFTAB9;USRFLDA9 Block  
USRFLDC1 Free field 1 coef   COE          
USRFLDC2 Fr field coeff 2   COE          
USRFLDD1 Free field date 1   D4          
USRFLDD2 Free field date 2   D4          
USRFLDD3 Free field date 3   D4          
USRFLDD4 Free field date 4   D4          
USRFLDM1 Free field amount 1   MD1          
USRFLDM2 Free field amount 2   MD1          
USRFLDM3 Free field amount 3   MD1          
USRFLDM4 Free field amount 4   MD1          
USRFLDM5 Free field amount 5   MD1          
USRFLDM6 Free field 6 amount   MD1          
VATREGAMT VAT repay adjust. - CoA   MD1          
VATREGCUM VAT adj total   MD1          
VATREGDAT Reference date   D4          
VATREGDED Deduct. VAT adjust - CoA   MD1          
VATREGDEDI Deduct VAT adjust - IAS   MD1          
VATRSD Residual duration   DUR          
VATYEAFLG Yearly adjust. index   M 4 1      
VEHBRA Vehicle make   ADI     [ADI]CODE=534;VEHBRA Block  
VEHCO2 CO2 rate   C 4        
VEHPLCNBR Number of places   C 4        
VEHPWR Admin power   C 4        
VEHTAXRUL Tax rule   M 15 3165      
VEHTYP Vehicle model   ADI     [ADI]CODE=965;VEHTYP Block  
VEHUSER User   ADI     [ADI]CODE=630;VEHUSER Block  
VEHUSGPRC % of usage   C 3        
VEHWEI1 TC wght   DCB 9.2        
VEHWEI2 TR wght   DCB 9.2