Table PREQUISA
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PREQUISA | PSA | Link purchase requests | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PSA0 | PSHNUM+PSDLIN+PQHNUM+PQDLIN | No | |
| PSA1 | PQHNUM+PQDLIN+PSHNUM+PSDLIN | No |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AUUID | Single identifier | AUUID | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | User | AUS | [AUS]CODUSR=[PSA]CREUSR | Other | ||||
| PQDLIN | Line | L | 8 | |||||
| PQHNUM | RFQ no. | VCR | ||||||
| PSDLIN | Pur. req. line no. | L | 8 | |||||
| PSHNUM | Request no. | VCR | ||||||
| PUU | Purchase unit | UOM | [TUN]TUN0=[PSA]PUU | Block | ||||
| QTYPUU | PUR quantity | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| STU | Stock unit | UOM | [TUN]TUN0=[PSA]STU | Block | ||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | User | AUS | [AUS]CODUSR=[PSA]UPDUSR | Other |