Shoptech E2 User Manual

What are Triggers?

Triggers are SQL statements that cause an action within E2SS. For example, you can run a trigger to notify Accounts
Receivable when payment on an invoice is late. Even the invoices and statements can be attached! You can also set up a
Trigger to notify the Shop Manager when a step is behind schedule.

The software comes with nearly 200 pre-set Triggers and the ability to write new ones with a Trigger Wizard. This wizard
works in much the same way as the Advance Search and Hot Spots Wizards work. So, a good knowledge of tables and
fields in E2 and writing SQL statements is necessary for the user to successfully write Triggers.

Triggers generally fall into two categories: Triggers that run off an event or Triggers that run on a schedule. It is important
to realize that when a Trigger runs off an event, a time comparison must take place for the Trigger to work properly. Our
defaults often use the #[LastRun]# date/time stamp on the Trigger to compare the date field in the Trigger to the last time
the Trigger ran. For example, the default "Quote Followup" Trigger compares the Followup Date date field in the Quote
table to the #[LastRun]# date/time stamp from the Trigger. This allows you to set up a Trigger that will notify you about
each individual event as it occurs without repeatedly sending you the same data. Including the #[LastRun]# comparison
allows the recipient to find out about it as it occurs, but they will not be notified about it again.

We could change the same Trigger to a scheduled one. We would remove the code that compares the Followup Date
date field to the #[LastRun]# date time stamp in the Trigger. The interval should probably be increased for this type of
Trigger because you will receive the same data over and over until the quote Followup Date has been changed or
deleted. If the interval is set to run weekly then the recipient will find out which quotes are at or past their followup date.
With the scheduled Trigger, the info on the same quotes will continue to be sent until the Followup Date is changed.

What You’ll Need

Everything you need to run the Triggers is included with the software. Each user will be automatically granted access to
add/modify, but this can be changed per user.

1. Go to File | System Maintenance | User Maintenance.

2. Select the user and click the Edit button.

3. Go to the Miscellaneous tab and remove the check next to Allow user to Add/Modify Standard Triggers.

Triggers are only available after a specific area of the software has been selected (e.g., Customers, Quotations, Orders,
Purchase Orders, etc). So, to open the triggers for Orders, simply go to the main Orders screen and press the F4 button
to see the set of Triggers created for that area. You can also access triggers by editing a specific record and pressing F4.
From here you can set up a trigger for a specific Customer or Job.

1

If you will be using the trigger server to send messages to external mail recipients, you will need to have a MAPI
compliant email program (like Outlook or Outlook Express) installed on the computer. If you will be sending faxes, then
you will need to have a modem, phone line, and the Microsoft Fax application configured.

The E2Server (E2srvADO) Executable

The E2server.EXE program is also included and can be found in the Source folder on the Server or Host computer where
E2 is installed. This executable performs many functions including processing the Triggers set to run in the system. There
are five tabs of information: Settings, Activity Log, Triggers, Scheduling, Time Tickets, and FAX.

Run the workstation setup program from the …blswin32\source folder to make sure the computer you will use has all of
the required supporting files installed.

If you are using the MS Access database platform then you will need to run the E2Server.exe on one computer on your
network. If you are using the SQL Server database platform, then you will use E2SrvADO.exe instead. You may need to
edit the shortcut for the E2 Trigger Server to point to the correct file.

When the program is started it will display in the computer’s system tray, and will start processing immediately.

To configure the E2 Trigger Server for the first time, right click on the E2 icon in the system tray. Select Pause Service
from the menu to make sure no unwanted email messages are sent.

2

The icon will now display in the system tray with a red slash through it indicating that the Server is now paused.
Right click the icon again to select from the other menu options.

Settings Tab

Database Settings

These settings show the user the path for BLS.MDB. Make sure this path is correct for your installation of E2. It should
point to the …blswin32\source folder. Use the Browse button to change this path if necessary. Set the Company Code to
your company name and the Document Directory to the folder where trigger documents will be saved.

Server Settings

The Trigger Timer Interval sets the frequency for the program to check the condition for each triggered activity to see if
the trigger should be run. The Interval set on actual Triggers also controls the frequency at which a trigger will run.

Click in the Log Activity to Audit Trail check box and the system will start tracking all the actions taken by the trigger
server which can be seen by running the GL | Audit Trail Summary report.

If you are using E2’s Contact Management module and have the Roll Missed Contact Mgt. Calls Forward check box
checked then E2 will update missed appointments and set them to the next day. You can also have an email sent to the
user on Missed Calls.

Pausing the Server

The Pause Server button lets you temporarily stop the server from collecting Active Trigger information. The Start Server
button enables the system again. You must click the Pause Server button to make any changes on the Settings tab.

Applying Settings

Once any settings are changed on the tab, the user must click the Apply button for them to take effect. The Exit button
and the Red X in the corner will close the E2 Trigger Server. If you want the trigger server to continue to run, just minimize
it back to the system tray.

Activity Tab

This log simply lists all the actions the trigger server has performed since it was started.

3

Triggers Tab

This is a list of all Active Triggers set to run in the system.

4

Scheduling Tab

This is a list of jobs waiting to be scheduled by the system. Users can enable prioritizing and rescheduling all open jobs
here so that processing at midnight will use these settings.

Time Tickets Tab

This is a list of Time Tickets waiting to be processed.

5

Fax Tab

This is a list of all Fax documents waiting to be sent. The user can specify a Cover Page to send with the fax here.

Stopping an Active Trigger

So now that a Trigger is active, what if you want to stop it? The best way to accomplish this quickly is to go to the E2
Server and remove the Trigger from the list of Active Triggers on the Triggers tab. Just click on the Trigger and then the
Delete button and the software will discontinue searching for matching documents.

Main Triggers Screen

Once the E2 Server is running, users can make Triggers active and set them to run. This is done easily by going into the
area of the system where the Trigger pertains and pressing the F4 key. This opens the main Triggers screen where each
Trigger for that area of the system displays.

System Area

The field displays the area of the system selected. You will also see a field displaying either “All Values” or a specific
record, depending on how the user accessed the Triggers. Triggers can be opened from the main screen of any area in
the system (ALL VALUES) or once a particular record has been selected. If a record has been selected, it will display in
this field.

Available Triggers

This list shows the user all the Triggers presently written for this area of the system.

Arrows

These arrows are used to activate and deactivate the selected Available Triggers. They act as toggles to move the
Triggers back and forth between the Available and Active list.

Active Triggers
This list shows the user all the Active Triggers selected for this area of the system.

Delete Button

This button allows the user to delete the selected Available Trigger. Once this is selected and the prompt is answered
“Yes,” the Trigger will be deleted from the system, not just for this user.

New Button

This button gives the user the option to start the Trigger Wizard where users can walk through creating brand new
Triggers step-by-step or if they are familiar with writing transact-SQL statements, a window where the user can create the
trigger without prompting. Refer to Creating a New Trigger in the User’s Guide for more in-depth information on using the
Wizard.

6

Copy Button

This button allows the user to copy the selected Trigger and create a new one from it. Refer to Copying a Trigger in the
User’s Guide for more in-depth information on copying Triggers.

Edit Button (Available Triggers)

This button allows the user to open the selected Available Trigger and manipulate every aspect of its setup: Code,
Description, SQL Statement, Recipients, EMail/FAX message, Attachments, and Documents.

Global Trigger For This System Area

This check box is automatically selected when “ALL VALUES” are selected with the F4 key (no specific document was
originally selected). This tells the system to look through all documents that could match the criteria. Even if the user does
enter Triggers with a specific document selected, there is still the opportunity to run the Trigger globally. Just click this
check box!

Edit Button (Active Triggers)

This button allows the user to open the selected Active Trigger and manipulate every aspect of its setup: Code,
Description, Processing Schedule, Recipients, EMail/FAX message, Attachments, and Documents.

Trigger Detail

Once a Trigger is selected to Copy, Edit, or become Active, the user will see the Trigger Detail. If it’s for copying or
editing, the General Tab will display the SQL Query. If the Trigger is being made Active, the user will see the Processing
Schedule defaults.

General Tab

This is where the Trigger is named with a Code and a Description. The SQL Statement will display when copying or
editing and the Processing Schedule displays when making a Trigger Active. Users can enter information directly into the
Description or SQL Statement here to alter it. Users will need a good command of the tables used in the E2 Shop System
as well as SQL in order to successfully write Triggers.
When running a Trigger, the Processing Schedule settings are changed so the system knows exactly when to start and
stop looking for the criteria. The Discontinue... check box is available so that only one occurrence of a document will be
emailed or faxed.

Message Tab

Select how you want the trigger delivered: EMail, Calendar, FAX, or Printer. Then complete the “recipients” section. The
To: button here opens the address list from File | Messaging. Each “recipients” section changes according to the Deliver
Via option chosen. An EMail just needs a To: person and a Subject. If the trigger is a global trigger and you would like for

the trigger server to send the email based on the contact set for that record, then you can use “[@]”. For example if you

use the Quote Entered trigger in the Customer area, then by typing [@] in the To: field, the trigger server will send the
email to the contact on the Quote (provided this customer contact has an email address).

The Calendar option loads this Trigger into the Contact Management calendar so in addition to selecting a To: person,
you’ll also have to assign an Object, select a corresponding Code, tell the system whether the Trigger should be Private
or not, and select a Contact, if applicable.

