Voyager Specials Testing Property

Company:  Specials Testing Company
RC Company Code: c00000098532
RC Company hmy: 114653
Property: Voyager Specials Property
RC Property Code: p0609592
RC Property hmy: 610063
Voyager code: rcspec
Voyager hmy: 2148

TR 752340 Specials scenarios.xlsx

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2989) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2990) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2991) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2992) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2993) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2994) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2995) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2996) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2997) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2998) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 2999) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 3000) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 3001) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 3002) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 3003) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 3004) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 3051) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc

select * from itf_rm_unitpricing where hunit in (select hmy from unit where hunittype = 3052) and bactive = 'True'  and ileaseterm < 13 and bnewmovein = 'True' order by ditfrent asc