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 |