Table ITMSALES
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| ITMSALES | ITS | Products - sales | Common Data |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| ITS0 | ITMREF | No | |
| ITS1 | ITMDES1 | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BASPRI | Base price | MD5 | ||||||
| BASPRIORI | Price origin | M | 15 | 2271 | ||||
| CFGVCRNUM | Journal number config | VCR | CFG | |||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CTMFLG | Back-to-back order | M | 4 | 1 | ||||
| CTMQTY | Direct bk-to-bk qty | QTY | ||||||
| DES1AXX | Description 1 | AX3 | ||||||
| EXPNUM | Export number | L | 8 | |||||
| GUAMON | Warranty (month) | C | 2 | |||||
| INVCND | Invoic. term | INVCND | [INVCND]INVCND0=INVCND;[V]GSUPCLE | Block | ||||
| ITMDES1 | Description 1 | DES | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[ITS]ITMREF | Delete | ||||
| ITMTYP | Type | M | 20 | 436 | ||||
| ITPTEX | Picking text | TXC | ||||||
| ITSTEX | Sales text | TXC | ||||||
| LNDFLG | Loan authorized | M | 4 | 1 | ||||
| LOAECCFLG | Version preload | M | 4 | 1 | ECC | |||
| MAXQTY | Maximum quantity | QTY | ||||||
| MINPFM | Minimum margin | RAT | ||||||
| MINPRI | Minimum price | MD5 | ||||||
| MINQTY | Minimum quantity | QTY | ||||||
| MINRMNPRC | Delivery tolerance % | RAT | ||||||
| PCK | Packaging | PCK | [TPA]TPA0=[ITS]PCK | Block | ||||
| PCKCAP | Packaging capacity | COE | ||||||
| PURPRIPRC | % applied | RAT | ||||||
| QTYFOR | Quantity formula | A | 3 | |||||
| SBSDAT | Substitution date | D | ||||||
| SBSITM | Substitution product | ITM | [ITM]ITM0=[ITS]SBSITM | Block | ||||
| THEPRI | Theoretical price | MD5 | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |