Micros 3700 SQL retriving the worng date?

[George Lake]

Hi.
I have this query
SELECT SEC.se_chk_seq, SEC.obj_num,business_date,SEC.chk_num,SEC.CHK_SEQ,SEC.SRV_EMP_SEQ,
SEC.rvc_seq,fixed_period_seq,SEC.chk_open_date_time,SEC.chk_clsd_date_time,SEC.cov_cnt,sub_ttl,tax_ttl,
RD.Location_Name_1 --"rest_name"
FROM "micros"."sls_export_chk_dtl" as SEC,"micros"."rest_def"as RD;
output to F:\APPS\EXPORT\chktotals.csv

If I run a button in Autosequnace that selects a date, the SQL runs and brings the correct data, but if I just run the sql form the command line it will default to the data of the last time it ran form autosequence, in other words, I run it in autosequence for the 17th, and the command line version will also retrieve data for the 17th.

 

[pmegan]

What is micros.sls_export_chk_dtl? I don't have that table in any of my 3700 databases.
Also, what is the autosequence linked to?