: !/bin/sh


tbsswbrate=`# tRate
#ID|int|no|4|10|0|no|(n/a)|(n/a)|
#ServiceTypeID|int|no|4|10|0|yes|(n/a)|(n/a)|
#Length|real|no|4|24||yes|(n/a)|(n/a)|
#Cost|money|no|8|19|4|yes|(n/a)|(n/a)|
#Cost100|money|no|8|19|4|yes|(n/a)|(n/a)|
#Percentage|int|no|4|10|0|yes|(n/a)|(n/a)|
#Description|varchar|no|255|||yes|no|no|
#Active|bit|no|1|||yes|(n/a)|(n/a)|
#StartDate|datetime|no|8|||yes|(n/a)|(n/a)|
#EndDate|datetime|no|8|||yes|(n/a)|(n/a)|
#LastUpdatedBy|varchar|no|50|||yes|no|no|
#PartCost|money|no|8|19|4|yes|(n/a)|(n/a)|

(tbssql <<SQLCMD0
select cost from tRate
where
--# ID = 1340
    ServiceTypeID = 1024
  and Active = 1
SQLCMD0
) | cut -d '|' -f 1`


echo "tbsswbrate=[$tbsswbrate]"