home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Computer Buyer 1999 March
/
Dpcb0399.iso
/
MONEY
/
Capital
/
SETUP.2
/
REPORTS
/
STPRDENQ.REP
< prev
next >
Wrap
Text File
|
1997-10-28
|
24KB
|
703 lines
VERSION 2.00
Begin Report STPRDENQ.REP
Caption = "STPRDENQ.REP"
Width = 11460
Height = 16185
Reportheader = 1200
Header = 3795
Transaction = 6975
SubTotal = 270
Footer = 0
Pagefooter = 15960
Replicate = 405
Style = 1
Query = "STTRND CDPRODID>=^@0 & CDPRODID<=^@1 ORDER BY CDPRODID+CDTYPE"
Macro = "1LU:Select from STNAME where CNPRODID=STTRND.CDPRODID"
Macro = "2LU:Select from STTRNH where CHTRANNO=STTRND.CDTRANNO"
BreakOn = "STTRND.CDPRODID"
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 = "Product Enquiry"
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 = 165
Top = 270
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 = 2400
Top = 270
Width = 1110
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Reference"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 2415
Top = 3360
Width = 990
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Qty"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 3795
Top = 3375
Width = 510
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Type"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 120
Top = 3375
Width = 600
End
Begin Control LABEL
Type = "Label"
Style = 1
Caption = "Date"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 1200
Top = 3375
Width = 585
End
Begin Control LABEL
Type = "Label"
Style = 2
Caption = "Qty Bal"
Font = "-135|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 285
Left = 4740
Top = 3375
Width = 645
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 = "Header Block"
Height = 270
Left = 135
Top = 555
Width = 1770
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 = "Header Block"
Height = 270
Left = 2430
Top = 555
Width = 3390
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="0","Description Only",IF(STNAME.CNPRODTYPE="1","Product Only","Full Stock Product"))"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2415
Top = 825
Width = 1485
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","Group ID:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 120
Top = 1620
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","Unit Desc.:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 120
Top = 1890
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","VAT Code:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 120
Top = 2160
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","Disc. 1:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2415
Top = 1620
Width = 540
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","Disc. 2:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2415
Top = 1890
Width = 540
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","Disc. 3:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2415
Top = 2160
Width = 540
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNANALHEAD,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1470
Top = 1620
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNUNITDESC,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1470
Top = 1890
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNVATCODE,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1470
Top = 2160
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE1,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4035
Top = 1620
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE2,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4035
Top = 1890
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0",STNAME.CNDISCODE3,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4035
Top = 2160
Width = 270
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC1<>0,STR(STNAME.CNDISC1,5,2)+"%","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4575
Top = 1620
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC2<>0,STR(STNAME.CNDISC2,5,2)+"%","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4575
Top = 1890
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNDISC3<>0,STR(STNAME.CNDISC3,5,2)+"%","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4575
Top = 2160
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","Min. Stock:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5655
Top = 1620
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","Selling Price:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 2415
Top = 2430
Width = 1080
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0",STR(STNAME.CNSELPRICE,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 4575
Top = 2430
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNMINSTOCK,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7005
Top = 1620
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","Re-Ord Level:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5655
Top = 1350
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOLEVEL,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7005
Top = 1350
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","In Stock:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5655
Top = 1890
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNQTYINST,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7005
Top = 1890
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","Cost Price:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5655
Top = 2430
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNCOSPRICE,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7005
Top = 2430
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","Supplier ID:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5655
Top = 1080
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STNAME.CNSUPPID,"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7005
Top = 1080
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","Last Issued:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 5640
Top = 810
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0"&STNAME.CNLASTISS<>NULLDATE,DTOC(STNAME.CNLASTISS),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 7005
Top = 810
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","Location:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8085
Top = 810
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STNAME.CNLOC),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 9570
Top = 810
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","Part No.:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8085
Top = 1080
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STNAME.CNSPARTNO),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 9165
Top = 1080
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","Re-Ord Qty:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8085
Top = 1350
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNREOQTY,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 9570
Top = 1350
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE="2","Average Cost:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 8085
Top = 2430
Width = 945
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE="2",STR(STNAME.CNAVGCOS,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 9570
Top = 2430
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STNAME.CNPRODTYPE<>"0","VAT Inclusive:","")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 135
Top = 2445
Width = 1215
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STNAME.CNPRODTYPE<>"0",STR(STNAME.CNVATPRICE,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Header Block"
Height = 270
Left = 1485
Top = 2445
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STTRND.CDTYPE="3","Cost =",IF((STTRND.CDTYPE="4"|STTRND.CDTYPE="5")&STTRND.CDPRODTYPE="2","Profit =",IF(STTRND.CDTYPE="0"|STTRND.CDTYPE="9","Completed ",IF(STTRND.CDTYPE="1"|STTRND.CDTYPE="B"|STTRND.CDTYPE="E"|STTRND.CDTYPE="F","Due "+IF(STTRNH.CHDUEDEL<>NULLDATE,DTOC(STTRNH.CHDUEDEL),""),""))))"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 5655
Top = 120
Width = 1620
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "IF(STTRND.CDTYPE="3",LTRIM(STR(STTRND.CDPRICE,10,2)),IF((STTRND.CDTYPE="4"|STTRND.CDTYPE="5")&STTRND.CDPRODTYPE="2",LTRIM(STR(STTRND.CDPROFIT,10,2)),IF(STTRND.CDTYPE="0"|STTRND.CDTYPE="1","From "+STTRND.CDACCID,IF(STTRND.CDTYPE="9"|STTRND.CDTYPE="B"|STTRND.CDTYPE="E"|STTRND.CDTYPE="F","To "+STTRND.CDACCID,""))))"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 8160
Top = 135
Width = 1290
End
Begin Control CDDOCNO
Type = "Text"
Style = 0
Fieldname = "CDDOCNO"
Filename = "STTRND"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 2415
Top = 120
Width = 1140
End
Begin Control LABEL
Type = "Label"
Style = 9
Caption = "MID(" ReceiptIssue Adjust Return CmPO POrd CmSO SOrd Prof Quot ",(INSTR("3485019BEF",STTRND.CDTYPE)*7)+1,7)"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 120
Top = 120
Width = 675
End
Begin Control CDTXNDATE
Type = "Text"
Style = 0
Fieldname = "CDTXNDATE"
Filename = "STTRND"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 1215
Top = 120
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF((STTRND.CDTYPE="1"|STTRND.CDTYPE="B")&STTRND.CDQTYBAL<>0,STR(STTRND.CDQTYBAL,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 4545
Top = 135
Width = 870
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "IF(STTRND.CDQUANTITY<>0,STR(STTRND.CDQUANTITY,10,2),"")"
Font = "-135|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
Location = "Transaction Block"
Height = 270
Left = 3495
Top = 135
Width = 810
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "" ""
Location = "Transaction Block"
Height = 270
Left = 9720
Top = 135
Width = 675
End
Begin Control LABEL
Type = "Label"
Style = 10
Caption = "" ""
Location = "Transaction Block"
Height = 270
Left = 7425
Top = 135
Width = 405
End