I have the same problem with the Series 1 table.   The easiest way to debug is to use the Excel ODBC interface and dump the table of a client.    Then you can see the actual codes and series for the query since Intuit doesn't document any of the tables.    You can get more info about the ODBC Excel connection in SDK documentation.

Regards,

Rick Kamp, EA