Table Abbreviation Description Module Activity code
PRETURN PNH Returns Purchasing  

Key Description Duplicates Activity code
PNH0 PNHNUM No  
PNH1 BPSNUM+RTNDAT Yes  
PNH2 RTNDAT+PNHNUM No  
PNH3 CPY+EECNUMDEB+RTNDAT Yes DEB

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ARVDATR Arrival date   D          
ATDTCODR AT code   A 100       KPO
AUUID Single identifier   AUUID          
AUZNUM Authorization number   A 15        
BETCPY Intercompany   M 4 1      
BETFCY Intersites   M 4 1      
BOLNUM BOL number   VCR          
BPAADD Address   ADR          
BPAADDLIG Address line 3 ADL          
BPAINV Billing address   ADR          
BPAPAY Pay-to BP address   ADR          
BPRNAM Company name 2 NAM          
BPRPAY Pay-to   BPR     [BPR]BPR0=[PNH]BPRPAY Block  
BPSINV Bill-by BP   BPR     [BPR]BPR0=[PNH]BPSINV Block  
BPSNUM Supplier   BPR     [BPR]BPR0=[PNH]BPSNUM Block  
BPTNUM Carrier   BPT     [BPT]BPT0=[PNH]BPTNUM Block  
BUY Buyer   AUS     [AUS]CODUSR=[PNH]BUY Block  
CCE Analytical dimension   CCE     [CCE]CCE0=DIE(indice);CCE(indice) Block ANA
CFMFLG Posted   M 4 1      
COPNBR No. copies return note   C 1        
CPY Company   CPY     [CPY]CPY0=[PNH]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CRY Country   CRY     [TCY]TCY0=[PNH]CRY Block  
CRYNAM Country name   NCY          
CTY City   CTY          
DIE Dimension type code   DIE     [DIE]DIE0=[PNH]DIE Block ANA
DPEDATR Departure date   D          
EECICT Incoterm   ICT     [ICTH]ICT0=[PNH]EECICT Block  
EECLOC Intrastat transport location   M 15 236     DEB
EECNAT Transaction nature   TEC     [TEC]TEC0=EECNAT;[V]GSUPCLE Block DEB
EECNUM EU identification   A 20       DEB
EECNUMDEB EU Intrastat   C 4       DEB
EECSCH Intrastat rule   TSC     [TSC]TSC0=EECSCH;[V]GSUPCLE Block DEB
EECTRN Intrastat transp. mode   M 15 237     DEB
ENTCOD Stock auto journal   GAU     [GAU]GAU0=[PNH]ENTCOD Block  
ETAR Arrival time   HM          
ETDR Departure time   HM          
EXPNUM Export number   L 8        
FFWADD Forwarding agent address   ADR          
FFWNUM Freight agent   BPT     [BPT]BPT0=[PNH]FFWNUM Block  
ICTCTY Incoterm town   CTY          
INVFLG Invoiced   M 15 280      
INVLINNBR No. invoiced lines   C 4        
LICPLATER Registration   REGLIC          
LINNBR Number of lines   C 4        
MANDOCR Manual document   DOC         KPO
MDL Delivery mode   MDL     [TMD]TMD0=[PNH]MDL Block  
PJTH Project   PJT     [PIM]PIM0=[PNH]PJTH Block  
PNHFCY Return site   FCY     [FCY]FCY0=[PNH]PNHFCY Block  
PNHNUM Return no.   VCR          
PNHTYP Return type   TPN     [TPN]TPN0=PNHTYP;[V]GSUPCLE Block TRSNE
POSCOD Postal code   POS          
PRNFLG Printed   M 4 1      
PSTDAT Reversal date   D          
PSTFLG Posted   M 4 1      
PSTLINNBR No. of posted lines   C 4        
PURTYP Purchase type   M 15 507      
REM Notes   A 250        
RTNDAT Return date   D          
SAT County   SAT          
TEX1 Text   TXC          
TEX2 Text   TXC          
TMPPNHNUM Return no.   VCR          
TOTGROWEI Gross weight   DCB 11.4        
TOTNETWEI Net weight   DCB 11.4        
TOTVOL Volume   DCB 11.4        
TRLLICPLATER Trailer license plate   REGLIC          
TRSCOD Movement code   ADI     [ADI]CODE=14;TRSCOD Other  
TSSCOD Statistical group   ADI     [ADI]CODE=indice+40;TSSCOD(indice) Block STS
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VACBPR Tax rule   TVB     [TVB]TVB0=VACBPR;[V]GSUPCLE Block  
VACTYP Tax rule type   C 1        
VOU Volume unit   UOM     [TUN]TUN0=[PNH]VOU Block  
WEU Weight unit   UOM     [TUN]TUN0=[PNH]WEU Block  
WRHE Warehouse   WRH     [WRH]WRH0=WRHE Other WRH