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