Table EXPENSES
| Table | Abbreviation | Title | Module | Activity code |
|---|---|---|---|---|
| EXPENSES | EXS | Cost | Expense notes | NOF |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| EXS0 | REFNUM+EXSNUM+CTRNUM+LIN | No | |
| EXS1 | UID+CUR+FCY+VCRTYP+EXSNUM | Yes | |
| EXS2 | IMPNUM | Yes | |
| EXS3 | REFNUM+CTRNUM+EXSNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACC | Account | 10 | GAC | [GAC]GAC0=COA;ACC | Delete | |||
| AUUID | Single identifier | AUUID | ||||||
| BPCNUM | Customer | BPR | SRV | |||||
| BPR | Private account | BPR | ||||||
| CCE | Analytical dimension | CCE | [CCE]CCE0=DIE(indice);CCE(indice) | Block | ANA | |||
| CMT | Acknowledgement comment | A | 80 | |||||
| COA | Chart code | 10 | COA | [COA]COA0=[EXS]COA | Delete | |||
| CODEXP | Expense codes | TES | [TES]TES0=[EXS]CODEXP | Block | ||||
| CPY | Company | CPY | [CPY]CPY0=[EXS]CPY | Delete | SRV | |||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CRETIM | Time | L | 8 | |||||
| CREUSR | Creation user | A | 5 | |||||
| CTRNUM | Contract | CTR | ||||||
| CUR | Currency | CUR | [TCU]TCU0=[EXS]CUR | Block | ||||
| CURLED | Ledger currency | 10 | CUR | [TCU]TCU0=[EXS]CURLED | Delete | |||
| DATEXS | Date | D | ||||||
| DEDCUR | Input VAT | MD2 | ||||||
| DES | Comments | A | 250 | |||||
| DIE | Dim type code | DIE | [DIE]DIE0=[EXS]DIE | Block | ANA | |||
| ENDDAT | End date | D | ||||||
| EXPNUM | Export number | L | 8 | |||||
| EXSNUM | Expense note | L | 8 | |||||
| EXSSTA | Status | M | 15 | 743 | ||||
| FCY | Site | FCY | [FCY]FCY0=[EXS]FCY | Delete | ||||
| IMPNUM | Import SIRH | A | 30 | |||||
| INVFLG | Invoiceable | M | 4 | 1 | SRV | |||
| LED | Ledger | 10 | LED | [LED]LED0=[EXS]LED | Delete | |||
| LIN | Line no. | L | 7 | |||||
| PAYCUR | Paid amt | MD2 | ||||||
| PAYSHR | Paid amt | MD2 | ||||||
| QTY | Quantity | L | 6 | |||||
| RATCPY | Currency rate | RCU | ||||||
| RATDIV | Dividing rate | 10 | RCU | |||||
| RATMLT | Multiplying rate | 10 | RCU | |||||
| RATRPT | Reporting rate | RCU | ||||||
| REFNUM | Employee ID | MAT | [ID]ID0=REFNUM | Block | ||||
| REQNUM | Request no. | VCR | ||||||
| RFUCUR | Amt. reimbursed | MD2 | ||||||
| RFUSHR | Amt. reimbursed | MD2 | ||||||
| SOHLIG | Line | L | 6 | SRV | ||||
| SOHNUM | Order | VCR | SRV | |||||
| STA | Posted | M | 4 | 1 | ||||
| STADAT | Visa date | D | ||||||
| STAFLG | Signature | AUS | [AUS]CODUSR=STAFLG | Other | ||||
| STRDAT | Start date | D | ||||||
| TAXCUR | Tax/Reimbursed amt | MD2 | ||||||
| TIT | Title | A | 80 | |||||
| TRFREQ | Slip transferred | M | 4 | 1 | ||||
| TYPRAT | Rate type | M | 15 | 202 | ||||
| UID | Identifier | L | 8 | |||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDTIM | Time | L | 8 | |||||
| UPDUSR | Change user | A | 5 | |||||
| VAT | VAT | VAT | [TVT]TVT0=VAT;[V]GDOSLEG | Block | ||||
| VATCUR | Tax amount | MD2 | ||||||
| VCRNUM | Journal | VCR | ||||||
| VCRTYP | Entry type | GTE |