Table PINVOICED
| Table | Abbreviation | Description | Module | Activity code |
|---|---|---|---|---|
| PINVOICED | PID | Purchase invoice detail | Purchasing |
| Key | Description | Duplicates | Activity code |
|---|---|---|---|
| PID0 | NUM+PIDLIN | No | |
| PID1 | TYPORI+NUMORI+LINORI+SEQORI+NUM+PIDLIN | No | |
| PID2 | ITMREF+NUM+PIDLIN | No | |
| PID3 | BPR+INVTYP+ITMREF+NUM+PIDLIN | No | |
| PID4 | POHNUM+POPLIN+POQSEQ | Yes | |
| PJMPJT1 | PJT | Yes | PJM |
| Column | Normal title | Dim. | Type | Length | Menu | Link expression | Cancellation | Act |
|---|---|---|---|---|---|---|---|---|
| ACCDAT | Accounting date | D | ||||||
| AMTATILIN | Line amount + tax | MD1 | ||||||
| AMTDEPLIN | Discount amount | MD1 | ||||||
| AMTNOTLIN | Line amount - tax | MD1 | ||||||
| AMTNOTLINCAL | Line amount - tax | MD1 | ||||||
| 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 | ||||||
| BPR | BP | BPR | [BPR]BPR0=[PID]BPR | Block | ||||
| BPSNUM | Supplier | BPR | [BPR]BPR0=[PID]BPSNUM | Block | ||||
| 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 | |||||
| CMMNUM | Commitment no. | VCR | ||||||
| CPR | Cost price | DCB | 10.8 | |||||
| CPRAMT | Fixed cost per unit | MD5 | ||||||
| CPRCOE | Landed cost coef. | COE | ||||||
| CPRCUR | Currency | CUR | [TCU]TCU0=[PID]CPRCUR | Block | ||||
| CPY | Company | CPY | [CPY]CPY0=[PID]CPY | Block | ||||
| CREDAT | Date created | D | ||||||
| CREDATTIM | Date time | ADATIM | ||||||
| CREUSR | Creation user | A | 5 | |||||
| CSTMAJLIN | New cost | M | 4 | 1 | ||||
| CSTPUR | Purchase cost per unit | MD8 | ||||||
| DCLEECNUM | VAT declaration no. | EEC | KPO | |||||
| DDTADEP1 | Dist. line inv. elmt. 1 | MD1 | ||||||
| DDTADEP2 | Dist. line inv. elmt. 2 | MD1 | ||||||
| DDTADEP3 | Dist. line inv. elmt. 3 | MD1 | ||||||
| DDTADEP4 | Dist. line inv. elmt. 4 | MD1 | ||||||
| DDTADEP5 | Dist. line inv. elmt. 5 | MD1 | ||||||
| DDTADEP6 | Dist. line inv. elmt. 6 | MD1 | ||||||
| DDTADEP7 | Dist. line inv. elmt. 7 | MD1 | ||||||
| DDTADEP8 | Dist. line inv. elmt. 8 | MD1 | ||||||
| DDTADEP9 | Dist. line inv. elmt. 9 | MD1 | ||||||
| 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 | |||||
| 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 | ||||||
| DISCRGREN1 | Discount 1 reason | PPR | [PPR]PPR0=[PID]DISCRGREN1 | Block | PP1 | |||
| DISCRGREN2 | Discount 2 reason | PPR | [PPR]PPR0=[PID]DISCRGREN2 | Block | PP2 | |||
| DISCRGREN3 | Discount 3 reason | PPR | [PPR]PPR0=[PID]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 | ||||
| EECFLOPHY | Physical flow | M | 4 | 1 | DEB | |||
| ENDDAT | End date | D | ||||||
| FASREF | FA reference | A | 30 | |||||
| FCSCOD | Cost | FCS | [FCS]FCS0=[PID]FCSCOD | Block | ||||
| FCSCPR | Stock cost total | MD1 | ||||||
| FCSCSTPUR | Purchase cost total | MD1 | ||||||
| FCY | Site | FCY | [FCY]FCY0=[PID]FCY | Block | ||||
| FCYLIN | Line site | FCY | [FCY]FCY0=[PID]FCYLIN | Block | ||||
| FLG1099 | 1099 | M | 4 | 1 | S1099 | |||
| GLU | Non-financial unit | UOM | [TUN]TUN0=[PID]GLU | Block | ||||
| GROPRI | Gross price | MD8 | ||||||
| INVLIN | Line | L | 8 | |||||
| INVNUM | Invoice number | VCR | ||||||
| INVTYP | Invoice category | M | 15 | 645 | ||||
| ITMDES | Description | DES | ||||||
| ITMDES1 | Description | DES | ||||||
| ITMKND | Product type | M | 15 | 2513 | ||||
| ITMREF | Product | ITM | [ITM]ITM0=[PID]ITMREF | Block | ||||
| LIKQTYCOE | Link qty. coef. | COE | ||||||
| LINAMTCPR | Stock cost | MD8 | ||||||
| LINCSTPUR | Purchase cost | MD8 | ||||||
| LINEECFLG | Debit line | M | 4 | 1 | DEB | |||
| LINORI | Source line | L | 8 | |||||
| LINPURTYP | Purchase type | M | 5 | 646 | ||||
| LINTEX | Text | TXC | ||||||
| LINTYP | Line type | M | 20 | 570 | ||||
| LINVOU | Volume unit | UOM | [TUN]TUN0=[PID]LINVOU | Block | ||||
| LINWEU | Weight unit | UOM | [TUN]TUN0=[PID]LINWEU | Block | ||||
| MATTOL | Matching tolerance | MAT | [MAT]MAT0=[PID]MATTOL | Block | ||||
| NETCUR | Currency | CUR | [TCU]TCU0=[PID]NETCUR | Block | ||||
| NETPRI | Net price | MD8 | ||||||
| NUM | Document no. | VCR | ||||||
| NUMORI | Source number | VCR | ||||||
| ORINETPRI | Source net price | MD8 | ||||||
| ORIQTYPUU | Source quantity | QTY | ||||||
| ORIQTYVOU | Original volume | QTY | ||||||
| ORIQTYWEU | Original weight | QTY | ||||||
| PERNBR | Periodicity | C | 4 | |||||
| PERTYP | Periodicity | M | 15 | 635 | ||||
| PIDLIN | Line | L | 8 | |||||
| PIHTYP | Purchase invoice cat. | M | 20 | 533 | ||||
| PIVTYP | Usr invoice type | TPV | [TPV]TPV0=PIVTYP;[V]GSUPCLE | Block | ||||
| PJT | Project | PJT | [PIM]PIM0=[PID]PJT | Block | ||||
| PNDLIN | Line | L | 8 | |||||
| PNHNUM | Return no. | VCR | ||||||
| POHNUM | Order no. | VCR | ||||||
| POPLIN | PO line | L | 8 | |||||
| POQSEQ | Sequence number | L | 8 | |||||
| PRIREN | Price reason | PPR | [PPR]PPR0=[PID]PRIREN | Block | ||||
| PRTFLG | Partial invoice | M | 4 | 1 | ||||
| PTDLIN | Line | L | 8 | |||||
| PTHNUM | Receipt no. | VCR | ||||||
| PUU | Purchase unit | UOM | [TUN]TUN0=[PID]PUU | Block | ||||
| QTYBUDLIN | Qty to be decommitted | QTY | ||||||
| QTYGLU | Actual quantity | QTY | ||||||
| QTYPUU | PUR quantity | QTY | ||||||
| QTYSTU | STK quantity | QTY | ||||||
| QTYUOM | Invoiced qty. | QTY | ||||||
| QTYVOU | Volume | QTY | ||||||
| QTYWEU | Weight | QTY | ||||||
| RCPDAT | Receipt date | D | ||||||
| SATISS | Issue region | SAT | PTX | |||||
| SATRCP | Receipt region | SAT | PTX | |||||
| SEQORI | Original sequence | L | 8 | |||||
| SHIPLIN | Line | L | 8 | |||||
| SHIPNUM | Shipment number | VCR | ||||||
| SIDLIN | Sales invoice line | L | 8 | |||||
| STCNUM | Cost structure | VCR | ||||||
| STCRFLG | Reconciled | M | 4 | 1 | ||||
| STRDAT | Start date | D | ||||||
| STU | Stock unit | UOM | [TUN]TUN0=[PID]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 | |||
| TSICOD | Statistical group | ADI | [ADI]CODE=indice+20;TSICOD(indice) | Other | STI | |||
| TWMSTA | Match status | M | 15 | 585 | ||||
| TYPORI | Line origin | M | 10 | 511 | ||||
| UOM | Invoicing unit | UOM | [TUN]TUN0=[PID]UOM | Block | ||||
| UOMPUUCOE | STK-PUR conversion | COE | ||||||
| UPDDAT | Change date | D | ||||||
| UPDDATTIM | Date time | ADATIM | ||||||
| UPDUSR | Change user | A | 5 | |||||
| VAT | Tax | 3 | VAT | [TVT]TVT0=VAT(indice);[V]GSUPCLE | Block |