Table FXDASSETS
| 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 | MD1 | 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 |