Table SPRICCONF
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
SPRICCONF | SPC | Customer pricing parameters | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
SPC0 | PLI | No | |
SPC1 | PLIENAFLG+PLITYP+PIO+PLI | No |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
ABB | Abbreviation | 5 | A | 3 | ||||
ATICNVFLG | Conversion - / +tax | M | 4 | 1 | ||||
AUUID | Single identifier | AUUID | ||||||
COMPRO | Commission factor | M | 15 | 244 | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CRIBPCNUM | Customer criterion | C | 1 | |||||
CRIBPR | BP criterion | C | 1 | |||||
CRICURNUM | Currency criterion | C | 1 | |||||
CRIDES | Criterion title | 5 | DES | |||||
CRIDIE | Dimension type code | 5 | DIE | [DIE]DIE0=[SPC]CRIDIE | Block | |||
CRIIND | Criterion index | 5 | C | 4 | ||||
CRIITM | Product criterion | C | 1 | |||||
CRIITMNUM | Product criterion | C | 1 | |||||
CRILEN | Field length | 5 | DCB | 5 | ||||
CRINBR | Numbers of criteria | C | 1 | |||||
CRIUOMNUM | Unit criterion | C | 1 | |||||
CUR | Currency | CUR | [TCU]TCU0=[SPC]CUR | Block | ||||
CURCNVFLG | Currency conversion | M | 4 | 1 | ||||
DESAXX | Description | AX3 | ||||||
DISCRGPRO | Charge/Discount processing | M | 15 | 244 | SPR | |||
EXPNUM | Export number | L | 8 | |||||
FIL | Table | 5 | ATB | [ATB]CODFIC=[SPC]FIL | Block | |||
FLD | Field | 5 | AVA | |||||
FLDTYP | Field type | 5 | ATY | [ATY]CODTYP=[SPC]FLDTYP | Block | |||
FLDTYPCPL | Supplement type | 5 | A | 10 | ||||
FOCPRO | Free products | M | 15 | 273 | ||||
FOCTYP | Free type | M | 15 | 274 | ||||
LANDESSHO | Descriptions | A | 60 | |||||
LIEN | Link | 5 | M | 5 | 49 | |||
PIO | Priority | C | 3 | |||||
PLI | Price list code | SPC | [SPC]SPC0=[SPC]PLI | Other | ||||
PLIBPRCNR | BP concerns | M | 15 | 2210 | ||||
PLICPY | Company | CPY | [CPY]CPY0=[SPC]PLICPY | Block | ||||
PLIENAFLG | Active | M | 4 | 1 | ||||
PLISEA | Price search | C | 1 | |||||
PLISTC | Structure code | PRS | [PRS]PRS0=1;PLISTC | Block | ||||
PLITYP | Price list type | M | 10 | 241 | ||||
PPUMNU | Local menu | 5 | C | 3 | ||||
PRIFLD | Base price field | A | 250 | |||||
PRIIND | Base price index | C | 4 | |||||
PRIPRO | Price processing | M | 15 | 270 | ||||
PRIQTYFLG | Price/Quantity | M | 15 | 239 | ||||
PRIREN | Reason | SPR | [SPR]SPR0=[SPC]PRIREN | Block | ||||
PRITYP | Price - / +tax | M | 6 | 243 | ||||
UOMCNVFLG | Unit conversion | M | 4 | 1 | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDNULPRI | Update zero price | M | 4 | 1 | ||||
UPDUSR | Change user | A | 5 |