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

Text File | 1996-03-06 | 21KB | 654 lines

VERSION 2.00
Begin Report INVSOR02.REP
      Caption      =   "INVSOR02.REP"
      Width        =   11175
      Height       =   16395
      Reportheader =   0
      Header       =   6375
      Transaction  =   6330
      SubTotal     =   3360
      Footer       =   0
      Pagefooter   =   16080
      Replicate    =   375
      Style        =   13
      Query        =   "STTRND "
      Macro        =   "1LU:Select from SLNAME where SLNAME.SNACCOUNT=STTRND.CDACCID"
      Macro        =   "1LU:Select from STTRNH where STTRNH.CHTRANNO=STTRND.CDTRANNO"
      Macro        =   "1OF:@REPVARS.REPTOT(0) = REPTOT(0)+1"
      Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
      BreakOn      =   "STTRND.CDTRANNO"
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Quantity""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   5670
      Top          =   5850
      Width        =   870
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Description""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   2655
      Top          =   5850
      Width        =   1140
End
Begin Control SNNAME
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "SNNAME"
      Filename     =   "SLNAME"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   2280
      Width        =   3645
End
Begin Control SNADD1
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "SNADD1"
      Filename     =   "SLNAME"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   2535
      Width        =   3645
End
Begin Control SNADD2
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "SNADD2"
      Filename     =   "SLNAME"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   2790
      Width        =   3645
End
Begin Control SNADD3
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "SNADD3"
      Filename     =   "SLNAME"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   3030
      Width        =   3645
End
Begin Control SNADD4
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "SNADD4"
      Filename     =   "SLNAME"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   3285
      Width        =   3645
End
Begin Control SNPOSTCODE
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "SNPOSTCODE"
      Filename     =   "SLNAME"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   3540
      Width        =   3645
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Price""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   6915
      Top          =   5850
      Width        =   600
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Product ID""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   360
      Top          =   5850
      Width        =   1275
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Invoice To:""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   2040
      Width        =   2025
End
Begin Control CHDEL1
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHDEL1"
      Filename     =   "STTRNH"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   6615
      Top          =   2280
      Width        =   3645
End
Begin Control CHDEL2
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHDEL2"
      Filename     =   "STTRNH"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   6615
      Top          =   2535
      Width        =   3645
End
Begin Control CHDEL3
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHDEL3"
      Filename     =   "STTRNH"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   6615
      Top          =   2790
      Width        =   3645
End
Begin Control CHDEL4
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHDEL4"
      Filename     =   "STTRNH"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   6615
      Top          =   3030
      Width        =   3645
End
Begin Control CHDEL5
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHDEL5"
      Filename     =   "STTRNH"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   6615
      Top          =   3285
      Width        =   3645
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Deliver To:""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   6615
      Top          =   2040
      Width        =   2025
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Despatched By""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   5535
      Top          =   4545
      Width        =   1215
End
Begin Control CHDESPBY
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHDESPBY"
      Filename     =   "STTRNH"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   6750
      Top          =   4545
      Width        =   1890
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Customer ID""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   5010
      Width        =   2025
End
Begin Control CHACCID
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHACCID"
      Filename     =   "STTRNH"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   2835
      Top          =   5010
      Width        =   1890
End
Begin Control COMPADD1
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "COMPADD1"
      Filename     =   "SYSTEM"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   540
      Width        =   3375
End
Begin Control COMPADD2
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "COMPADD2"
      Filename     =   "SYSTEM"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   810
      Width        =   3375
End
Begin Control COMPADD3
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "COMPADD3"
      Filename     =   "SYSTEM"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   1080
      Width        =   3375
End
Begin Control COMPADD4
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "COMPADD4"
      Filename     =   "SYSTEM"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   1350
      Width        =   3375
End
Begin Control COMPTEL
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "COMPTEL"
      Filename     =   "SYSTEM"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   5265
      Top          =   810
      Width        =   2160
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   1
      Caption      =   "Telephone No."
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   4185
      Top          =   810
      Width        =   1080
End
Begin Control COMPFAX
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "COMPFAX"
      Filename     =   "SYSTEM"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   5265
      Top          =   1080
      Width        =   2160
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Value""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   285
      Left         =   9885
      Top          =   5850
      Width        =   600
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   12
      Caption      =   ""Order Acknowledgement""
      Font         =   "-240|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   7560
      Top          =   360
      Width        =   3375
