Table Status for AP03630MC_Wrk

(0) Share

Report

Posted on by WaltBlanchard

480

Hi All,

Just trying to confirm something I think I remember about SL for a few years back. I'm working with the AP03630MC_Wrk table in the AP Check Register (03.630.00) report. When I run a SQL query against the table with no report preview, I get a found set of about 1100 records, none of which are the record I am looking for, and all for the same period over a year ago. When I run the same query with a report in preview mode, I get a different larger found set, and then the same original found set when I close out of the preview.

I believe, if I am remember things correctly that this table should be empty, except when the ROI has accessed it for a report. Am I remembering this correctly?

Thanks - Walt

*This post is locked for comments

All responses (2)

Answers (1)

WaltBlanchard 480 on at

Like (0)

Report

RE: Table Status for AP03630MC_Wrk

Thanks Perumalsany R,

Good to know that the old brain bucket is still in working order - somewhat. ;-)

Thanks again for confirming my thoughts,

Walt
Verified answer

Ram Peru 2,830 on at

Like (1)

Report

RE: Table Status for AP03630MC_Wrk

Good morning Walt,

Yes, you are remembering this correctly. The ROI of report will populate the records into the AP03630MC_wrk table while print preview the report.

Normally all the work table should be empty.

Hope this explains.