Table Abbreviation Description Module Activity code
PRETURND PND Detail return Purchasing  

Key Description Duplicates Activity code
PND0 PNHNUM+PNDLIN No  
PND1 PTHNUM+PTDLIN Yes  
PND2 LININVFLG+BPSINV+ITMREF+PNHNUM+PNDLIN No  
PND3 POHNUM+POPLIN+POQSEQ Yes  
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
AUUID Single identifier   AUUID          
BASTAXLIN1 Tax basis 1   MD1          
BPAINV Billing address   ADR          
BPOCRY Shipping country   CRY     [TCY]TCY0=[PND]BPOCRY Block  
BPSINV Bill-by BP   BPR     [BPR]BPR0=[PND]BPSINV Block  
BPSNDE Supplier packing slip no.   A 20        
BPSNUM Supplier   BPR     [BPR]BPR0=[PND]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
CPR Cost price   MD8          
CPRCOE Landed cost coef.   COE          
CPRCUR Currency   CUR     [TCU]TCU0=[PND]CPRCUR Block  
CPY Company   CPY     [CPY]CPY0=[PND]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
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=[PND]DISCRGREN1 Block PP1
DISCRGREN2 Discount 2 reason   PPR     [PPR]PPR0=[PND]DISCRGREN2 Block PP2
DISCRGREN3 Discount 3 reason   PPR     [PPR]PPR0=[PND]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
EECINCRAT Intrastat increase   RAT         DEB
GROPRI Gross price   MD8          
INVQTYPUU Invoiced PUR   QTY          
INVQTYSTU Invoiced STU   QTY          
ITMDES Description   DES          
ITMDES1 Description   DES          
ITMKND Product type   M 15 2513      
ITMREF Product   ITM     [ITM]ITM0=[PND]ITMREF Block  
LIKQTYCOE Link qty. coef.   COE          
LINAMT Line amount - tax   MD1          
LINATIAMT Line amount + tax   MD1          
LINAUTFLG Automatic flow   M 4 1      
LINCAT Movement category   M 15 574      
LINEECFLG Debit line   M 4 1     DEB
LININVFLG Invoiced line   M 4 1      
LINPRNFLG Line printed   M 4 1      
LINPSTDAT Reversal date   D          
LINPSTFLG Posted line   M 4 1      
LINPURTYP Purchase type   M 5 646      
LINSTOFCY Shipment site   FCY     [FCY]FCY0=[PND]LINSTOFCY Block  
LINTEX Text   TXC          
LINTYP Line type   M 20 570      
NETCUR Currency   CUR     [TCU]TCU0=[PND]NETCUR Block  
NETPRI Net price   MD8          
NETPRIPUU Net price PUR   MD8          
ORDFLG Reinstatement   M 15 540      
ORICRY Destination country   CRY     [TCY]TCY0=[PND]ORICRY Block  
PJT Project   PJT     [PIM]PIM0=[PND]PJT Block  
PNDLIN Line   L 8        
PNHFCY Return site   FCY     [FCY]FCY0=[PND]PNHFCY Block  
PNHNUM Return no.   VCR          
POHFCY Order site   FCY     [FCY]FCY0=[PND]POHFCY Block  
POHNUM Order no.   VCR          
POHTYP Order type   M 20 506      
POPLIN Line   L 8        
POQSEQ PO sequence no.   L 8        
PRIREN Price reason   PPR     [PPR]PPR0=[PND]PRIREN Block  
PTDLIN Line   L 8        
PTHNUM Receipt no.   VCR          
PUU Purchase unit   UOM     [TUN]TUN0=[PND]PUU Block  
QTYPUU PUR quantity   QTY          
QTYSTU STK quantity   QTY          
QTYUOM Quantity   QTY          
RTNDAT Return date   D          
RTNDES Reason description   DES          
RTNREN Return reason   SHO          
SATISS Issue region   SAT         PTX
SRDLIN Sales return line   L 8        
SRDQTYSTU Sale return qty STK   QTY          
SRHNUM Sales return no.   VCR          
STOMGTCOD Stock management   M 15 215      
STU Stock unit   UOM     [TUN]TUN0=[PND]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
TRSFAM Transaction group   ADI     [ADI]CODE=9;TRSFAM RTZ  
TSICOD Statistical group   ADI     [ADI]CODE=indice+20;TSICOD(indice) Other STI
UNTWEI Unit weight   WEI          
UOM Return unit   UOM     [TUN]TUN0=[PND]UOM Block  
UOMFLG Return PAC   M 4 1      
UOMPUUCOE STK-PUR conversion   COE          
UOMSTUCOE STK 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  
WEU Weight unit   UOM     [TUN]TUN0=[PND]WEU Block  
WRH Warehouse   WRH     [WRH]WRH0=WRH Other WRH