Table Abbreviation Description Module Activity code
UPORDERP UOP PO price history Purchasing  

Key Description Duplicates Activity code
POP0 POHNUM+LINREVNUM+POPLIN+POPSEQ No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
CPY Company   CPY     [CPY]CPY0=[UOP]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
DISCRGREN1 Discount 1 reason   PPR     [PPR]PPR0=[UOP]DISCRGREN1 Block PP1
DISCRGREN2 Discount 2 reason   PPR     [PPR]PPR0=[UOP]DISCRGREN2 Block PP2
DISCRGREN3 Discount 3 reason   PPR     [PPR]PPR0=[UOP]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
EXPNUM Export number   L 8        
FCYADD Receipt address   ADR          
GROPRI Gross price   MD8          
ITMDES Description   DES          
ITMDES1 Description   DES          
ITMREF Product   ITM     [ITM]ITM0=[UOP]ITMREF Block  
LINBUY Buyer   AUS     [AUS]CODUSR=[UOP]LINBUY Block  
LINREVNUM Revision no.   C 4        
MATTOL Matching tolerance   MAT     [MAT]MAT0=[UOP]MATTOL Block  
NETPRI Net price   MD8          
ORICRY Country of origin   CRY     [TCY]TCY0=[UOP]ORICRY Block  
PJT Project   A 20        
POHNUM Order no.   VCR          
POHTYP Order type   M 20 506      
POPCREFLG Creation flag   M 4 1      
POPDAT Application end date   D          
POPLIN Line   L 8        
POPSEQ Sequence   L 8        
PRHFCY Receiving site   FCY     [FCY]FCY0=[UOP]PRHFCY Block  
PRIREN Price reason   PPR     [PPR]PPR0=[UOP]PRIREN Block  
QUAFLG QC management   M 4 1      
REVCOD Revision code   A 1        
STRDAT Price effectivity date   D          
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
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VAT Tax 3 VAT     [TVT]TVT0=VAT(indice);[V]GSUPCLE Block