Table PPRICLIST
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
PPRICLIST | PPL | Supplier price lists | Common Data |
Key | Description | Duplicates | Activity code |
---|---|---|---|
PPL0 | PLI+PLICRD+PLILIN | No | |
PPL1 | PLI+PLICRI+PLISTRDAT | Yes | |
PPL2 | PLI+PLICRI1+PLISTRDAT | Yes | |
PPL3 | PLI+PLICRI2+PLISTRDAT | Yes |
Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
---|---|---|---|---|---|---|---|---|
AUUID | Single identifier | AUUID | ||||||
COMCOE | Comm factor | CCR | ||||||
CPNITMREF | Component | ITM | [ITM]ITM0=[PPL]CPNITMREF | Block | ||||
CREDAT | Date created | D | ||||||
CREDATTIM | Date time | ADATIM | ||||||
CREUSR | Creation user | A | 5 | |||||
CUR | Currency | CUR | [TCU]TCU0=[PPL]CUR | Block | ||||
DCGVAL | Charge/discount value | MD8 | PPR | |||||
EXPNUM | Export number | L | 8 | |||||
FOCAMTBKT | Free Class | MD1 | ||||||
FOCAMTMIN | Free threshold | MD1 | ||||||
FOCITMREF | Free product | ITM | [ITM]ITM0=[PPL]FOCITMREF | Block | ||||
FOCQTY | Free quantity | QTY | ||||||
FOCQTYBKT | Free Class | QTY | ||||||
FOCQTYMIN | Free threshold | QTY | ||||||
FOCUOM | Unit | UOM | [TUN]TUN0=[PPL]FOCUOM | Block | ||||
IMPNUMLIG | Import line | L | 8 | |||||
LTI | Lead time | C | 3 | |||||
MAXAMT | Maximum value | MD1 | ||||||
MAXQTY | Maximum quantity | QTY | ||||||
MINAMT | Minimum value | MD1 | ||||||
MINQTY | Minimum quantity | QTY | ||||||
PLI | Price list code | PLI | ||||||
PLICRD | Price list record | VCR | ||||||
PLICRI | Criteria | PPX | ||||||
PLICRI1 | Criteria 1 | PPU | ||||||
PLICRI2 | Criteria 2 | PPU | ||||||
PLICRI3 | Criterion 3 | PPU | ||||||
PLICRI4 | Criterion 4 | PPU | ||||||
PLICRI5 | Criterion 5 | PPU | ||||||
PLIENDDAT | Validity end date | D | ||||||
PLILIN | Line | L | 8 | |||||
PLISTRDAT | Validity start date | D | ||||||
PRI | Price | MD8 | ||||||
PRIDIV | Price factor | C | 4 | |||||
UOM | Unit | UOM | [TUN]TUN0=[PPL]UOM | Block | ||||
UPDDAT | Change date | D | ||||||
UPDDATTIM | Date time | ADATIM | ||||||
UPDUSR | Change user | A | 5 |