Computer Buyer 1999 March/Dpcb0399.iso/MONEY/Capital/SETUP.2/REPORTS/STREOSUP.REP

Text File | 1996-07-10 | 10KB | 324 lines

VERSION 2.00
Begin Report STREOSUP.REP
      Caption      =   "STREOSUP.REP"
      Width        =   11475
      Height       =   16185
      Reportheader =   1200
      Header       =   1335
      Transaction  =   9615
      SubTotal     =   135
      Footer       =   0
      Pagefooter   =   15960
      Replicate    =   420
      Style        =   8
      Query        =   "STNAME CNSUPPID=>^@0 & CNSUPPID<=^@1 & CNPRODTYPE="2"&((CNQTYINST+CNQTYONORD-CNQTYALLOC)<CNREOLEVEL)&CNREOQTY<>0 ORDER BY CNSUPPID+CNPRODID"
      Macro        =   "1LU:Select from PLNAME where PNCODE=STNAME.CNSUPPID"
      BreakOn      =   "STNAME.CNSUPPID"
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   12
      Caption      =   "TRIM(SYSTEM.COMPNAME)"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Reportheader Block"
      Height       =   270
      Left         =   -15
      Top          =   405
      Width        =   11070
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Stock Re-Order by Supplier"
      Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Reportheader Block"
      Height       =   420
      Left         =   135
      Top          =   675
      Width        =   11025
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "DTOC(DATE())"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Reportheader Block"
      Height       =   285
      Left         =   135
      Top          =   705
      Width        =   1800
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   ""Page: "+PAGENUM()"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Reportheader Block"
      Height       =   285
      Left         =   9585
      Top          =   720
      Width        =   1395
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   1
      Caption      =   "Product ID"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   30
      Top          =   945
      Width        =   945
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   1
      Caption      =   "Description"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   2265
      Top          =   945
      Width        =   1245
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Quantity"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   4380
      Top          =   945
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "In Stock"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   4380
      Top          =   1215
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Quantity"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   5190
      Top          =   945
      Width        =   915
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Allocated"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   5190
      Top          =   1215
      Width        =   915
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "On"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   6270
      Top          =   945
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Order"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   6270
      Top          =   1215
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   2
      Caption      =   "Re-Order"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   7080
      Top          =   945
      Width        =   780
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   ""Quantity ""
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   6945
      Top          =   1215
      Width        =   915
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   4
      Caption      =   "Unit"
      Font         =   "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   7890
      Top          =   945
      Width        =   510
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   1
      Caption      =   "Supplier ID:"
      Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   30
      Top          =   555
      Width        =   1080
End
Begin Control CNSUPPID
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNSUPPID"
      Filename     =   "STNAME"
      Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   1080
      Top          =   540
      Width        =   1365
End
Begin Control PNNAME
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "PNNAME"
      Filename     =   "PLNAME"
      Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   2520
      Top          =   540
      Width        =   5415
End
Begin Control CNPRODID
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNPRODID"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   30
      Top          =   150
      Width        =   1635
End
Begin Control CNDESC
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNDESC"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   1830
      Top          =   150
      Width        =   2355
End
Begin Control CNQTYINST
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNQTYINST"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   4170
      Top          =   150
      Width        =   870
End
Begin Control CNQTYALLOC
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNQTYALLOC"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   5115
      Top          =   150
      Width        =   870
End
Begin Control CNQTYONORD
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNQTYONORD"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   6060
      Top          =   150
      Width        =   870
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)<0),"Free Stock Exceeded",IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)=0),"Down to Zero Free Stock",IF(((STNAME.CNQTYINST-STNAME.CNQTYALLOC)<STNAME.CNMINSTOCK),"Down to Min. Stock","")))"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   8505
      Top          =   150
      Width        =   1485
End
Begin Control CNREOQTY
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNREOQTY"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   7005
      Top          =   150
      Width        =   870
End
Begin Control CNUNITDESC
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CNUNITDESC"
      Filename     =   "STNAME"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   7950
      Top          =   150
      Width        =   600
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "IF((STNAME.CNQTYINST+STNAME.CNREOQTY+STNAME.CNQTYONORD-STNAME.CNQTYALLOC)<STNAME.CNREOLEVEL,"<<Below Re-Ord>>","")"
      Font         =   "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   9990
      Top          =   150
      Width        =   1215
End