Table TABEXPENS
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| TABEXPENS | TES | Expenses codes | Expense notes | NOF |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TES0 | CODEXP | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCCOD | Accounting code | CAC | [CAC]CAC0=11;ACCCOD;[V]GSUPCLE | Block | ||||
| ACS | Access code | ACS | [ACS]ACS0=[TES]ACS | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CCEDAC | Analytical modifications | M | 4 | 1 | ANA | |||
| CCEINI | Default dimensions | CDE | [CDE]CDE0=CCEINI;[V]GSUPCLE | Block | ||||
| CODEXP | Expense codes | TES | [TES]TES0=[TES]CODEXP | Delete | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DEB | Debit | M | 15 | 1 | ||||
| DESEXP | Title | DES | ||||||
| DESFLG | Comment | M | 15 | 1 | ||||
| DESSHO | Short title | SHO | ||||||
| DIE | Dimension type | DIE | [DIE]DIE0=[TES]DIE | Block | ANA | |||
| GRP | Group | AGF | [AGF]AGF0=[TES]GRP | Delete | ||||
| PRO | Early | M | 15 | 1 | ||||
| TYPVLT | Valuation type | M | 15 | 552 | ||||
| UOM | Unit | ADI | [ADI]CODE=551;UOM | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VAT | Tax | VAT | [TVT]TVT0=VAT;[V]GDOSLEG | Block | ||||
| VLTDEFPAR | Default value | VRA | [VRA]VRA0=VLTDEFPAR | Block | ||||
| VLTPFDPAR | Cap | VRA | [VRA]VRA0=VLTPFDPAR | Block | ||||
| VLYEND | Valid to | D | ||||||
| VLYSTR | Valid from | D |