Table Abbreviation Description Module Activity code
SORDERC SOC Sales orders - early / late Sales  

Key Description Duplicates Activity code
SOC0 SOHNUM+SOPLIN No  
SOC1 BPCORD+BPAADD+ITMREF Yes  
SOC2 CUSORDREF+BPCORD+BPAADD+ITMREFBPC No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
BPAADD Delivery address   ADR          
BPCORD Sold-to   BPC     [BPC]BPC0=[SOC]BPCORD Other  
BPIEECNUM EU identification   A 20       DEB
CPLAMT Actual amount   MD1          
CPY Company   CPY     [CPY]CPY0=[SOC]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUMDATEAR Cumulative customer start date   D          
CUSORDREF Customer order ref   A 20        
DLVQTYCUM Total delivered   QTY          
DSPPRC Weekly quantity split 7 C 3        
EARDAT Calculated early / late date   D          
EARDATCUS Customer early/late date   D          
EARHOU Calculated early / late time   HM          
EARHOUCUS Customer early/late time   HM          
EARQTY Calculated early / late quanti   QTY          
EARQTYCUS Customer early/late qty   QTY          
ECCVALMAJ Major version   ECS         ECC
ECCVALMIN Minor version   EVL         ECC
EECICT Incoterm   ICT     [ICTH]ICT0=[SOC]EECICT Block  
EECLOC Intrastat transport location   M 15 236     DEB
EXTAMT Expected amount   MD1          
EXTQTY Planned quantity   QTY          
FFWADD Forwarding agent address   ADR          
FFWNUM Freight agent   BPT     [BPT]BPT0=[SOC]FFWNUM Block  
FIMHOR Firm horizon   C 4        
ICTCTY Incoterm town   CTY          
ITMDES Description   DES          
ITMDES1 Description   DES          
ITMDESBPC Customer description   DES          
ITMREF Product   ITM     [ITM]ITM0=[SOC]ITMREF Block  
ITMREFBPC Customer product   A 20        
ITMREVNUM Revision no.   C 4        
ORDQTYCUM Total ordered   QTY          
PJT Project   PJT     [PIM]PIM0=[SOC]PJT Block  
PLI Price list code   SPC     [SPC]SPC0=[SOC]PLI Other  
SALFCY Sales site   FCY     [FCY]FCY0=[SOC]SALFCY Block  
SAU Sales unit   UOM     [TUN]TUN0=[SOC]SAU Block  
SAUSTUCOE SAL-STK conv.   COE          
SOCTEX Product text   TXC          
SOHNUM Order no.   VCR          
SOPLIN Line   L 8        
SSTCOD SST tax code   ADI     [ADI]CODE=203;SSTCOD Block LTA
STOFCY Shipment site   FCY     [FCY]FCY0=[SOC]STOFCY Block  
STU Stock unit   UOM     [TUN]TUN0=[SOC]STU Block  
TSICOD Statistical group   ADI     [ADI]CODE=indice+20;TSICOD(indice) Other STI
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
USEPLC Location reference   A 30        
VACBPR Tax rule   TVB     [TVB]TVB0=VACBPR;[V]GSUPCLE Block  
VACITM Tax level 3 TVI     [TVI]TVI0=VACITM(indice);[V]GSUPCLE Block  
VAT Tax 3 VAT     [TVT]TVT0=VAT(indice);[V]GSUPCLE Block  
VLYDATITM Validity date   D