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 |