Table UPORDERQ
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| UPORDERQ | UOQ | PO quantity history | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| POQ0 | POHNUM+LINREVNUM+POPLIN+POQSEQ | No |
| 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 | |||||
| AUUID | Single identifier | AUUID | ||||||
| BASTAXLIN1 | Tax basis 1 | MD1 | ||||||
| BPAINV | Billing address | ADR | ||||||
| BPSINV | Bill-by BP | BPS | [BPS]BPS0=[UOQ]BPSINV | Other | ||||
| BPSNUM | Supplier | BPS | [BPS]BPS0=[UOQ]BPSNUM | Other | ||||
| CAD | Sequencing | M | 7 | 278 | ||||
| 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 | |||||
| CMMFLG | Commitment indic | C | 1 | |||||
| CMMNUM | Commitment no. | VCR | ||||||
| CMMTAX | Commitment type | M | 25 | 578 | ||||
| CPR | Stock cost per unit | MD8 | ||||||
| CPRAMT | Fixed cost per unit | MD5 | ||||||
| CPRCOE | Landed cost coef. | COE | ||||||
| CPRCUR | Company currency | CUR | [TCU]TCU0=[UOQ]CPRCUR | Block | ||||
| CPRPRI | Production cost PUR | MD8 | ||||||
| CPY | Company | CPY | [CPY]CPY0=[UOQ]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CSTPUR | Purchase cost per unit | MD8 | ||||||
| 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 | |||||
| DEMENDDAT | Requesteded end date | D | ||||||
| DEMENDHOU | Requested end time | C | 4 | |||||
| DEMRCPDAT | Requested receipt date | D | ||||||
| DEMRCPHOU | Requested delivery time | C | 4 | |||||
| DISBASLIN1 | Rebate tax basis 1 | MD1 | ||||||
| DISCRGAMT1 | Discount/Charge 1 | MD1 | ||||||
| DISCRGAMT2 | Discount/Charge 2 | MD1 | ||||||
| DISCRGAMT3 | Discount/Charge 3 | MD1 | ||||||
| DISCRGAMT4 | Discount/Charge 4 | MD1 | ||||||
| DISCRGAMT5 | Discount/Charge 5 | MD1 | ||||||
| DISCRGAMT6 | Discount/Charge 6 | MD1 | ||||||
| DISCRGAMT7 | Discount/Charge 7 | MD1 | ||||||
| DISCRGAMT8 | Discount/Charge 8 | MD1 | ||||||
| DISCRGAMT9 | Discount/Charge 9 | MD1 | ||||||
| ECCVALMAJ | Major version | ECS | ECC | |||||
| ECCVALMIN | Minor version | EVL | ECC | |||||
| EXPNUM | Export number | L | 8 | |||||
| EXTRCPDAT | Exp. receipt date | D | ||||||
| FBUFLG | Budget overrun | M | 4 | 1 | ||||
| FCSCPR | Stock cost total | MD1 | ||||||
| FCSCSTPUR | Purchase cost total | MD1 | ||||||
| FCYADD | Receipt address | ADR | ||||||
| INVQTYPUU | Invoiced PUR | QTY | ||||||
| INVQTYSTU | Invoiced STU | QTY | ||||||
| INVRCPNBR | No. of invoice receipts | C | 4 | |||||
| ITMKND | Product type | M | 15 | 2513 | ||||
| ITMREF | Product | ITM | [ITM]ITM0=[UOQ]ITMREF | Block | ||||
| ITMREFBPS | Supplier product | A | 20 | |||||
| ITMREFORI | Released product | ITM | [ITM]ITM0=[UOQ]ITMREFORI | Block | ||||
| LASINVDAT | Last invoice date | D | ||||||
| LASRCPDAT | Last receipt date | D | ||||||
| LIKQTYCOE | Link qty. coef. | COE | ||||||
| LINAMT | Line amount - tax | MD1 | ||||||
| LINAMTCPR | Stock cost | MD8 | ||||||
| LINATI | Line amount + tax | MD1 | ||||||
| LINATIAMT | Line amount + tax | MD1 | ||||||
| LINCLEFLG | Line closed | M | 4 | 1 | ||||
| LINCSTPUR | Purchase cost | MD8 | ||||||
| LININVFLG | Invoiced line | M | 4 | 1 | ||||
| LININVNBR | Number of invoices | C | 4 | |||||
| LINOCNDAT | Ack. date | D | ||||||
| LINOCNFLG | Acknowledgement flag | C | 1 | |||||
| LINOCNNUM | Ack. ID | A | 20 | |||||
| LINPRNFLG | Line printed | M | 4 | 1 | ||||
| LINPURTYP | Purchase type | M | 5 | 646 | ||||
| LINRCPNBR | Number of receipts | C | 4 | |||||
| LINREVNUM | Revision no. | C | 4 | |||||
| LINSTA | Line status | M | 7 | 279 | ||||
| LINSTOFCY | Shipment site | FCY | [FCY]FCY0=[UOQ]LINSTOFCY | Block | ||||
| LINTEX | Text | TXC | ||||||
| LINTYP | Line type | M | 20 | 570 | ||||
| LINVOU | Volume unit | UOM | [TUN]TUN0=[UOQ]LINVOU | Block | ||||
| LINWEU | Weight unit | UOM | [TUN]TUN0=[UOQ]LINWEU | Block | ||||
| MON | Months | C | 2 | |||||
| NETCUR | Currency | CUR | [TCU]TCU0=[UOQ]NETCUR | Block | ||||
| OCNLIN | Interco. sales line | L | 8 | |||||
| OCNSEQ | Interco. sales seq. | L | 8 | |||||
| OFS | Reorder LT | LTI | ||||||
| ORDDAT | Order date | D | ||||||
| ORI | Request source | M | 15 | 505 | ||||
| POHFCY | Order site | FCY | [FCY]FCY0=[UOQ]POHFCY | Block | ||||
| POHNUM | Order no. | VCR | ||||||
| POHTYP | Order type | M | 20 | 506 | ||||
| POPLIN | Line | L | 8 | |||||
| POQLNK | Line + sequence | A | 16 | |||||
| POQSEQ | Sequence number | L | 8 | |||||
| PPDLIN | Response line | L | 8 | |||||
| PQHNUM | RFQ no. | VCR | ||||||
| PRHFCY | Receiving site | FCY | [FCY]FCY0=[UOQ]PRHFCY | Block | ||||
| PTDLIN | Line | L | 8 | |||||
| PTHNUM | Receipt no. | VCR | ||||||
| PUU | Purchase unit | UOM | [TUN]TUN0=[UOQ]PUU | Block | ||||
| QTYPUU | PUR quantity | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| QTYUOM | Ordered qty. | QTY | ||||||
| QTYVOU | Volume | QTY | ||||||
| QTYWEU | Weight | QTY | ||||||
| RCPCLEFLG | Closed by receipt | M | 4 | 1 | ||||
| RCPQTYPUU | Received PUR | QTY | ||||||
| RCPQTYSTU | Received STK | QTY | ||||||
| REACSTPUR | Actual purchase cost | MD8 | ||||||
| RETQTYPUU | Required PUR | QTY | ||||||
| RETQTYSTU | Required STK | QTY | ||||||
| RETRCPDAT | Requirement date | D | ||||||
| REVCOD | Revision code | A | 1 | |||||
| SCOADD | Subcon. address | ADR | ||||||
| SDDLIN | Delivery line | L | 8 | |||||
| SDHNUM | Delivery no. | VCR | ||||||
| SHIQTYPUU | PUR qty. being deliv. | QTY | ||||||
| SHIQTYSTU | STK qty. being deliv. | QTY | ||||||
| SOHNUM | Sales order no. | VCR | ||||||
| SOPLIN | Sales order line | L | 8 | |||||
| SOQSEQ | Sequence number | L | 8 | |||||
| STCNUM | Cost structure | VCR | ||||||
| STU | Stock unit | UOM | [TUN]TUN0=[UOQ]STU | Block | ||||
| UOM | Order unit | UOM | [TUN]TUN0=[UOQ]UOM | Block | ||||
| UOMFLG | Order in PAC | M | 4 | 1 | ||||
| UOMPUUCOE | STK-PUR conversion | COE | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| USEPLC | Location reference | A | 30 | |||||
| VCRLINORI | Source document line | L | 8 | |||||
| VCRNUMORI | Original document | VCR | ||||||
| VCRSEQORI | Source document sequence no. | L | 8 | |||||
| VCRTYPORI | Source document type | M | 15 | 701 | ||||
| WEE | Week no. | C | 2 | |||||
| WIPNUM | Order no. | VCR | ||||||
| WIPSTA | WIP status | M | 15 | 317 | ||||
| WIPTYP | Order type | M | 15 | 306 | ||||
| YEA | Year | C | 4 |