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