Table PORDERQ
Table | Abbreviation | Description | Module | Activity code |
---|---|---|---|---|
PORDERQ | POQ | POs quantities | Purchasing |
Key | Description | Duplicates | Activity code |
---|---|---|---|
POQ0 | POHNUM+POPLIN+POQSEQ | No | |
POQ1 | LININVFLG+WIPSTA+BPSINV+ITMREF+POHNUM | Yes | |
POQ2 | LINCLEFLG+WIPSTA+PRHFCY+BPSNUM+POHNUM | Yes | |
POQ3 | POHNUM+POQLNK | No | |
POQ4 | VCRTYPORI+VCRNUMORI+VCRLINORI+VCRSEQORI+ITMREFORI | Yes |
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 | BPR | [BPR]BPR0=[POQ]BPSINV | Block | ||||
BPSNUM | Supplier | BPR | [BPR]BPR0=[POQ]BPSNUM | Block | ||||
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=[POQ]CPRCUR | Block | ||||
CPRPRI | Production cost PUR | MD8 | ||||||
CPY | Company | CPY | [CPY]CPY0=[POQ]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=[POQ]ITMREF | Block | ||||
ITMREFBPS | Supplier product | A | 20 | |||||
ITMREFORI | Released product | ITM | [ITM]ITM0=[POQ]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=[POQ]LINSTOFCY | Block | ||||
LINTEX | Text | TXC | ||||||
LINTYP | Line type | M | 20 | 570 | ||||
LINVOU | Volume unit | UOM | [TUN]TUN0=[POQ]LINVOU | Block | ||||
LINWEU | Weight unit | UOM | [TUN]TUN0=[POQ]LINWEU | Block | ||||
MON | Months | C | 2 | |||||
NETCUR | Currency | CUR | [TCU]TCU0=[POQ]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=[POQ]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=[POQ]PRHFCY | Block | ||||
PTDLIN | Line | L | 8 | |||||
PTHNUM | Receipt no. | VCR | ||||||
PUU | Purchase unit | UOM | [TUN]TUN0=[POQ]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 | ||||||
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=[POQ]STU | Block | ||||
UOM | Order unit | UOM | [TUN]TUN0=[POQ]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 |