Table Abbreviation Description Module Activity code
SORDERQ SOQ Sales orders - quantities Sales  

Key Description Duplicates Activity code
SOQ0 SOHNUM+SOPLIN+SOQSEQ No  
SOQ1 STOFCY+SHIDAT+BPCORD+BPAADD+ITMREF Yes  
SOQ2 ITMREF+SHIDAT Yes  
SOQ3 SOQSTA+SHIDAT+DLVPIOCMP+SOHNUM+SOPLIN+SOQSEQ No  
SOQ4 SOQSTA+SOHCAT+STOFCY+BPCORD+BPAADD Yes  
SOQ6 SHIDAT+SOHNUM+SOPLIN+SOQSEQ No  
SOQPJM1 PJT+ITMREF+SOHNUM+SOPLIN+SOQSEQ No PJM

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
ALLQTY Allocated qty.   QTY          
ALLQTYSTU Allocated qty STU   QTY          
ALLTYP Allocation type   M 15 450      
AUUID Single identifier   AUUID          
BASTAXLIN Taxable amount   MD1         KUS
BPAADD Delivery address   BPD     [BPD]BPD0=BPCORD;BPAADD Block  
BPCORD Sold-to   BPC     [BPC]BPC0=[SOQ]BPCORD Other  
BPTNUM Carrier   BPT     [BPT]BPT0=[SOQ]BPTNUM Block  
CAD Sequencing   M 7 278      
CCLDAT Date closed   D          
CCLREN Closing reason   ADI     [ADI]CODE=201;CCLREN Block  
CPY Company   CPY     [CPY]CPY0=[SOQ]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
DAYLTI Delivery LT in days   C 3        
DDTANOT Invoice line allocation elemen   MD1         SFL
DDTANUM Invoice line allocation elemen   SFI     [SFI]SFI0=[SOQ]DDTANUM Block SFL
DEMDLVDAT Req. delivery date   D          
DEMDLVHOU Delivery request time   HM          
DEMDLVREF Delivery req ref   A 20        
DEMNUM Order no.   VCR          
DEMSTA Order status   M 10 317      
DLVDAY Day   C 2        
DLVFLG Deliverable   M 4 1      
DLVPIO Delivery priority   M 15 410      
DLVPIOCMP Compl priority del   C 1        
DLVQTY Delivered quantity   QTY          
DLVQTYSTU Delivered qty STU   QTY          
DRN Route no.   M 15 409      
DSPLINFLG Distribution   M 4 1      
DSPLINVOL Line volume   QTY          
DSPLINWEI Line weight   QTY          
DSPVOU Volume unit   UOM     [TUN]TUN0=[SOQ]DSPVOU Block  
DSPWEU Weight unit   UOM     [TUN]TUN0=[SOQ]DSPWEU Block  
ECCVALMAJ Major version   ECS         ECC
ECCVALMIN Minor version   EVL         ECC
EXPNUM Export number   L 8        
EXTDLVDAT Exp delivery date   D          
FMI Product source   M 20 445      
FMILIN Back-to-back order line   L 8        
FMINUM Back-to-back order no.   VCR          
FMISEQ Back-to-back order seq.   L 8        
GEOCOD Geographic code   GEO         KUS
IMPNUMLIG Import line   L 8        
INSCTYFLG City interior flag   A 1       KUS
INVAMT Amount invoiced   MC1          
INVFLG Invoiced   M 4 1      
INVPRNBOM Print component on invoice   M 4 1      
INVQTY Invoiced qty.   QTY          
INVQTYSTU Invoiced STU   QTY          
ITMREF Product   ITM     [ITM]ITM0=[SOQ]ITMREF Block  
LINORDNUM Origin line   L 8       EDIX3
LOC Location filter   LOC     [STC]STC0=STOFCY;LOC Block  
LOT Filter lot   LOT          
LPRQTY Qty. on list prep.   QTY          
LPRQTYSTU Qty list prep STU   QTY          
MAXDLVDAT Max delivery date   D         EDIX3
MAXDLVHOU Max delivery time   HM         EDIX3
MDL Delivery mode   MDL     [TMD]TMD0=[SOQ]MDL Block  
MON Months   C 2        
NDEPRNBOM PS print component   M 4 1      
OCNPRNBOM Print component on acknowledgement   M 4 1      
ODLQTY Qty. in process   QTY          
ODLQTYSTU STK qty. in process   QTY          
OPRQTY Qty. being prepared   QTY          
OPRQTYSTU Qty being prep STU   QTY          
ORDDAT Order date   D          
ORIQTY Initial order quantity   QTY          
PCK Packaging   PCK     [TPA]TPA0=[SOQ]PCK Block  
PCKCAP Packaging capacity   COE          
PERENDDAT Period end date   D          
PERNBRDAY Number of period days   C 3        
PERSTRDAT Period start date   D          
PITFLG Points management   QTY          
PJT Project   PJT     [PIM]PIM0=[SOQ]PJT Block  
POHNUM Order no.   VCR          
POPLIN Line   L 8        
POQSEQ Sequence number   L 8        
PRECOD Preparation code   PRC          
PREQTY Qty. prepared   QTY          
PREQTYSTU Qty prepared STU   QTY          
PRGBILNUM Billing plan number   PBIL     [PBILH]PBILH0=[SOQ]PRGBILNUM Other PJM
QTY Ordered quantity   QTY          
QTYSTU Ordered STU   QTY          
RATTAXLIN Tax rates   RAT         KUS
SALFCY Sales site   FCY     [FCY]FCY0=[SOQ]SALFCY Block  
SDDLIN Delivery line   L 8        
SDHNUM Delivery no.   VCR          
SHIDAT Shipment date   D          
SHIHOU Shipment time   HM          
SHTQTY Shortage   QTY          
SHTQTYSTU Qty shortage STU   QTY          
SOHCAT Order category   M 15 412      
SOHNUM Order no.   VCR          
SOPLIN Line   L 8        
SOQPSONUM Project doc number   PSO     [PSOH]PSOH0=[SOQ]SOQPSONUM Block PJM
SOQSEQ Sequence number   L 8        
SOQSEQNUM Line   L 8       PJM
SOQSTA Line status   M 7 279      
SOQTEX Line text   TXC          
STA Filter status   A 12        
STOFCY Shipment site   FCY     [FCY]FCY0=[SOQ]STOFCY Block  
STOMGTCOD Stock management   M 15 215      
TAXFLG Taxable flag   M 4 1     KUS
TAXGEOFLG Taxed geo flag   A 1       KUS
TAXREGFLG Recorded tax flag   M 4 1     KUS
TDLQTY Qty to deliver   QTY          
TDLQTYSTU STK qty to deliver   QTY          
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USELIMDAT Use-by date   D         EDIX3
USEPLC Location reference   A 30        
VTC Vertex transaction code   A 1       KUS
VTS Vertex transaction sub-type   A 1       KUS
WEE Week no.   C 2        
YEA Year   C 4