Calculate debtors at the end of the year? debtors-50000, bad debts-2000, discount allowed-1000, 5% on bad debt, 2% discount allowed?
2152What are the Different heads of income tax act 1961? tax rate on companies according to current budget?
6 13151Journalise the following Entries? Outstanding salary of rs. 20000/- Prepaid insurance of rs. 5000/-
13 27977Post New OPI Global Interview Questions
HR generalist position is a key position in advising, assisting and reporting to HR head, in such a case what are your strengths and work attitude?
Explain split(), sub(), sub() methods of “re” module in python?
hai friends can u expalin about real time process of testing at the company, like flow diagram
How do I select a language in visual studio code?
What is array and function?
Explain different relationships in SFDC?
What is asp net framework?
What is ejb client?
Explain how to taken care performance management in people tools?
Which function would you use to replace a record in a database in php?
How will you add a font to a cell using apache poi?
What is scripting autism?
What is software fault?
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg
what is LSR?