Table > Module Sales > Table Sales orders - quantities 

TableAbbreviationDescriptionModuleActivity code
SORDERQSOQSales orders - quantitiesSales 

KeyDescriptionDuplicatesActivity code
SOQ0SOHNUM+SOPLIN+SOQSEQNo 
SOQ1STOFCY+SHIDAT+BPCORD+BPAADD+ITMREFYes 
SOQ2ITMREF+SHIDATYes 
SOQ3SOQSTA+SHIDAT+DLVPIOCMP+SOHNUM+SOPLIN+SOQSEQNo 
SOQ4SOQSTA+SOHCAT+STOFCY+BPCORD+BPAADDYes 
SOQ6SHIDAT+SOHNUM+SOPLIN+SOQSEQNo 
SOQPJM1PJT+ITMREF+SOHNUM+SOPLIN+SOQSEQNoPJM

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
ALLQTYAllocated qty. QTY     
ALLQTYSTUAllocated qty STU QTY     
ALLTYPAllocation type M15450   
AUUIDSingle identifier AUUID     
BASTAXLINTaxable amount MD1    KUS
BPAADDDelivery address BPD  [BPD]BPD0=BPCORD;BPAADDBlock 
BPCORDSold-to BPC  [BPC]BPC0=[SOQ]BPCORDOther 
BPTNUMCarrier BPT  [BPT]BPT0=[SOQ]BPTNUMBlock 
CADSequencing M7278   
CCLDATDate closed D     
CCLRENClosing reason ADI  [ADI]CODE=201;CCLRENBlock 
CPYCompany CPY  [CPY]CPY0=[SOQ]CPYBlock 
CREDATDate created D     
CREDATTIMDate time ADATIM     
CREUSRCreation user A5    
DAYLTIDelivery LT in days C3    
DDTANOTInvoice line allocation elemen MD1    SFL
DDTANUMInvoice line allocation elemen SFI  [SFI]SFI0=[SOQ]DDTANUMBlockSFL
DEMDLVDATReq. delivery date D     
DEMDLVHOUDelivery request time HM     
DEMDLVREFDelivery req ref A20    
DEMNUMOrder no. VCR     
DEMSTAOrder status M10317   
DLVDAYDay C2    
DLVFLGDeliverable M41   
DLVPIODelivery priority M15410   
DLVPIOCMPCompl priority del C1    
DLVQTYDelivered quantity QTY     
DLVQTYSTUDelivered qty STU QTY     
DRNRoute no. M15409   
DSPLINFLGDistribution M41   
DSPLINVOLLine volume QTY     
DSPLINWEILine weight QTY     
DSPVOUVolume unit UOM  [TUN]TUN0=[SOQ]DSPVOUBlock 
DSPWEUWeight unit UOM  [TUN]TUN0=[SOQ]DSPWEUBlock 
ECCVALMAJMajor version ECS    ECC
ECCVALMINMinor version EVL    ECC
EXPNUMExport number L8    
EXTDLVDATExp delivery date D     
FMIProduct source M20445   
FMILINBack-to-back order line L8    
FMINUMBack-to-back order no. VCR     
FMISEQBack-to-back order seq. L8    
GEOCODGeographic code GEO    KUS
IMPNUMLIGImport line L8    
INSCTYFLGCity interior flag A1   KUS
INVAMTAmount invoiced MC1     
INVFLGInvoiced M41   
INVPRNBOMPrint component on invoice M41   
INVQTYInvoiced qty. QTY     
INVQTYSTUInvoiced STU QTY     
ITMREFProduct ITM  [ITM]ITM0=[SOQ]ITMREFBlock 
LINORDNUMOrigin line L8   EDIX3
LOCLocation filter LOC  [STC]STC0=STOFCY;LOCBlock 
LOTFilter lot LOT     
LPRQTYQty. on list prep. QTY     
LPRQTYSTUQty list prep STU QTY     
MAXDLVDATMax delivery date D    EDIX3
MAXDLVHOUMax delivery time HM    EDIX3
MDLDelivery mode MDL  [TMD]TMD0=[SOQ]MDLBlock 
MONMonths C2    
NDEPRNBOMPS print component M41   
OCNPRNBOMPrint component on acknowledgement M41   
ODLQTYQty. in process QTY     
ODLQTYSTUSTK qty. in process QTY     
OPRQTYQty. being prepared QTY     
OPRQTYSTUQty being prep STU QTY     
ORDDATOrder date D     
ORIQTYInitial order quantity QTY     
PCKPackaging PCK  [TPA]TPA0=[SOQ]PCKBlock 
PCKCAPPackaging capacity COE     
PERENDDATPeriod end date D     
PERNBRDAYNumber of period days C3    
PERSTRDATPeriod start date D     
PITFLGPoints management QTY     
PJTProject PJT  [PIM]PIM0=[SOQ]PJTBlock 
POHNUMOrder no. VCR     
POPLINLine L8    
POQSEQSequence number L8    
PRECODPreparation code PRC     
PREQTYQty. prepared QTY     
PREQTYSTUQty prepared STU QTY     
PRGBILNUMBilling plan number PBIL  [PBILH]PBILH0=[SOQ]PRGBILNUMOtherPJM
QTYOrdered quantity QTY     
QTYSTUOrdered STU QTY     
RATTAXLINTax rates RAT    KUS
SALFCYSales site FCY  [FCY]FCY0=[SOQ]SALFCYBlock 
SDDLINDelivery line L8    
SDHNUMDelivery no. VCR     
SHIDATShipment date D     
SHIHOUShipment time HM     
SHTQTYShortage QTY     
SHTQTYSTUQty shortage STU QTY     
SOHCATOrder category M15412   
SOHNUMOrder no. VCR     
SOPLINLine L8    
SOQPSONUMProject doc number PSO  [PSOH]PSOH0=[SOQ]SOQPSONUMBlockPJM
SOQSEQSequence number L8    
SOQSEQNUMLine L8   PJM
SOQSTALine status M7279   
SOQTEXLine text TXC     
STAFilter status A12    
STOFCYShipment site FCY  [FCY]FCY0=[SOQ]STOFCYBlock 
STOMGTCODStock management M15215   
TAXFLGTaxable flag M41  KUS
TAXGEOFLGTaxed geo flag A1   KUS
TAXREGFLGRecorded tax flag M41  KUS
TDLQTYQty to deliver QTY     
TDLQTYSTUSTK qty to deliver QTY     
UPDDATChange date D     
UPDDATTIMDate time ADATIM     
UPDUSRChange user A5    
USELIMDATUse-by date D    EDIX3
USEPLCLocation reference A30    
VTCVertex transaction code A1   KUS
VTSVertex transaction sub-type A1   KUS
WEEWeek no. C2    
YEAYear C4