Get the value of Status field on the REVRECSCHEDULES tables via ODBC

Based on NetSuite Help Guide via the following navigational path below:

Accounting : Revenue Recognition : Using Revenue Recognition : Working with Revenue Recognition Schedules : Reviewing the Revenue Recognition Schedules List

Status – The amortization status can be one of the following:
   - Not Started – No revenue has yet been recognized.
   - In Progress – Some revenue has been recognized, but not all.
   - Complete – All revenue has been recognized for this schedule.


Alternate SQL Query:

select RS.SCHEDULE_ID,
(select case when sum(decode(IS_RECOGNIZED,'No',1,0)) = count(1) then 'Not Started'
 when sum(decode(IS_RECOGNIZED,'No',1,0)) < count(1) then 'In Progress'
 else 'Complete' end
 from REVRECSCHEDULELINES RSL where RS.SCHEDULE_ID = RSL.SCHEDULE_ID) Status
from REVRECSCHEDULES RS