Table PREQUISD
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PREQUISD | PSD | Purchase request detail | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PSD0 | PSHNUM+PSDLIN | No | |
| PSD1 | LINORDFLG+ITMREF+EXTRCPDAT+PSHNUM+PSDLIN | Yes | |
| PSD2 | LINORDFLG+LINBUY+EXTORDDAT | Yes | |
| PSD3 | PSDNUMMMS+PSHNUM+PSDLIN | No | MMS |
| PJMPJT1 | PJT | Yes | PJM |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| AMTTAXISS | Issue tax amount | MD1 | PTX | |||||
| AMTTAXLIN1 | Tax amount 1 | MD1 | ||||||
| AMTTAXLIN2 | Tax amount 2 | MD1 | ||||||
| AMTTAXLIN3 | Tax amount 3 | MD1 | ||||||
| AMTTAXOTH1 | Amount other tax 1 | MD1 | PTX | |||||
| AMTTAXOTH2 | Amount other tax 2 | MD1 | PTX | |||||
| AMTTAXRCP | Receipt tax amount | MD1 | PTX | |||||
| ATECORI | Source | M | 15 | 7885 | ||||
| AUUID | Single identifier | AUUID | ||||||
| BASTAXLIN1 | Tax basis 1 | MD1 | ||||||
| BPSNUM | Supplier | BPR | [BPR]BPR0=[PSD]BPSNUM | Block | ||||
| CHGCOE | Rate | RCU | ||||||
| CHGTYP | Rate type | M | 15 | 202 | ||||
| CLCAMT1 | Tax calculation basis 1 | MD1 | ||||||
| CLCAMT2 | Tax calculation basis 2 | MD1 | ||||||
| CLCAMT3 | Tax calculation basis 3 | MD1 | ||||||
| CLCAMT4 | Tax calculation basis 4 | MD1 | PTX | |||||
| CLCAMT5 | Tax calculation basis 5 | MD1 | PTX | |||||
| CLCAMT6 | Tax calculation basis 6 | MD1 | PTX | |||||
| CLCAMT7 | Tax calculation basis 7 | MD1 | PTX | |||||
| CMMPRPFLG | Pre commitment indic | C | 1 | |||||
| CMMPRPNUM | Pre-commitment no. | VCR | ||||||
| CMMPRPTAX | Commitment type | M | 25 | 578 | ||||
| CPY | Company | CPY | [CPY]CPY0=[PSD]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CUR | Currency | CUR | [TCU]TCU0=[PSD]CUR | Block | ||||
| DEDTAXISS | Deductible tax | MD1 | PTX | |||||
| DEDTAXLIN1 | Deductible tax 1 | MD1 | ||||||
| DEDTAXLIN2 | Deductible tax 2 | MD1 | ||||||
| DEDTAXLIN3 | Deductible tax 3 | MD1 | ||||||
| DEDTAXOTH1 | Deductible tax | MD1 | PTX | |||||
| DEDTAXOTH2 | Deductible tax | MD1 | PTX | |||||
| DEDTAXRCP | Deductible tax | MD1 | PTX | |||||
| DISCRGREN1 | Discount 1 reason | PPR | [PPR]PPR0=[PSD]DISCRGREN1 | Block | PP1 | |||
| DISCRGREN2 | Discount 2 reason | PPR | [PPR]PPR0=[PSD]DISCRGREN2 | Block | PP2 | |||
| DISCRGREN3 | Discount 3 reason | PPR | [PPR]PPR0=[PSD]DISCRGREN3 | Block | PP3 | |||
| DISCRGREN4 | Discount 4 reason | C | 4 | PP4 | ||||
| DISCRGREN5 | Discount 5 reason | C | 4 | PP5 | ||||
| DISCRGREN6 | Discount 6 reason | C | 4 | PP6 | ||||
| DISCRGREN7 | Discount 7 reason | C | 4 | PP7 | ||||
| DISCRGREN8 | Discount 8 reason | C | 4 | PP8 | ||||
| DISCRGREN9 | Discount 9 reason | C | 4 | PP9 | ||||
| DISCRGVAL1 | Discount/Charge 1 | MD8 | PP1 | |||||
| DISCRGVAL2 | Discount/Charge 2 | MD8 | PP2 | |||||
| DISCRGVAL3 | Discount/Charge 3 | MD8 | PP3 | |||||
| DISCRGVAL4 | Discount/Charge 4 | DCB | 19.8 | PP4 | ||||
| DISCRGVAL5 | Discount/Charge 5 | DCB | 19.8 | PP5 | ||||
| DISCRGVAL6 | Discount/Charge 6 | DCB | 19.8 | PP6 | ||||
| DISCRGVAL7 | Discount/Charge 7 | DCB | 19.8 | PP7 | ||||
| DISCRGVAL8 | Discount/Charge 8 | DCB | 19.8 | PP8 | ||||
| DISCRGVAL9 | Discount/Charge 9 | DCB | 19.8 | PP9 | ||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EXTORDDAT | Calculated order date | D | ||||||
| EXTRCPDAT | Requested date | D | ||||||
| FBUFLG | Budget overrun | M | 4 | 1 | ||||
| GROPRI | Gross price | MD8 | ||||||
| ITMDES | Description | DES | ||||||
| ITMDES1 | Description | DES | ||||||
| ITMKND | Product type | M | 15 | 2513 | ||||
| ITMREF | Product | ITM | [ITM]ITM0=[PSD]ITMREF | Block | ||||
| LINAMT | Line amount - tax | MD1 | ||||||
| LINAPPFLG | Signed line | M | 15 | 280 | ||||
| LINATIAMT | Line amount + tax | MD1 | ||||||
| LINBUY | Buyer | AUS | [AUS]CODUSR=[PSD]LINBUY | Block | ||||
| LINCLEFLG | Line closed | M | 4 | 1 | ||||
| LINORDFLG | Ordered line | M | 4 | 1 | ||||
| LINPURTYP | Purchase type | M | 5 | 646 | ||||
| LINTEX | Text | TXC | ||||||
| NBAOF | No. of RFQs | L | 4 | |||||
| NETPRI | Net price | MD8 | ||||||
| ORDQTYPUU | Ordered PUR | QTY | ||||||
| ORDQTYSTU | Ordered STK | QTY | ||||||
| ORI | Request source | M | 15 | 505 | ||||
| PJT | Project | PJT | [PIM]PIM0=[PSD]PJT | Block | ||||
| PPDLIN | Response line | L | 8 | |||||
| PQHNUM | RFQ no. | VCR | ||||||
| PRHFCY | Receiving site | FCY | [FCY]FCY0=[PSD]PRHFCY | Block | ||||
| PRIREN | Price reason | PPR | [PPR]PPR0=[PSD]PRIREN | Block | ||||
| PSDLIN | Line | L | 8 | |||||
| PSDNUMMMS | Maintenance line id | A | 15 | |||||
| PSHFCY | Request site | FCY | [FCY]FCY0=[PSD]PSHFCY | Block | ||||
| PSHNUM | Request no. | VCR | ||||||
| PUU | Purchase unit | UOM | [TUN]TUN0=[PSD]PUU | Block | ||||
| QTYPUU | PUR quantity | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| STU | Stock unit | UOM | [TUN]TUN0=[PSD]STU | Block | ||||
| TAXISS | Issue tax | VAT | [TVT]TVT0=TAXISS;[V]GSUPCLE | Block | PTX | |||
| TAXOTH1 | Other tax 1 | VAT | [TVT]TVT0=TAXOTH1;[V]GSUPCLE | Block | PTX | |||
| TAXOTH2 | Other tax 2 | VAT | [TVT]TVT0=TAXOTH2;[V]GSUPCLE | Block | PTX | |||
| TAXRCP | Receipt tax | VAT | [TVT]TVT0=TAXRCP;[V]GSUPCLE | Block | PTX | |||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VACBPR | Tax rule | TVB | [TVB]TVB0=VACBPR;[V]GSUPCLE | Block | ||||
| VACTYP | Tax rule type | C | 1 | |||||
| VAT | Tax | 3 | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block | |||
| WIPNUM | Order no. | VCR |