Table TMPMASFAS
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPMASFAS | MFS | Temporary table asset actions | Fixed Assets |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| MFS0 | TRTNUM+OBJREF | No | |
| MFS1 | TRTNUM+CPY+OBJREF | No | |
| MFS2 | TRTNUM+AASIND+OBJREF | No | |
| MFS3 | TRTNUM+AASIND+OBJREFO | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AASBUS | Activity | VC9 | ||||||
| AASBUSO | Activity | VC9 | ||||||
| AASDES1 | Description | DCO | ||||||
| AASDES1N | Description | DCO | ||||||
| AASDES2 | Description 2 | DCO | ||||||
| AASDES2N | Description 2 | DCO | ||||||
| AASDESO | Description | DCO | ||||||
| AASIND | Grouping indicator | A | 1 | |||||
| AASIPTDAT | Allocation date | D4 | ||||||
| AASORINBV | NV IGS source asset | MD1 | ||||||
| AASQTY | Quantity | QTY | ||||||
| AASQTYN | Quantity | QTY | ||||||
| AASTYP | Type | M | 15 | 3151 | ||||
| AASUOM | Unit | UOM | [TUN]TUN0=[MFS]AASUOM | Delete | ||||
| ACCCOD | Accounting code | CAC | [CAC]CAC0=[V]GVML_COGIMMO;ACCCOD;[V]GSUPCLE | Other | ||||
| ACCCODO | Accounting code | CAC | [CAC]CAC0=[V]GVML_COGIMMO;ACCCODO;[V]GSUPCLE | Other | ||||
| ACGBSEVAL | CoA bal sht value | MD1 | ||||||
| ACGCPLDED | Add deduc VAT CoA | MD1 | ||||||
| ACGCUR | CoA curr. | CUR | [TCU]TCU0=[MFS]ACGCUR | Other | ||||
| 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 | ||||
| ADMCOEFO | Admission coef. | RAT | ||||||
| ADMCOER | Admission coef. | RAT | ||||||
| ASJCOE | Liability coef. | RAT | ||||||
| ASJCOEF | Liability coef. | RAT | ||||||
| ASJCOEFGLO | Global adjust. index | M | 4 | 1 | ||||
| ASJCOEFO | Liability coef. | RAT | ||||||
| ASJCOER | Liability coef. | RAT | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BRDPRC | Distribution % | RAT | ||||||
| BSEVAL | Init bal sht value | MD1 | ||||||
| BUY | Buyer | BPR | [BPR]BPR0=[MFS]BUY | Other | ||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Delete | ANA | |||
| CCEO | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Delete | ANA | |||
| CCLTRF | Cancellation | M | 1 | 1 | ||||
| CCNACTCOD | Update code | CCA | CCN | |||||
| CCNACTCODO | Update code | CCA | CCN | |||||
| CCNREF | Concession contract | CCN | [CCN]CCN0=[MFS]CCNREF | Other | CCN | |||
| CMP | Main | AAS | [FAS]FAS0=[MFS]CMP | Delete | ||||
| CMP1 | Main | AAS | [FAS]FAS0=[MFS]CMP1 | Delete | ||||
| CMPORI | Main source | AAS | [FAS]FAS0=[MFS]CMPORI | Delete | ||||
| CMPSTA | Status | M | 15 | 3229 | ||||
| CNX | Context | M | 25 | 3100 | ||||
| CPY | Company | CPY | [CPY]CPY0=[MFS]CPY | Delete | ||||
| CRBGRAAMT | Reintegrtd amount | MD1 | ||||||
| CRBGRACUM | Reintegration total | MD1 | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[MFS]CREUSR | Other | ||||
| DATEFF | Deprec. bill date | D4 | ||||||
| DATISSPST | Issue date | D4 | ||||||
| DEDCOE | Deduction coef | RAT | ||||||
| DEDCOEF | Deduction coef | RAT | ||||||
| DEDCOEFO | 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=[MFS]DIE | Other | ANA | |||
| DPM | Depreciation method | DPM | ||||||
| DPMO | Depreciation method | DPM | ||||||
| DPMT | Theoretical method used | DPM | ||||||
| DPRBAS | Reval. BS value | MD1 | ||||||
| DPRBASO | Reval. BS value | MD1 | ||||||
| DPRCUM | FY depre total | MD1 | ||||||
| DPRCUMFLG | FYR forc deprec tot | M | 1 | 1 | ||||
| DPRCUMO | FY depre total | MD1 | ||||||
| DPRPLN | Depreciation plan | M | 25 | 3101 | ||||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Delete | ||||
| DSPO | Distribution | DSP | [DSP]DSP0=DSP;1 | Delete | ||||
| ETRNAT | Recpt nature | M | 15 | 3157 | ||||
| EXECLOCUIO | Init cuml clos FY | MD1 | ||||||
| EXECLOCUMI | Init cuml clos FY | MD1 | ||||||
| EXECLOCUMT | Theo cumul clos FY | MD1 | ||||||
| EXECLOCUTO | Theo cumul clos FY | MD1 | ||||||
| EXEIMLCUM | Cumulated exp. Y-1 | MD1 | ||||||
| EXEIMLCUMO | Cumulated exp. Y-1 | MD1 | ||||||
| EXERVADEV | Closed FY total reval. surpl. | MD1 | ||||||
| EXERVECUM | Acc. impair. rev. FY-1 | MD1 | ||||||
| EXERVECUMO | Acc. impair. rev. FY-1 | MD1 | ||||||
| EXETRFCUM | Depr rec transf FYR-1 | MD1 | ||||||
| EXETRFCUMO | Depr rec transf FYR-1 | MD1 | ||||||
| EXTIMLTYP | Impair. ext. reason | ADI | [ADI]CODE=516;EXTIMLTYP | RTZ | ||||
| EXTISSFLG | Provisional disposal | M | 4 | 1 | ||||
| EXTSALAMT | Expected sale amount | MD1 | ||||||
| FCY | Financial site | FCY | [FCY]FCY0=[MFS]FCY | Delete | ||||
| FCYO | Financial site | FCY | [FCY]FCY0=[MFS]FCYO | Delete | ||||
| FIYENDDAT | Fiscal year end date | D4 | ||||||
| FIYSTRDAT | Fiscal year start date | D4 | ||||||
| FLGCLC | Asset to calculate | M | 4 | 1 | ||||
| FLGCNXCLC | Context to calculate | 11 | M | 4 | 1 | |||
| FLGCNXFLX | Generated flows | A | 11 | |||||
| FLGERR | Flag | M | 1 | 1 | ||||
| FLGMOD | Flag | M | 1 | 1 | ||||
| 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 | ||||||
| GRAAMT | Subsidy amount | MD1 | ||||||
| GRUGAL | Intra-group +/- val | 15 | MD1 | |||||
| GRUTAXBAS | IGS tax basis | MD1 | ||||||
| IASACC | IFRS allocation | GAC | [GAC]GAC0="";IASACC | Other | ||||
| IASACN | IFRS nature | M | 15 | 2628 | ||||
| IASBSEVAL | IFRS bal sht val | MD1 | ||||||
| IASCGU | UGT | ADI | [ADI]CODE=613;IASCGU | Delete | ||||
| IASCGUO | UGT | ADI | [ADI]CODE=613;IASCGUO | Delete | ||||
| IASCPLDED | IAS/IFRS add ded VAT | MD1 | ||||||
| IASCUR | IFRS curr. | CUR | [TCU]TCU0=[MFS]IASCUR | Other | ||||
| IASCURTYP | Rate type | M | 15 | 202 | ||||
| IASDEV | IAS bal sht var val | MD1 | ||||||
| IASETRNOT | Receipt value ex-tax | MD1 | ||||||
| IASRATCUR | Currency rate | RCU | ||||||
| IASREGCUM | VAT adj total | MD1 | ||||||
| IASREVVAT | IFRS VAT repayment | MD1 | ||||||
| IASVATREG | IAS/IFRS tax adjust | MD1 | ||||||
| IML | Impairment | MD1 | ||||||
| IMLANNFLG | Deprec. canceln flag | M | 20 | 1 | ||||
| IMLBLC | Impairment loss balance | MD1 | ||||||
| IMLBLCO | Impairment loss balance | MD1 | ||||||
| IMLO | Impairment | MD1 | ||||||
| IMLRVE | Impairment loss reversal | MD1 | ||||||
| IMLRVEISS | Impair. rev./disposal | 15 | MD1 | |||||
| IMLRVELIM | Reversal cap | MD1 | ||||||
| IMLRVEO | Impairment loss reversal | MD1 | ||||||
| IMLTYP | Impairment loss type | M | 15 | 3280 | ||||
| INTIMLTYP | Intern.reason | ADI | [ADI]CODE=519;INTIMLTYP | RTZ | ||||
| ISRVAL | Insurance value | MD1 | ||||||
| ISSAMT | Disposal amount | 15 | MD1 | |||||
| ISSDAT | Issue date | D4 | ||||||
| ISSDATRUL | Disposal date rule | M | 30 | 3274 | ||||
| ISSTYP | Disposal reason | M | 15 | 3159 | ||||
| ISSVATAMT | VAT due on disposal | MD1 | ||||||
| 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 | ||||||
| LNGGAL | Long term +/- value | 15 | MD1 | |||||
| MSGERR | Message | A | 100 | |||||
| MVTDAT | Transfer date | D4 | ||||||
| NBV | Net value | MD1 | ||||||
| NBVO | Net value | MD1 | ||||||
| NBVT | Theor net value | MD1 | ||||||
| NBVTO | Theor net value | MD1 | ||||||
| NEWDUR | New duration | C | 4 | KPO | ||||
| NSPVAL | Market value | MD1 | ||||||
| NSPVALO | Prev market value | MD1 | ||||||
| OBJREF | Asset | VC9 | ||||||
| OBJREFN | Asset reference | AAS | [FAS]FAS0=[MFS]OBJREFN | Other | ||||
| OBJREFO | Srce ref for asset | AAS | [FAS]FAS0=[MFS]OBJREFO | Other | ||||
| OBYRNWCON | CRO flag | M | 4 | 1 | CCN | |||
| OBYRNWCONO | CRO flag | M | 4 | 1 | CCN | |||
| ORIPURAMT | IGS src asst purc amt | MD1 | ||||||
| OWNTYP | Holding type | M | 15 | 3171 | ||||
| PCGDEV | CoA bal sht var val | MD1 | ||||||
| PERCLOCUIO | Init cumul per clos | MD1 | ||||||
| PERCLOCUM | Periodic total P-1 | MD1 | ||||||
| PERCLOCUMI | Init cumul per clos | MD1 | ||||||
| PERCLOCUMO | Periodic total P-1 | MD1 | ||||||
| PERCLOCUMT | Theo cumul clos per | MD1 | ||||||
| PERCLOCUTO | Theo cumul clos per | MD1 | ||||||
| PERCLOEXC | Office P-1 amt excep. | MD1 | ||||||
| PERCLOEXCI | Acc P-1 exc depr I | MD1 | ||||||
| PERCLOEXCO | Office P-1 amt excep. | MD1 | ||||||
| PERCLOEXCT | Acc P-1 exc depr T | MD1 | ||||||
| PERCLOEXIO | Acc P-1 exc depr I | MD1 | ||||||
| PERCLOEXTO | Acc P-1 exc depr T | MD1 | ||||||
| PERENDDAT | Period end date | D4 | ||||||
| PERIMLCUM | Depre total P-1 | MD1 | ||||||
| PERIMLCUMO | Depre total P-1 | MD1 | ||||||
| PERREFCLC | Calculation period | D4 | ||||||
| PERREFCLCT | Per. for T calculation | D4 | ||||||
| PERRVADEV | Closed P total reval. surpl. | MD1 | ||||||
| PERRVECUM | Acc. impair. rev. P-1 | MD1 | ||||||
| PERRVECUMO | Acc. impair. rev. P-1 | MD1 | ||||||
| PERSTRDAT | Period start date | D4 | ||||||
| PURDAT | Purchase date | D4 | ||||||
| PURNAT | Purch nature | M | 15 | 3152 | ||||
| PYBVATTYP | VAT repayment | M | 15 | 3160 | ||||
| R76COE | Reval. coeff. 76 | COE | ||||||
| REGTVAFLG | VAT adjustment | M | 1 | 1 | ||||
| REGUL | Tax adjustment | MD1 | ||||||
| REGULI | Tax adjustment | MD1 | ||||||
| RENTRF | Reason | ADI | [ADI]CODE=612;RENTRF | Delete | ||||
| RNWDAT | Renewal date | D4 | CCN | |||||
| RNWDATFLG | Forced renewal date | M | 4 | 1 | CCN | |||
| RNWDATFLGO | Forced renewal date | M | 4 | 1 | CCN | |||
| RNWDATO | Renewal date | D4 | CCN | |||||
| RNWFLG | ERO flag | M | 4 | 1 | CCN | |||
| RNWFLGO | ERO flag | M | 4 | 1 | CCN | |||
| RPLVAL | New value | MD1 | ||||||
| RSDVAL | Residual value | MD1 | ||||||
| RVAAMT | Revaluation amount | MD1 | ||||||
| RVAAMTO | Revaluation amount | MD1 | ||||||
| RVAAPR | Evaluator | A | 15 | |||||
| RVACMT | Comment | DCO | ||||||
| RVACOE | Revaluation coef | COE | ||||||
| RVACOEREF | Table reference | A | 20 | |||||
| RVADAT | Revaluation date | D4 | ||||||
| RVATIADAT | Reval. effective start | M | 15 | 3273 | ||||
| RVATYP | Revaluation type | M | 15 | 3253 | ||||
| SALCLSDAT | Asset date for sale | D4 | ||||||
| SET | Group No | A | 20 | |||||
| SHOGAL | Short term +/- value | 15 | MD1 | |||||
| STABILTYP | Stability type | M | 15 | 3156 | ||||
| STRDPRDAT | Depre start date | D4 | ||||||
| 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 | ||||
| TAXCOEFO | Taxation coeff | RAT | ||||||
| TAXCOER | Taxation coeff | RAT | ||||||
| TAXTYP | Tax type | M | 15 | 3158 | ||||
| THESLI | Theo holding duratn | DUR | ||||||
| TPAFLG | Remittance with payment | M | 4 | 1 | CCN | |||
| TPAFLGO | Remittance with payment | M | 4 | 1 | CCN | |||
| TRTNUM | Processing number | L | 8 | |||||
| UNLINK | Undo | M | 4 | 1 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[MFS]UPDUSR | Other | ||||
| USRFLDA1 | Free field 1 | ADI | [ADI]CODE=REFTAB1;USRFLDA1 | Other | ||||
| USRFLDA10 | Free field 10 | ADI | [ADI]CODE=REFTAB10;USRFLDA10 | Other | ||||
| USRFLDA2 | Free field 2 | ADI | [ADI]CODE=REFTAB2;USRFLDA2 | Other | ||||
| USRFLDA3 | Free field 3 | ADI | [ADI]CODE=REFTAB3;USRFLDA3 | Other | ||||
| USRFLDA4 | Free field 4 | ADI | [ADI]CODE=REFTAB4;USRFLDA4 | Other | ||||
| USRFLDA5 | Free field 5 | ADI | [ADI]CODE=REFTAB5;USRFLDA5 | Other | ||||
| USRFLDA6 | Free field 6 | ADI | [ADI]CODE=REFTAB6;USRFLDA6 | Other | ||||
| USRFLDA7 | Free field 7 | ADI | [ADI]CODE=REFTAB7;USRFLDA7 | Other | ||||
| USRFLDA8 | Free field 8 | ADI | [ADI]CODE=REFTAB8;USRFLDA8 | Other | ||||
| USRFLDA9 | Free field 9 | ADI | [ADI]CODE=REFTAB9;USRFLDA9 | Other | ||||
| 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 | ||||||
| VALNET | Net value | MD1 | ||||||
| VATREGAMT | VAT adj amount | 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 |