Table TMPCNSESL2
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| TMPCNSESL2 | TESL2 | EC Sales List | Financials | ESL |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| TESL20 | USERID+SEQ | No | |
| TESL21 | USERID+EECNUM+SALTYPCOD | Yes | |
| TESL22 | USERID+EECNUM+SALTYPCOD+CRY+CPY+FCYLIN+OFFACC+TAX+TYP+NUM+LIN+ACC+SEQ | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACC | Account | GAC | [GAC]GAC0=COA;ACC | Other | ||||
| ACCDAT | Accounting date | D | ||||||
| AMT | Amount | MD1 | ||||||
| AUUID | Single identifier | AUUID | ||||||
| CAT | Category | M | 15 | 618 | ||||
| COMMENT | Comment | A | 250 | |||||
| CPY | Company | CPY | [CPY]CPY0=[TESL2]CPY | Other | ||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | AUS | [AUS]CODUSR=[TESL2]CREUSR | Block | ||||
| CRY | Country | CRY | [TCY]TCY0=[TESL2]CRY | Other | ||||
| CUR | Currency | CUR | [TCU]TCU0=[TESL2]CUR | Other | ||||
| DESVCR | Description | DES | ||||||
| DOCDAT | Document date | D | ||||||
| EECNUM | EU VAT no. | A | 20 | |||||
| ERRTYP | Error | C | 4 | |||||
| FCYLIN | Site | FCY | [FCY]FCY0=[TESL2]FCYLIN | Other | ||||
| FLG | A | 3 | ||||||
| LIN | Line | C | 3 | |||||
| NBERR | Errors | C | 4 | |||||
| NBWRN | Warnings | C | 4 | |||||
| NUM | Document no. | VCR | ||||||
| OFFACC | BP code | BPR | [BPR]BPR0=[TESL2]OFFACC | Other | ||||
| SALTYPCOD | Type | A | 8 | |||||
| SEQ | Sequence | L | 8 | |||||
| STA | Status | M | 15 | 617 | ||||
| TAX | Tax | VAT | [TVT]TVT0=TAX;[V]GSUPCLE | Other | ||||
| TYP | Entry type | GTE | [GTE]GTE0=TYP;LEG | Other | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | AUS | [AUS]CODUSR=[TESL2]UPDUSR | Block | ||||
| USERID | User identity+ adxuid | ID | ||||||
| VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Other |