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 |