home *** CD-ROM | disk | FTP | other *** search
/ Piper's Pit BBS/FTP: ibm 0010 - 0019 / ibm0010-0019 / ibm0010.tar / ibm0010 / MSWBASE4.ZIP / INVENTRY / PRODMOVC.SBQ < prev    next >
Encoding:
Text File  |  1989-09-01  |  471 b   |  12 lines
  1. SB
  2. PRODUCT
  3. STMOVMNT
  4. STTYPE
  5.  
  6. DP
  7. Product Movement Report
  8. FIELD ON "PRODUCT"Product_Code.PRODUCT,Description.PRODUCT ON "STMOVMNT"@5Movement_Date.STMOVMNT,Movement_Type.STMOVMNT,Description.STTYPE,@45Movement_Qty.STMOVMNT,Movement_Value.STMOVMNT,Movement_Ref.STMOVMNT
  9. GROUP Movement_Type.STMOVMNT COUNT 
  10. Product_Code.PRODUCT = Stock_Code.STMOVMNT AND Movement_Type.STMOVMNT = Movement_Type.STTYPE
  11. Movement_Type.STMOVMNT,Movement_Date.STMOVMNT,Stock_Code.STMOVMNT
  12.