End
Begin Control CHDOCNO
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHDOCNO"
      Filename     =   "STTRNH"
      Font         =   "-240|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   8370
      Top          =   630
      Width        =   2160
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   1
      Caption      =   "Facsimile No."
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   4185
      Top          =   1080
      Width        =   1080
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "IF(TRIM(REPSTR(9))<>"P" & TRIM(SYSTEM.VATREG)<>"","VAT Reg. No.","")"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   4185
      Top          =   1350
      Width        =   1140
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Customer VAT Reg. No.""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   4545
      Width        =   2025
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   ""Date : ""
      Font         =   "-195|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   7950
      Top          =   900
      Width        =   945
End
Begin Control CHTXNDATE
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHTXNDATE"
      Filename     =   "STTRNH"
      Font         =   "-195|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   8910
      Top          =   900
      Width        =   1620
End
Begin Control COMPNAME
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "COMPNAME"
      Filename     =   "SYSTEM"
      Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   810
      Top          =   270
      Width        =   4995
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Page No. "+STR(REPTOT(0),3,0)"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   8700
      Top          =   5010
      Width        =   1395
End
Begin Control SNVATREGNO
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "SNVATREGNO"
      Filename     =   "SLNAME"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   3240
      Top          =   4545
      Width        =   2160
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "IF(TRIM(REPSTR(9))<>"P" & TRIM(SYSTEM.VATREG)<>"",SYSTEM.COUNTRY,"")"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   5265
      Top          =   1350
      Width        =   270
End
Begin Control VATREG
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "VATREG"
      Filename     =   "SYSTEM"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   5535
      Top          =   1350
      Width        =   2025
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "IF(SLNAME.SNVATREGNO="" | SLNAME.SNCOUNTRY="XN","",SLNAME.SNCOUNTRY)"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   2835
      Top          =   4545
      Width        =   405
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Customer Ref.""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   8700
      Top          =   4545
      Width        =   1080
End
Begin Control CHREF
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHREF"
      Filename     =   "STTRNH"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Header Block"
      Height       =   270
      Left         =   9840
      Top          =   4545
      Width        =   1620
End
Begin Control CDDESC
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CDDESC"
      Filename     =   "STTRND"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   270
      Left         =   2385
      Top          =   90
      Width        =   3300
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "if(STTRND.CDPRODTYPE="0","",STTRND.CDPRODID)"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   285
      Left         =   285
      Top          =   90
      Width        =   2070
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   "if(STTRND.CDPRICE=0,"",STR(STTRND.CDPRICE,10,2))"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   285
      Left         =   6495
      Top          =   90
      Width        =   990
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   "if(STTRND.CDQUANTITY=0,"",STR(STTRND.CDQUANTITY,10,2))"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   285
      Left         =   5550
      Top          =   90
      Width        =   855
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   "if(STTRND.CDGOODSVAL=0,"",STR(STTRND.CDGOODSVAL,10,2))"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Transaction Block"
      Height       =   285
      Left         =   9465
      Top          =   90
      Width        =   990
End
Begin Control CHTOTGOODS
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHTOTGOODS"
      Filename     =   "STTRNH"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Subtotal Block"
      Height       =   270
      Left         =   9465
      Top          =   1335
      Width        =   990
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   ""Total Goods""
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Subtotal Block"
      Height       =   285
      Left         =   7560
      Top          =   1335
      Width        =   1275
End
Begin Control CHNARR
      Type         =   "Text"
      Style        =   0
      Fieldname    =   "CHNARR"
      Filename     =   "STTRNH"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Subtotal Block"
      Height       =   945
      Left         =   270
      Top          =   2265
      Width        =   6540
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "if(STTRNH.CHOVRDISC=0,"","Less : Overall Discount")"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Subtotal Block"
      Height       =   285
      Left         =   7560
      Top          =   1875
      Width        =   1950
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   10
      Caption      =   "if(STTRNH.CHOVRDISC=0,"",STR(STTRNH.CHOVRDISC,10,2))"
      Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Subtotal Block"
      Height       =   270
      Left         =   9465
      Top          =   1875
      Width        =   990
End
Begin Control LABEL
      Type         =   "Label"
      Style        =   9
      Caption      =   "IF(TRIM(REPSTR(9))<>"P" & TRIM(SYSTEM.VATREG)<>"",">> ORDER SUBJECT TO VAT AT CURRENT RATE(S) <<","")"
      Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
      Location     =   "Subtotal Block"
      Height       =   285
      Left         =   270
      Top          =   930
      Width        =   4920
End