Table LEASE
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| LEASE | LEA | Lease contracts | Fixed Assets | LEA |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| LEA0 | LEAREF | No | |
| LEA1 | CPY+LEAREF | No | |
| LEA2 | CPY+FCY+LEAREF | No | |
| LEA3 | LEAREFORI | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | CAC | [CAC]CAC0=[V]GVML_COGLOCF;ACCCOD;[V]GSUPCLE | Other | ||||
| AUUID | Single identifier | AUUID | ||||||
| BEFRNT | Advance rent | MD1 | ||||||
| BSENAT | Bal sht line | M | 15 | 3226 | ||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Other | ANA | |||
| CIGCOD | IGS reference | A | 10 | |||||
| CPY | Company | CPY | [CPY]CPY0=[LEA]CPY | Delete | ||||
| CREDAT | Date created | D4 | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREORI | Entry origin | M | 15 | 3162 | ||||
| CREUSR | Creation user | A | 5 | |||||
| CUMIASBSE | Receipt value total | MD1 | ||||||
| CUMRNTAMT | Charge total | MD1 | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[LEA]CUR | Other | ||||
| CURTYP | Rate type | M | 15 | 202 | ||||
| CUTDAT | Update date | D4 | ||||||
| DIE | Dimension type code | DIE | [DIE]DIE0=[LEA]DIE | Other | ANA | |||
| DSP | Distribution | DSP | [DSP]DSP0=DSP;1 | Other | ||||
| DURPER | Period duratns | C | 4 | |||||
| ENDLEADAT | Contrct end date | D4 | ||||||
| FCY | Site | FCY | [FCY]FCY0=[LEA]FCY | Block | ||||
| IASCUR | IFRS curr. | CUR | [TCU]TCU0=[LEA]IASCUR | Other | ||||
| IASCURTYP | Rate type | M | 15 | 202 | ||||
| IASRATCUR | IFRS currency exch rate | RCU | ||||||
| ICRBRWRAT | Incremental borrowing rate | RAT | ||||||
| IMPLEARAT | Implied interest rate | RAT | ||||||
| INIDIRCST | Initial direct costs | MD1 | ||||||
| INIPREVAL | Init. present value | MD1 | ||||||
| INIPREVALC | Init. present value | MD1 | ||||||
| INIPREVALI | Init. present value | MD1 | ||||||
| INIROU | Initial right of use | MD1 | ||||||
| INIROUC | Initial right of use | MD1 | ||||||
| INIROUI | Initial right of use | MD1 | ||||||
| LEAAMT | Capital amount | MD1 | ||||||
| LEAAMTDEV | Capital in company currency | MD1 | ||||||
| LEAAMTIAS | Capital in IFRS currency | MD1 | ||||||
| LEACUR | Funding currency | CUR | [TCU]TCU0=[LEA]LEACUR | Other | ||||
| LEADES | Description 1 | DCO | ||||||
| LEADES2 | Description 2 | DCO | ||||||
| LEAEXS | Building cost | MD1 | ||||||
| LEANAT | Nature | M | 15 | 3166 | ||||
| LEAORI | Source | M | 15 | 3155 | ||||
| LEARAT | Interest rate | RAT | ||||||
| LEAREF | Lse contract ref. | LEA | [LEA]LEA0=[LEA]LEAREF | BSRA | ||||
| LEAREFORI | Lease ag IGS origi | VC9 | ||||||
| LEASTA | Status | M | 15 | 3227 | ||||
| LEATYP | Contract type | M | 15 | 3224 | ||||
| LES | Lessor | BPR | [BPR]BPR0=[LEA]LES | Other | ||||
| RATCUR | Currency rate | RCU | ||||||
| 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 | |||||
| RESCOS | Restoration cost | MD1 | ||||||
| RPUDAT | Option exercise date | D4 | ||||||
| RPUVAL | Scrap value | MD1 | ||||||
| RPUVALDEV | Scrap value | MD1 | ||||||
| RPUVALIAS | Scrap value | MD1 | ||||||
| STRLEADAT | Contrct start date | D4 | ||||||
| TRMLEADAT | Termination date | D4 | ||||||
| UPDDAT | Change date | D4 | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| 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 |