Table SPRICPRTQ
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| SPRICPRTQ | SPQ | Sales price catalog | Sales |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| SPQ0 | COD+BPCORD+ITMREF+SPQLIN | No | |
| SPQ1 | COD+ITMREF+BPCORD+SPQLIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPCORD | Sold-to | BPR | [BPR]BPR0=[SPQ]BPCORD | Delete | ||||
| COD | Catalog | SPP | [SPP]SPP0=[SPQ]COD | Delete | ||||
| COMCOE | Comm factor | CCR | ||||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[SPQ]CUR | Other | ||||
| DAT | Date | D | ||||||
| DCGVAL | Charge/discount value | 9 | MD8 | |||||
| FOCITMREF | Free product | ITM | [ITM]ITM0=[SPQ]FOCITMREF | Delete | ||||
| FOCQTY | Free quantity | QTY | ||||||
| FOCUOM | Unit | UOM | [TUN]TUN0=[SPQ]FOCUOM | Other | ||||
| GROPRI | Gross price | MD8 | ||||||
| ITMREF | Product | ITM | [ITM]ITM0=[SPQ]ITMREF | Delete | ||||
| LTI | Lead time | C | 3 | |||||
| MINQTY | Minimum quantity | QTY | ||||||
| NETPRI | Net price | MD8 | ||||||
| PLI | Price list code | 12 | SPC | [SPC]SPC0=[SPQ]PLI | Delete | |||
| PLICRD | Price list record | 12 | VCR | |||||
| PLILIN | Line | 12 | L | 8 | ||||
| PLIREN | Reason | 12 | SPR | [SPR]SPR0=[SPQ]PLIREN | Other | |||
| PRITYP | Price - / +tax | M | 6 | 243 | ||||
| SALFCY | Sales site | FCY | [FCY]FCY0=[SPQ]SALFCY | Delete | ||||
| SPQLIN | Line | L | 8 | |||||
| STOFCY | Shipment site | FCY | [FCY]FCY0=[SPQ]STOFCY | Delete | ||||
| UOM | Unit | UOM | [TUN]TUN0=[SPQ]UOM | Other | ||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |