Table > Module Sales > Table Sales return detail 

TableAbbreviationDescriptionModuleActivity code
SRETURNDSRDSales return detailSales 

KeyDescriptionDuplicatesActivity code
SRD0SRHNUM+SRDLINNo 
SRD1SDHNUM+SDDLINYes 
SRD2SIHNUM+RTNCNOFLGYes 
PJMPJT1PJTYesPJM

ColumnNormal titleDim.TypeLengthMenuLink expressionCancellationAct
AUUIDSingle identifier AUUID     
CPYCompany CPY  [CPY]CPY0=[SRD]CPYBlock 
CREDATDate created D     
CREDATTIMDate time ADATIM     
CREUSRCreation user A5    
CURCurrency CUR  [TCU]TCU0=[SRD]CURBlock 
DLVQTYDelivered qty. QTY     
EXPNUMExport number L8    
EXTQTYExpected return qty. QTY     
EXTQTYSTUFcast retn qty STK QTY     
IMPNUMLIGImport line L8    
ITMDESDescription DES     
ITMDES1Description DES     
ITMREFProduct ITM  [ITM]ITM0=[SRD]ITMREFBlock 
NETPRINet price MD8     
NETPRIATINet price + tax MD8     
NETPRINOTNet price - tax MD8     
ORDUPDReactivated order M41   
PJTProject PJT  [PIM]PIM0=[SRD]PJTBlock 
PNDLINSuppl return line L8    
PNHNUMSupplier return no. VCR     
PRIORDOrder price MD5     
QTYReturn quantity QTY     
QTYSTUReturn quantity STK QTY     
RTNCNOFLGCredit memo subject M41   
RTNDATReturn date D     
RTNINVUPDRet deduct from inv M41   
RTNRENReturn reason ADI  [ADI]CODE=7;RTNRENBlock 
RTNSTOUPDActual stock return M41   
SAUSales unit UOM  [TUN]TUN0=[SRD]SAUBlock 
SAUSTUCOESAL-STK conv. COE     
SCSDATReversal date D     
SCSLINAAE line L8    
SCSNUMNo. credit note to be issued VCR     
SDDLINDelivery line L8    
SDHNUMDelivery no. VCR     
SIDLINCredit memo line L8    
SIHNUMCredit memo no. VCR     
SRDLINReturn line L8    
SRDTEXReturn line text TXC     
SRHCATReturn category M20493   
SRHNUMReturn no. VCR     
STOFCYReceiving site FCY  [FCY]FCY0=[SRD]STOFCYBlock 
STUStock unit UOM  [TUN]TUN0=[SRD]STUBlock 
UPDDATChange date D     
UPDDATTIMDate time ADATIM     
UPDUSRChange user A5    
WRHWarehouse WRH  [WRH]WRH0=WRHOtherWRH