Table > Module Sales > Table Sales orders - header 

TableAbbreviationDescriptionModuleActivity code
SORDERSOHSales orders - headerSales 

KeyDescriptionDuplicatesActivity code
SOH0SOHNUMNo 
SOH1BPCORD+CUSORDREFYes 
SOH2CUSORDREF+BPCORDYes 
SOH3ORDSTA+BPCORDYes 
SOH4ORDSTA+SOHNUMNo 
SOH5ORDSTA+INVSTA+SOHCATYes 
SOH7SOHNUMENDYesKPO

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
ADRVALValidated M41  LTA
ALLLINNBRNo. of lines to allocate C4    
ALLSTAAllocation status M15416   
ALLTYPAllocation type M15450   
AMTTAXTax amount MD1    KUS
APPFLGSigned M15280   
AUUIDSingle identifier AUUID     
BASTAXTax basis MD1    KUS
BETCPYIntercompany M41   
BETFCYIntersite M41   
BPAADDDelivery address BPD  [BPD]BPD0=BPCORD;BPAADDBlock 
BPAINVInvoice address code ADR     
BPAORDOrder addr code ADR     
BPAPYRAddress pay-by ADR     
BPCADDLIGOrder address3ADL     
BPCCRYCountry of order CRY  [TCY]TCY0=[SOH]BPCCRYBlock 
BPCCRYNAMOrder country name NCY     
BPCCTYOrder city CTY     
BPCGRUGroup customer BPR  [BPR]BPR0=[SOH]BPCGRUBlock 
BPCINVBill-to customer BPR  [BPR]BPR0=[SOH]BPCINVBlock 
BPCNAMSold-to customer name2NAM     
BPCORDSold-to BPR  [BPR]BPR0=[SOH]BPCORDBlock 
BPCPOSCODOrder postal code POS     
BPCPYRPay-by BPR  [BPR]BPR0=[SOH]BPCPYRBlock 
BPCSATOrder state SAT     
BPDADDLIGDelivery address3ADL     
BPDCRYDelivery country CRY  [TCY]TCY0=[SOH]BPDCRYBlock 
BPDCRYNAMDelivery country name NCY     
BPDCTYDelivery city CTY     
BPDNAMShip-to customer name2NAM     
BPDPOSCODDeliv postal code POS     
BPDSATDelivery country SAT     
BPIADDLIGBilling address3ADL     
BPICRYCountry of invoice CRY  [TCY]TCY0=[SOH]BPICRYBlock 
BPICRYNAMInvoice country name NCY     
BPICTYInvoice city CTY     
BPIEECNUMEU identification A20   DEB
BPINAMBill-to customer name2NAM     
BPIPOSCODInvoice postal code POS     
BPISATInvoice state SAT     
BPTNUMCarrier BPT  [BPT]BPT0=[SOH]BPTNUMBlock 
CCEDimension CCE  [CCE]CCE0=DIE(indice);CCE(indice)BlockANA
CCLDATDate closed D     
CCLRENClosing reason ADI  [ADI]CODE=201;CCLRENBlock 
CDTSTACredit status M15419   
CDTSTAPPrevious credit status M15419   
CHGRATCurrency rate DCB5.6    
CHGTYPRate type M15202   
CLELINNBRNo. closed lines C4    
CMGNUMMarketing campaign CMG  [CMG]CMG0=[SOH]CMGNUMRTZ 
CNDNAMDelivery contact AIN  [AIN]AIN0=CNDNAMBlock 
CNINAMInvoice contact AIN  [AIN]AIN0=CNINAMBlock 
CNTNAMPerson to contact AIN  [AIN]AIN0=CNTNAMBlock 
COPNBRNo. copies acknowledgement of receipt C1    
CPYCompany CPY  [CPY]CPY0=[SOH]CPYBlock 
CREDATDate created D     
CREDATTIMDate time ADATIM     
CREUSRCreation user A5    
CURCurrency CUR  [TCU]TCU0=[SOH]CURBlock 
CUSORDREFCustomer order ref A20    
DAYLTIDelivery lead time C3    
DEMDLVDATReq. delivery date D     
DEMDLVHOUExp. delivery time HM    EDIX3
DEPSettlement discount TDA  [TDA]TDA0=DEP;[V]GSUPCLEBlock 
DIEDimension type code DIE  [DIE]DIE0=[SOH]DIEBlockANA
DISCRGTYPDiscount / charge type M10255  SPR
DLRATIAmount to deliver +tax MD1     
DLRNOTAmount to deliver -tax MD1     
DLVLINNBRNo. of delivered lines C4    
DLVPIODelivery priority M15410   
DLVSTADelivery status M15417   
DMEPartial delivery M15414   
DRAFTREJReject draft M41   
DRAFTREJRENDraft rej. reason A60    
DRAFTSTATUSDraft C2    
DRNRoute no. M15409   
DSPTOTQTYQuantity total DCB9.6    
DSPTOTVOLVolume aggregation QTY     
DSPTOTWEIWeight aggregation QTY     
DSPVOUVolume unit UOM  [TUN]TUN0=[SOH]DSPVOUBlock 
DSPWEUWeight unit UOM  [TUN]TUN0=[SOH]DSPWEUBlock 
EECICTIncoterm ICT  [ICTH]ICT0=[SOH]EECICTBlock 
EECLOCIntrastat transport location M15236  DEB
EXPNUMExport number L8    
FFWADDForwarding agent address ADR     
FFWNUMFreight agent BPT  [BPT]BPT0=[SOH]FFWNUMBlock 
GEOCODGeographic code GEO    KUS
HLDCODBlock code ADI  [ADI]CODE=204;HLDCODBlock 
HLDCODPPrevious block code ADI  [ADI]CODE=204;HLDCODPBlock 
HLDDATBlock/Release date D     
HLDDATPPrevious block date D     
HLDSTABlock status M10491   
HLDTIMBlock/Release time HM     
HLDTIMPPrevious block time HM     
HLDUSRBlock/Release user AUS  [AUS]CODUSR=[SOH]HLDUSRBlock 
HLDUSRPPrevious block user AUS  [AUS]CODUSR=[SOH]HLDUSRPBlock 
ICTCTYIncoterm town CTY     
IMEInvoicing mode M15408   
INRATITo invoice including tax MD1     
INRNOTTo invoice excluding tax MD1     
INRSCHATIScheduled invoice including tax MD1     
INRSCHNOTScheduled invoice excluding tax MD1     
INSCTYFLGCity interior flag A1   KUS
INVCNDInvoic. term INVCND  [INVCND]INVCND0=INVCND;[V]GSUPCLEBlock 
INVDTAInvoicing element SFI  [SFI]SFI0=[SOH]INVDTAOtherSFI
INVDTAAMT% or amt inv el DCB11.4   SFI
INVDTADSPDistrib key DSP  [DSP]DSP0=INVDTADSP;1OtherSFI
INVDTALINInvoice line element C2   SPR
INVDTATYPValue type M32227  SFI
INVLINNBRNo. invoiced lines C4    
INVSTAInvoice status M15418   
LANLanguage LAN  [TLA]TLA0=[SOH]LANBlock 
LASDLVDATLast delivery date D     
LASDLVNUMLast delivery no. VCR     
LASINVDATLast invoice date D     
LASINVNUMLast invoice no. VCR     
LINNBRNumber of lines C4    
LNDRTNDATLoan return date D     
MDLDelivery mode MDL  [TMD]TMD0=[SOH]MDLBlock 
OCNFLGPrint acknowledgment M41   
OCNPRNAcknowledgment printed M41   
ODLOne order per delivery M41   
OPGNUMMarketing operation VCR     
OPGTYPOperation type A3    
ORDATILine amt. + tax MD1     
ORDATILLine amt. + tax (company) MD1     
ORDCLEClose unfilled lines M41   
ORDDATOrder date D     
ORDINVATIValuation + tax MD1     
ORDINVATILCosting tax incl. cy MD1     
ORDINVNOTValuation - tax MD1     
ORDINVNOTLCosting tax excl. cy MD1     
ORDNOTLine amt. - tax MD1     
ORDNOTLLine amt. - tax (company) MD1     
ORDSTAOrder state M15415   
ORIFCYOriginal site FCY  [FCY]FCY0=[SOH]ORIFCYBlock 
PFMTOTTotal margin MD1     
PJTProject PJT  [PIM]PIM0=[SOH]PJTBlock 
PLISTCStructure code PRS  [PRS]PRS0=1;PLISTCOther 
PRFNUMProforma invoice no. VCR     
PRITYPPrice - / +tax M6243   
PTEPayment term PTE  [TPT]TPT0=PTE;[V]GCURLEG;1Block 
REPSales rep REP  [REP]REP0=[SOH]REPBlockREP
REVNUMRevision no. C4    
SALFCYSales site FCY  [FCY]FCY0=[SOH]SALFCYBlock 
SDHTYPDelivery type TSD  [TSD]TSD0=SDHTYP;[V]GSUPCLEBlock 
SFISSTCODSST tax code ADI  [ADI]CODE=203;SFISSTCODBlockSFI
SHIADECODShipper / receiver code A35    
SHIDATShipment date D     
SINUMIntegrale part no. A10   SMI
SOHCATOrder category M15412   
SOHCFMFLGElectronic signature M41  KPO
SOHNUMOrder no. VCR     
SOHNUMENDFinal number VCR    KPO
SOHTEX1Ord header text TXC     
SOHTEX2Ord footer text TXC     
SOHTYPOrder type TSO  [TSO]TSO0=SOHTYP;[V]GSUPCLEBlock 
SOHVALDATValidation date D    KPO
SQHNUMQuote no. VCR     
SRENUMService request SRE  [SRE]SRE0=[SOH]SRENUMRTZ 
SSTENTCODEntity/Use ADI  [ADI]CODE=202;SSTENTCODBlockLTA
STOFCYShipment site FCY  [FCY]FCY0=[SOH]STOFCYBlock 
TSCCODStatistical group ADI  [ADI]CODE=indice+30;TSCCOD(indice)OtherSTC
UNLRelease M41   
UPDDATChange date D     
UPDDATTIMDate time ADATIM     
UPDUSRChange user A5    
VACBPRTax rule TVB  [TVB]TVB0=VACBPR;[V]GSUPCLEBlock 
VCRINVCNDDATBeginning due date D     
VLYDATCONValidity date D     
VTTVertex transaction type A1   KUS