Table Abbreviation Description Module Activity code
VSQUOTED VQD Sales quote history - details Sales  

Key Description Duplicates Activity code
SQD0 SQHNUM+LINREVNUM+SQDLIN No  

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=[VQD]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=[VQD]CPY Block  
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
DAYLTI Delivery LT in days   C 3        
DDAYLTI Lead time   C 4        
DDTANOT Invoice line allocation elemen   MD1         SFL
DDTANUM Invoice line allocation elemen   SFI     [SFI]SFI0=[VQD]DDTANUM Block SFL
DISCRGREN1 Discount 1 reason   SPR     [SPR]SPR0=[VQD]DISCRGREN1 Block SP1
DISCRGREN2 Discount 2 reason   SPR     [SPR]SPR0=[VQD]DISCRGREN2 Block SP2
DISCRGREN3 Discount 3 reason   SPR     [SPR]SPR0=[VQD]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=[VQD]DSPVOU Block  
DSPWEU Weight unit   UOM     [TUN]TUN0=[VQD]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=[VQD]ITMREF Block  
LINPFM Line margin   MC1          
LINQUOATI Line amount + tax   MC1          
LINQUONOT Line amount - tax   MC1          
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=[VQD]PJT Block  
PRIREN Price reason   SPR     [SPR]SPR0=[VQD]PRIREN Block  
QTY Quote quantity   QTY          
QUODAT Quote date   D          
RATTAXLIN Tax rates   RAT         KUS
REP1 Sales rep 1   REP     [REP]REP0=[VQD]REP1 Block RE1
REP2 Sales rep 2   REP     [REP]REP0=[VQD]REP2 Block RE2
REPCOE Commission factor   CCR          
REPRAT1 Commission rate 1   RAT         RE1
REPRAT2 Commission rate 2   RAT         RE2
REVCOD Revision code   A 1        
SALFCY Sales site   FCY     [FCY]FCY0=[VQD]SALFCY Block  
SAU Sales unit   UOM     [TUN]TUN0=[VQD]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=[VQD]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=[VQD]STOFCY Block  
STU Stock unit   UOM     [TUN]TUN0=[VQD]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          
UPDDATE Date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5        
VACITM Tax level 3 TVI     [TVI]TVI0=VACITM(indice);[V]GSUPCLE Block  
VACITM1 Tax level 1   TVI     [TVI]TVI0=VACITM1;[V]GSUPCLE Block  
VACITM2 Tax level 2   TVI     [TVI]TVI0=VACITM2;[V]GSUPCLE Block  
VACITM3 Tax level 3   TVI     [TVI]TVI0=VACITM3;[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