tOpSۯ *W'Vx  RMLSTX  All By Name Name  +STX:Name RSM RMLAPV  All By Name +Name  +APV:Name RSM lx  BINRFQ All By Customer  +Customer ID +RFQH:CustomerID RSM RMLCOR All By Corporate Code +Code  +CORP:Code  HOUSE RMLPTY All By Product Type ID +Code  +PTY:Code  HOUSE x  RMLARC All By Customer Name +Customer Name  +ARC:Name RSM RMLPRO All By Product ID  +Product ID +PRO:ProductID  HOUSE  x  RMLPRO !Products Linked To One Customer Customer ID= NFJOE  +Product ID ( PRO:CustomerID='NFJOE') +PRO:ProductID HOUSE Customer ID = ~ ~ ~ bNON NON NON C NFJOE  Product ID + Products For Vendor=HOUSE Sort By Product ID Vendor ID= HOUSE  +Product ID ( PRO:VendorID[1:5]= 'HOUSE') +PRO:ProductID HOUSE Vendor ID = = = = bNON NON NON HO HOUSE  Product ID +  6 GC rsoted all invoices for one month vin current month *qpaid invoices for month of july 1998 0)sales tax payable report for december 1998  s %paid invoices for month of july 1998 Htoapv  all by name & rc all by customer name  pro all by product id  ty all by product type id x RMLCON )All Records Sorted By Organization Name +Organization Name  +CONT:Name  HOUSE N/~/x  RTOARC All By Customer Name +Customer Name  +ARC:Name RSM  RTOPRO All By Product ID  +Product ID +PRO:ProductID RSM  RMLACC All By Description  +Description +ACC:Description RSM  RMLSHI All By Customer Name +Customer Name  +ARC:Name  HOUSE  RMLPPL All By Product ID  +Product ID +PRO:ProductID  HOUSE lx  RGLFIN All Departments  5HOUSE = = = = bNON NON NON  +  BGLGLT All By Transaction ID +Transaction ID +GLT:TransactionID  vHOUSE = = = = bNON NON NON  Transaction ID +  BAPAPD "All Transactions Greater Than 26 Transaction ID>= 26  +Account ( APD:TransactionID>=26)  +APD:Account HOUSE Transaction ID >= = = = bNON NON NON 26 26 Account +  ]M-zBF\$*2RJ Nu6p af>:.!WkCC rapapd -invoices within current month sorted by name mlacc all by description pty  all by code &soecs  paid invoices month of february ted all invoices for one month [ ',.247<?DFJORfltw{x  DRMLPRO +Inventoried Products Sorted By Product ID Inventoried= 1  +Product ID ( PRO:OwnedBy= 'I') +PRO:ProductID HOUSE Inventoried = = = = bNON NON NON 1 1  Product ID +  ERMLPRO DAll Products For Vendor=HOUSE Sort By Product ID Vendor ID= HOUSE  +Product ID ( PRO:VendorID[1:5]= 'HOUSE') +PRO:ProductID HOUSE Vendor ID = = = = bNON NON NON HO HOUSE  Product ID + x  ORMLCKH )All Items To One Vendor, Sorted By Date Vendor ID= HOUSE +Payment Date ( CKR:VendorID[1:5]= 'HOUSE') +CKR:PaymentDate HOUSE Vendor ID = = = = bNON NON NON HO HOUSE  Payment Date +  PRSOSOS 0Open Orders Past Ship Date For One Salesperson *EmployeeID= HOUSE AND AND Order Status= O -Customer ID-Ship Date B( SOH:EmployeeID[1:5]= 'HOUSE' AND AND SOH:OrderStatus[1:1]= 'O') -SOH:CustomerID,-SOH:ShipDate HOUSE EmployeeID  Ship Date  Order Status = <=Today's Date = = bAND AND NON HO HOUSE ^O  Customer ID & Ship Date --++ XGC rsoecs  paid invoices month of february (range of invoice numbers  xsod /open order report (detail) for one employee id (s with vendor invoice but no price  s all invoices within current month sort by invoice Borders booked in current month by customer id Ccustomers with credit balances july 99's invoices "open invoices as of 12/31/98 within current month UAorders past est. ship date by cust. id/order @"ship date for one salesperson GPsorted by est. ship date/customer id ?, sorted by order date rders with p.o. = start99 4today's voids, sorted by employee id2 (voider) ۰lx  FRMLPRO +All Linked Products Sorted By Form Number AND +Customer ID+Catalog Number ( AND) #+PRO:CustomerID,+PRO:CatalogNumber HOUSE Last Sale Date  Customer ID <=  Not Equal To = = bAND NON   Customer ID &Catalog Number +  HRSOTES &Paid Invoices For Month Of July 1998 HPayment Date>= 07/01/98 AND Payment Date<= 07/31/98 AND Paid In Full= Y P( SOH:PaymentDate>='72138' AND SOH:PaymentDate<='72168' AND SOH:PaidInFull='Y') HOUSE Payment Date  Payment Date  Paid In Full >= <= = ~ bAND AND NON P 72138 ,72168 ,Y +  IRMLACC All By Account  ACC:Account  HOUSE /x  2RAPAPH 8Invoices Within Current Month Sorted By Order ID AND  +Order ID ( AND)  +APH:OrderID HOUSE Invoice Date  Invoice Date Current Month  Current Year = = bAND NON   Order ID +  3RAPAPH gOpen Invoices For Employee=HOUSE Sorted By OrderIDEmployee ID= HOUSE AND Payment StatusNot Equal To P  +Order ID )( APH:EmployeeID[1:5]= 'HOUSE' AND<>'P')  +APH:OrderID HOUSE Employee ID Payment Status =  Not Equal To = = bAND NON NON HO HOUSE ,P  Order ID + lx  RMLARC "Customer List For HOUSE Accounts Employee ID= HOUSE +Customer Name  ( ARC:EmployeeID[1:5]= 'HOUSE')  +ARC:Name HOUSE Employee ID = = = = f NON NON HO HOUSE Customer Name +  RMLSHI 0Ship To List Sorted By Customer Name, Location +Customer Name+Location +ARC:Name,+SHI:Location  HOUSE = = = = bNON NON NON  Customer Name $ Location ++  BGLGLT )All A/P Account Transactions By Account  +Account 5( GLT:Account~'S100-00' AND GLT:Source[1:3]= 'APH')  +GLT:Account HOUSE Account Source Module ~ = = = bAND NON NON S  S100-00 )APH Account +  GC rmlpty  all by code &Wproduct type id  shi all by customer name # ship to list for one customer 'sorted by customer name, location s for one employee id  pl &products with ship to location = 0001 | tx  all by name & state % pso2xo *all customers, sorted by city/customer id 1employee id=049, sorted by city/customer id  ecn all invoices for one month 0invoiced orders for one month one employee 0paid invoices for one month (one salesman) !.rep category 1 = pop) s invoiced order for one month j.one employee wpaid invoices for march  #one month (comm table = a) u.rep category 1 = pop)y#lx  RGLFIN Department=111 #Department= 111 ( ACC:Department[1:3]= '515') )HOUSE Department = = = = bNON NON NON 51 111 +  BGLGLT %All Transactions Posted To Period 1  Period= 1  -Account ( GLT:Period[1:1]= '1')  -GLT:Account *HOUSE Period = = = = bNON NON NON 1 1 Account -+++  BGLGLT !Transactions For Sales Period 6 /Period= 7 AND Account= 40101-02 AND Year= 1999 +Source C( GLT:Period=7 AND GLT:Account[1:8]= '40101-02' AND GLT:Year=1999)  +GLT:Source HOUSE Period !Account Year = = = = bAND AND NON 7 7 0 40101-02 )1999 Source + &x  ,RAPAPH &All Records Sorted By Transaction ID +Transaction ID +APD:TransactionID  HOUSE = = = = bNON NON NON  Transaction ID +  -BGLGLT (All Transactions For Account=201000-00 )Account~ 20100-00 AND Source Module= APH +Source Transaction ID ?( UPPER(LEFT(GLT:Account,8))= '20100-00' AND GLT:Source='APH') +GLT:SourceTransactionID xHOUSE Account Source Module ~ = ~ ~ bAND NON NON S  20100-00 )APH Source Transaction ID + )x  ORMLCKH )All Items To One Vendor, Sorted By Date Vendor ID= HOUSE +Payment Date ( CKR:VendorID[1:5]= 'HOUSE') +CKR:PaymentDate HOUSE Vendor ID = = = = bNON NON NON HO HOUSE  Payment Date +  PRSOSOS 0Open Orders Past Ship Date For One Salesperson *EmployeeID= HOUSE AND AND Order Status= O -Customer ID-Ship Date B( SOH:EmployeeID[1:5]= 'HOUSE' AND AND SOH:OrderStatus[1:1]= 'O') -SOH:CustomerID,-SOH:ShipDate HOUSE EmployeeID  Ship Date  Order Status = <=Today's Date = = bAND AND NON HO HOUSE ^O  Customer ID & Ship Date --++ ,%&x  .RMLEMP All +Code  +EMP:Code  HOUSE = = = = bNON NON NON  Code +  /RAPAPH ,Invoices Due In Current Month By Vendor ID AND +Vendor ID+Vendor Invoice ( AND) +APH:VendorID,+APH:Invoice HOUSE Due Date  Due Date Current Month  Current Year = = bAND NON   Vendor ID (Vendor Invoice +  0RAPAPH .Invoices Within Current Month Sorted By Name AND +Name+Vendor Invoice ( AND) +APH:Name,+APH:Invoice HOUSE Invoice Date  Invoice Date Current Month  Current Year = = bAND NON  Name -Vendor Invoice +  1RAPAPH .Open Invoices Sorted By Vendor ID & Due Date Payment Status= O +Vendor ID+Due Date ( APH:PaymentStatus[1:1]= 'O') +APH:VendorID,+APH:DueDate HOUSE Payment Status = = = = bNON NON NON O O  Vendor ID ( Due Date + 0lx  RSOSOS Open Invoices As Of 12/31/98 ,Payment Date<= 01/01/99 AND Paid In Full= N  +Customer ID I(SOH:InvoiceDate<72322 AND (SOH:PaymentDate>=72322 OR ~SOH:PaymentDate)) +SOH:CustomerID HOUSE Payment Date  Paid In Full <= = = = bAND NON NON 72 72322 ,N  Customer ID +  RSOSOS #Open Orders, Sorted By Order Date Order Status= O +Order Date+Customer ID ( SOH:OrderStatus[1:1]= 'O') +SOH:OrderDate,+SOH:CustomerID HOUSE Order Status = = = = bNON NON NON O O  Order Date ' Customer ID +  BSOSOD (Open Line Items, Sorted By Employee ID Payment StatusExactly Equal To $+Employee ID+Customer Name+Order ID ( SOH:PaidInFull='') '+SOH:EmployeeID,+SOH:Name,+SOH:OrderID HOUSE Payment Status Exactly Equal To = = = bNON NON NON   Employee ID &Customer Name $ Order ID + 4lx  4RAPAPH -Open Invoices Discountable In Current Month !AND Payment StatusNot Equal To P +Vendor ID+Vendor Invoice  ( AND<>'P') +APH:VendorID,+APH:Invoice HOUSE Discount Date Payment Status Current Month  Not Equal To = = bAND NON NON  DP  Vendor ID (Vendor Invoice +  5RAPAPH kInvoices For Checks Written Within A Date Range Invoice Date<= 03/01/99 AND Invoice Date<= 03/31/99 AND +Check Number 9( APH:InvoiceDate<=72381 AND APH:InvoiceDate<=72411 AND) +APH:CheckNumber HOUSE Invoice Date  Invoice Date  Check Number <= <=  Not Equal To = bAND AND NON 72 72381 ,72411  Check Number +  6RAPAPD KAll Line Items On Or After 02/10 Sorted By Account Invoice Date> 02/01/98 Account ( APH:InvoiceDate>'71988') APD:GLExpenseAccount oHOUSE Invoice Date > ~ ~ ~ bNON NON NON I 71988 Account 8lx  tRAPAPH Tagged Invoices By Name  Tagged= Y +Name+Vendor Invoice ( APH:MARK[1:1]= 'Y') +APH:Name,+APH:Invoice 1HOUSE Tagged = = = = bNON NON NON Y Y Name -Vendor Invoice +  uRSOECS .Paid Invoices For One Month (Comm Table = A) [Payment Date>= 06/01/99 AND Payment Date<= 06/30/99 AND Paid In Full= Y AND Comm. Table= A v( SOH:PaymentDate>=72473 AND SOH:PaymentDate<=72502 AND SOH:PaidInFull[1:1]= 'Y' AND EMP:CommissionTableID[1:1]= 'A') +REMSOH:OrderID @MRW  Payment Date  Payment Date  Paid In Full  Comm. Table >= <= = = bAND AND AND 72 72473 ,72502 ,Y 0A +  vRSOTED All Invoices For One Month HInvoice Date>= 09/01/99 AND Invoice Date<= 09/30/99 AND Order Status= I S( SOH:InvoiceDate>=72565 AND SOH:InvoiceDate<=72594 AND SOH:OrderStatus[1:1]= 'I') MRW  Invoice Date  Invoice Date  Order Status >= <= = = bAND AND NON 72 72565 ,72594 ,I + <lx  RINSIR GProducts For One Customer Sorted By Form Number Customer ID= 00DEAN +Catalog Number !( PRO:CustomerID[1:6]= '00DEAN') +PRO:CatalogNumber HOUSE Customer ID = = = = bNON NON NON 00 00DEAN Catalog Number +  RAPAPH Invoices Paid After 01/01/99 PaymentDate>= 01/01/99  +Vendor ID J( APH:InvoiceDate<72322 AND (APH:PaymentDate>=72322 OR ~APH:PaymentDate)) +APH:VendorID HOUSE PaymentDate >= = = = bNON NON NON 72 72322  Vendor ID +  RSOSOS Orders With P.O. = START99 Customer P.O.= START99  +Customer ID !( SOH:Reference[1:7]= 'START99') +SOH:CustomerID HOUSE Customer P.O. = = = = bNON NON NON ST START99  Customer ID + @%&x  RMLACC Assets Sorted By Description Type= A  +Description ( ACC:Type[1:1]= 'A') +ACC:Description HOUSE Type = = = = bNON NON NON A A  Description +  RAPAPH 'Open Items Bye Vendor ID/Invoice Date Payment Status= O +Vendor ID+Vendor Invoice ( APH:PaymentStatus[1:1]= 'O') +APH:VendorID,+APH:Invoice HOUSE Payment Status = = = = bNON NON NON O O  Vendor ID (Vendor Invoice +  RAPAPH  Invoices For REFERENCE=START99 Reference= START99  +Vendor ID !( APH:Reference[1:7]= 'START99') +APH:VendorID HOUSE Reference = = = = bNON NON NON ST START99  Vendor ID +  RMLSHI Ship Tos For One Employee ID Employee ID= HOUSE +Customer ID+Customer Name "( ARC:EmployeeID[1:7]= 'O'BRIEN') +ARC:CustomerID,+ARC:Name HOUSE Employee ID = = = = bNON NON NON O' O'BRIEN  Customer ID &Customer Name + DN/~/x  RTOAPV  All By Name +Name  +APV:Name RSM RTOPTY All By Product Type ID +Code  +PTY:Code RSM BAPAPD %All Line Items On Or After 02/10/98 Invoice Date> 02/01/98 Account ( APH:InvoiceDate>'71988') APD:GLExpenseAccount oHOUSE Invoice Date > ~ ~ ~ bNON NON NON I 71988 Account  BAPAPD &March Invoices For Vendor ID = HOUSE -Invoice Date in Month=3 AND Vendor ID= HOUSE +Invoice Date B( MONTH(APH:InvoiceDate) = MONTH(72016) AND APH:VendorID='HOUSE') +APH:InvoiceDate THOUSE Invoice Date  Vendor ID M= = ~ ~ bAND NON NON  72016 ,INGRAM  Invoice Date +  BSOSOD %All Invoices, Invoiced Before Today +Customer ID+Product Type #+SOD:CustomerID,+PRO:ProductTypeID HOUSE Invoice Date T< ~ ~ ~ bNON NON NON I  Customer ID & Product Type ++ HR%&x  BSOSOD Product Type/ID/Invoice All #+Product Type+Product Type+Invoice 3+PRO:ProductTypeID,+PRO:ProductTypeID,+SOH:Invoice  _HOUSE ~ ~ ~ ~ bNON NON NON   Product Type % Product Type %Invoice +  BINBPH All Sorted By Vendor ID  +Vendor ID +PRH:VendorID  cHOUSE ~ ~ ~ ~ bNON NON NON T  Vendor ID +  RMLARC $Balance <> 0 Sorted By Customer ID  Balance<>0  +Customer ID ( ARC:Balance<>'B') +ARC:CustomerID !HOUSE Balance <> = = = bNON NON NON B B Customer Name +  RINSIR -All Products With Product Type of Stock Tab Product Type ID= STOCKTAB  +Product ID  ( PRO:ProductTypeID='STOCKTAB') PRO:ProductID RSM Product Type ID = ~ ~ ~ bNON NON NON P  STOCKTAB  Product ID + L:lx  'P')  +APH:OrderID HOUSE Employee ID Payment Status =  Not Equal To = = bAND NON NON HO HOUSE ,P  Order ID +  >RAPAPD SLine Items From Past Due Invoices Sorted By Vendor Due Date<=Today AND Vendor ID~ =( APH:DueDate<= TODAY() AND UPPER(LEFT(APH:VendorID,0))= '') APD:VendorID,APH:Invoice HOUSE Due Date  Vendor ID T< ~ ~ ~ bAND NON NON V + PH%&x  RRMLARC +All Medical Customers By Employee ID/Name Category #1= MEDICAL +EmployeeID+Customer Name !( ARC:Category1[1:7]= 'MEDICAL') +ARC:EmployeeID,+ARC:Name !HOUSE Category #1 = = = = bNON NON NON ME MEDICAL  EmployeeID 'Customer Name +  SRMLARC All Tagged Records  Tagged= Y +Customer Name ( ARC:Mark[1:1]= 'Y')  +ARC:Name !HOUSE Tagged = = = = bNON NON NON Y Y Customer Name +  WRMLPTY  All By Code +Code  +PTY:Code  HOUSE ^RINISR &Inventoried Items Sorted by Location Owned By= I AND Category Product ID 0( PRO:OwnedBy[1:1]= 'I' AND PRO:OnHandQuantity) *PRO:Category, PRO:Location, PRO:ProductID DHOUSE Owned By On Hand = > = = bAND NON NON I I  Category ) Product ID T$lx  7RAPAPD &All Records Sorted By Transaction ID +Transaction ID +APD:TransactionID  HOUSE = = = = bNON NON NON  Transaction ID +  :RAPAPD kInvoices For Checks Written Within A Date Range Invoice Date<= 03/01/99 AND Invoice Date<= 03/31/99 AND +Check Number 9( APH:InvoiceDate<=72381 AND APH:InvoiceDate<=72411 AND) +APH:CheckNumber HOUSE Invoice Date  Invoice Date  Check Number <= <=  Not Equal To = bAND AND NON 72 72381 ,72411  Check Number +  ;RAPAPD .Invoices Within Current Month Sorted By Name AND +Name+Vendor Invoice ( AND) +APH:Name,+APH:Invoice HOUSE Invoice Date  Invoice Date Current Month  Current Year = = bAND NON  Name -Vendor Invoice + Xlx  tRAPAPH Tagged Invoices By Name  Tagged= Y +Name+Vendor Invoice ( APH:MARK[1:1]= 'Y') +APH:Name,+APH:Invoice 1HOUSE Tagged = = = = bNON NON NON Y Y Name -Vendor Invoice +  uRSOECS .PaYVN/~/x  RGLFIN Department=All -HOUSE Department = = = = bNON NON NON  +  BGLGLT One Transaction = 1984 Source Transaction= 1984  +Account  ( GLT:SourceTransactionID=1984)  +GLT:Account HOUSE Source Transaction = = = = bNON NON NON 19 1984 Account +  RSOSOS  Customers With Credit Balances Payment Status= C  +Customer ID ( SOH:PaymentStatus[1:1]= 'C') +SOH:CustomerID nHOUSE Payment Status = = = = bNON NON NON C C  Customer ID +  RARAGE &All Customers, Sorted By Employee ID +Employee ID+Customer ID  +ARC:EmployeeID,+ARC:CustomerID HOUSE Employee ID = = = = bNON NON NON   Employee ID & Customer ID +  RSOSOS 0Today's Voids, Sorted By Employee ID2 (Voider) 1Order Status= V AND Acknowledge DateToday's Date +Employee ID 2 >( SOH:OrderStatus[1:1]= 'V' AND SOH:AcknowledgeDate= TODAY()) +SOH:EmployeeID2 HOUSE Order Status Acknowledge Date =  Today's Date = = bAND NON NON V V Employee ID 2 + ^-%&x  'RAPCRR Cash Requirement Report Due Date<=Today AND Vendor ID~ =( APH:DueDate<= TODAY() AND UPPER(LEFT(APH:VendorID,0))= '') HOUSE Due Date  Vendor ID T< ~ ~ ~ bAND NON NON V +  (RSOECS !Paid Invoices Month Of February *Payment Date Month<=2 AND Paid In Full= Y <( MONTH(SOH:PaymentDate) <= 2 AND SOH:PaidInFull[1:1]= 'Y') HOUSE Payment Date  Paid In Full Month<= = = = bAND NON NON 2 2 0Y +  )RSOTED &Paid Invoices For Month Of July 1998 HPayment Date>= 07/01/98 AND Payment Date<= 07/31/98 AND Paid In Full= Y P( SOH:PaymentDate>='72138' AND SOH:PaymentDate<='72168' AND SOH:PaidInFull='Y') HOUSE Payment Date  Payment Date  Paid In Full >= <= = ~ bAND AND NON P 72138 ,72168 ,Y +  +BAPAPH ,All Transactions After Transaction ID #341 Transaction ID>= 341 +Transaction ID ( APH:TransactionID>='341') +APH:TransactionID xHOUSE Transaction ID >= ~ ~ ~ bNON NON NON T 341 Transaction ID + c88x  RAPPCS $Tagged To Pay, Sorted By Vendor ID  Tagged= Y  +Vendor ID ( APH:Mark[1:1]= 'Y') +APH:VendorID HOUSE Tagged = = = = bNON NON NON Y Y  Vendor ID +  BSOSOH Summary For October Invoice Date Month=10  +Customer ID ( MONTH(SOH:InvoiceDate) = 10) +SOH:CustomerID HOUSE Invoice Date Month= = = = bNON NON NON 10 10  Customer ID +  RMLARC Balance <> 0 & Balance<>0 +Code ( ARC:Balance<>'')  +ARC:Code RSM Balance <> ~ ~ ~ bNON NON NON B 0 Code +  RINSIR 'Products With Product Type = STOCKTAB Product Type ID= STOCKTAB  +Product ID  ( PRO:ProductTypeID='STOCKTAB') PRO:ProductID RSM Product Type ID = ~ ~ ~ bNON NON NON P  STOCKTAB  Product ID +  RAPVPS All POs Sorted By P.O. Number +Purchase Order +VPO:PONumber  HOUSE ~ ~ ~ ~ bNON NON NON V Purchase Order +  BINBPH 'All Transactions Sorted By Entry Date  +Entry Date +PRH:EntryDate  HOUSE ~ ~ ~ ~ bNON NON NON T  Entry Date + h4%&x  BINBPH Entries Made On 06/15/98 Entry Date= 06/15/98  +Entry Date ( PRH:EntryDate='72122') +PRH:EntryDate HOUSE Entry Date = ~ ~ ~ bNON NON NON E 72122  Entry Date +  RSOECS Paid Invoices For March )Payment Date Month=3 AND Paid In Full= Y +Name ;( MONTH(SOH:PaymentDate) = 3 AND SOH:PaidInFull[1:1]= 'Y')  +REMSOH:Name HOUSE Payment Date  Paid In Full Month= = = = bAND NON NON 3 3 0Y Name +  RSOTED ,Sales Tax Payable Report For December 1998 HPayment Date>= 12/01/98 AND Payment Date<= 12/31/98 AND Paid In Full= Y P( SOH:PaymentDate>='72292' AND SOH:PaymentDate<='72321' AND SOH:PaidInFull='Y') HOUSE Payment Date  Payment Date  Paid In Full >= <= = ~ bAND AND NON P 72292 ,72321 ,Y +  BGLGLT *Cost Of Goods Sold Account For Period 12 !Account= 45101-02 AND Period= 12 .( GLT:Account='45101-02' AND GLT:Period='12') HOUSE Account Period = = ~ ~ bAND NON NON P  45101-02 )12 + m$o QUE:MODULEQUE:SECONDKEY QUE:LOCKED QUE:NAME22?QUE:FILTEREXPRESSION>QUE:SORTORDER=QUE:FILTER<QUE:SORT;QUE:ENTRYDATE?QUE:EMPLOYEEID GQUE:FILTERFIELDS@ (QUE:FILTEROPERATORS 'QUE:FILTERJOINS GQUE:FILTERVALUES 2QUE:SORTFIELDS2g QUE:SORTOPERATORSQUE:KEYMODULEć  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ  UNNAMEDr(%&x  {BAPAPD %All Invoices Ordered By Employee ID  +Employee ID +APH:EmployeeID DDDN  Order ID = = = = bNON NON NON   Employee ID +  |RMLSPL 'Products With Ship To Location = 0001 Location= 0001 +Product Type ID+Product ID ( SHI:Location[1:4]= '0001') "+PRO:ProductTypeID,+PRO:ProductID DHOUSE Location = = = = bNON NON NON 00 0001 Product Type ID " Product ID +  ~RAPAPD Transaction ID 1420-1711 .Transaction ID> 1419 AND Transaction ID< 1711 +Transaction ID 5( APH:TransactionID>1419 AND APH:TransactionID<1711) +APD:TransactionID EHOUSE Transaction ID Transaction ID > < = = bAND NON NON 14 1419 -1711 Transaction ID +  RMLARC Frierson's Customer List Employee ID= 023 %+Customer Name+Customer ID+State+Zip ( ARC:EmployeeID[1:3]= '023') .+ARC:Name,+ARC:CustomerID,+ARC:State,+ARC:Zip SCMM  Employee ID = = = = bNON NON NON 02 023 Customer Name $ Customer ID &State ,Zip + wc%&x  fBAPAPD All Paid Invoices !*Payment Date<=Today AND Payment Status= P +Account Vendor ID 7( APH:PaymentDate<= TODAY() AND APH:PaymentStatus='P') $+APD:GLExpenseAccount, APH:VendorID oHOUSE Payment Date Payment Status T< = ~ ~ bAND NON NON P BP Account * Vendor ID +  hBSOSOD 0All Of Today's Invoices, Sorted By Customer ID Invoice Date=Today +Customer ID+Product Type ( SOH:InvoiceDate<= TODAY()) #+SOD:CustomerID,+PRO:ProductTypeID `HOUSE Invoice Date  Current Date ~ ~ ~ bNON NON NON I  Customer ID & Product Type ++  jRSOECS Invoiced Order For One Month OInvoice Date>= 07/01/99 AND Invoice Date<= 07/31/99 AND EmployeeIDNot Equal To  +Order ID L( SOH:InvoiceDate>=72503 AND SOH:InvoiceDate<=72533 AND SOH:EmployeeID<>'') +REMSOH:OrderID fMRW  Invoice Date  Invoice Date  EmployeeID >= <=  Not Equal To = bAND AND NON 72 72503 ,72533  Order ID +  kBINBPH Vendor ID All  +Vendor ID +PRH:VendorID  cHOUSE ~ ~ ~ ~ bNON NON NON T  Vendor ID + | ]GC rmlacc all by description ! ssets sorted by description  pv  all by name & rc all by customer name 0customers in one state, sorted by zip code +smedical customers by employee id/name Rtagged records Sbalance <> 0 %sorted by customer id  1name &lcustomer list for house accounts name = a mfrierson's customer list one employee's customers  ckh (all items to one vendor, sorted by date VOwithin current month, sorted by check # Luncleared checks, sorted by check # !Mdeposits, sorted by check # N on (all records sorted by organization name  r all by corporate code  emp all . .ppl all by product id  ro all by product id +linked products sorted by form number bFproducts for vendor=house sort by product id Einventoried products sorted by product id %Dproducts linked to one customer  sl 6products for customer 399240, sort by form number lGC bapapd $all invoices ordered by employee id %{line items on or after 02/10/98 paid invoices "ftransactions greater than 26 0expenses for one g/l account for one month (to account 8110050 for one quarter *march invoices for vendor id = house  h +all transactions after transaction id #341  +glglt (all a/p account transactions by account by transaction id (transactions for account=201000-00 -"posted to period 1 .cost of goods sold account for period 12 one transaction = 1984 %transactions for sales period 6  inbph all sorted by vendor id 'transactions sorted by entry date entries made on 06/15/98 vendor id all $ krfq all by customer " sosod $all invoices, invoiced before today 0of today's invoices, sorted by customer id ,hopen line items, sorted by employee id !product type/id/invoice all  h july 99's invoices summary for october  rapapd Xall line items on or after 02/10 sorted by account6records sorted by transaction id ;7invoices for checks written within a date range : 88x  lRMLARC &Balance <> 0 Sorted By Customer Name  Balance<>0 +Code ( ARC:Balance<>'')  +ARC:Code RSM Balance <> ~ ~ ~ bNON NON NON B  Customer ID +  mRMLARC Customer Name = A !Name~ A +Code  ( UPPER(LEFT(ARC:Name,1))= 'A')  +ARC:Code RSM Name ~ ~ ~ ~ bNON NON NON N A  Customer ID +  oRARAGE All By Employee ID  +Employee ID +ARC:EmployeeID  HOUSE = = = = bNON NON NON   Employee ID +  pRMLSTX All By State +State  +STX:State  +HOUSE = = = = bNON NON NON  State +  qRSOTED All Invoices In Current Month Invoice Date in Current Month +( MONTH(SOH:InvoiceDate) = MONTH(TODAY())) -HOUSE Invoice Date Current Month = = = bNON NON NON  +  sRMLARC 0All Customers In One State, Sorted By Zip Code  State= IA +Zip ( ARC:State[1:2]= 'IA')  +ARC:Zip ?PRO State = = = = bNON NON NON IA IA Zip + -%&x  'RAPCRR Cash Requirement Report Due Date<=Today AND Vendor ID~ =( APH:DueDate<= TODAY() AND UPPER(LEFT(APH:VendorID,0))= '') HOUSE Due Date  Vendor ID T< ~ ~ ~ bAND NON NON V +  (RSOECS !Paid Invoices Month Of February *Payment Date Month<=2 AND Paid In Full= Y <( MONTH(SOH:PaymentDate) <= 2 AND SOH:PaidInFull[1:1]= 'Y') HOUSE Payment Date  Paid In Full Month<= = = = bAND NON NON 2 2 0Y +  )RSOTED &Paid Invoices For Month Of July 1998 HPayment Date>= 07/01/98 AND Payment Date<= 07/31/98 AND Paid In Full= Y P( SOH:PaymentDate>='72138' AND SOH:PaymentDate<='72168' AND SOH:PaidInFull='Y') HOUSE Payment Date  Payment Date  Paid In Full >= <= =$% "GC rapapd -invoices within current month sorted by name ;9order id <line items from past due invoices sorted by vendor>open items for employee=house sorted by orderid =transaction id 1420-1711 ~ h %all records sorted by transaction id 0,invoices due in current month by vendor id E/for checks written within a date range 5reference=start99 paid after 01/01/99 )within current month sorted by name @09order id 2open invoices discountable in current month M4for employee=house sorted by orderid3sorted by vendor id & due date %1tems bye vendor id/invoice date tagged invoices by name  tcrr cash requirement report  'pcs tagged to pay, sorted by name *vendor id  vps all pos sorted by p.o. number  rage all by employee id &ocustomers, sorted by employee id sorted by customer name Kemployee id/customer id Jglfin all departments "department=111 # all # infmc 'inventoried items sorted by product id zisr %inventoried items sorted by location ^sir ,all products with product type of stock tab Yproducts for one customer sorted by form number with product type = stocktab mlacc all by account #Iy%&x  RSOECN All Invoices For One Month HInvoice Date>= 09/01/99 AND Invoice Date<= 09/30/99 AND Order Status= I  +Order ID S( SOH:InvoiceDate>=72565 AND SOH:InvoiceDate<=72594 AND SOH:OrderStatus[1:1]= 'I') +REMSOH:OrderID MRW  Invoice Date  Invoice Date  Order Status >= <= = = bAND AND NON 72 72565 ,72594 ,I  Order ID +  RAPPCS Tagged To Pay, Sorted By Name  Tagged= Y +Name+Vendor Invoice ( APH:Mark[1:1]= 'Y') +APH:Name,+APH:Invoice iMRW Tagged = = = = bNON NON NON Y Y Name -Vendor Invoice +  BSOSOH July 99's Invoices HInvoice Date>= 09/01/99 AND Invoice Date<= 09/30/99 AND Order Status= I +Employee ID Order ID S( SOH:InvoiceDate>=72565 AND SOH:InvoiceDate<=72594 AND SOH:OrderStatus[1:1]= 'I') +SOH:EmployeeID, SOH:OrderID RLB  Invoice Date  Invoice Date  Order Status >= <= = = bAND AND NON 72 72565 ,72594 ,I  Employee ID & Order ID +  RSOSOS July 99's Invoices HInvoice Date>= 07/01/99 AND Invoice Date<= 07/31/99 AND Order Status= I +Employee ID+Order ID S( SOH:InvoiceDate>=72503 AND SOH:InvoiceDate<=72533 AND SOH:OrderStatus[1:1]= 'I') +SOH:EmployeeID,+SOH:OrderID RLB  Invoice Date  Invoice Date  Order Status >= <= = = bAND AND NON 72 72503 ,72533 ,I  Employee ID & Order ID + %&x  RMLARC One Employee's Customers Employee ID= 031 %+Customer Name+Customer ID+State+Zip ( ARC:EmployeeID[1:3]= '031') .+ARC:Name,+ARC:CustomerID,+ARC:State,+ARC:Zip SCMM  Employee ID = = = = bNON NON NON 03 031 Customer Name $ Customer ID &State ,Zip +  RMLPSL GProducts For Customer 399240, Sort By Form Number Customer ID= 399240  +Form Number !( PRO:CustomerID[1:6]= '399240') +PRO:FormNumber SHOUSE Customer ID = = = = bNON NON NON 39 399240  Form Number +  RSOECN ,Invoiced Orders For One Month One Employee ]Invoice Date>= 07/01/99 AND Invoice Date<= 07/31/99 AND Order Status= I AND Employee ID= 029  +Order ID r( SOH:InvoiceDate>=72503 AND SOH:InvoiceDate<=72533 AND SOH:OrderStatus[1:1]= 'I' AND SOH:EmployeeID[1:3]= '029') +REMSOH:OrderID vHOUSE Invoice Date  Invoice Date  Order Status  Employee ID >= <= = = bAND AND AND 72 72503 ,72533 ,I 0029  Order ID +  RSOECN Paid Invoices For One Month (Rep Category 1 = POP)Payment Date>= 09/01/99 AND Payment Date<= 09/30/99 AND Paid In Full= Y AND Rep Category 1= POP +Customer ID+Order ID p( SOH:PaymentDate>=72565 AND SOH:PaymentDate<=72594 AND SOH:PaidInFull[1:1]= 'Y' AND EMP:Category1[1:3]= 'POP') #+REMSOH:CustomerID,+REMSOH:OrderID MRW  Payment Date  Payment Date  Paid In Full Rep Category 1 >= <= = = bAND AND AND 72 72565 ,72594 ,Y 0POP  Customer ID & Order ID + %&x  wRSOECS +Invoiced Order For One Month One Employee HInvoice Date>= 07/01/99 AND Invoice Date<= 07/31/99 AND EmployeeID= 035  +Order ID T( SOH:InvoiceDate>=72503 AND SOH:InvoiceDate<=72533 AND SOH:EmployeeID[1:3]= '035') +REMSOH:OrderID UMRW  Invoice Date  Invoice Date  EmployeeID >= <= = = bAND AND NON 72 72503 ,72533 ,035  Order ID +  xRSOECS Range Of Invoice Numbers  Invoice>= 30 AND Invoice<= 50 AND EmployeeIDNot Equal To ( SOH:Invoice>=30 AND SOH:Invoice<=50 AND SOH:EmployeeID<>'') +REMSOH:Invoice BMRW Invoice Invoice EmployeeID >= <=  Not Equal To = bAND AND NON 30 30 ,50 +  yRSOECS Paid Invoices For One Month (Rep Category 1 = POP)Payment Date>= 07/01/99 AND Payment Date<= 07/31/99 AND Paid In Full= Y AND Rep Category 1= POP +Customer ID+Order ID p( SOH:PaymentDate>=72503 AND SOH:PaymentDate<=72533 AND SOH:PaidInFull[1:1]= 'Y' AND EMP:Category1[1:3]= 'POP') +REMSOH:OrderID gMRW  Payment Date  Payment Date  Paid In Full Rep Category 1 >= <= = = bAND AND AND 72 72503 ,72533 ,Y 0POP  Customer ID & Order ID +  zRINFMC (Inventoried Items Sorted By Product ID Owned By= I  +Product ID ( PRO:OwnedBy[1:1]= 'I') +PRO:ProductID DHOUSE Owned By = = = = bNON NON NON I I  Product ID + 2N/~/x  JRARAGE 'All Sorted By Employee ID/Customer ID +Employee ID+Customer ID  +ARC:EmployeeID,+ARC:CustomerID  HOUSE = = = = bNON NON NON   Employee ID & Customer ID +  KRARAGE All Sorted By Customer Name +Name  +ARC:Name  HOUSE = = = = bNON NON NON  Name +  LRMLCKH sAll Items Within Current Month, Sorted By Check # Bank Account= CHECKING ACCOUN AND Payment Date in Current Month +Check Number X( CKR:BankAccount[1:15]= 'CHECKING ACCOUN' AND MONTH(CKR:PaymentDate) = MONTH(TODAY())) +CKR:CheckNumber HOUSE Bank Account  Payment Date = Current Month = = bAND NON NON CH CHECKING ACCOUN  Check Number +  MRMLCKH )All Uncleared Checks, Sorted By Check # )TaggedNot Equal To Y AND Payment Type= C +Check Number /( CKR:Mark<>'Y' AND CKR:PaymentType[1:1]= 'C') +CKR:CheckNumber HOUSE Tagged ! Payment Type  Not Equal To = = = bAND NON NON Y Y 0C  Check Number +  NRMLCKH +All Uncleared Deposits, Sorted By Check # )TaggedNot Equal To Y AND Payment Type= C +Check Number /( CKR:Mark<>'Y' AND CKR:PaymentType[1:1]= 'C') +CKR:CheckNumber HOUSE Tagged ! Payment Type  Not Equal To = = = bAND NON NON Y Y 0C  Check Number + %&x  BAPAPD ,Expenses for One G/L Account For One Month IAccount= 7615010 AND Invoice Date>= 08/01/99 AND Invoice Date<= 08/31/99 +Invoice Date U( APD:Account[1:7]= '7615010' AND APH:InvoiceDate>=72534 AND APH:InvoiceDate<=72564) +APH:InvoiceDate HOUSE Account Invoice Date  Invoice Date = >= <= = bAND AND NON 76 7615010 *72534 ,72564  Invoice Date +  RSO2XO +All Customers, Sorted By City/Customer ID +Employee ID+City+Customer ID *+SOH:EmployeeID,+ARC:City,+SOH:CustomerID CMM = = = = bNON NON NON   Employee ID &City - Customer ID +  BAPAPD -Expenses To Account 8110050 For One Quarter IAccount= 8110050 AND Invoice Date>= 07/01/99 AND Invoice Date<= 09/30/99 +Invoice Date U( APD:Account[1:7]= '8110050' AND APH:InvoiceDate>=72503 AND APH:InvoiceDate<=72594) +APH:InvoiceDate MRW Account Invoice Date  Invoice Date = >= <= = bAND AND NON 81 8110050 *72503 ,72594  Invoice Date +  RSOECN ,Paid Invoices For One Month (One Salesman) ]Payment Date>= 09/01/99 AND Payment Date<= 09/30/99 AND Paid In Full= Y AND Employee ID= 046 +Customer ID+Order ID q( SOH:PaymentDate>=72565 AND SOH:PaymentDate<=72594 AND SOH:PaidInFull[1:1]= 'Y' AND SOH:EmployeeID[1:3]= '046') #+REMSOH:CustomerID,+REMSOH:OrderID HOUSE Payment Date  Payment Date  Paid In Full  Employee ID >= <= = = bAND AND AND 72 72565 ,72594 ,Y 0046  Customer ID & Order ID + %&x  RSO2XO -Employee ID=049, Sorted By City/Customer ID Employee ID= 049 +Employee ID+City+Customer ID ( SOH:EmployeeID[1:3]= '049') *+SOH:EmployeeID,+ARC:City,+SOH:CustomerID CMM  Employee ID = = = = bNON NON NON 04 049  Employee ID &City - Customer ID +  RSOSOD 0Open Order Report (Detail) For One Employee ID %Order Status= O AND Employee ID= 023 +Employee ID+Order ID <( SOH:OrderStatus[1:1]= 'O' AND SOH:EmployeeID[1:3]= '023') +SOH:EmployeeID,+SOH:OrderID CMM  Order Status  Employee ID = = = = bAND NON NON O O 0023  Employee ID & Order ID +  RSOSOD .Open Orders With Vendor Invoice But No Price EExtended Price= 0 AND Order Status= O AND Vendor InvoiceNot Equal To +Employee ID+Order ID O( SOD:ExtendedPrice=0 AND SOH:OrderStatus[1:1]= 'O' AND SOD:VendorInvoice<>'') +SOH:EmployeeID,+SOH:OrderID HOUSE Extended Price  Order Status Vendor Invoice = =  Not Equal To = bAND AND NON 0 0 0O  Employee ID & Order ID +  RMLSHI Ship To List For One Customer Customer ID= NWSB  +Location ( ARC:CustomerID[1:4]= 'NWSB') +SHI:Location HOUSE Customer ID = = = = f NON NON NW NWSB  Location + <N/~/x  ?RSOSOS COpen Orders Sorted By Est. Ship Date/Customer ID Order Status= O +Ship Date+Customer ID ( SOH:OrderStatus[1:1]= 'O') +SOH:ShipDate,+SOH:CustomerID HOUSE Order Status = = = = bNON NON NON O O  Ship Date ( Customer ID +  @RSOSOS GOpen Orders Past Est. Ship Date By Cust. ID/Order Order Status= O AND  +Customer ID !( SOH:OrderStatus[1:1]= 'O' AND) +SOH:CustomerID HOUSE Order Status  Ship Date = <=Today's Date = = bAND NON O O  Customer ID +  ARSOSOS $Open Invoices Within Current Month Payment Status= O AND AND +Customer ID+Invoice '( SOH:PaymentStatus[1:1]= 'O' AND AND) +SOH:CustomerID,+SOH:Invoice HOUSE Payment Status  Invoice Date  Invoice Date = Current Month  Current Year = bAND AND NON O O  Customer ID &Invoice +  BRSOSOS KAll Invoices Within Current Month Sort By Invoice Order Status= I AND AND  +Invoice %( SOH:OrderStatus[1:1]= 'I' AND AND)  +SOH:Invoice HOUSE Order Status  Invoice Date  Invoice Date = Current Month  Current Year = bAND AND NON I I Invoice +  CRSOSOS rAll Orders Booked In Current Month By Customer ID Order Date in Current Month AND AND Order StatusNot Equal To Q +Customer ID+Order ID F( MONTH(SOH:OrderDate) = MONTH(TODAY()) AND AND SOH:OrderStatus<>'Q') +SOH:CustomerID,+SOH:OrderID HOUSE Order Date  Order Date  Order Status Current Month  Current Year  Not Equal To = bAND AND  vQ  Customer ID & Order ID +