Table > Module Sales > Table Sales orders - price 

TableAbbreviationDescriptionModuleActivity code
SORDERPSOPSales orders - priceSales 

KeyDescriptionDuplicatesActivity code
SOP0SOHNUM+SOPLIN+SOPSEQNo 
SOP1BPCORD+BPAADD+ITMREF+ENDDATYes 
SOP2SOQSTA+SOHCAT+STOFCY+BPCORD+BPAADDYes 
SOP3SOHNUM+SOPLINYes 
SOP4SOQSTA+SOHCAT+SALFCY+BPCINVYes 

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
AUUIDSingle identifier AUUID     
BPAADDDelivery address BPD  [BPD]BPD0=BPCORD;BPAADDBlock 
BPCINVBill-to customer BPC  [BPC]BPC0=[SOP]BPCINVOther 
BPCORDSold-to BPC  [BPC]BPC0=[SOP]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=[SOP]CPYBlock 
CREDATDate created D     
CREDATTIMDate time ADATIM     
CREUSRCreation user A5    
DISCRGREN1Discount 1 reason SPR  [SPR]SPR0=[SOP]DISCRGREN1BlockSP1
DISCRGREN2Discount 2 reason SPR  [SPR]SPR0=[SOP]DISCRGREN2BlockSP2
DISCRGREN3Discount 3 reason SPR  [SPR]SPR0=[SOP]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=[SOP]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=[SOP]PCNTNUMRTZPREPM
PFMMargin MD1     
PRIRENPrice reason SPR  [SPR]SPR0=[SOP]PRIRENBlock 
REP1Sales rep 1 REP  [REP]REP0=[SOP]REP1BlockRE1
REP2Sales rep 2 REP  [REP]REP0=[SOP]REP2BlockRE2
REPCOECommission factor CCR     
REPRAT1Commission rate 1 RAT    RE1
REPRAT2Commission rate 2 RAT    RE2
SALFCYSales site FCY  [FCY]FCY0=[SOP]SALFCYOther 
SAUSales unit UOM  [TUN]TUN0=[SOP]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=[SOP]STOFCYOther 
STRDATValidity start date D     
STUStock unit UOM  [TUN]TUN0=[SOP]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