home *** CD-ROM | disk | FTP | other *** search
/ Computer Buyer 1999 March / Dpcb0399.iso / MONEY / Capital / SETUP.2 / REPORTS / PLACCENQ.REP < prev    next >
Text File  |  1995-12-11  |  19KB  |  580 lines
  1. VERSION 2.00
  2. Begin Report PLACCENQ.REP
  3.       Caption      =   "PLACCENQ.REP"
  4.       Width        =   11175
  5.       Height       =   16395
  6.       Reportheader =   945
  7.       Header       =   2490
  8.       Transaction  =   1605
  9.       SubTotal     =   3150
  10.       Footer       =   0
  11.       Pagefooter   =   15690
  12.       Replicate    =   360
  13.       Style        =   1
  14.       Query        =   "PLTRAN PTCODE=>^@0 & PTCODE<=^@1 ORDER BY PTCODE"
  15.       Macro        =   "1LU:Select from PLNAME where PLNAME.PNCODE=PLTRAN.PTCODE"
  16.       Macro        =   "1OF:@REPVARS.REPTOT(0) = 0"
  17.       Macro        =   "1OF:@REPVARS.REPTOT(1) = 0"
  18.       Macro        =   "1OF:@REPVARS.REPTOT(2) = 0"
  19.       Macro        =   "1OF:@REPVARS.REPTOT(3) = 0"
  20.       Macro        =   "1OF:@REPVARS.REPTOT(4) = 0"
  21.       Macro        =   "2OF:@REPVARS.REPTOT(0) = @REPVARS.REPTOT(0)+PLTRAN.PTOUTSTAND"
  22.       Macro        =   "2OF:@REPVARS.REPTOT(1) = PERIOD(DATE(),PLTRAN.PTTXNDATE)"
  23.       Macro        =   "2CD:When PLTRAN.PTTXNTYPE="P" & PLTRAN.PTALLOC=" " then REPTOT(1)=-1"
  24.       Macro        =   "2CD:When REPTOT(1)=-1 then REPTOT(6)=REPTOT(6)+PLTRAN.PTOUTSTAND"
  25.       Macro        =   "2CD:When REPTOT(1)=0 then REPTOT(2)=REPTOT(2)+PLTRAN.PTOUTSTAND"
  26.       Macro        =   "2CD:When REPTOT(1)=1 then REPTOT(3)=REPTOT(3)+PLTRAN.PTOUTSTAND"
  27.       Macro        =   "2CD:When REPTOT(1)=2 then REPTOT(4)=REPTOT(4)+PLTRAN.PTOUTSTAND"
  28.       Macro        =   "2CD:When REPTOT(1)=3 then REPTOT(5)=REPTOT(5)+PLTRAN.PTOUTSTAND"
  29.       Macro        =   "3PP:@REPVARS.REPTOT(0) = 0"
  30.       Macro        =   "3PP:@REPVARS.REPTOT(1) = 0"
  31.       Macro        =   "3PP:@REPVARS.REPTOT(2) = 0"
  32.       Macro        =   "3PP:@REPVARS.REPTOT(3) = 0"
  33.       Macro        =   "3PP:@REPVARS.REPTOT(4) = 0"
  34.       Macro        =   "3PP:@REPVARS.REPTOT(5) = 0"
  35.       Macro        =   "3PP:@REPVARS.REPTOT(6) = 0"
  36.       BreakOn      =   "PLTRAN.PTCODE"
  37. End
  38. Begin Control LABEL
  39.       Type         =   "Label"
  40.       Style        =   4
  41.       Caption      =   "Supplier Account Enquiry"
  42.       Font         =   "-315|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  43.       Location     =   "Reportheader Block"
  44.       Height       =   420
  45.       Left         =   135
  46.       Top          =   540
  47.       Width        =   10890
  48. End
  49. Begin Control LABEL
  50.       Type         =   "Label"
  51.       Style        =   9
  52.       Caption      =   "DTOC(DATE())"
  53.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  54.       Location     =   "Reportheader Block"
  55.       Height       =   285
  56.       Left         =   135
  57.       Top          =   720
  58.       Width        =   1800
  59. End
  60. Begin Control LABEL
  61.       Type         =   "Label"
  62.       Style        =   10
  63.       Caption      =   ""Page "+PAGENUM()"
  64.       Font         =   "-165|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  65.       Location     =   "Reportheader Block"
  66.       Height       =   285
  67.       Left         =   9210
  68.       Top          =   705
  69.       Width        =   1800
  70. End
  71. Begin Control LABEL
  72.       Type         =   "Label"
  73.       Style        =   12
  74.       Caption      =   "TRIM(SYSTEM.COMPNAME)"
  75.       Font         =   "-195|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  76.       Location     =   "Reportheader Block"
  77.       Height       =   420
  78.       Left         =   135
  79.       Top          =   135
  80.       Width        =   10890
  81. End
  82. Begin Control LABEL
  83.       Type         =   "Label"
  84.       Style        =   1
  85.       Caption      =   "Date"
  86.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  87.       Location     =   "Header Block"
  88.       Height       =   285
  89.       Left         =   270
  90.       Top          =   2160
  91.       Width        =   1140
  92. End
  93. Begin Control LABEL
  94.       Type         =   "Label"
  95.       Style        =   1
  96.       Caption      =   "Reference"
  97.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  98.       Location     =   "Header Block"
  99.       Height       =   285
  100.       Left         =   3060
  101.       Top          =   2160
  102.       Width        =   1140
  103. End
  104. Begin Control LABEL
  105.       Type         =   "Label"
  106.       Style        =   2
  107.       Caption      =   "Debit"
  108.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  109.       Location     =   "Header Block"
  110.       Height       =   285
  111.       Left         =   5700
  112.       Top          =   2160
  113.       Width        =   1410
  114. End
  115. Begin Control LABEL
  116.       Type         =   "Label"
  117.       Style        =   2
  118.       Caption      =   "Balance"
  119.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  120.       Location     =   "Header Block"
  121.       Height       =   285
  122.       Left         =   8895
  123.       Top          =   2160
  124.       Width        =   1275
  125. End
  126. Begin Control PNNAME
  127.       Type         =   "Text"
  128.       Style        =   0
  129.       Fieldname    =   "PNNAME"
  130.       Filename     =   "PLNAME"
  131.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  132.       Location     =   "Header Block"
  133.       Height       =   270
  134.       Left         =   270
  135.       Top          =   270
  136.       Width        =   2700
  137. End
  138. Begin Control PNADD1
  139.       Type         =   "Text"
  140.       Style        =   0
  141.       Fieldname    =   "PNADD1"
  142.       Filename     =   "PLNAME"
  143.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  144.       Location     =   "Header Block"
  145.       Height       =   270
  146.       Left         =   270
  147.       Top          =   540
  148.       Width        =   2700
  149. End
  150. Begin Control PNADD2
  151.       Type         =   "Text"
  152.       Style        =   0
  153.       Fieldname    =   "PNADD2"
  154.       Filename     =   "PLNAME"
  155.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  156.       Location     =   "Header Block"
  157.       Height       =   270
  158.       Left         =   270
  159.       Top          =   810
  160.       Width        =   2700
  161. End
  162. Begin Control PNADD3
  163.       Type         =   "Text"
  164.       Style        =   0
  165.       Fieldname    =   "PNADD3"
  166.       Filename     =   "PLNAME"
  167.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  168.       Location     =   "Header Block"
  169.       Height       =   270
  170.       Left         =   270
  171.       Top          =   1080
  172.       Width        =   2700
  173. End
  174. Begin Control PNADD4
  175.       Type         =   "Text"
  176.       Style        =   0
  177.       Fieldname    =   "PNADD4"
  178.       Filename     =   "PLNAME"
  179.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  180.       Location     =   "Header Block"
  181.       Height       =   270
  182.       Left         =   270
  183.       Top          =   1350
  184.       Width        =   2700
  185. End
  186. Begin Control PNPOSTCODE
  187.       Type         =   "Text"
  188.       Style        =   0
  189.       Fieldname    =   "PNPOSTCODE"
  190.       Filename     =   "PLNAME"
  191.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  192.       Location     =   "Header Block"
  193.       Height       =   270
  194.       Left         =   270
  195.       Top          =   1620
  196.       Width        =   2700
  197. End
  198. Begin Control PNCODE
  199.       Type         =   "Text"
  200.       Style        =   0
  201.       Fieldname    =   "PNCODE"
  202.       Filename     =   "PLNAME"
  203.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  204.       Location     =   "Header Block"
  205.       Height       =   270
  206.       Left         =   4860
  207.       Top          =   270
  208.       Width        =   1350
  209. End
  210. Begin Control LABEL
  211.       Type         =   "Label"
  212.       Style        =   1
  213.       Caption      =   "Supplier ID:"
  214.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  215.       Location     =   "Header Block"
  216.       Height       =   270
  217.       Left         =   3780
  218.       Top          =   270
  219.       Width        =   945
  220. End
  221. Begin Control LABEL
  222.       Type         =   "Label"
  223.       Style        =   1
  224.       Caption      =   "Turnover:"
  225.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  226.       Location     =   "Header Block"
  227.       Height       =   270
  228.       Left         =   7965
  229.       Top          =   540
  230.       Width        =   1080
  231. End
  232. Begin Control PNTURNOVER
  233.       Type         =   "Text"
  234.       Style        =   0
  235.       Fieldname    =   "PNTURNOVER"
  236.       Filename     =   "PLNAME"
  237.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  238.       Location     =   "Header Block"
  239.       Height       =   270
  240.       Left         =   9180
  241.       Top          =   540
  242.       Width        =   1350
  243. End
  244. Begin Control LABEL
  245.       Type         =   "Label"
  246.       Style        =   1
  247.       Caption      =   "Credit Limit:"
  248.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  249.       Location     =   "Header Block"
  250.       Height       =   270
  251.       Left         =   7965
  252.       Top          =   945
  253.       Width        =   1215
  254. End
  255. Begin Control PNDEBIT
  256.       Type         =   "Text"
  257.       Style        =   0
  258.       Fieldname    =   "PNDEBIT"
  259.       Filename     =   "PLNAME"
  260.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  261.       Location     =   "Header Block"
  262.       Height       =   270
  263.       Left         =   9180
  264.       Top          =   945
  265.       Width        =   1350
  266. End
  267. Begin Control LABEL
  268.       Type         =   "Label"
  269.       Style        =   1
  270.       Caption      =   "Type"
  271.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  272.       Location     =   "Header Block"
  273.       Height       =   285
  274.       Left         =   1845
  275.       Top          =   2160
  276.       Width        =   870
  277. End
  278. Begin Control LABEL
  279.       Type         =   "Label"
  280.       Style        =   2
  281.       Caption      =   "Credit"
  282.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  283.       Location     =   "Header Block"
  284.       Height       =   285
  285.       Left         =   7320
  286.       Top          =   2160
  287.       Width        =   1410
  288. End
  289. Begin Control PNPHONE
  290.       Type         =   "Text"
  291.       Style        =   0
  292.       Fieldname    =   "PNPHONE"
  293.       Filename     =   "PLNAME"
  294.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  295.       Location     =   "Header Block"
  296.       Height       =   270
  297.       Left         =   4590
  298.       Top          =   810
  299.       Width        =   1890
  300. End
  301. Begin Control PNFAX
  302.       Type         =   "Text"
  303.       Style        =   0
  304.       Fieldname    =   "PNFAX"
  305.       Filename     =   "PLNAME"
  306.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  307.       Location     =   "Header Block"
  308.       Height       =   270
  309.       Left         =   4590
  310.       Top          =   1215
  311.       Width        =   1890
  312. End
  313. Begin Control LABEL
  314.       Type         =   "Label"
  315.       Style        =   1
  316.       Caption      =   "Tel:"
  317.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  318.       Location     =   "Header Block"
  319.       Height       =   270
  320.       Left         =   3780
  321.       Top          =   810
  322.       Width        =   675
  323. End
  324. Begin Control LABEL
  325.       Type         =   "Label"
  326.       Style        =   1
  327.       Caption      =   "Fax:"
  328.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  329.       Location     =   "Header Block"
  330.       Height       =   270
  331.       Left         =   3780
  332.       Top          =   1215
  333.       Width        =   675
  334. End
  335. Begin Control PNCONTACT
  336.       Type         =   "Text"
  337.       Style        =   0
  338.       Fieldname    =   "PNCONTACT"
  339.       Filename     =   "PLNAME"
  340.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  341.       Location     =   "Header Block"
  342.       Height       =   270
  343.       Left         =   4590
  344.       Top          =   1620
  345.       Width        =   2565
  346. End
  347. Begin Control LABEL
  348.       Type         =   "Label"
  349.       Style        =   1
  350.       Caption      =   "Contact:"
  351.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  352.       Location     =   "Header Block"
  353.       Height       =   270
  354.       Left         =   3780
  355.       Top          =   1620
  356.       Width        =   810
  357. End
  358. Begin Control LABEL
  359.       Type         =   "Label"
  360.       Style        =   1
  361.       Caption      =   "Status"
  362.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  363.       Location     =   "Header Block"
  364.       Height       =   285
  365.       Left         =   4275
  366.       Top          =   2160
  367.       Width        =   1140
  368. End
  369. Begin Control PTTXNDATE
  370.       Type         =   "Text"
  371.       Style        =   0
  372.       Fieldname    =   "PTTXNDATE"
  373.       Filename     =   "PLTRAN"
  374.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  375.       Location     =   "Transaction Block"
  376.       Height       =   270
  377.       Left         =   270
  378.       Top          =   60
  379.       Width        =   1410
  380. End
  381. Begin Control PTREF
  382.       Type         =   "Text"
  383.       Style        =   0
  384.       Fieldname    =   "PTREF"
  385.       Filename     =   "PLTRAN"
  386.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  387.       Location     =   "Transaction Block"
  388.       Height       =   270
  389.       Left         =   3060
  390.       Top          =   60
  391.       Width        =   1275
  392. End
  393. Begin Control LABEL
  394.       Type         =   "Label"
  395.       Style        =   9
  396.       Caption      =   "MID("   InvCrnPayAdjDscRfd",INSTR("ICPADF",PLTRAN.PTTXNTYPE)*3+1,3)"
  397.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  398.       Location     =   "Transaction Block"
  399.       Height       =   270
  400.       Left         =   1890
  401.       Top          =   75
  402.       Width        =   1080
  403. End
  404. Begin Control LABEL
  405.       Type         =   "Label"
  406.       Style        =   10
  407.       Caption      =   "CORD(PLTRAN.PTVALUE,10,2,-1)"
  408.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  409.       Location     =   "Transaction Block"
  410.       Height       =   285
  411.       Left         =   5700
  412.       Top          =   75
  413.       Width        =   1410
  414. End
  415. Begin Control LABEL
  416.       Type         =   "Label"
  417.       Style        =   10
  418.       Caption      =   "CORD(PLTRAN.PTVALUE,10,2,1)"
  419.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  420.       Location     =   "Transaction Block"
  421.       Height       =   285
  422.       Left         =   7320
  423.       Top          =   75
  424.       Width        =   1410
  425. End
  426. Begin Control LABEL
  427.       Type         =   "Label"
  428.       Style        =   10
  429.       Caption      =   "IF(PLTRAN.PTVALUE>0 & PLTRAN.PTVALUE<>PLTRAN.PTOUTSTAND,CORD(PLTRAN.PTOUTSTAND,10,2,1),"")"
  430.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  431.       Location     =   "Transaction Block"
  432.       Height       =   285
  433.       Left         =   8805
  434.       Top          =   75
  435.       Width        =   1410
  436. End
  437. Begin Control LABEL
  438.       Type         =   "Label"
  439.       Style        =   9
  440.       Caption      =   "if(PLTRAN.PTDISP="D","Disputed",MID("         Paid     Allocated",INSTR("PA",PLTRAN.PTALLOC)*9+1,9))"
  441.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  442.       Location     =   "Transaction Block"
  443.       Height       =   270
  444.       Left         =   4320
  445.       Top          =   75
  446.       Width        =   1350
  447. End
  448. Begin Control LABEL
  449.       Type         =   "Label"
  450.       Style        =   10
  451.       Caption      =   "STR(@REPVARS.REPTOT(0),10,2)"
  452.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  453.       Location     =   "Subtotal Block"
  454.       Height       =   285
  455.       Left         =   8805
  456.       Top          =   765
  457.       Width        =   1410
  458. End
  459. Begin Control LABEL
  460.       Type         =   "Label"
  461.       Style        =   2
  462.       Caption      =   "Balance"
  463.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  464.       Location     =   "Subtotal Block"
  465.       Height       =   270
  466.       Left         =   8640
  467.       Top          =   495
  468.       Width        =   1485
  469. End
  470. Begin Control LABEL
  471.       Type         =   "Label"
  472.       Style        =   10
  473.       Caption      =   "STR(@REPVARS.REPTOT(5),10,2)"
  474.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  475.       Location     =   "Subtotal Block"
  476.       Height       =   285
  477.       Left         =   435
  478.       Top          =   765
  479.       Width        =   1410
  480. End
  481. Begin Control LABEL
  482.       Type         =   "Label"
  483.       Style        =   10
  484.       Caption      =   "STR(@REPVARS.REPTOT(2),10,2)"
  485.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  486.       Location     =   "Subtotal Block"
  487.       Height       =   285
  488.       Left         =   5295
  489.       Top          =   765
  490.       Width        =   1410
  491. End
  492. Begin Control LABEL
  493.       Type         =   "Label"
  494.       Style        =   10
  495.       Caption      =   "STR(@REPVARS.REPTOT(3),10,2)"
  496.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  497.       Location     =   "Subtotal Block"
  498.       Height       =   285
  499.       Left         =   3675
  500.       Top          =   765
  501.       Width        =   1410
  502. End
  503. Begin Control LABEL
  504.       Type         =   "Label"
  505.       Style        =   10
  506.       Caption      =   "STR(@REPVARS.REPTOT(4),10,2)"
  507.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  508.       Location     =   "Subtotal Block"
  509.       Height       =   285
  510.       Left         =   2055
  511.       Top          =   765
  512.       Width        =   1410
  513. End
  514. Begin Control LABEL
  515.       Type         =   "Label"
  516.       Style        =   2
  517.       Caption      =   "Current"
  518.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  519.       Location     =   "Subtotal Block"
  520.       Height       =   270
  521.       Left         =   5265
  522.       Top          =   495
  523.       Width        =   1485
  524. End
  525. Begin Control LABEL
  526.       Type         =   "Label"
  527.       Style        =   2
  528.       Caption      =   "1 Month"
  529.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  530.       Location     =   "Subtotal Block"
  531.       Height       =   270
  532.       Left         =   3645
  533.       Top          =   495
  534.       Width        =   1485
  535. End
  536. Begin Control LABEL
  537.       Type         =   "Label"
  538.       Style        =   2
  539.       Caption      =   "2 Months"
  540.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  541.       Location     =   "Subtotal Block"
  542.       Height       =   270
  543.       Left         =   2025
  544.       Top          =   495
  545.       Width        =   1485
  546. End
  547. Begin Control LABEL
  548.       Type         =   "Label"
  549.       Style        =   2
  550.       Caption      =   "3 Months +"
  551.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  552.       Location     =   "Subtotal Block"
  553.       Height       =   270
  554.       Left         =   405
  555.       Top          =   495
  556.       Width        =   1485
  557. End
  558. Begin Control LABEL
  559.       Type         =   "Label"
  560.       Style        =   10
  561.       Caption      =   "STR(@REPVARS.REPTOT(6),10,2)"
  562.       Font         =   "-180|0|0|0|400|0|0|0|0|3|2|1|34|Arial"
  563.       Location     =   "Subtotal Block"
  564.       Height       =   285
  565.       Left         =   6915
  566.       Top          =   765
  567.       Width        =   1410
  568. End
  569. Begin Control LABEL
  570.       Type         =   "Label"
  571.       Style        =   2
  572.       Caption      =   "Unallocated"
  573.       Font         =   "-165|0|0|0|700|0|0|0|0|3|2|1|34|Arial"
  574.       Location     =   "Subtotal Block"
  575.       Height       =   270
  576.       Left         =   6885
  577.       Top          =   495
  578.       Width        =   1485
  579. End
  580.