Table SINCENT
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SINCENT | SNE | Price update definition | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SNE0 | COD | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACS | Access code | ACS | [ACS]ACS0=[SNE]ACS | Block | ||||
| AUUID | Single identifier | AUUID | ||||||
| CHGTYP | Rate type | M | 15 | 202 | ||||
| COD | Code | A | 7 | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CURNEW | New currency | CUR | [TCU]TCU0=[SNE]CURNEW | Block | ||||
| CUROLD | Old currency | CUR | [TCU]TCU0=[SNE]CUROLD | Block | ||||
| DESAXX | Description | AX3 | ||||||
| EXPLNK | Link expression | 10 | AFR | 60 | ||||
| LANDESSHO | Descriptions | A | 60 | |||||
| LASCHGTYP | Rate type | M | 15 | 202 | ||||
| LASCURNEW | New currency | CUR | [TCU]TCU0=[SNE]LASCURNEW | Block | ||||
| LASCUROLD | Old currency | CUR | [TCU]TCU0=[SNE]LASCUROLD | Block | ||||
| LASDATPRO | Last process | D | ||||||
| LASENDCRD | Last price record | VCR | ||||||
| LASENDDAT | Validity end date | D | ||||||
| LASSTRCRD | First price record | VCR | ||||||
| LASSTRDAT | Validity start date | D | ||||||
| LASVLYDAT | Valid on | D | ||||||
| NBTBL | Number of tables | C | 2 | |||||
| NBVAR | Number | C | 2 | |||||
| PLI | Price list code | SPC | [SPC]SPC0=[SNE]PLI | Other | ||||
| PLIENDCRD | Last price record | VCR | ||||||
| PLIENDDAT | Validity end date | D | ||||||
| PLISTC | Structure code | PRS | [PRS]PRS0=1;PLISTC | Other | ||||
| PLISTRCRD | First price record | VCR | ||||||
| PLISTRDAT | Validity start date | D | ||||||
| SNEENAFLG | Active | M | 4 | 1 | ||||
| TBL | Linked tables | 10 | ATB | [ATB]CODFIC=[SNE]TBL | Block | |||
| TYP | Type | M | 15 | 454 | ||||
| UPDCRDFLG | Changeable | M | 4 | 1 | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATFLG | Changeable | M | 4 | 1 | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VARCOD | Variable | 20 | A | 10 | ||||
| VARCTL | Control table | 20 | ACL | [ACL]ACL0=[SNE]VARCTL | Block | |||
| VARDEF | Default value | 20 | AFR | 30 | ||||
| VARDES | Description | 20 | DES | |||||
| VARDESAXX | Description | 20 | AX3 | |||||
| VARLAS | Last value | 20 | AFR | 20 | ||||
| VARLNG | Length | 20 | DCB | 8 | ||||
| VARTYP | Type | 20 | ATY | [ATY]CODTYP=[SNE]VARTYP | Block | |||
| VLYDAT | Valid on | D |