Table PRESP
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PRESP | PPH | RFQ responses | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PPH0 | BPSNUM+PQHNUM+PQDLIN | No | |
| PPH1 | ITMREF+BPSNUM+PQHNUM | Yes | |
| PPH2 | BPSNUM+ITMREF+PQHNUM | Yes |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| BPSNUM | Supplier | BPR | [BPR]BPR0=[PPH]BPSNUM | Block | ||||
| CPY | Company | CPY | [CPY]CPY0=[PPH]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| EANCODBPS | Supplier UPC code | A | 20 | |||||
| ITMDESBPS | Supplier description | DES | ||||||
| ITMREF | Product | A | 20 | |||||
| ITMREFBPS | Supplier product | A | 20 | |||||
| LINNBR | Number of lines | C | 4 | |||||
| PLISTC | Structure code | PRS | [PRS]PRS0=2;PLISTC | Block | ||||
| PQDLIN | Line | L | 8 | |||||
| PQHFCY | RFQ site | FCY | [FCY]FCY0=[PPH]PQHFCY | Block | ||||
| PQHNUM | RFQ no. | VCR | ||||||
| PRIFLG | Price recorded | M | 4 | 1 | ||||
| PRILINNBR | Number of price lines | C | 4 | |||||
| PRNFLG | Printed | M | 4 | 1 | ||||
| RSPDAT | Response date | D | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 |