The FAX option needs a Company and FAX number associated. If the trigger is a global trigger and you would like for the
trigger server to send the fax based on the contact set for that record, then you can use “[#]”.
For example if you use the PO Entered trigger in the Vendor area, then by typing [#] in the To: field, the trigger server will
send the fax to the contact on the PO (provided this vendor contact has a fax number).

Finally, compose the “message” section. When editing, not all the options are available for choosing fields to insert into
the text. Users will have to have a good command of available fields in order to make radical changes to the message.
When creating New or Copying, the user will see the Fields drop-down list and the Add to Text Button. Enter the common
text as needed. Then just click the down arrow and scroll through until the “fill-in” field needed displays. Click “Add Text” to
insert the field at the end of the message.

Attachments Tab

Use the Attach button to display the Open dialog box where the user can navigate to the appropriate directory and select
the document to attach. Documents attached on this tab are any that do not originate from the E2 Shop System (e.g.,
CAD drawings, Excel Spreadsheets, Word Documents, etc.). The Remove button will delete the selected document in the
list from being sent with this EMail/FAX, not delete it from the system. The View button allows the user to select a
document and view it in its associated application.

7

Documents Tab

This tab is where documents from the E2 Shop System are included with an EMail/FAX, typically you will see a report
listed here that will run as the trigger runs which will be included with the message. Use the drop-down arrow in the
Documents field to select from the available documents. Then click the Attach button and the document displays in the
list. The Remove button will delete the selected document in the list from being sent with this EMail/FAX, not delete it from
the system.

What are the rules for creating triggers?

 When using the wizard only 2 tables can be used. Most of the default triggers use the UserTransactions table as

the 2nd table. This lets the user track transactions minute by minute.

 Almost any SQL Statement can be a trigger. If a date field isn’t used to compare to the lastrun date then the

trigger will generally return the same record(s) over and over.

 If you are using the [@] and [#] on global triggers, you need to make sure that your contacts have email

addresses and/or fax numbers, or you may receive error messages as the trigger server tries to determine the
recipient.

 The message must always begin at the very top of the text box. Adding characters, spaces, or returns will stop

the message from being sent when the Trigger finds a match.

 It is recommended that you make your triggers meaningful. No one wants to be inundated with email messages or

faxes. You may not want to set a Trigger to tell you when your employees clocked in. This is a good example of
what a Trigger should be used for. If you wanted to know when your employees clocked in, it would be more
efficient to use the Attendance Summary. If you had a problem employee or two with a consistent history of being
late, you could set the Trigger for each of those employees so that you could be notified each day when they
clocked in.

 When writing your own triggers, be sure to think about field types as you make links between tables. The Value

and Value2 fields in the UserTransactions table are Text (String) fields and cannot be linked to numeric fields like
Employee Codes, Work Center Numbers, or Operation Numbers. A statement like the one below would not work:
SELECT * FROM WORKCNTR WHERE WORKCNTR IN (SELECT VALUE FROM USERTRANSACTIONS
WHERE ACTION = ‘EDIT’ AND TRANSDATE >= #[LASTRUN]#)
because the WORKCNTR is a number and not a text field and the results will not ever match.

Creating a triggered email message to Quality Manager for a Non-Conformance

This example uses the Sample database that ships with E2. Create a trigger on customer CARTER that notifies the QC
manager (a user set up in E2) when a non-conformance is received.

1. Go to Tables | Customers.

2. Click Search to load list and select CARTER.

3. From the customer detail screen press the F4 key to display the Triggers associated with customers.

4. The ‘Available Triggers’ list displays all currently defined Triggers, which relate to customers. Our goal is to set a
Trigger to notify the QC Manager when a non-conformance is received, so scroll through the list of available
triggers and select NON-CONFORMANCE ENTERED.

5. Click the > button to move this Trigger to the ‘Active Triggers’ list. The Trigger Detail screen displays.

6. This screen allows us to specify all details regarding the Trigger we are creating.

7. In order to send an email to the order entry contact, switch to the Message tab.

8. Select Email in the ‘Deliver via’ frame.

9. In the To textbox of the ‘Email recipient(s)’ frame we will enter the email address of your QC Manager.

8

10. You can modify the actual text of the message to be sent in the ‘Email Message Body Text’ field.

11. Use the Attach and Documents tabs to specify whether these items should be included with the email. In this
case, the system will automatically include a copy of the nonconformance report for the manager’s review.

12. Select OK when complete to activate the Trigger.

Additional E2 Trigger Server Functions

As mentioned earlier, there are other actions that the Trigger Server can perform when configured.

Quality related Triggers (Quality module must be licensed)

In addition to enabling standard triggers throughout E2, you can also create Quality specific triggers to be used
in the areas of Employee Training, Work Center Maintenance, Tooling Maintenance and Document Control.

To create a trigger in any of these areas, select the item to edit and then click the Triggered… button at the
top of the screen. Set the trigger parameters you want E2 to use, including the begin date, Threshold Type,
Threshold Value and Threshold Units to let E2 know when the triggered event should be created. For example,
if you want E2 to automatically create a Training Event for your employees, go to Quality | Employee
Training and Edit the employee.

9

Click the Triggered Training button.

If you want this employee to receive industry related training on a quarterly basis, designate the date you want
to start “counting down” from and then choose the most appropriate Threshold Type – in this instance, we will
select CALENDAR to indicate the training will be automatically scheduled on a pre-set time frame. To create
the training event quarterly, you could select 90 days, 12 weeks or, as we will in this example, 3 months. Since
we back-dated the begin date to reflect the start of the current week, E2 displays the number of days that have

already passed in the defined time frame. Had we “forward-dated” the begin date to next week; the elapsed

time would display “0” until the designated date was passed. Once the time frame has been defined, all that

remains is to designate the type of training to be performed by selecting the appropriate Training Code from
the list you create under Table Maintenance. If we wanted to create a trigger for training that needed to be
performed based on the amount of work our Employee does, the Threshold may have been set to PIECES or
MANHOURS instead, in which case the ability of the trigger to work successfully would be based on accurate
Time Tickets & Piece Counts being turned in.

When finished, click OK to save the triggered item and return to the Detail Screen. Do not confuse what we
just did with making an entry on this screen. The items present here represent existing, scheduled events,
whether past or present, that are referenced here for historical purposes. The trigger we just created is a way
to have these events automatically created using the designated thresholds on an ongoing basis so you don’t
have to continuously create them yourself. In our example, in 3 months time, E2 will automatically create an
entry on this screen indicating it is time for the listed training to take place and the trigger would automatically
re-set itself to create another event entry 3 months from then and so on until the trigger is discontinued on the
E2 Server application. If you want the event to also be added automatically to the Contact Management
Calendar, make sure to mark the trigger accordingly when setting it up.

10

Queued Reports

Many of the reports in E2 offer the user the ability to have the report automatically run at set times, on a regular basis, to a
specific destination.

Example: Production Summary

Go to Shop Control | Production Summary and set the Report Destination to Queue.

When the user clicks the Generate Report button, the Schedule a Queued Report window will open.

11

The user can set dates and times indicating when to start printing the report and when to stop. The user can also set the

interval between runs of the report. Let’s say you want the report to be waiting on your printer each Monday morning when

you arrive at 7:00 am.

1. Set the Begin Date field to Monday of next week.

2. Set the Begin Time to the time that you would like the report to be printed, say 6:45.

3. The End Date indicates when the report will no longer be needed, so you could leave this at 12/31/30. Or if you
only want this report to be queued for 1 year, you could set the End Date to 1 year from today.

4. Similarly, the End Time indicates the time that the report should no longer run.

5. Set the Interval to a number in minutes between printing occurances. For example, if left at 1 minute, the report
will print each minute of the day until the End Date and Time are reached. Setting the interval to 1440 (60 * 24)
will generate the report once a day at about the Begin Time. Set the Interval to 10080 to print the report on a
weekly basis.

6. Check the Discontinue Trigger After First Occurance to have the report stop printing after the first time.

Note: Queued reports are user specific. If you would like to have the same report queued but with different filtering, then
you will need to have it set up to run using different User ID’s.

Scheduling

If you are using E2 to schedule your jobs, you can set up the Trigger Server to prioritize and/or perform a global
reschedule nightly.

In E2 go to Shop Control | Scheduling and then click on the Settings tab. Make sure that either the Backward or Forward
Direction is set.

You may choose to uncheck the Update Schedule In “Real Time” checkbox if you have the trigger server do the Global
Reschedule for you. This will cause newly entered orders to be scheduled during overnight processing rather than while
processing the order at order entry. One benefit of this is that the order entry process should be faster.

12

On the Whiteboard tab, click the Global Reschedule button to open the Global Reschedule window.

Click on the Prioritize Jobs button to set the Priority Calculation Criteria based on your company’s needs.
Make any changes necessary to the First, Second, Third, or Fourth Criteria and then click the Calculate Priorities button.

When prioritization is complete, click OK. Now these settings will apply when the trigger server performs the overnight
processing.

13

On the Scheduling tab of the trigger server, check the desired checkboxes.

Click the Process button to complete the prioritization and/or reschedule to be sure that all the settings are correct and to
verify that the process will complete overnight.

Time Tickets (Split Processing)

If you experience delays while processing orders, or clocking in and out of jobs using Data Collection or PC Data
Collection, you may benefit from turning on a feature called split processing.

Besides entering the Time Ticket when a job is stopped using Data Collection or PC Data Collection, E2 will also update
the Job Status information like pieces good and pieces scrapped and the actual end time for the routing step. It will also
update the schedule as steps are finished. In some environments, there could be contention for access to the database
tables that need to be written to. If this is the case, then order entry processing and data entry at the clocks or PC Data
Collection could take longer to complete.

By turning on the Split Processing option from Company Maintenance | Edit | Data Collection tab, you off load the
responsibility of updating the job status from the Data Collection or PC Data Collection applications to the trigger server.
This means that Data Collection or PC Data Collection still enters the Time Tickets, but will not update the pieces good,
etc. Instead the Trigger server will update this information.

If you turn Split Processing on, be sure to shut down Data Collection and PC Data Collection and Exit the Trigger Server.
Start the applications again for the setting to take affect.

Faxing

If you plan to use the Trigger Server to act as a fax server, there are two requirements that the computer running the
Trigger Server must meet: there must be a modem installed in the computer including a phone line along with the
Microsoft Fax application, and MS Word must be installed. You cannot configure the Trigger server to utilize a fax
machine or other Multi-Function printing device. Make sure that you are able to fax from the “server” outside of E2 first.

Most of the reports in E2 can be faxed. In many cases, E2 can automatically complete the fax number fields for you based
on the contact information for that record. As an example, go to Tables | Customers and edit a customer. On the Contacts
tab, make sure that at least one contact has a fax number. Next, go to Orders | Order Entry and then either create a new
order or edit an existing one for the customer you just edited. Click on the Header tab and set the Contact to the Customer
Contact for whom you just verified the fax number. Click OK to accept your changes. Process the order if necessary. Click
the Print button, and then click on the Work Order tab. Next, set the Report Destination to FAX. Click the Single Work
Order button.

14

Recipient

E2 should populate the Company, Subject, and the Fax Recipient Information for you. You can change any of this
information if necessary.

Cover Page
You can type a text message to be printed on the Cover Page here. If you leave the option in the Fax Service Information
set to Microsoft Fax, E2 will check to see if the Microsoft Fax program is set up on your computer. For this to work, you
will need to have a modem installed. If you set it to Generate Fax On E2 Server instead, then E2 sends the report to the
E2 Trigger Server to be faxed.

Attachments
If the report you fax has Documents attached which are set to print when that report is printed, they will display on this tab.
You can click the Attach button, to browse for additional documents or clock Remove a document from the list. Click the
View button to open the Attachment in AutoVue.

Click OK to send the fax. E2 will export your report as a RTF file to the user’s Default Document Directory, which can be
set up in User Maintenance on the Miscellaneous Settings tab. A record will be added to the table that is checked by the
E2 Trigger Server containing the Recipient, fax number, message, and name and location of the RTF file that was
created. The next time the Trigger Server refreshes, it should send the fax.

Appendix

What are the default triggers?
BankCode

CASH RECEIPT ENTERED

SELECT * FROM Receipt WHERE BankCode = '[SearchVal1]' AND CheckNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND TransDate > #[LastRun]#) AND CustCode
IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

CASH RECEIPT PROCESSED

SELECT * FROM Receipt WHERE BankCode = '[SearchVal1]' AND ProcFlag = 1 AND CheckNo IN (SELECT Value2
FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) AND
CustCode IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CHECK ENTERED

SELECT * FROM [Check] WHERE BankCode = '[SearchVal1]' AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

15

CHECK PROCESSED

SELECT * FROM [Check] WHERE BankCode = '[SearchVal1]' AND ProcFlag = 1 AND CheckNo IN (SELECT Value
FROM UserTransactions WHERE Object = 'Check' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

CAR

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND CustRMANo = '[SearchVal1]' AND FeedbackNo
IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND CustRMANo = '[SearchVal1]' AND FeedbackNo
IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND CustRMANo = '[SearchVal1]' AND FeedbackNo
IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

CARCode

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND CustRMANo = '[SearchVal1]' AND FeedbackNo
IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND CustRMANo = '[SearchVal1]' AND FeedbackNo
IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND CustRMANo = '[SearchVal1]' AND FeedbackNo
IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

CashReceipt

CASH RECEIPT CLEARED

SELECT * FROM Receipt WHERE CustCode = '[SearchVal1]' AND CheckNo = '[SearchVal2]' AND CheckNo IN
(SELECT Value2 FROM UserTransactions WHERE Object = 'BankRec' AND Action = 'CLEAR' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

Check

CHECK CLEARED

SELECT * FROM [Check] WHERE CheckNo = '[SearchVal1]' AND CheckNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'BankRec' AND Action = 'CLEAR' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

16

CurrencyCode

INVOICE ENTERED

SELECT * FROM Billing WHERE CurrencyCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

ORDER ENTERED

SELECT * FROM Orders WHERE CurrencyCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

ORDER PROCESSED

SELECT * FROM Orders WHERE CurrencyCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Order' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

QUOTE ENTERED

SELECT * FROM Quote WHERE CurrencyCode = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

SHIPMENT ENTERED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE CurrencyCode =
'[SearchVal1]') AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action =
'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SHIPMENT PROCESSED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE CurrencyCode =
'[SearchVal1]') AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action =
'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

VENDOR INVOICE ENTERED

SELECT * FROM VendorInv WHERE CurrencyCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'VendorInv' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

CASH RECEIPT ENTERED

SELECT * FROM Receipt WHERE CurrencyCode = '[SearchVal1]' AND CheckNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND TransDate > #[LastRun]#) AND CustCode
IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

CHECK ENTERED

SELECT * FROM [Check] WHERE CurrencyCode = '[SearchVal1]' AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

CASH RECEIPT PROCESSED

SELECT * FROM Receipt WHERE CurrencyCode = '[SearchVal1]' AND CheckNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) AND
CustCode IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

17

CHECK PROCESSED

SELECT * FROM [Check] WHERE CurrencyCode = '[SearchVal1]' AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

CustContact

CASH RECEIPT ENTERED

SELECT * FROM ReceiptDet WHERE InvoiceNo IN (SELECT InvoiceNo FROM Billing WHERE CustCode =
'[SearchVal1]') AND InvoiceNo IN (SELECT InvoiceNo FROM BillingDet WHERE ContactName = '[SearchVal2]') AND
CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY RecDate DESC

INVOICE ENTERED

SELECT * FROM Billing WHERE CustCode = '[SearchVal1]' AND InvoiceNo IN (SELECT InvoiceNo FROM BillingDet
WHERE ContactName = '[SearchVal2]') AND InvoiceNo IN (SELECT Value FROM UserTransactions WHERE Object =
'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ORDER ENTERED

SELECT * FROM Orders WHERE CustCode = '[SearchVal1]' AND PurchContact = '[SearchVal2]' AND OrderNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#)
ORDER BY DateEnt DESC

QUOTE ENTERED

SELECT * FROM Quote WHERE CustCode = '[SearchVal1]' AND ContactName = '[SearchVal2]' AND QuoteNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#)
ORDER BY DateEnt DESC

SHIPMENT ENTERED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE CustCode = '[SearchVal1]'
AND PurchContact = '[SearchVal2]') AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object =
'Shipment' AND Action = 'NEW' AND TransDate > #[LastRun]#)

ORDER PROCESSED

SELECT * FROM Orders WHERE CustCode = '[SearchVal1]' AND PurchContact = '[SearchVal2]' AND OrderNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Order' AND Action = 'PROCESS' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

SHIPMENT PROCESSED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE CustCode = '[SearchVal1]'
AND PurchContact = '[SearchVal2]') AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object =
'Shipment' AND Action = 'PROCESS' AND TransDate > #[LastRun]#)

CASH RECEIPT PROCESSED

SELECT * FROM ReceiptDet WHERE InvoiceNo IN (SELECT InvoiceNo FROM Billing WHERE CustCode =
'[SearchVal1]') AND InvoiceNo IN (SELECT InvoiceNo FROM BillingDet WHERE ContactName = '[SearchVal2]') AND
CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS' AND
TransDate > #[LastRun]#) ORDER BY RecDate DESC

18

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

Customer

ORDER ENTERED

SELECT * FROM Orders WHERE CustCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

QUOTE ENTERED

SELECT * FROM Quote WHERE CustCode = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ORDER PROCESSED

SELECT * FROM Orders WHERE CustCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SHIPMENT ENTERED

SELECT * FROM DelTicket WHERE CustCode = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

SHIPMENT PROCESSED

SELECT * FROM DelTicket WHERE CustCode = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) Order BY
DateEnt DESC

INVOICE ENTERED

SELECT * FROM Billing WHERE CustCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CASH RECEIPT ENTERED

SELECT * FROM Receipt WHERE CustCode = '[SearchVal1]' AND CustCode IN (SELECT Value FROM
UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

CASH RECEIPT PROCESSED

SELECT * FROM Receipt WHERE CustCode = '[SearchVal1]' AND CustCode IN (SELECT Value FROM
UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

19

ESTIMATE ENTERED

SELECT * FROM Estim WHERE CustCode = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY EntDate DESC

INVOICE 30 DAYS LATE

SELECT * FROM Billing WHERE CustCode = '[SearchVal1]' AND DateValue(#[LastRun]#) > (DateValue(NetDueDate)
+30) AND PymtStatus = 'U' AND NetDueDate < Now

INVOICE LATE

SELECT * FROM Billing WHERE CustCode = '[SearchVal1]' AND #[LastRun]# > NetDueDate AND PymtStatus = 'U' AND
NetDueDate < Now

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate
>#[LastRun]#) ORDER BY DateEnt DESC

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

NON-CONFORMANCE ENTERED

SELECT * FROM NonConformance WHERE CustCode = '[SearchVal1]' AND NonConfNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'NonConf' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY
EnterDate DESC

CORRECTIVE ACTION ENTERED

SELECT * FROM CAR WHERE CustCode = '[SearchVal1]' AND CorrectiveActionNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CAR' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

RETURN ISSUED

SELECT * FROM CustReturn WHERE CustCode = '[SearchVal1]' AND CustRMANo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CustReturn' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

NON-CONFORMANCE PROCESSED

SELECT * FROM NonConformance WHERE CustCode = '[SearchVal1]' AND NonConfNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'NonConf' AND Action = 'PROCESS DATE' AND TransDate > #[LastRun]#) ORDER
BY EnterDate DESC

CORRECTIVE ACTION IMPLEMENTED

SELECT * FROM CAR WHERE CustCode = '[SearchVal1]' AND CorrectiveActionNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CAR' AND Action = 'IMPLEMENTATION DATE' AND TransDate > #[LastRun]#)
ORDER BY DateEnt DESC

20

CORRECTIVE ACTION CLOSED OUT

SELECT * FROM CAR WHERE CustCode = '[SearchVal1]' AND CorrectiveActionNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CAR' AND Action = 'CLOSE OUT DATE' AND TransDate > #[LastRun]#) ORDER
BY DateEnt DESC

CORRECTIVE ACTION VERIFIED

SELECT * FROM CAR WHERE CustCode = '[SearchVal1]' AND CorrectiveActionNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CAR' AND Action = 'VERIFICATION DATE' AND TransDate > #[LastRun]#) ORDER
BY DateEnt DESC

CORRECTIVE ACTION LATE

SELECT * FROM CAR WHERE ResponseDue IS NOT NULL AND ImplementationDate IS NULL AND ResponseDue <
#[LastRun]# AND CustCode = '[SearchVal1]' ORDER BY EnterDate DESC

Dept

ESTIMATE ENTERED

SELECT * FROM Estim WHERE RouteEmpl = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY EntDate DESC

Document

DOCUMENT IS APPROVED

SELECT * FROM DocumentControl WHERE DocNumber = '[SearchVal1]' AND DocNumber IN (SELECT Value FROM
UserTransactions WHERE Object = 'DOCUMENT' AND Action = 'APPROVED' AND TransDate > #[LastRun]#) ORDER
BY DateEnt DESC

DOCUMENT IS ENTERED

SELECT * FROM DocumentControl WHERE DocNumber = '[SearchVal1]' AND DocNumber IN (SELECT Value FROM
UserTransactions WHERE Object = 'DOCUMENT' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

DOCUMENT IS PROPOSED

SELECT * FROM DocumentControl WHERE DocNumber = '[SearchVal1]' AND DocNumber IN (SELECT Value FROM
UserTransactions WHERE Object = 'DOCUMENT' AND Action = 'PROPOSED' AND TransDate > #[LastRun]#) ORDER
BY DateEnt DESC

DOCUMENT IS RELEASED

SELECT * FROM DocumentControl WHERE DocNumber = '[SearchVal1]' AND DocNumber IN (SELECT Value FROM
UserTransactions WHERE Object = 'DOCUMENT' AND Action = 'RELEASED' AND TransDate > #[LastRun]#) ORDER
BY DateEnt DESC

DOCUMENT IS RETIRED

SELECT * FROM DocumentControl WHERE DocNumber = '[SearchVal1]' AND DocNumber IN (SELECT Value FROM
UserTransactions WHERE Object = 'DOCUMENT' AND Action = 'RETIRED' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

DOCUMENT IS REVISED

SELECT * FROM DocumentControl WHERE DocNumber = '[SearchVal1]' AND DocNumber IN (SELECT Value FROM
UserTransactions WHERE Object = 'DOCUMENT' AND Action = 'REVISION' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

21

DOCUMENT IS ROLLED BACK

SELECT * FROM DocumentControl WHERE DocNumber = '[SearchVal1]' AND DocNumber IN (SELECT Value FROM
UserTransactions WHERE Object = 'DOCUMENT' AND Action = 'ROLLBACK' AND TransDate > #[LastRun]#) ORDER
BY DateEnt DESC

Employee

CLOCKED IN

SELECT * FROM AttendDet WHERE EmplCode = [SearchVal1] AND CreatedBy = 'CLOCK IN' AND
DateValue(TicketDate) = DateValue(#[LastRun]#) AND TimeValue(ActClockInTime) > TimeValue(#[LastRunTime]#) AND
TimeValue(ActClockInTime) < TimeValue(#[NowTime]#)

CLOCKED OUT

SELECT * FROM AttendDet WHERE EmplCode = [SearchVal1] AND CreatedBy = 'CLOCK OUT' AND
DateValue(TicketDate) = DateValue(#[LastRun]#) AND TimeValue(ActClockOutTime) > TimeValue(#[LastRunTime]#)
AND TimeValue(ActClockOutTime) < TimeValue(#[NowTime]#)

BREAK START

SELECT * FROM AttendDet WHERE AttendCode = 9999 AND EmplCode = [SearchVal1] AND DateValue(TicketDate) =
DateValue(#[LastRun]#) AND (ActClockOutTime IS NULL OR ActClockOutTime = '' OR ActClockOutTime = '99:99')

BREAK STOP

SELECT * FROM AttendDet WHERE AttendCode = 9999 AND EmplCode = [SearchVal1] AND DateValue(TicketDate) =
DateValue(#[LastRun]#) AND ActClockOutTime IS NOT NULL

STARTED JOB

SELECT * FROM Online WHERE EmplCode = '[SearchVal1]' AND LogonTime > #[LastRun]# AND LogonTime < Now

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND EmplCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND EmplCode = '[SearchVal1]' AND FeedbackNo
IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND EmplCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

Estimate

QUOTE ENTERED

SELECT * FROM QuoteDet WHERE PartNo = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#)

JOB ENTERED

SELECT * FROM OrderDet WHERE PartNo = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#)

22

SHIPMENT ENTERED

SELECT * FROM DelTicketDet WHERE PartNo = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND TransDate > #[LastRun]#)

SHIPMENT PROCESSED

SELECT * FROM DelTicketDet WHERE PartNo = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'PROCESS' AND TransDate > #[LastRun]#)

INVOICE ENTERED

SELECT * FROM BillingDet WHERE PartNo = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#)

ROUTING EDITED

SELECT * FROM Estim WHERE PartNo = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'ROUTING' AND TransDate > #[LastRun]#) ORDER BY EntDate DESC

BOM EDITED

SELECT * FROM Estim WHERE PartNo = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'BOM' AND TransDate > #[LastRun]#) ORDER BY EntDate DESC

REVISION EDITED

SELECT * FROM Estim WHERE PartNo = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'REVISION' AND TransDate > #[LastRun]#) ORDER BY EntDate DESC

INVENTORY POSTED

SELECT * FROM JobMaterials WHERE PartNo = '[SearchVal1]' AND QtyPosted1 > 0 AND OutsideService = 'N' AND
DatePosted > #[LastRun]# AND DatePosted < Now

Feedback

CORRECTIVE ACTION ENTERED

SELECT * FROM CAR WHERE FeedbackNo IN (SELECT Value FROM UserTransactions WHERE Object = 'CAR' AND
Action = 'NEW' AND TransDate > #[LastRun]#)

CORRECTIVE ACTION PROCESSED

SELECT * FROM CAR WHERE FeedbackNo IN (SELECT Value FROM UserTransactions WHERE Object = 'CAR' AND
Action = 'PROCESS' AND TransDate > #[LastRun]#)

CORRECTIVE ACTION IMPLEMENTED

SELECT * FROM CAR WHERE FeedbackNo IN (SELECT Value FROM UserTransactions WHERE Object = 'CAR' AND
Action = 'IMPLEMENTATION DATE' AND TransDate > #[LastRun]#)

CORRECTIVE ACTION VERIFIED

SELECT * FROM CAR WHERE FeedbackNo IN (SELECT Value FROM UserTransactions WHERE Object = 'CAR' AND
Action = 'VERIFICATION DATE' AND TransDate > #[LastRun]#)

CORRECTIVE ACTION CLOSED OUT

SELECT * FROM CAR WHERE FeedbackNo IN (SELECT Value FROM UserTransactions WHERE Object = 'CAR' AND
Action = 'CLOSE OUT DATE' AND TransDate > #[LastRun]#)

CORRECTIVE ACTION LATE

SELECT * FROM CAR WHERE ResponseDue IS NOT NULL AND ImplementationDate IS NULL AND ResponseDue <
#[LastRun]# AND FeedbackNo = '[SearchVal1]' ORDER BY EnterDate DESC

23

FeedbackCode

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND FeedbackCode = '[SearchVal1]' AND
FeedbackNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY EnterDate DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND FeedbackCode = '[SearchVal1]' AND
FeedbackNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY EnterDate DESC

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND FeedbackCode = '[SearchVal1]' AND
FeedbackNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY EnterDate DESC

GLCode

ESTIMATE ENTERED

SELECT * FROM Estim WHERE GLCode = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY EntDate DESC

INVENTORY ENTERED

SELECT * FROM Estim WHERE GLCode = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY EntDate DESC

VENDOR ENTERED

SELECT * FROM VendCode WHERE GLAcct1 = '[SearchVal1]' AND VendCode IN (SELECT Value FROM
UserTransactions WHERE Object = 'Vendor' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateOpen
DESC

INVOICE ENTERED

SELECT * FROM Billing WHERE InvoiceNo IN (SELECT InvoiceNo FROM BillingDet WHERE GLAcct1 = '[SearchVal1]')
AND InvoiceNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Invoice' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

VENDOR INVOICE ENTERED

SELECT * FROM VendorInv WHERE InvoiceNo IN (SELECT InvoiceNo FROM VendorInvDet WHERE GLAcct =
'[SearchVal1]') AND InvoiceNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'VendorInv' AND Action =
'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CHECK ENTERED

SELECT * FROM [Check] WHERE CheckNo IN (SELECT CheckNo FROM CheckDet WHERE GLAcct = '[SearchVal1]')
AND CheckNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Check' AND Action = 'NEW' AND
TransDate> #[LastRun]#) ORDER BY DateEnt DESC

CHECK PROCESSED

SELECT * FROM [Check] WHERE CheckNo IN (SELECT CheckNo FROM CheckDet WHERE GLAcct = '[SearchVal1]')
AND CheckNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Check' AND Action = 'PROCESS' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

24

CASH RECEIPT ENTERED

SELECT * FROM Receipt WHERE CheckNo IN (SELECT CheckNo FROM ReceiptDet WHERE GLAcct = '[SearchVal1]')
AND CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND
TransDate > #[LastRun]#) AND CustCode IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt'
AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CASH RECEIPT PROCESSED

SELECT * FROM Receipt WHERE CheckNo IN (SELECT CheckNo FROM ReceiptDet WHERE GLAcct = '[SearchVal1]')
AND CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS'
AND TransDate > #[LastRun]#) AND CustCode IN (SELECT Value FROM UserTransactions WHERE Object =
'CashReceipt' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

JOURNAL ENTRY ENTERED

SELECT * FROM GL WHERE JournalNo IN (SELECT JournalNo FROM GLDet WHERE GLAccount = '[SearchVal1]')
AND JournalNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Journal' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

PO ENTERED

SELECT * FROM PO WHERE PONum IN (SELECT PONum FROM PODet WHERE GLCode = '[SearchVal1]') AND
PONum IN (SELECT Value FROM UserTransactions WHERE Object = 'PO' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

PO PROCESSED

SELECT * FROM PO WHERE PONum IN (SELECT PONum FROM PODet WHERE GLCode = '[SearchVal1]') AND
PONum IN (SELECT Value FROM UserTransactions WHERE Object = 'PO' AND Action = 'PROCESS' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

GroupCode

GL CODE ENTERED

SELECT * FROM GLAccounts WHERE AcctCode = '[SearchVal1]' AND GLAcctNum IN (SELECT Value FROM
UserTransactions WHERE Object = 'GLCode' AND Action = 'NEW' AND TransDate > #[LastRun]#)

InvItem

INVOICE ENTERED

SELECT * FROM BillingDet WHERE PartNo = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#)

BOM EDITED

SELECT * FROM Estim WHERE PartNo = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'BOM' AND TransDate > #[LastRun]#)

JOB ENTERED

SELECT * FROM OrderDet WHERE PartNo = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#)

QUOTE ENTERED

SELECT * FROM QuoteDet WHERE PartNo = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#)

REVISION EDITED

SELECT * FROM Estim WHERE PartNo = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'REVISION' AND TransDate > #[LastRun]# )

25

ROUTING EDITED

SELECT * FROM Estim WHERE PartNo = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'ROUTING' AND TransDate > #[LastRun]# AND TransDate < Now)

SHIPMENT ENTERED

SELECT * FROM DelTicketDet WHERE PartNo = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND TransDate > #[LastRun]#)

SHIPMENT PROCESSED

SELECT * FROM DelTicketDet WHERE PartNo = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'PROCESS' AND TransDate > #[LastRun]#)

INVENTORY POSTED

SELECT * FROM JobMaterials WHERE PartNo = '[SearchVal1]' AND QtyPosted1 > 0 AND OutsideService = 'N' AND
DatePosted > #[LastRun]# AND DatePosted < Now

INVENTORY LOW

SELECT * FROM Estim WHERE PartNo = '[SearchVal1]' AND ReOrdLevel > (SELECT SUM(QtyOnHand) FROM
BinLocations WHERE BinLocations.PartNo = Estim.PartNo) AND Estim.PartNo IN (SELECT PartNo FROM
InventoryAdjustments WHERE InventoryAdjustments.DatePosted > #[LastRun]#)

Invoice

CASH RECEIPT ENTERED

SELECT * FROM Receipt WHERE CheckNo IN (SELECT CheckNo FROM ReceiptDet WHERE InvoiceNo =
'[SearchVal1]')AND CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action
= 'NEW' AND TransDate > #[LastRun]#) AND CustCode IN (SELECT Value FROM UserTransactions WHERE Object =
'CashReceipt' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CASH RECEIPT PROCESSED

SELECT * FROM Receipt WHERE CheckNo IN (SELECT CheckNo FROM ReceiptDet WHERE InvoiceNo =
'[SearchVal1]') AND CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action
= 'PROCESS' AND TransDate > #[LastRun]#) AND CustCode IN (SELECT Value FROM UserTransactions WHERE
Object = 'CashReceipt' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

INVOICE LATE

SELECT * FROM Billing WHERE InvoiceNo = '[SearchVal1]' AND #[LastRun]# > NetDueDate AND PymtStatus = 'U' AND
NetDueDate < Now

INVOICE 30 DAYS LATE

SELECT * FROM Billing WHERE InvoiceNo = '[SearchVal1]' AND DateValue(#[LastRun]#) > (DateValue(NetDueDate)
+30) AND PymtStatus = 'U' AND NetDueDate < Now

Job

JOB CLOSED

SELECT * FROM ORDERDET WHERE JobNo = '[SearchVal1]' AND Status = 'Closed'

JOB LATE

SELECT * FROM Releases INNER JOIN OrderDet ON OrderDet.JobNo = Releases.JobNo WHERE Releases.JobNo =
'[SearchVal1]' AND Releases.DateComplete IS NULL AND Now > Releases.DueDate AND Releases.DelType = 0 AND
Releases.Qty > 0

26

JOB OUTSIDE

SELECT * FROM PODet Inner Join PO ON PODet.PONum = PO.PONum WHERE PODet.JobNo = '[SearchVal1]' AND
PODet.OutsideService = 'Y' AND PODet.PONum IN (SELECT Value FROM UserTransactions WHERE Object = 'PO'
AND Action = 'NEW' AND TransDate > #[LastRun]#)

INVOICE ENTERED

SELECT * FROM BillingDet WHERE JobNo = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#)

SHIPMENT ENTERED

SELECT * FROM DelTicketDet WHERE JobNo = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND TransDate > #[LastRun]#)

TIME TICKET ENTERED

SELECT * FROM TimeTicketDet WHERE JobNo = '[SearchVal1]' AND DateValue(TicketDate) = DateValue(#[LastRun]#)

STOCK SHIPMENT ENTERED

SELECT * FROM DelTicketDet WHERE JobNo = '[SearchVal1]' AND Qty2Stock >0 AND DelTicketNo IN (SELECT Value
FROM UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND TransDate > #[LastRun]#)

INVENTORY POSTED

SELECT * FROM ORDERDET WHERE JobNo = '[SearchVal1]' AND Status = 'Open' AND JobNo IN (SELECT DISTINCT
JobNo FROM JobMaterials WHERE OutsideService = 'N' AND QtyPosted1 > 0)

MATERIAL ARRIVED

SELECT * FROM POReleases WHERE JobNo = '[SearchVal1]' AND DateReceived IS NOT NULL AND PONum IN
(SELECT PONum FROM PODet WHERE OutsideService = 'N') AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'PROCESS' AND TransDate > #[LastRun]#)

PIECES SCRAPPED

SELECT * FROM TimeTicketDet WHERE JobNo = '[SearchVal1]' AND PiecesScrapped > 0 ORDER BY Counter DESC

REVISION EDITED

SELECT * FROM OrderDet WHERE JobNo = '[SearchVal1]' AND JobNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Job' AND Action = 'REVISION' AND TransDate > #[LastRun]#)

ROUTING EDITED

SELECT * FROM OrderDet WHERE JobNo = '[SearchVal1]' AND JobNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Job' AND Action = 'ROUTING' AND TransDate > #[LastRun]#)

ROUTING COMPLETED

SELECT * FROM ORDERDET WHERE JobNo = '[SearchVal1]' AND JobNo IN (SELECT DISTINCT JobNo FROM
OrderRouting WHERE Status = 'Closed' OR Status = 'Finished')

SCHEDULE EDITED

SELECT * FROM OrderDet WHERE JobNo = '[SearchVal1]' AND JobNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Job' AND Action = 'RELEASES' AND TransDate > #[LastRun]#)

JobStep

STEP COMPLETED

SELECT * FROM ORDERDET WHERE JobNo = '[SearchVal1]' AND JobNo IN (SELECT JobNo FROM OrderRouting
WHERE StepNo = [SearchVal2] AND (Status = 'Closed' OR Status = 'Finished'))

27

PIECES SCRAPPED

SELECT * FROM OrderDet INNER JOIN TimeTicketDet ON OrderDet.JobNo = TimeTicketDet.JobNo WHERE
OrderDet.JobNo = '[SearchVal1]' AND OrderDet.JobNo IN (SELECT DISTINCT JobNo FROM TimeTicketDet WHERE
JobNo = '[SearchVal1]' AND StepNo = [SearchVal2] AND PiecesScrapped > 0)

STEP BEHIND SCHEDULE

SELECT * FROM ORDERDET WHERE JobNo = '[SearchVal1]' AND JobNo IN (SELECT JobNo FROM OrderRouting
WHERE StepNo = [SearchVal2] AND (Status = 'Current' OR Status = 'Pending' OR Status = 'Future') AND #[LastRun]# >
EstimEndDate)

STEP BEGIN LATE

SELECT * FROM ORDERDET WHERE JobNo = '[SearchVal1]' AND JobNo IN (SELECT JobNo FROM OrderRouting
WHERE StepNo = [SearchVal2] AND (Status = 'Current' OR Status = 'Pending' OR Status = 'Future') AND #[LastRun]# >
EstimStartDate)

STEP OVER EST HOURS

SELECT * FROM ORDERDET WHERE JobNo = '[SearchVal1]' AND JobNo IN (SELECT JobNo FROM OrderRouting
WHERE StepNo = [SearchVal2] AND (Status = 'Current' OR Status = 'Pending' OR Status = 'Future') AND TotActHrs >
TotEstHrs)

Journal

JOURNAL ENTRY CLEARED

SELECT * FROM GL WHERE JournalNo = '[SearchVal1]' AND JournalNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'BankRec' AND Action = 'CLEAR' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

NonConf

CORRECTIVE ACTION CLOSED OUT

SELECT * FROM CAR WHERE CorrectiveActionNo IN (SELECT CorrectiveActionNo FROM NonConformance WHERE
NonConfNo = '[SearchVal1]') AND CorrectiveActionNo IN (SELECT Value FROM UserTransactions WHERE Object =
'CAR'AND Action = 'CLOSE OUT DATE' AND TransDate > #[LastRun]#) ORDER BY EnterDate DESC

CORRECTIVE ACTION IMPLEMENTED

SELECT * FROM CAR WHERE CorrectiveActionNo IN (SELECT CorrectiveActionNo FROM NonConformance WHERE
NonConfNo = '[SearchVal1]') AND CorrectiveActionNo IN (SELECT Value FROM UserTransactions WHERE Object =
'CAR' AND Action = 'IMPLEMENTATION DATE' AND TransDate > #[LastRun]#) ORDER BY EnterDate DESC

CORRECTIVE ACTION LATE

SELECT * FROM CAR WHERE ResponseDue IS NOT NULL AND ImplementationDate IS NULL AND ResponseDue <
#[LastRun]# AND CorrectiveActionNo IN (SELECT CorrectiveActionNo FROM NonConformance WHERE NonConfNo =
'[SearchVal1]') ORDER BY EnterDate DESC

CORRECTIVE ACTION VERIFIED

SELECT * FROM CAR WHERE CorrectiveActionNo IN (SELECT CorrectiveActionNo FROM NonConformance WHERE
NonConfNo = '[SearchVal1]') AND CorrectiveActionNo IN (SELECT Value FROM UserTransactions WHERE Object =
'CAR' AND Action = 'VERIFICATION DATE' AND TransDate > #[LastRun]#) ORDER BY EnterDate DESC

OperCode

ROUTING ENTERED

SELECT * FROM Routing WHERE OperCode = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'NEW' AND TransDate > #[LastRun]#)

28

Order

SHIPMENT ENTERED

SELECT * FROM DelTicket INNER JOIN Orders ON DelTicket.OrderNo = Orders.OrderNo
WHERE Orders.OrderNo = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object
= 'Shipment' AND Action = 'NEW' AND TransDate > #[LastRun]#)

SHIPMENT PROCESSED

SELECT * FROM DelTicket INNER JOIN Orders ON DelTicket.OrderNo = Orders.OrderNo WHERE Orders.OrderNo =
'[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action =
'PROCESS' AND TransDate > #[LastRun]#)

INVOICE ENTERED

SELECT * FROM BillingDet WHERE JobNo IN (SELECT JobNo FROM OrderDet WHERE JobNo = '[SearchVal1]') AND
InvoiceNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate >
#[LastRun]#)

CASH RECEIPT ENTERED

SELECT * FROM Receipt WHERE CheckNo IN (SELECT CheckNo FROM ReceiptDet WHERE InvoiceNo IN (SELECT
InvoiceNo FROM DelTicketDet WHERE JobNo IN (SELECT JobNo FROM OrderDet WHERE OrderNo = '[SearchVal1]')))
AND CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND
TransDate > #[LastRun]#) AND CustCode IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt'
AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CASH RECEIPT PROCESSED

SELECT * FROM Receipt WHERE CheckNo IN (SELECT CheckNo FROM ReceiptDet WHERE InvoiceNo IN (SELECT
InvoiceNo FROM DelTicketDet WHERE JobNo IN (SELECT JobNo FROM OrderDet WHERE OrderNo = '[SearchVal1]')))
AND CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS'
AND TransDate > #[LastRun]#) AND CustCode IN (SELECT Value FROM UserTransactions WHERE Object =
'CashReceipt' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND OrderNo = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND OrderNo = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND OrderNo = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY EnterDate DESC

PO

CHECK ENTERED

SELECT * FROM [Check] WHERE CheckNo IN (SELECT CheckNo FROM CheckDet WHERE InvoiceNo IN (SELECT
InvoiceNo FROM VendorInvPOs WHERE PONum = '[SearchVal1]')) AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

29

CHECK PROCESSED

SELECT * FROM [Check] WHERE CheckNo IN (SELECT CheckNo FROM CheckDet WHERE InvoiceNo IN (SELECT
InvoiceNo FROM VendorInvPOs WHERE PONum = '[SearchVal1]')) AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

RECEIVER ENTERED

SELECT * FROM ReceiverDet WHERE PONum = '[SearchVal1]' AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'NEW' AND TransDate > #[LastRun]#)

RECEIVER PROCESSED

SELECT * FROM ReceiverDet WHERE PONum = '[SearchVal1]' AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'PROCESS' AND TransDate > #[LastRun]#)

INVOICE ENTERED

SELECT * FROM VendorInv WHERE InvoiceNo IN (SELECT InvoiceNo FROM VendorInvPOs WHERE PONum =
'[SearchVal1]') AND InvoiceNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'VendorInv' AND Action =
'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ProdCode

JOB ENTERED

SELECT * FROM OrderDet WHERE ProdCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#)

JOB PROCESSED

SELECT * FROM OrderDet WHERE ProdCode = '[SearchVal1]' AND JobNo IS NOT NULL AND JobNo <> '' AND
OrderNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Order' AND Action = 'PROCESS' AND
TransDate > #[LastRun]#)

INVENTORY ENTERED

SELECT * FROM Estim WHERE ProdCode = '[SearchVal1]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY EntDate DESC

QUOTE ENTERED

SELECT * FROM QuoteDet INNER JOIN Estim ON QuoteDet.PartNo = Estim.PartNo WHERE Estim.ProdCode =
'[SearchVal1]' AND QuoteNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Quote' AND Action = 'NEW'
AND TransDate > #[LastRun]#)

SHIPMENT ENTERED

SELECT * FROM DelTicketDet INNER JOIN Estim ON DelTicketDet.PartNo = Estim.PartNo WHERE Estim.ProdCode =
'[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action =
'NEW' AND TransDate > #[LastRun]#)

SHIPMENT PROCESSED

SELECT * FROM DelTicketDet INNER JOIN Estim ON DelTicketDet.PartNo = Estim.PartNo WHERE Estim.ProdCode =
'[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action =
'PROCESS' AND TransDate > #[LastRun]#)

INVOICE ENTERED

SELECT * FROM BillingDet WHERE ProdCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#)

30

Quote

ORDER ENTERED

SELECT * FROM Orders WHERE QuoteNo = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ORDER PROCESSED

SELECT * FROM Orders WHERE QuoteNo = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

QUOTE EXPIRED

SELECT * FROM Quote WHERE QuoteNo = '[SearchVal1]' AND ExpireDate IS NOT NULL AND #[LastRun]# >
ExpireDate AND ExpireDate < Now ORDER BY ExpireDate DESC

QUOTE FOLLOWUP

SELECT * FROM Quote WHERE QuoteNo = '[SearchVal1]' AND FollowupDate IS NOT NULL AND #[LastRun]# >
FollowupDate AND FollowupDate < Now ORDER BY FollowupDate DESC

Receiver

INVOICE ENTERED

SELECT * FROM VendorInv WHERE ReceiverNo = '[SearchVal1]' AND InvoiceNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'VendorInv' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

CHECK ENTERED

SELECT * FROM [Check] WHERE CheckNo IN (SELECT CheckNo FROM CheckDet WHERE InvoiceNo IN (SELECT
InvoiceNo FROM VendorInv WHERE ReceiverNo = '[SearchVal1]')) AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

CHECK PROCESSED

SELECT * FROM [Check] WHERE CheckNo IN (SELECT CheckNo FROM CheckDet WHERE InvoiceNo IN (SELECT
InvoiceNo FROM VendorInv WHERE ReceiverNo = '[SearchVal1]')) AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

RFQ

PO ENTERED

SELECT * FROM PO WHERE RFQNo = '[SearchVal1]' AND PONum IN (SELECT Value FROM UserTransactions
WHERE Object = 'PO' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

PO PROCESSED

SELECT * FROM PO WHERE RFQNo = '[SearchVal1]' AND PONum IN (SELECT Value FROM UserTransactions
WHERE Object = 'PO' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

RECEIVER ENTERED

SELECT * FROM Receiver WHERE ReceiverNo IN (SELECT ReceiverNo FROM ReceiverDet WHERE PONum IN
(SELECT PONum FROM PO WHERE RFQNo = '[SearchVal1]')) AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

31

RECEIVER PROCESSED

SELECT * FROM Receiver WHERE ReceiverNo IN (SELECT ReceiverNo FROM ReceiverDet WHERE PONum IN
(SELECT PONum FROM PO WHERE RFQNo = '[SearchVal1]')) AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

RFQ EXPIRED

SELECT * FROM RFQ WHERE RFQNo = '[SearchVal1]' AND ExpireDate IS NOT NULL AND #[LastRun]# > ExpireDate
AND ExpireDate < Now ORDER BY DateEnt DESC

Salesman

QUOTE ENTERED

SELECT * FROM Quote WHERE SalesID = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ORDER ENTERED

SELECT * FROM Orders WHERE SalesID = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

INVOICE ENTERED

SELECT * FROM Billing WHERE SalesID = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ORDER PROCESSED

SELECT * FROM Orders WHERE SalesID = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'PROCESS' AND TransDate > #[LastRun]#)

SHIPMENT ENTERED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE SalesID = '[SearchVal1]')
AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SHIPMENT PROCESSED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE SalesID = '[SearchVal1]')
AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action = 'PROCESS'
AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CASH RECEIPT ENTERED

SELECT * FROM ReceiptDet WHERE InvoiceNo IN (SELECT InvoiceNo FROM Billing WHERE SalesID = '[SearchVal1]')
AND CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND
TransDate > #[LastRun]#) AND CustCode IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt'
AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY RecDate DESC

CASH RECEIPT PROCESSED

SELECT * FROM ReceiptDet WHERE InvoiceNo IN (SELECT InvoiceNo FROM Billing WHERE SalesID = '[SearchVal1]')
AND CheckNo IN (SELECT Value2 FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS'
AND TransDate > #[LastRun]#) AND CustCode IN (SELECT Value FROM UserTransactions WHERE Object =
'CashReceipt' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY RecDate DESC

32

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback INNER JOIN Orders ON Orders.OrderNo = Feedback.OrderNo WHERE FeedbackType =
'NEGATIVE' AND Orders.SalesID = '[SearchVal1]' AND FeedbackNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY EnterDate DESC

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback INNER JOIN Orders ON Orders.OrderNo = Feedback.OrderNo WHERE FeedbackType =
'POSITIVE' AND Orders.SalesID = '[SearchVal1]' AND FeedbackNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY EnterDate DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback INNER JOIN Orders ON Orders.OrderNo = Feedback.OrderNo WHERE FeedbackType =
'NEUTRAL' AND Orders.SalesID = '[SearchVal1]' AND FeedbackNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY EnterDate DESC

QUOTE FOLLOWUP

SELECT * FROM Quote WHERE SalesID = '[SearchVal1]' AND FollowUpDate > #[LastRun]#) ORDER BY QuoteNo
DESC

QUOTE EXPIRED

SELECT * FROM Quote WHERE SalesID = '[SearchVal1]' AND ExpireDate > #[LastRun]#) ORDER BY QuoteNo DESC

Scheduling

JOB START BEHIND

SELECT * FROM ORDERDET WHERE JobNo IN (SELECT JobNo FROM Scheduling WHERE #[LastRun]# > StartDate)

JOB FINISH BEHIND

SELECT * FROM ORDERDET WHERE JobNo IN (SELECT JobNo FROM Scheduling WHERE #[LastRun]# > EndDate)

ShipCode

INVOICE ENTERED

SELECT * FROM Billing WHERE ShipCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER By DateEnt

QUOTE ENTERED

SELECT * FROM Quote WHERE ShipCode = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ORDER ENTERED

SELECT * FROM Orders WHERE ShipCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ORDER PROCESSED

SELECT * FROM Orders WHERE ShipCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SHIPMENT PROCESSED

SELECT * FROM DelTicket WHERE ShipCode = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

33

SHIPMENT ENTERED

SELECT * FROM DelTicket WHERE ShipCode = '[SearchVal1]' AND DelTicketNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

Shipment

INVOICE ENTERED

SELECT * FROM Billing WHERE InvoiceNo IN (SELECT InvoiceNo FROM BillingDet WHERE DelTicketNo =
'[SearchVal1]') AND InvoiceNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Invoice' AND Action =
'NEW'AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CASH RECEIPT ENTERED

SELECT * FROM Receipt WHERE CheckNo IN (SELECT CheckNo FROM ReceiptDet WHERE InvoiceNo IN (SELECT
InvoiceNo FROM BillingDet WHERE DelTicketNo = '[SearchVal1]')) AND CheckNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND TransDate > #[LastRun]#) AND CustCode
IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

CASH RECEIPT PROCESSED

SELECT * FROM Receipt WHERE CheckNo IN (SELECT CheckNo FROM ReceiptDet WHERE InvoiceNo IN (SELECT
InvoiceNo FROM BillingDet WHERE DelTicketNo = '[SearchVal1]')) AND CheckNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) AND
CustCode IN (SELECT Value FROM UserTransactions WHERE Object = 'CashReceipt' AND Action = 'PROCESS' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

TaxCode

QUOTE ENTERED

SELECT * FROM Quote WHERE TaxType = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

ORDER ENTERED

SELECT * FROM Orders WHERE TaxCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#)

ORDER PROCESSED

SELECT * FROM Orders WHERE TaxCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Order' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

INVOICE ENTERED

SELECT * FROM Billing WHERE TaxCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SHIPMENT ENTERED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE TaxCode = '[SearchVal1]')
AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SHIPMENT PROCESSED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE TaxCode = '[SearchVal1]')
AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action = 'PROCESS'
AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

34

TermsCode

INVOICE ENTERED

SELECT * FROM Billing WHERE TermsCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

ORDER ENTERED

SELECT * FROM Orders WHERE TermsCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

ORDER PROCESSED

SELECT * FROM Orders WHERE TermsCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Order' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

QUOTE ENTERED

SELECT * FROM Quote WHERE TermsCode = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

SHIPMENT ENTERED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE TermsCode = '[SearchVal1]')
AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action = 'NEW' AND
TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SHIPMENT PROCESSED

SELECT * FROM DelTicket WHERE OrderNo IN (SELECT OrderNo FROM Orders WHERE TermsCode = '[SearchVal1]')
AND DelTicketNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Shipment' AND Action = 'PROCESS'
AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

VendContact

PO ENTERED

SELECT * FROM PO WHERE VendCode = '[SearchVal1]' AND Contact = '[SearchVal2]' AND PONum IN (SELECT Value
FROM UserTransactions WHERE Object = 'PO' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

RECEIVER ENTERED

SELECT * FROM Receiver WHERE PONum IN (SELECT PONum FROM PO WHERE VendCode = '[SearchVal1]' AND
Contact = '[SearchVal2]') AND ReceiverNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Receiver' AND
Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

RFQ ENTERED

SELECT * FROM RFQ WHERE VendCode = '[SearchVal1]' AND ContactName = '[SearchVal2]' AND RFQNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'RFQ' AND Action = 'NEW' AND TransDate > #[LastRun]#)
ORDER BY DateEnt DESC

SERVICE PO ENTERED

SELECT * FROM PO WHERE VendCode = '[SearchVal1]' AND Contact = '[SearchVal2]' AND PONum IN (SELECT
PONum FROM PODet WHERE OutsideService = 'Y') AND PONum IN (SELECT Value FROM UserTransactions WHERE
Object = 'PO' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

35

SERVICE PO PROCESSED

SELECT * FROM PO WHERE VendCode = '[SearchVal1]' AND Contact = '[SearchVal2]' AND PONum IN (SELECT
PONum FROM PODet WHERE OutsideService = 'Y') AND PONum IN (SELECT Value FROM UserTransactions WHERE
Object = 'PO' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

PO PROCESSED

SELECT * FROM PO WHERE VendCode = '[SearchVal1]' AND Contact = '[SearchVal2]' AND PONum IN (SELECT Value
FROM UserTransactions WHERE Object = 'PO' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

RECEIVER PROCESSED

SELECT * FROM Receiver WHERE PONum IN (SELECT PONum FROM PO WHERE VendCode = '[SearchVal1]' AND
Contact = '[SearchVal2]') AND ReceiverNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Receiver' AND
Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND CustCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

Vendor

CHECK ENTERED

SELECT * FROM [Check] WHERE VendCode = '[SearchVal1]' AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

RFQ ENTERED

SELECT * FROM RFQ WHERE VendCode = '[SearchVal1]' AND RFQNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'RFQ' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

RECEIVER ENTERED

SELECT * FROM Receiver WHERE VendCode = '[SearchVal1]' AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

CHECK PROCESSED

SELECT * FROM [Check] WHERE VendCode = '[SearchVal1]' AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

36

PO PROCESSED

SELECT * FROM PO WHERE VendCode = '[SearchVal1]' AND PONum IN (SELECT Value FROM UserTransactions
WHERE Object = 'PO' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

RECEIVER PROCESSED

SELECT * FROM Receiver WHERE VendCode = '[SearchVal1]' AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

PO ENTERED

SELECT * FROM PO WHERE VendCode = '[SearchVal1]' AND PONum IN (SELECT Value FROM UserTransactions
WHERE Object = 'PO' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SERVICE PO ENTERED

SELECT * FROM PO WHERE VendCode = '[SearchVal1]' AND PONum IN (SELECT PONum FROM PODet WHERE
OutsideService = 'Y') AND PONum IN (SELECT Value FROM UserTransactions WHERE Object = 'PO' AND Action =
'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SERVICE PO PROCESSED

SELECT * FROM PO WHERE VendCode = '[SearchVal1]' AND PONum IN (SELECT PONum FROM PODet WHERE
OutsideService = 'Y') AND PONum IN (SELECT Value FROM UserTransactions WHERE Object = 'PO' AND Action =
'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

VENDOR INVOICE ENTERED

SELECT * FROM VendorInv WHERE VendCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'VendorInv' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

NEGATIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEGATIVE' AND VendCode = '[SearchVal1]' AND FeedbackNo
IN (SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

NEUTRAL FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'NEUTRAL' AND VendCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

POSITIVE FEEDBACK RECEIVED

SELECT * FROM Feedback WHERE FeedbackType = 'POSITIVE' AND VendCode = '[SearchVal1]' AND FeedbackNo IN
(SELECT Value FROM UserTransactions WHERE Object = 'Feedback' AND Action = 'NEW' AND TransDate >
#[LastRun]#) ORDER BY DateEnt DESC

CORRECTIVE ACTION ENTERED

SELECT * FROM CAR WHERE VendCode = '[SearchVal1]' AND CorrectiveActionNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CAR' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

CORRECTIVE ACTION IMPLEMENTED

SELECT * FROM CAR WHERE VendCode = '[SearchVal1]' AND CorrectiveActionNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CAR' AND Action = 'IMPLEMENTATION DATE' AND TransDate > #[LastRun]#)
ORDER BY DateEnt DESC

37

CORRECTIVE ACTION VERIFIED

SELECT * FROM CAR WHERE VendCode = '[SearchVal1]' AND CorrectiveActionNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CAR' AND Action = 'VERIFICATION DATE' AND TransDate > #[LastRun]#) ORDER
BY DateEnt DESC

CORRECTIVE ACTION CLOSED OUT

SELECT * FROM CAR WHERE VendCode = '[SearchVal1]' AND CorrectiveActionNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'CAR' AND Action = 'CLOSE OUT DATE' AND TransDate > #[LastRun]#) ORDER
BY DateEnt DESC

CORRECTIVE ACTION LATE

SELECT * FROM CAR WHERE ResponseDue IS NOT NULL AND ImplementationDate IS NULL AND ResponseDue <
#[LastRun]# AND VendCode = '[SearchVal1]' ORDER BY EnterDate DESC

CHANGE ON RFQ FOR ESTIMATE

SELECT * FROM Usertransactions WHERE Action = 'ADJUST' AND Comments LIKE 'Cost*' AND Object = 'ESTIMATE'
AND TransDate > #[LastRun]#

CHANGE ON RFQ FOR JOB

SELECT * FROM Usertransactions WHERE Action = 'ADJUST' AND Comments LIKE 'Cost*' AND Object = 'JOB' AND
TransDate > #[LastRun]#

VendorInv

CHECK ENTERED

SELECT * FROM [Check] WHERE CheckNo IN (SELECT CheckNo FROM CheckDet WHERE VendCode =
'[SearchVal1]' AND InvoiceNo = '[SearchVal2]') AND CheckNo IN (SELECT Value FROM UserTransactions WHERE
Object = 'Check' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

CHECK PROCESSED

SELECT * FROM [Check] WHERE CheckNo IN (SELECT CheckNo FROM CheckDet WHERE VendCode =
'[SearchVal1]' AND InvoiceNo = '[SearchVal2]') AND CheckNo IN (SELECT Value FROM UserTransactions WHERE
Object = 'Check' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

INVOICE LATE

SELECT * FROM VendorInv WHERE VendCode = '[SearchVal1]' AND InvoiceNo = '[SearchVal2]' AND #[LastRun]# >
NetDueDate AND PymtStatus = 'U' AND NetDueDate < Now

VendType

PO ENTERED

SELECT * FROM PO WHERE VendType = '[SearchVal1]' AND PONum IN (SELECT Value FROM UserTransactions
WHERE Object = 'PO' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

PO PROCESSED

SELECT * FROM PO WHERE VendType = '[SearchVal1]' AND PONum IN (SELECT Value FROM UserTransactions
WHERE Object = 'PO' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

INVOICE ENTERED

SELECT * FROM VendorInv WHERE VendType = '[SearchVal1]' AND InvoiceNo IN (SELECT Value2 FROM
UserTransactions WHERE Object = 'VendorInv' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

38

CHECK ENTERED

SELECT * FROM [Check] WHERE VendType = '[SearchVal1]' AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

CHECK PROCESSED

SELECT * FROM [Check] WHERE VendType = '[SearchVal1]' AND CheckNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Check' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

RECEIVER ENTERED

SELECT * FROM Receiver WHERE VendType = '[SearchVal1]' AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt
DESC

RECEIVER PROCESSED

SELECT * FROM Receiver WHERE VendType = '[SearchVal1]' AND ReceiverNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Receiver' AND Action = 'PROCESS' AND TransDate > #[LastRun]#) ORDER BY
DateEnt DESC

RFQ ENTERED

SELECT * FROM RFQ WHERE VendType = '[SearchVal1]' AND RFQNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'RFQ' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SERVICE PO ENTERED

SELECT * FROM PO WHERE VendType = '[SearchVal1]' AND PONum IN (SELECT PONum FROM PODet WHERE
OutsideService = 'Y') AND PONum IN (SELECT Value FROM UserTransactions WHERE Object = 'PO' AND Action =
'NEW' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

SERVICE PO PROCESSED

SELECT * FROM PO WHERE VendType = '[SearchVal1]' AND PONum IN (SELECT PONum FROM PODet WHERE
OutsideService = 'Y') AND PONum IN (SELECT Value FROM UserTransactions WHERE Object = 'PO' AND Action =
'PROCESS' AND TransDate > #[LastRun]#) ORDER BY DateEnt DESC

Work Center

ROUTING IS ENTERED

SELECT * FROM Routing WHERE WorkCntr = '[SearchVal2]' AND PartNo IN (SELECT Value FROM UserTransactions
WHERE Object = 'Estimate' AND Action = 'NEW' AND TransDate > #[LastRun]#)

JOB IS ENTERED

SELECT * FROM OrderRouting WHERE WorkCntr = '[SearchVal2]' AND OrderNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#)

LOG IN

SELECT * FROM Online WHERE WorkCntr = '[SearchVal1]' AND LogonTime > #[LastRun]# AND LogonTime < Now

WorkCode

JOB ENTERED

SELECT * FROM OrderDet WHERE WorkCode = '[SearchVal1]' AND OrderNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Order' AND Action = 'NEW' AND TransDate > #[LastRun]#)

39

JOB PROCESSED

SELECT * FROM OrderDet WHERE JobNo IS NOT NULL AND JobNo <> '' AND WorkCode = '[SearchVal1]' AND
OrderNo IN (SELECT Value FROM UserTransactions WHERE Object = 'Order' AND Action = 'NEW' AND TransDate >
#[LastRun]#)

SHIPMENT ENTERED

SELECT * FROM OrderDet WHERE WorkCode = '[SearchVal1]' AND OrderNo IN (SELECT OrderNo FROM DelTicket
WHERE ProcFlag = 0 AND DateEnt > #[LastRun]#)

SHIPMENT PROCESSED

SELECT * FROM OrderDet WHERE WorkCode = '[SearchVal1]' AND OrderNo IN (SELECT OrderNo FROM DelTicket
WHERE ProcFlag = 1 AND DateEnt > #[LastRun]#)

QUOTE ENTERED

SELECT * FROM QuoteDet WHERE WorkCode = '[SearchVal1]' AND QuoteNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Quote' AND Action = 'NEW' AND TransDate > #[LastRun]#)

INVOICE ENTERED

SELECT * FROM BillingDet WHERE WorkCode = '[SearchVal1]' AND InvoiceNo IN (SELECT Value FROM
UserTransactions WHERE Object = 'Invoice' AND Action = 'NEW' AND TransDate > #[LastRun]#)

CUSTOMER ENTERED

SELECT * FROM CustCode WHERE WorkCode = '[SearchVal1]' AND CustCode IN (SELECT Value FROM
UserTransactions WHERE Object = 'Customer' AND Action = 'NEW' AND TransDate > #[LastRun]#) ORDER BY
DateOpen DESC

40