Table > Module Sales > Table Sales order history - price 

TableAbbreviationDescriptionModuleActivity code
VSORDERPVOPSales order history - priceSales 

KeyDescriptionDuplicatesActivity code
VOP0SOHNUM+LINREVNUM+SOPLIN+SOPSEQNo 

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
AUUIDSingle identifier AUUID     
BPAADDDelivery address BPD  [BPD]BPD0=BPCORD;BPAADDBlock 
BPCINVBill-to customer BPC  [BPC]BPC0=[VOP]BPCINVOther 
BPCORDSold-to BPC  [BPC]BPC0=[VOP]BPCORDOther 
BPCSALPRIConsumer sales price MD8    EDIX3
CLCAMT1Tax calculation basis 1 MD1     
CLCAMT2Tax calculation basis 2 MD1     
CNDNAMDelivery contact AIN  [AIN]AIN0=CNDNAMBlock 
CONNUMService contract no. VCR     
CPRPRICost price MD8     
CPYCompany CPY  [CPY]CPY0=[VOP]CPYBlock 
CREDATDate created D     
CREDATTIMDate time ADATIM     
CREUSRCreation user A5    
DISCRGREN1Discount 1 reason SPR  [SPR]SPR0=[VOP]DISCRGREN1BlockSP1
DISCRGREN2Discount 2 reason SPR  [SPR]SPR0=[VOP]DISCRGREN2BlockSP2
DISCRGREN3Discount 3 reason SPR  [SPR]SPR0=[VOP]DISCRGREN3BlockSP3
DISCRGREN4Discount 4 reason C4   SP4
DISCRGREN5Discount 5 reason C4   SP5
DISCRGREN6Discount 6 reason C4   SP6
DISCRGREN7Discount 7 reason C4   SP7
DISCRGREN8Discount 8 reason C4   SP8
DISCRGREN9Discount 9 reason C4   SP9
DISCRGVAL1Discount/Charge 1 MD8    SP1
DISCRGVAL2Discount/Charge 2 MD8    SP2
DISCRGVAL3Discount/Charge 3 MD8    SP3
DISCRGVAL4Discount/Charge 4 DCB19.8   SP4
DISCRGVAL5Discount/Charge 5 DCB19.8   SP5
DISCRGVAL6Discount/Charge 6 DCB19.8   SP6
DISCRGVAL7Discount/Charge 7 DCB19.8   SP7
DISCRGVAL8Discount/Charge 8 DCB19.8   SP8
DISCRGVAL9Discount/Charge 9 DCB19.8   SP9
ENDDATValidity end date D     
EXPNUMExport number L8    
FOCFLGFree M10439   
GROPRIGross price MD8     
INVCNDInvoic. term INVCND  [INVCND]INVCND0=INVCND;[V]GSUPCLEBlock 
ITMDESDescription DES     
ITMDES1Description DES     
ITMREFProduct ITM  [ITM]ITM0=[VOP]ITMREFBlock 
ITMREFBPCCustomer product A20    
LINREVNUMRevision no. C4    
LINTYPLine type M15423   
NETPRINet price MD8     
NETPRIATINet price + tax MD8     
NETPRINOTNet price - tax MD8     
ORILINFree line source L8    
PCNTNUMContract number PREPI  [PREPI]PREPI0=[VOP]PCNTNUMOtherPREPM
PFMMargin MD1     
PRIRENPrice reason SPR  [SPR]SPR0=[VOP]PRIRENBlock 
REP1Sales rep 1 REP  [REP]REP0=[VOP]REP1BlockRE1
REP2Sales rep 2 REP  [REP]REP0=[VOP]REP2BlockRE2
REPCOECommission factor CCR     
REPRAT1Commission rate 1 RAT    RE1
REPRAT2Commission rate 2 RAT    RE2
REVCODRevision code A1    
SALFCYSales site FCY  [FCY]FCY0=[VOP]SALFCYOther 
SAUSales unit UOM  [TUN]TUN0=[VOP]SAUBlock 
SAUSTUCOESAL-STK conv. COE     
SOHCATOrder category M15412   
SOHNUMOrder no. VCR     
SOPLINLine L8    
SOPSEQSequence L8    
SOQSTALine status M7279   
SQDLINQuote line L8    
SQHNUMQuote no. VCR     
SSTCODSST tax code ADI  [ADI]CODE=203;SSTCODBlockLTA
STOFCYShipment site FCY  [FCY]FCY0=[VOP]STOFCYOther 
STRDATValidity start date D     
STUStock unit UOM  [TUN]TUN0=[VOP]STUBlock 
TSICODStatistical group ADI  [ADI]CODE=indice+20;TSICOD(indice)OtherSTI
UPDDATChange date D     
UPDDATTIMDate time ADATIM     
UPDUSRChange user A5    
VACITMTax level3TVI  [TVI]TVI0=VACITM(indice);[V]GSUPCLEBlock 
VATTax3VAT  [TVT]TVT0=VAT(indice);[V]GSUPCLEBlock