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 |