Table > Module Purchasing > Table Purchase price variance report 

TableAbbreviationDescriptionModuleActivity code
PPRIVARWRKPPVPurchase price variance reportPurchasing 

KeyDescriptionDuplicatesActivity code
PPVPIDYes 

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
AUUIDSingle identifier AUUID     
BPSNAMCompany name NAM     
BPSNUMSupplier BPS  [BPS]BPS0=[PPV]BPSNUMOther 
CREDATTIMDate time ADATIM     
CREUSRUser AUS  [AUS]CODUSR=[PPV]CREUSROther 
CSTTOTTotal cost MD8     
CURCurrency CUR  [TCU]TCU0=[PPV]CURBlock 
FCYSite FCY  [FCY]FCY0=[PPV]FCYBlock 
ITMDES1Description 1 DES     
ITMREFProduct ITM  [ITM]ITM0=[PPV]ITMREFBlock 
NETPRINet price MD8     
NUMInvoice number VCR     
PIDProcesses A20    
PIDPRIInvoice price MD8     
PLINLine L8    
PNUMDocument no. VCR     
POHNUMOrder no. VCR     
QTYSTUSTK quantity QTY     
STKVARStock itm variance MD8     
STUStock unit UOM  [TUN]TUN0=[PPV]STUBlock 
UPDDATTIMDate time ADATIM     
UPDUSRUser AUS  [AUS]CODUSR=[PPV]UPDUSROther