Table TMPLOFGRP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPLOFGRP | TLG | Temporary table | Fixed Assets |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TDE0 | EDTNUM+CPY+FCY+AASREF+CODLOF+LINLOF | No | |
| TDE1 | EDTNUM+CODLOF+LINLOF | No | |
| TDE2 | EDTNUM+AASREF | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AASDES1 | Description | DCO | ||||||
| AASIPTDAT | Allocation date | D4 | ||||||
| AASREF | Asset | VC9 | ||||||
| ACCCOD | Accounting code | CAC | [CAC]CAC0=GVML_COGIMMO;ACCCOD;[V]GSUPCLE | Other | ||||
| ACCDES | Accounting code title | DCO | ||||||
| ACGCUR | CoA curr. | CUR | [TCU]TCU0=[TLG]ACGCUR | Other | ||||
| ACGETRNOT | Receipt value ex-tax | MD1 | ||||||
| ACGGRP | Family | FAM | [FAM]FAM0=ACGGRP | Other | ||||
| ACGGRPDES | Family title | DCO | ||||||
| ACT | Activity | VC9 | ||||||
| AMTNOTCPY | Amount - tax | MD1 | ||||||
| AMTVATCPY | Tax amount | MD1 | ||||||
| AMTVATRCPY | VAT recovered | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| BPR | Supplier | BPR | [BPR]BPR0=[TLG]BPR | Other | ||||
| COA | Chart of accounts | COA | [COA]COA0=[TLG]COA | Delete | ||||
| CODLOF | Reference | VC9 | ||||||
| COURS | Currency rate | RCU | ||||||
| CPY | Company | CPY | [CPY]CPY0=[TLG]CPY | Delete | ||||
| CPYNAM | Company name | NAM | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREORI | Entry origin | M | 15 | 3162 | ||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[TLG]CREUSR | Other | ||||
| DATCOURS | Rate date | D4 | ||||||
| DATIMP | Allocation date | D4 | ||||||
| DATVCR | Invoice date | D4 | ||||||
| DEDVATAMT | VAT recovered | MD1 | ||||||
| DEDVATAMTI | VAT recovered | MD1 | ||||||
| DEDVATRAT | Recovered VAT rate | RAT | ||||||
| DEDVATRATI | Recovered VAT rate | RAT | ||||||
| DES | Description | DES | ||||||
| DEVRPT | Reporting currency | CUR | [TCU]TCU0=[TLG]DEVRPT | Other | ||||
| EDTNUM | Processing number | L | 8 | |||||
| FCY | Financial site | FCY | [FCY]FCY0=[TLG]FCY | Delete | ||||
| FCYNAM | Name | NAM | ||||||
| FLGLIKAAS | Asset link | M | 4 | 1 | ||||
| FLGLOFMAI | Principal expense | M | 4 | 1 | ||||
| IASCUR | IFRS curr. | CUR | [TCU]TCU0=[TLG]IASCUR | Other | ||||
| IASETRNOT | Receipt value ex-tax | MD1 | ||||||
| ITSDAT | In service date | D4 | ||||||
| IVCVATAMT | VAT invoiced | MD1 | ||||||
| IVCVATAMTI | VAT invoiced | MD1 | ||||||
| IVCVATRAT | Invd VAT rate | RAT | ||||||
| IVCVATRATI | Invd VAT rate | RAT | ||||||
| LED | Ledger | M | 15 | 2644 | ||||
| LINLOF | Line number | C | 4 | |||||
| OWNTYP | Holding type | M | 15 | 3171 | ||||
| PURDAT | Purchase date | D4 | ||||||
| QTY | Quantity | QTY | ||||||
| TYPCUR | Rate type | M | 15 | 202 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[TLG]UPDUSR | Other |