dbartley 8/10/2013 10:23:11 AM

Quick SQL question

Quick question what does it mean when it says tsl? I can’t find it as a view, table, stored proc nothing!

 

 

update tsl
set                          tsl.PABILRATE = erl.PAProfitAmount
                                ,tsl.PAORIGBILLRATE = erl.PAProfitAmount
                                ,tsl.PA_Base_Billing_Rate = erl.PAProfitAmount
                                ,tsl.PAORIGBSBILLRTE = erl.PAProfitAmount
                                ,tsl.PATotalProfit = tsl.PAQtyQ * erl.paprofitamount
                                ,tsl.PAORIGTOTPROF = tsl.PAQtyQ * erl.paprofitamount
                                ,tsl.PAACREV = tsl.PAQtyQ * erl.paprofitamount
                                ,tsl.PAORIACCRREV = tsl.PAQtyQ * erl.paprofitamount
from PA30101 tsl

 

Version: Unknown or N/A
Section: SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3