Table TABEXPENS
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TABEXPENS | TES | Expenses tables | A/P-A/R accounting |
| 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=20;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 | |||
| CCEFLG | Analytical modifications | M | 4 | 1 | ANA | |||
| CODEXP | Expense code | TES | [TES]TES0=[TES]CODEXP | Delete | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| DESEXP | Description | DES | ||||||
| DESFLG | Comment | M | 4 | 1 | ||||
| DESSHO | Short description | SHO | ||||||
| DESTRA | Description | AX3 | ||||||
| DIE | Analytical dimension type | DIE | [DIE]DIE0=[TES]DIE | Block | ANA | |||
| GFY | Group | AGF | [AGF]AGF0=[TES]GFY | Block | ||||
| INICCE | Initialization | M | 4 | 2802 | ANA | |||
| NBRCCE | C | 2 | ||||||
| PCCCOD | Cost type | PJCC | [PJCC]PCC0=[TES]PCCCOD | Block | PJM | |||
| SHOTRA | Short description | AX1 | ||||||
| TYPVLT | Valuation type | M | 15 | 2803 | ||||
| UOM | Unit | ADI | [ADI]CODE=10;UOM | Block | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VAT | Tax | VAT | [TVT]TVT0=VAT;[V]GSUPCLE | Block | ||||
| VLTDEFPAR | Default value | ADP | ||||||
| VLTDEFUNI | Default value | DCB | 9.2 | |||||
| VLTPFDPAR | Cap | ADP | ||||||
| VLTPFDUNI | Cap | DCB | 9.2 | |||||
| VLYEND | Validity end date | D | ||||||
| VLYSTR | Validity start date | D |