home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1995 September / Image.iso / working / pegasus / setup.2 / REPORTS / VATPLUN.REP < prev    next >
Encoding:
Text File  |  1995-06-21  |  9.6 KB  |  307 lines
  1. VERSION 2.00
  2. Begin Report VATPLUN.REP
  3.       Caption      =   "VATPLUN.REP"
  4.       Width        =   11175
  5.       Height       =   15825
  6.       Reportheader =   975
  7.       Header       =   570
  8.       Transaction  =   13290
  9.       SubTotal     =   15
  10.       Footer       =   690
  11.       Pagefooter   =   15720
  12.       Replicate    =   330
  13.       Style        =   0
  14.       Query        =   "PLTRAN PTTXNTYPE="P" & PTALLOC=" "  ORDER BY PTCODE"
  15.       Macro        =   "2LU:Select from PLNAME where PNCODE=PLTRAN.PTCODE"
  16.       Macro        =   "2OF:@REPVARS.REPTOT(0) = PLTRAN.PTVALUE-PLTRAN.PTVAT"
  17.       Macro        =   "2OF:@REPVARS.REPTOT(1) = REPTOT(1)+PLTRAN.PTVALUE"
  18.       Macro        =   "2OF:@REPVARS.REPTOT(2) = REPTOT(2)+REPTOT(0)"
  19.       Macro        =   "2OF:@REPVARS.REPTOT(3) = REPTOT(3)+PLTRAN.PTVAT"
  20.       Macro        =   "4PP:@REPVARS.REPTOT(0) = 0"
  21.       Macro        =   "4PP:@REPVARS.REPTOT(1) = 0"
  22.       Macro        =   "4PP:@REPVARS.REPTOT(2) = 0"
  23.       Macro        =   "4PP:@REPVARS.REPTOT(3) = 0"
  24. End
  25. Begin Control LABEL
  26.       Type         =   "Label"
  27.       Style        =   4
  28.       Caption      =   "Purchase Unallocated Payments"
  29.       Font         =   "-285|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  30.       Location     =   "Reportheader Block"
  31.       Height       =   420
  32.       Left         =   0
  33.       Top          =   675
  34.       Width        =   11025
  35. End
  36. Begin Control LABEL
  37.       Type         =   "Label"
  38.       Style        =   9
  39.       Caption      =   "DTOC(DATE())"
  40.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  41.       Location     =   "Reportheader Block"
  42.       Height       =   285
  43.       Left         =   135
  44.       Top          =   705
  45.       Width        =   2880
  46. End
  47. Begin Control LABEL
  48.       Type         =   "Label"
  49.       Style        =   10
  50.       Caption      =   "PAGENUM()"
  51.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  52.       Location     =   "Reportheader Block"
  53.       Height       =   285
  54.       Left         =   10395
  55.       Top          =   720
  56.       Width        =   585
  57. End
  58. Begin Control LABEL
  59.       Type         =   "Label"
  60.       Style        =   2
  61.       Caption      =   "Page:"
  62.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  63.       Location     =   "Reportheader Block"
  64.       Height       =   285
  65.       Left         =   9720
  66.       Top          =   720
  67.       Width        =   585
  68. End
  69. Begin Control LABEL
  70.       Type         =   "Label"
  71.       Style        =   12
  72.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  73.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  74.       Location     =   "Reportheader Block"
  75.       Height       =   270
  76.       Left         =   -15
  77.       Top          =   405
  78.       Width        =   11070
  79. End
  80. Begin Control LABEL
  81.       Type         =   "Label"
  82.       Style        =   1
  83.       Caption      =   "Supplier ID"
  84.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  85.       Location     =   "Header Block"
  86.       Height       =   285
  87.       Left         =   135
  88.       Top          =   240
  89.       Width        =   1005
  90. End
  91. Begin Control LABEL
  92.       Type         =   "Label"
  93.       Style        =   4
  94.       Caption      =   "Date"
  95.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  96.       Location     =   "Header Block"
  97.       Height       =   285
  98.       Left         =   1290
  99.       Top          =   240
  100.       Width        =   870
  101. End
  102. Begin Control LABEL
  103.       Type         =   "Label"
  104.       Style        =   1
  105.       Caption      =   "Reference"
  106.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  107.       Location     =   "Header Block"
  108.       Height       =   285
  109.       Left         =   2610
  110.       Top          =   240
  111.       Width        =   1005
  112. End
  113. Begin Control LABEL
  114.       Type         =   "Label"
  115.       Style        =   2
  116.       Caption      =   "Value"
  117.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  118.       Location     =   "Header Block"
  119.       Height       =   285
  120.       Left         =   3900
  121.       Top          =   240
  122.       Width        =   1005
  123. End
  124. Begin Control LABEL
  125.       Type         =   "Label"
  126.       Style        =   1
  127.       Caption      =   "Supplier Name"
  128.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  129.       Location     =   "Header Block"
  130.       Height       =   285
  131.       Left         =   8760
  132.       Top          =   240
  133.       Width        =   1410
  134. End
  135. Begin Control LABEL
  136.       Type         =   "Label"
  137.       Style        =   2
  138.       Caption      =   "Goods"
  139.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  140.       Location     =   "Header Block"
  141.       Height       =   285
  142.       Left         =   5115
  143.       Top          =   240
  144.       Width        =   1140
  145. End
  146. Begin Control LABEL
  147.       Type         =   "Label"
  148.       Style        =   2
  149.       Caption      =   "VAT"
  150.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  151.       Location     =   "Header Block"
  152.       Height       =   285
  153.       Left         =   6330
  154.       Top          =   240
  155.       Width        =   1005
  156. End
  157. Begin Control LABEL
  158.       Type         =   "Label"
  159.       Style        =   4
  160.       Caption      =   "VAT Code"
  161.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  162.       Location     =   "Header Block"
  163.       Height       =   285
  164.       Left         =   7545
  165.       Top          =   240
  166.       Width        =   870
  167. End
  168. Begin Control PTCODE
  169.       Type         =   "Text"
  170.       Style        =   0
  171.       Fieldname    =   "PTCODE"
  172.       Filename     =   "PLTRAN"
  173.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  174.       Location     =   "Transaction Block"
  175.       Height       =   270
  176.       Left         =   135
  177.       Top          =   60
  178.       Width        =   1005
  179. End
  180. Begin Control PTTXNDATE
  181.       Type         =   "Text"
  182.       Style        =   0
  183.       Fieldname    =   "PTTXNDATE"
  184.       Filename     =   "PLTRAN"
  185.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  186.       Location     =   "Transaction Block"
  187.       Height       =   270
  188.       Left         =   1290
  189.       Top          =   60
  190.       Width        =   1140
  191. End
  192. Begin Control PTREF
  193.       Type         =   "Text"
  194.       Style        =   0
  195.       Fieldname    =   "PTREF"
  196.       Filename     =   "PLTRAN"
  197.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  198.       Location     =   "Transaction Block"
  199.       Height       =   270
  200.       Left         =   2610
  201.       Top          =   60
  202.       Width        =   1140
  203. End
  204. Begin Control PNNAME
  205.       Type         =   "Text"
  206.       Style        =   0
  207.       Fieldname    =   "PNNAME"
  208.       Filename     =   "PLNAME"
  209.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  210.       Location     =   "Transaction Block"
  211.       Height       =   270
  212.       Left         =   8775
  213.       Top          =   60
  214.       Width        =   2805
  215. End
  216. Begin Control LABEL
  217.       Type         =   "Label"
  218.       Style        =   10
  219.       Caption      =   "STR(REPTOT(0),10,2)"
  220.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  221.       Location     =   "Transaction Block"
  222.       Height       =   255
  223.       Left         =   5145
  224.       Top          =   75
  225.       Width        =   1035
  226. End
  227. Begin Control PTVALUE
  228.       Type         =   "Text"
  229.       Style        =   0
  230.       Fieldname    =   "PTVALUE"
  231.       Filename     =   "PLTRAN"
  232.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  233.       Location     =   "Transaction Block"
  234.       Height       =   255
  235.       Left         =   3870
  236.       Top          =   60
  237.       Width        =   1065
  238. End
  239. Begin Control PTVAT
  240.       Type         =   "Text"
  241.       Style        =   0
  242.       Fieldname    =   "PTVAT"
  243.       Filename     =   "PLTRAN"
  244.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  245.       Location     =   "Transaction Block"
  246.       Height       =   255
  247.       Left         =   6300
  248.       Top          =   60
  249.       Width        =   1065
  250. End
  251. Begin Control PTVATCODE
  252.       Type         =   "Text"
  253.       Style        =   0
  254.       Fieldname    =   "PTVATCODE"
  255.       Filename     =   "PLTRAN"
  256.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  257.       Location     =   "Transaction Block"
  258.       Height       =   255
  259.       Left         =   7785
  260.       Top          =   60
  261.       Width        =   390
  262. End
  263. Begin Control LABEL
  264.       Type         =   "Label"
  265.       Style        =   4
  266.       Caption      =   "Total"
  267.       Font         =   "-180|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  268.       Location     =   "Footer Block"
  269.       Height       =   285
  270.       Left         =   2565
  271.       Top          =   405
  272.       Width        =   870
  273. End
  274. Begin Control LABEL
  275.       Type         =   "Label"
  276.       Style        =   10
  277.       Caption      =   "STR(REPTOT(1),10,2)"
  278.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  279.       Location     =   "Footer Block"
  280.       Height       =   255
  281.       Left         =   3765
  282.       Top          =   390
  283.       Width        =   1170
  284. End
  285. Begin Control LABEL
  286.       Type         =   "Label"
  287.       Style        =   10
  288.       Caption      =   "STR(REPTOT(2),10,2)"
  289.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  290.       Location     =   "Footer Block"
  291.       Height       =   255
  292.       Left         =   4995
  293.       Top          =   405
  294.       Width        =   1170
  295. End
  296. Begin Control LABEL
  297.       Type         =   "Label"
  298.       Style        =   10
  299.       Caption      =   "STR(REPTOT(3),10,2)"
  300.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  301.       Location     =   "Footer Block"
  302.       Height       =   255
  303.       Left         =   6195
  304.       Top          =   405
  305.       Width        =   1170
  306. End
  307.