Dictionary >  Module Sales >  Table Sales price catalog  

Display all Hide all

Table Abbreviation Description Module Activity code
SPRICPRTQ SPQ Sales price catalog Sales  

Key Description Duplicates Activity code
SPQ0 COD+BPCORD+ITMREF+SPQLIN No  
SPQ1 COD+ITMREF+BPCORD+SPQLIN No  

Column Normal title Dim. Type Length Menu Link expression Cancellation Act
AUUID Single identifier   AUUID          
BPCORD Sold-to   BPR     [BPR]BPR0=[SPQ]BPCORD Delete  
COD Catalog   SPP     [SPP]SPP0=[SPQ]COD Delete  
COMCOE Comm factor   CCR          
CREDAT Date created   D          
CREDATTIM Date time   ADATIM          
CREUSR Creation user   A 5        
CUR Currency   CUR     [TCU]TCU0=[SPQ]CUR Other  
DAT Date   D          
DCGVAL Charge/discount value 9 MD8          
FOCITMREF Free product   ITM     [ITM]ITM0=[SPQ]FOCITMREF Delete  
FOCQTY Free quantity   QTY          
FOCUOM Unit   UOM     [TUN]TUN0=[SPQ]FOCUOM Other  
GROPRI Gross price   MD8          
ITMREF Product   ITM     [ITM]ITM0=[SPQ]ITMREF Delete  
LTI Lead time   C 3        
MINQTY Minimum quantity   QTY          
NETPRI Net price   MD8          
PLI Price list code 12 SPC     [SPC]SPC0=[SPQ]PLI Delete  
PLICRD Price list record 12 VCR          
PLILIN Line 12 L 8        
PLIREN Reason 12 SPR     [SPR]SPR0=[SPQ]PLIREN Other  
PRITYP Price - / +tax   M 6 243      
SALFCY Sales site   FCY     [FCY]FCY0=[SPQ]SALFCY Delete  
SPQLIN Line   L 8        
STOFCY Shipment site   FCY     [FCY]FCY0=[SPQ]STOFCY Delete  
UOM Unit   UOM     [TUN]TUN0=[SPQ]UOM Other  
UPDDAT Change date   D          
UPDDATTIM Date time   ADATIM          
UPDUSR Change user   A 5