Dictionary >  Module Purchasing >  Table Purchase price variance report  

Display all Hide all

Table Abbreviation Description Module Activity code
PPRIVARWRK PPV Purchase price variance report Purchasing  

Key Description Duplicates Activity code
PPV PID Yes  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
BPSNAM Company name   NAM          
BPSNUM Supplier   BPS     [BPS]BPS0=[PPV]BPSNUM Other  
CREDATTIM Date time   ADATIM          
CREUSR User   AUS     [AUS]CODUSR=[PPV]CREUSR Other  
CSTTOT Total cost   MD8          
CUR Currency   CUR     [TCU]TCU0=[PPV]CUR Block  
FCY Site   FCY     [FCY]FCY0=[PPV]FCY Block  
ITMDES1 Description 1   DES          
ITMREF Product   ITM     [ITM]ITM0=[PPV]ITMREF Block  
NETPRI Net price   MD8          
NUM Invoice number   VCR          
PID Processes   A 20        
PIDPRI Invoice price   MD8          
PLIN Line   L 8        
PNUM Document no.   VCR          
POHNUM Order no.   VCR          
QTYSTU STK quantity   QTY          
STKVAR Stock itm variance   MD8          
STU Stock unit   UOM     [TUN]TUN0=[PPV]STU Block  
UPDDATTIM Date time   ADATIM          
UPDUSR User   AUS     [AUS]CODUSR=[PPV]UPDUSR Other