Table Abbreviation Description Module Activity code
SQUOTED SQD Quote detail Sales  

Key Description Duplicates Activity code
SQD0 SQHNUM+SQDLIN No  
SQD1 ORDFLG+SALFCY+BPCORD Yes  
PJMPJT1 PJT Yes PJM

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
BASTAXLIN Taxable amount   MD1         KUS
BPAADD Delivery address   ADR          
BPCORD Sold-to   BPC     [BPC]BPC0=[SQD]BPCORD Other  
CLCAMT1 Tax calculation basis 1   MD1          
CLCAMT2 Tax calculation basis 2   MD1          
CNDNAM Delivery contact   AIN     [AIN]AIN0=CNDNAM Block  
CPRPRI Cost price   MD8          
CPY Company   CPY     [CPY]CPY0=[SQD]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=[SQD]DDTANUM Block SFL
DISCRGREN1 Discount 1 reason   SPR     [SPR]SPR0=[SQD]DISCRGREN1 Block SP1
DISCRGREN2 Discount 2 reason   SPR     [SPR]SPR0=[SQD]DISCRGREN2 Block SP2
DISCRGREN3 Discount 3 reason   SPR     [SPR]SPR0=[SQD]DISCRGREN3 Block SP3
DISCRGREN4 Discount 4 reason   C 4       SP4
DISCRGREN5 Discount 5 reason   C 4       SP5
DISCRGREN6 Discount 6 reason   C 4       SP6
DISCRGREN7 Discount 7 reason   C 4       SP7
DISCRGREN8 Discount 8 reason   C 4       SP8
DISCRGREN9 Discount 9 reason   C 4       SP9
DISCRGVAL1 Discount/Charge 1   MD8         SP1
DISCRGVAL2 Discount/Charge 2   MD8         SP2
DISCRGVAL3 Discount/Charge 3   MD8         SP3
DISCRGVAL4 Discount/Charge 4   DCB 19.8       SP4
DISCRGVAL5 Discount/Charge 5   DCB 19.8       SP5
DISCRGVAL6 Discount/Charge 6   DCB 19.8       SP6
DISCRGVAL7 Discount/Charge 7   DCB 19.8       SP7
DISCRGVAL8 Discount/Charge 8   DCB 19.8       SP8
DISCRGVAL9 Discount/Charge 9   DCB 19.8       SP9
DLVFLG Deliverable   M 4 1      
DSPLINFLG Distribution   M 4 1      
DSPLINVOL Line volume   QTY          
DSPLINWEI Line weight   QTY          
DSPVOU Volume unit   UOM     [TUN]TUN0=[SQD]DSPVOU Block  
DSPWEU Weight unit   UOM     [TUN]TUN0=[SQD]DSPWEU Block  
ECCVALMAJ Major version   ECS         ECC
ECCVALMIN Minor version   EVL         ECC
EXPNUM Export number   L 8        
FOCFLG Free   M 10 439      
GEOCOD Geographic code   GEO         KUS
GROPRI Gross price   MD8          
IMPNUMLIG Import line   L 8        
INSCTYFLG City interior flag   A 1       KUS
INVPRNBOM Print component on invoice   M 4 1      
ITMDES Description   DES          
ITMDES1 Description   DES          
ITMREF Product   ITM     [ITM]ITM0=[SQD]ITMREF Block  
LINREVNUM Revision no.   C 4        
LINTYP Line type   M 15 423      
NDEPRNBOM PS print component   M 4 1      
NETPRI Net price   MD8          
NETPRIATI Net price + tax   MD8          
NETPRINOT Net price - tax   MD8          
OCNPRNBOM Print component on acknowledgement   M 4 1      
ORDFLG Ordered   M 4 1      
ORDQTY Ordered qty.   QTY          
ORILIN Free line source   L 8        
PFM Margin   MD1          
PJT Project   PJT     [PIM]PIM0=[SQD]PJT Block  
PRIREN Price reason   SPR     [SPR]SPR0=[SQD]PRIREN Block  
QTY Quote quantity   QTY          
QUODAT Quote date   D          
RATTAXLIN Tax rates   RAT         KUS
REP1 Sales rep 1   REP     [REP]REP0=[SQD]REP1 Block RE1
REP2 Sales rep 2   REP     [REP]REP0=[SQD]REP2 Block RE2
REPCOE Commission factor   CCR          
REPRAT1 Commission rate 1   RAT         RE1
REPRAT2 Commission rate 2   RAT         RE2
SALFCY Sales site   FCY     [FCY]FCY0=[SQD]SALFCY Block  
SAU Sales unit   UOM     [TUN]TUN0=[SQD]SAU Block  
SAUSTUCOE SAL-STK conv.   COE          
SOHNUM Order no.   VCR          
SOPLIN Line   L 8        
SQDLIN Quote line   L 8        
SQDPSONUM Project doc number   PSO     [PSOH]PSOH0=[SQD]SQDPSONUM Block PJM
SQDSEQNUM Line   L 8       PJM
SQDTEX Line text   TXC          
SQHNUM Quote no.   VCR          
SSTCOD SST tax code   ADI     [ADI]CODE=203;SSTCOD Block LTA
STOFCY Shipment site   FCY     [FCY]FCY0=[SQD]STOFCY Block  
STU Stock unit   UOM     [TUN]TUN0=[SQD]STU Block  
TAXFLG Taxable flag   M 4 1     KUS
TAXGEOFLG Taxed geo flag   A 1       KUS
TAXREGFLG Recorded tax flag   M 4 1     KUS
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VACITM Tax level 3 TVI     [TVI]TVI0=VACITM(indice);[V]GSUPCLE Block  
VAT Tax 3 VAT     [TVT]TVT0=VAT(indice);[V]GSUPCLE Block  
VTC Vertex transaction code   A 1       KUS
VTS Vertex transaction sub-type   A 1       KUS