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 |